DP-500 Online Practice Questions and Answers

DRAG DROP

You have a shared dataset in Power Bl named Dataset1.

You have an on-premises Microsoft SQL Server database named DB1.

You need to ensure that Dataset1 refreshes data from DB1.

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 the following code in an Azure Synapse notebook.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the code. NOTE: Each correct selection is worth one point.

Hot Area:

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 have a Power Bl dataset that contains the following measure.

You need to improve the performance of the measure without affecting the logic or the results. What should you do?

A. Replace both calculate functions by using a variable that contains the calculate function.

B. Remove the alternative result of blank( ) from the divide function.

C. Create a variable and replace the values for [sales Amount].

D. Remove "calendar'[Flag] = "YTD" from the code.

You need to provide users with a reproducible method to connect to a data source and transform the data by using an Al function. The solution must meet the following requirement

Minimize development effort.

Avoid including data in the file.

Which type of file should you create?

A. PBIDS

B. PBIX

C. PBIT

You have two Power BI reports named Report1 and Report2.

Report1 connects to a shared dataset named Dataset1.

Report2 connects to a local dataset that has the same structure as Dataset1. Report2 contains several calculated tables and parameters.

You need to prepare Report2 to use Dataset1.

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

NOTE: Each correct selection is worth one point.

A. Remove the data source permissions.

B. Delete all the Power Query Editor objects.

C. Modify the source of each query.

D. Update all the parameter values.

E. Delete all the calculated tables.

You have a Power BI tenant.

You plan to publish 10 paginated reports that will be used by a team of business analysts.

You need to create a new workspace for the reports. The solution must minimize costs.

Which license mode should you select for the new workspace?

A. Pro

B. Premium per user

C. Embedded

D. Premium per capacity

You have a Power BI tenant.

You invite an external consultant to work in the tenant.

You need to grant the consultant access to the tenant. The solution must meet the following requirements:

The consultant must be able to consume, create, and update reports and datasets.

The consultant must access content by using Azure AD B2B.

Which settings should you enable in the Power BI Admin portal? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. Invite external users to your organization.

B. Allow Azure Active Directory guest users to access Power BI.

C. Allow Azure Active Directory guest users to edit and manage content in the organization.

D. External sharing.

You have a Power BI report hosted on the Power BI service. The report displays expenses by department for department managers and contains a line chart that shows expenses by month.

You need to ensure that users can choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.

What should you do?

A. Create a mobile report that contains a column chart.

B. Add a column chart a bookmark, and a button for users to choose a visual.

C. Enable report readers to personalize visuals.

D. Create a separate report page for users to view a column chart.