DRAG DROP
You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

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.

Comment: *

Name: *

Email: *

Verification: *

DRAG DROP
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have the visual shown in the Original exhibit. {Click the Original tab.)

You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

What should you add to the visual?

• A.a measure
• B.a trendline
• C.a forecast
• D.an Average line

Correct Answer: C

Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.

Reference:
https://powerbi.microsoft.com/fr-fr/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365/

Comment: *

Name: *

Email: *

Verification: *

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

You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/powerquery-m/text-replace
https://docs.microsoft.com/en-us/powerquery-m/text-end

Comment: *

Name: *

Email: *

Verification: *