Microsoft DA-100 Cert Guide PDF 100% Cover Real Exam Questions [Q23-Q37]

QUESTION 23
Drag and Drop Question
You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:
– Identify months that have order counts above the mean.
– Display the mean monthly order count.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

QUESTION 24
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

QUESTION 25
You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 26
What is the minimum number of Power BI datasets needed to support the reports?

QUESTION 27
Drag and Drop Question
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail data.
The users require insights on the completeness of the data and the value distributions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

QUESTION 28
You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 29
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?

QUESTION 30
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

QUESTION 31
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

QUESTION 32
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

QUESTION 33
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?

QUESTION 34
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: “Hi. I’ve put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions.” You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

QUESTION 35
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

QUESTION 36
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers.
What should you do?

QUESTION 37
Hotspot Question
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.
Sales contains the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.