Power BI Data Sources Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Get or Connect to Data

What you'll be asked

  1. Which button in the Power BI Desktop Home ribbon is the primary starting point for connecting to data from sources like Excel, SQL Server, or the Web?
  2. You need to connect to a massive SQL Server database. The requirement is that the report must show the most up-to-date data available without waiting for a scheduled refresh, and the data should not be stored in the Power BI file. Which storage mode should you select?
  3. When using the 'Folder' connector to combine multiple CSV files into a single table, what is a mandatory requirement for the files to combine correctly without errors?
  4. You are trying to extract data from a website where the data is not formatted in a standard HTML table. Which Power BI feature allows you to provide samples of the data you want so that Power BI can infer the extraction pattern?
  5. You are combining data from a sensitive internal SQL database with data from a public CSV file hosted on a website. You receive a 'Formula.Firewall' error. Which setting must you configure to ensure data from the SQL database is never sent to the public web source during the merge process?

Answers and explanations come after you submit.