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

Page: 1 / 14
Total 149 questions

Question 1

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 2

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 3

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 4

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 5

You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.

What should you do?



Answer : A

Question 6

You have a collection of reports for the HR department of your company.

You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.

Which type of visualization should you use?



Answer : C

Question 7

You have a table that contains sales data and approximately 1,000 rows.

You need to identify outliers in the table. Which type of visualization should you use?



Answer : C

Page:    1 / 14   
Total 149 questions