You create a report by using Microsoft Power Bl Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network.
You plan to publish the report to the Power Bl Service.
What should you implement to ensure that users who consume the report from the Power Bl Service have the most up-to-date data from the cube?

• A.an OData feed
• B.a subscription
• C.a scheduled refresh of the dataset
• D.an On-premises data gateway

Comment: *

Name: *

Email: *

Verification: *

You are profiling data by using Power Query Editor.
The AddressLine2 column in a table named Address is 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 selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

Hotspot Question
You have two Azure SQL databases that contain the same tables and columns. For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a table that contains the following three columns:
City
Total Sales
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

How should you configure the visualization? 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/power-bi/visuals/power-bi-visualization-influencers

Comment: *

Name: *

Email: *

Verification: *

You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation

Comment: *

Name: *

Email: *

Verification: *