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?

A.

Share the dashboard to the user.

B.

Create a subscription.

C.

Create a data alert.

D.

Tag the user in a comment.

You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and
Quantity Ordered. The solution must highlight orders that have a similar unit price and
ordered quantity.
Which type of visualization and which feature should you use? To answer, select the
appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have a report that contains a bar chart and a column chart. The bar chart shows
customer count by
customer segment. The column chart shows sales by month.
You need to ensure that when a segment is selected in the bar chart, you see which
portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is
selected?

A.

no impact

B.

highlight

C.

filter

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from
an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises
data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize
configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each
correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A.

Configure the dataset to use the existing On-premises data gateway.

B.

Deploy an On-premises data gateway in personal mode.

C.

Set the refresh frequency to Daily.

D.

Configure the dataset to use the personal gateway

You have two tables named Customers and Invoice in a Power BI model. The Customers
table contains the following fields:
CustomerID
Customer City
Customer State
Customer Name
Customer Address 1
Customer Address 2
Customer Postal Code
The Invoice table contains the following fields:
Order ID
Invoice ID
Invoice Date
Customer ID
Total Amount
Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A
customer can have many invoices within one month.
The Power BI model must provide the following information:
The number of customers invoiced in each state last month
The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The
solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You view a query named Transactions as shown in the following exhibit.

You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.

You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant
distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the
sales records of their region. The sales managers are prevented from viewing records from
other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?

A.

From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.

B.

Change the Microsoft Power Bl license type of the sales manager.

C.

Manage the permissions of the underlying dataset

D.

Request that the sales manager be added to the correct Azure Active Directory group

You build a report about warehouse inventory data. The dataset has more than 10 million
product records from 200 warehouses worldwide. You have a table named Products that
contains the columns shown in the following table.

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?

A.

Show whitespace

B.

Column profile

C.

Column distribution

D.

Column quality

You have a report page that contains the visuals shown in the following exhibit.

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 section, you will NOT be able to return to it. As a
result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large
Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order
table.
Solution: From Power Query Editor, you import the table and then add a filter step to the
query.
Does this meet the goal?

A.

Yes

B.

No