Exit demo DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI PDF format · free preview

Microsoft DP-500 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/dp-500.html

Question 1
Single choice

What should you configure in the deployment pipeline?

A.

a backward deployment

B.

a selective deployment

C.

auto-binding

D.

a data source rule

Question 2
Single choice

How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?

A.

an incremental refresh of Product where the ModifiedDate value is during the last three days.

B.

an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last three days.

C.

a full refresh of all the tables

D.

an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last hour.

Question 3
Single choice

You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements.

What should you do?

A.

Grant the sales managers the Build permission for the existing Power Bl datasets.

B.

Grant the sales managers admin access to the existing Power Bl workspace.

C.

Create a deployment pipeline and grant the sales managers access to the pipeline.

D.

Create a PBIT file and distribute the file to the sales managers.

Question 4
Multiple choice

You need to recommend a solution to ensure that sensitivity labels are applied. The solution must minimize administrative effort.
Which three actions should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A.

From the Power Bl Admin portal, set Allow users to apply sensitivity labels for Power Bl content to Enabled.

B.

From the Power Bl Admin portal, set Apply sensitivity labels from data sources to their data in Power Bl to Enabled.

C.

In SQLDW. apply sensitivity labels to the columns in the Customer and CustomersWithProductScore tables.

D.

In the Power Bl datasets, apply sensitivity labels to the columns in the Customer and CustomersWithProductScore tables.

E.

From the Power Bl Admin portal, set Make certified content discoverable to Enabled.

Question 5
Hotspot

HOTSPOT

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.

Question 6
Drag & drop

DRAG DROP

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.

Question 7
Drag & drop

DRAG DROP

You need to create the customized Power BI usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative effort.

Which four 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.

Question 8
Hotspot

HOTSPOT

You need to create a measure to count orders for the market basket analysis.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 9
Multiple choice

You need to recommend a solution for the customer workspaces to support the planned changes.
Which two configurations should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A.

Set Use datasets across workspaces to Enabled

B.

Publish the financial data to the web.

C.

Grant the Build permission for the financial data to each customer.

D.

Configure the FinData workspace to use a Power Bl Premium capacity.

Question 10
Single choice

You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the Microsoft SQL Server data warehouse.

What should you include in the recommendation?

A.

Azure Purview

B.

Site-to-Site VPN

C.

an XMLA endpoint

D.

the on-premises data gateway

Showing 10 of 189 questions · Unlock the full set