Question 26
You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
The AddressLine2 column in a table named Address is shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Question 27
DRAG DROP
You have a query named Customer that imports CSV files from a data lake.
The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)
Each file contains deltas of any new or modified rows from each load to the data lake.
Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
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.
You have a query named Customer that imports CSV files from a data lake.
The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)
Each file contains deltas of any new or modified rows from each load to the data lake.
Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
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 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?
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?
Question 29
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You publish an app to the entire organization.
Does this meet the goal?
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You publish an app to the entire organization.
Does this meet the goal?
Question 30
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?