You need to configure access for the sales department users. The solution must me meet
the security requirements. What should you do?

A.

Add the sales department as a member of the reports workspace

B.

Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

C.

Distribute an app to the users in the Azure Active Directory group of the sales
department.

D.

Share each report to the Azure Active Directory group of the sales department

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

A.

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.

B.

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

C.

From Power Bl Desktop, use the Auto date/time option when creating the reports.

D.

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.

You need to minimize me size of the dataset. The solution must meet the report
requirements What should you do?

A.

Change lite OrderlD column in the Orders table to the text data type.

B.

Filter out discontinued products while importing the Product table.

C.

Remove the QuantityPerUnit column from the Products table

D.

Group the Categories table by the CategorylD column.

You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company. The reports display the data configured as shown in the following table.

You need to ensure that the users of the reports can locate the correct report by using
natural language queries.
What should you do?

A.

From the properties of the dataset, create four Featured Q&A Questions.

B.

From the Format settings of the reports, modify the Page Information.

C.

From the properties of the dataset, modify the Q&A and Cortana settings.

D.

From the properties of the workspace, modify the Language Settings.

You have a report that includes a card visualization.
You need to apply the following conditional formatting to the card while minimizing design
effort.
For values that are greater than or equal to 100, the font of the data label must be dark red.
For values that are less than 100, the font of the data label must be dark gray.
Which type of format should you use?

A.

Color scale

B.

Rules

C.

Field value

You use an R visual to produce a map of 500,000 customers. You include the values of
CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is
unique.
In powerbi.com, when users load the visual, they only see some of the customers.
What is the cause of the issue?

A.

The visual was built by using a different version of R.

B.

The data comes from a Microsoft SQL Server source.

C.

The data is deduplicated.

D.

Too many records were sent to the visual.

You have sales data in a star schema that contains four tables named Sales, Customer,
Date, and Product.
The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the
data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must
minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

A.

Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.

B.

Duplicate the Date query in Power Query and use active relationships between both Date tables.

C.

On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

D.

Create an active relationship between Sales and Date for the purchase date and an
inactive relationship for the ship date

You need to provide a user with the ability to add members to a workspace. The solution must use the
principle of least privilege.
Which role should you assign to the user?

A.

Viewer

B.

Contributor

C.

Member

D.

Admin

You plan to develop a Power BI report that has a bar chart to display the number of
customers by location. You have a table named Customer that has the following columns:
• Customer ID
• CustomerName
• Address
• City
• ProvState
• Country
You need to allow users to drill down by location. The report will display the number of
each customer by Country, and drill down to ProvState, and then to City. How should you
configure the drill down in the bar chart?

A.

In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.

B.

In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.

C.

In the Axis field, add Country at the top, followed by ProvState, and then City.

D.

In the Value field, add Country at the top, followed by ProvState, and then City.

Your organization has a team of power users who recently created 20 Power BI
dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown
in the exhibit. (Click the Exhibit.)

What should you do first?

A.

From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

B.

From the Power BI Admin portal, modify the Privacy Settings.

C.

From the properties of each dashboard, modify the Share dashboard settings.

D.

Instruct each user to install Microsoft Office 2016.

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question
presents a different goal and answer choices, but the text of the scenario is the
same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
- Date[Month] in the mm
yyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column.
This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Order table and the Store table on the
Store_ID column.
What should you do before you create the relationship?

A.

In the Order table query, use the Table.TrasformRows function.

B.

In the Store table query, use the Table.TrasformRows function.

C.

In the Store table query, use the Table.TrasformColumnTypes function.

D.

In the Order table query, use the Table.TrasformColumnTypes function.