Analyzing Data with Power BI Free Sample Questions

Description

Covers getting, profiling and transforming data from different sources, designing data models and DAX measures, creating reports and dashboards, and managing datasets and workspaces for deployment.

8 free sample questions47 in the full practice test Other version: PL-300(214)

Try simulator

DA-100 Sample Questions

  1. Question 1

    You have a Microsoft Excel workbook with a spreadsheet named Sales.

    You want to use the Sales spreadsheet in a Power BI dashboard report.

    How should you prepare the data on Sales spreadsheet?

    Answer and explanation

    Correct answer: C

    Converting data to a flat table in Excel is the essential first step before importing into Power BI. A flat table ensures each column contains the same data type (text, date, number, or currency) and includes a header row without total or summary rows. This structure allows Power BI to properly recognize data types and establish relationships. Simply importing the data, publishing the spreadsheet, or uploading the workbook without proper table formatting will result in data import errors and poor data model performance in Power BI.

  2. Question 2

    You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01.

    You want to be able to use Microsoft R scripts in your visualization.

    You install SQL Server R Services on SQL01.

    Does this action allow you to use Microsoft R scripts in your visualization?

    Answer and explanation

    Correct answer: B

    Explanation: By default, Power BI Desktop doesn't include, deploy, or install the R engine. To run R scripts in Power BI Desktop, you must separately install Microsoft R on your local computer.References: https://docs.microsoft.com/en-us/sql/machine-learning/install/sql-r-services-windows-install?view=sql-server-2016

  3. Question 3

    You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01.

    You want to be able to use Microsoft R scripts in your visualization.

    You download and install Microsoft R Open on the computer that has Power BI Desktop installed.

    Does this action allow you to use Microsoft R scripts in your visualization?

    Answer and explanation

    Correct answer: A

    Explanation: By default, Power BI Desktop doesn't include, deploy, or install the R engine. To run R scripts in Power BI Desktop, you must separately install Microsoft R on your local computer.References: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals

  4. Question 4

    You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01.

    You want to be able to use Microsoft R scripts in your visualization.

    You download and install Visual Studio on the computer that has Power BI Desktop installed.

    Does this action allow you to use Microsoft R scripts in your visualization?

    Answer and explanation

    Correct answer: B

    Explanation: By default, Power BI Desktop doesn't include, deploy, or install the R engine. To run R scripts in Power BI Desktop, you must separately install Microsoft R on your local computer.References: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals

Register free for 4 more questions

Or unlock all 47 DA-100 questions with explanations, timed mode and flashcards.