Power BI Data Sources Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Get or Connect to Data

Power BI Data Sources Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 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. 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. 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. 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. 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?