DP-500 Online Practice Questions and Answers

HOTSPOT

You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements:

Code must always be merged to the main branch before being published, and the main branch must be used for publishing resource

The workspace templates must be stored in the publish branch.

A branch named dev123 will be created to support the development of a new feature.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You have a dataset that contains a table named UserPermissions. UserPermissions contains the following data.

You plan to create a security role named User Security for the dataset. You need to filter the dataset based on the current users. What should you include in the DAX expression?

A. [UserPermissions] - USERNAME()

B. [UserPermissions] - USERPRINCIPALNAME()

C. [User] = USERPRINCIPALNAME()

D. [User] = USERNAME()

E. [User] = USEROBJECTID()

You are creating a Python visual in Power Bl Desktop.

You need to retrieve the value of a column named Unit Price from a DataFrame.

How should you reference the Unit Price column in the Python code?

A. pandas.DataFrame('Unit Price')

B. dataset['Unit Price']

C. data = [Unit Price]

D. ('Unit Price')

You are running a diagnostic against a query as shown in the following exhibit.

What can you identify from the diagnostics query?

A. All the query steps are folding.

B. Elevated permissions are being used to query records.

C. The query is timing out.

D. Some query steps are folding.

You have five Power Bl reports that contain R script data sources and R visuals.

You need to publish the reports to the Power Bl service and configure a daily refresh of datasets.

What should you include in the solution?

A. a Power Bl Embedded capacity

B. an on-premises data gateway (standard mode)

C. a workspace that connects to an Azure Data Lake Storage Gen2 account

D. an on-premises data gateway (personal mode)

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 report that contains a single page. The page contains two line charts and one bar chart.

You need to ensure that users can perform the following tasks for all three visuals:

Switch the measures used in the visuals.

Change the visual type.

Add a legend.

The solution must minimize development effort.

What should you do?

A. Enable personalization for each visual.

B. Enable personalization for the report.

C. Create a bookmark for each acceptable combination of visual type, measure, and legend in the bar chart.

D. Edit the interactions between the three visuals.

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.

You have a Power BI workspace named workspace1 that contains three reports and two dataflows.

You have an Azure Data Lake Storage account named storage1.

You need to integrate workspace1 and storage1.

What should you do first?

A. In storage1, create a folder named dataflows.

B. Delete the dataflows from workspace1.

C. In storage1, create a folder named reports.

D. Delete the reports from workspace1.

You need to identify the root cause of the data refresh issue. What should you use?

A. the Usage Metrics Report in powerbi.com

B. Query Diagnostics in Power Query Editor

C. Performance analyzer in Power Bl Desktop