DP-500 Online Practice Questions and Answers

DRAG DROP

You plan to create a Power Bl report that will use an OData feed as the data source. You will retrieve all the entities from two different collections by using the same service root

The OData feed is still in development. The location of the feed will change once development is complete.

The report will be published before the OData feed development is complete.

You need to minimize development effort to change the data source once the location changes.

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.

Select and Place:

HOTSPOT

You have a Power Bl dataset that has the query dependencies 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.

Hot Area:

HOTSPOT

You manage a dataset that contains the two data sources as shown in the following table.

When you attempt to refresh the dataset in powerbi.com, you receive the following error message: "[Unable to combine data] Add Columns is accessing data sources that have privacy levels which cannot be used together. Please rebuild this

data combination."

You discover that the dataset contains queries that fold data from the SharePoint folder to the Azure SQL database.

You need to resolve the error. The solution must provide the highest privacy possible.

Which privacy level should you select for each data source? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You need to populate the CustomersWithProductScore table.

How should you complete the stored procedure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset.

During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB."

You need to ensure that you can refresh the dataset.

What should you do?

A. Turn on Large dataset storage format.

B. Connect Workspace1 to an Azure Data Lake Storage Gen2 account

C. Change License mode to Premium per user.

D. Change the location of the Premium capacity.

You have a Power BI dataflow named DF1 that contains the following columns:

OrderID SaleDate ProductID SalesAmount ProductCategory

You create a Power BI dataset named DS1 that uses DF1 as a data source. DS1 creates an aggregated view of the data in DF1. The view contains the following columns:

SaleMonth SalesAmount ProductCategory

You need to minimize how long it takes to refresh DS1.

What should you do first?

A. Add a computed entity to DF1.

B. Create a custom function in DS1.

C. Create a linked entity in DF1.

D. Add a computed column to DS1.

The enterprise analytics team needs to notify the report owners of the planned changes. The solution must minimize administrative effort. What should the team do?

A. Locate all the downstream reports, identify all the users that are assigned the Admin role, and then send an email to each user.

B. Write a PowerShell script to access the Power BI API that retrieves a list of downstream reports and a list of workspace administrators, and then send an email to each workspace administrator.

C. Perform impact analysis on the Financial Model dataset to notify the workspace contacts.

D. Perform impact analysis feature on the lake database data source to notify the workspace contacts.

You are creating a Power BI report that will contain multiple visuals.

You need to ensure that the report is accessible to users who use a screen reader.

Which two configurations should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. consistent colors for each visual

B. consistent fonts for each visual

C. alt text for each visual

D. the tab order for each page

E. Play Axis for each page

You have a Power BI Premium capacity.

From the Power BI Premium Capacity Metrics app, you discover the following:

There is insufficient CPU to execute dataset refreshes.

Out-of-memory throttling occurs when the dataset is waiting.

You need to recommend a solution to resolve the performance issues.

Solution: You assign Premium per user licenses to all workspace members.

Does this meet the goal?

A. Yes

B. No

You have a Power BI tenant.

You need to ensure that all reports use a consistent set of colors and fonts. The solution must ensure that the colors and fonts can be applied to existing reports.

What should you create?

A. a report theme file

B. a PBIX file

C. a Power BI template