DA-100 Exam Training Practice Tests (Microsoft Analyzing Data with Microsoft Power BI)]

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?

A. Q&A B. key influencers C. decomposition tree D. funnel chart

Correct Answer: B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

Question 3

You have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?

A. Add a Top N filter to the visual. B. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the C. Configure the Sales Profit measure to use the RANKX function. D. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-query/append-queries

Question 5

You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?

A. Set Data Connectivity mode to Import. B. Add a SQL statement. C. Set Data Connectivity mode to DirectQuery. D. Set the Command timeout in minutes setting.

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

A. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table. B. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column C. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column. D. From Power Bi Desktop, use the Auto date/time option when creating the reports.

Correct Answer: B

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