Microsoft DA-100 Analyzing Data with Microsoft Power BI Exam Practice Test

Page:    1 / 14   
Total 141 questions

Question 1

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Explanation.

Answer as below

See Below Explanation:




Answer : A

Question 2

ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.

The table has 12 million rows. All the columns are needed for analysis.

You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.

What should you do?



Answer : B

Question 3

In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset

You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data

What should you do?



Answer : B

Question 4

You are building a Power BI report to analyze customer segments.

You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.

Which type of visualization should you use?



Answer : D

Question 5

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.

You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.

What should you do?



Answer : D

Page:    1 / 14   
Total 141 questions