DP-500 Online Practice Questions and Answers

DRAG DROP

You are using DAX Studio to query an XMLA endpoint.

You need to identify the duplicate values in a column named Email in a table named Subscription.

How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used once, more than once. may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select and Place:

HOTSPOT

You use Vertipaq Analyzer to analyze a model.

The Relationships tab contains the results 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:

You need to implement object-level security (OLS) in the Power Bl dataset for the sales associates.

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:

You have a Power Bl dataset named Datasetl.

In Datasetl, you currently have 50 measures that use the same time intelligence logic.

You need to reduce the number of measures, while maintaining the current functionality.

Solution: From Power Bl Desktop, you group the measures in a display folder.

Does this meet the goal?

A. Yes

B. No

You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join operations in the query. What should you review?

A. the query statistics

B. the query plan

C. the query history

D. the server timings

You need to save Power Bl dataflows in an Azure Storage account.

Which two prerequisites are required to support the configuration? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. The storage account must be protected by using an Azure Firewall.

B. The connection must be created by a user that is assigned the Storage Blob Data Owner role.

C. The storage account must have hierarchical namespace enabled.

D. Dataflows must exist already for any directly connected Power Bl workspaces.

E. The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual. What should you do?

A. Replace long text with abbreviations and acronyms.

B. Configure a unique marker for each series.

C. Configure a distinct color for each series.

D. Move important information to a tooltip.

You are optimizing a Power Bl data model by using DAX Studio.

You need to capture the query events generated by a Power Bl Desktop report.

What should you use?

A. the DMV list

B. a Query Plan trace

C. an All Queries trace

D. a Server Timings trace

You have a Power Bl dataset named Datasetl.

In Dataset1, you currently have 50 measures that use the same time intelligence logic.

You need to reduce the number of measures, while maintaining the current functionality.

Solution: From DAX Studio, you write a query that uses grouping sets.

Does this meet the goal?

A. Yes

B. No

The new process for deploying Power BI reports and datasets to the User Experience workspace must ensure that the datasets point to the lake database to which the relevant dataset is deployed. The views in each lake database must

present the data in a tabular format.

You need to optimize the workflow for the creation of reports and the adjustment of tables by the enterprise analytics team.

What should you do?

A. Add a tenant-level storage connection to Power BI.

B. Create a linked service in workspace1.

C. Create an integration runtime in workspace1.

D. From the Tenant setting, enable Use global search for Power BI.