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?
You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
First name
Last name
Email address
State/Region
Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You have a Power Bl query named Sates that imports the columns shown in the following table.
Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTL Each correct selection is worth one pant.
You are creating a Power Bl report by using Power Bi Desktop.
You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.
Which type of visual should you use?
You have a Power Bl report named Orders that supports the following analysis:
• Total sales over time
• The count of orders over time
• New and repeat customer counts
The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.
You use Microsoft Power B1 Desktop to review the data shown in the following exhibit.
You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?
You have a report in Power Bl named report1 that is based on a shared dataset.
You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.
What should you do?
You are creating a query to be used as a Country dimension in a star schema.
A snapshot of the source data is shown in the following table.
You need to create the dimension. The dimension must contain a list of unique countries.
Which two actions should you perform? Each correct answer presents part of the solution.
You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured as 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 solution is worth one point
