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.

You need to create a relationship in the dataset for RLS.
What should you do? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have a query that returns the data shown in the following exhibit.

Which step should you use in the query?

A.

=Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".
Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta
[Serialized.Text = true] in type {itemType}}}), "classes")

B.

= Table.Unpivot(Source, {"classes"}, "Attribute", "Value")

C.

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",",
QuoteStyle.None), {"classes.1"})

D.

= Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to
ensure that the users can consume the content on a report page in a logical order. What
should you configure in Microsoft Power Bl Desktop?

A.

the bookmark order

B.

the layer order

C.

the tab order

D.

the X position