March Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

DP-500 Exam Dumps - Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

Question # 4

The enterprise analytics team needs to resolve the DAX measure performance issues.

What should the team do first?

A.

Use Performance analyzer in Power Bl Desktop to get the DAX durations.

B.

Use DAX Studio to get detailed statistics on the server timings.

C.

Use DAX Studio to review the Vertipaq Analyzer metrics.

D.

Use Tabular Editor to create calculation groups.

Full Access
Question # 5

You need to create Power BI reports that will display data based on the customers’ subscription level.

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.

Full Access
Question # 6

You need to recommend a solution to resolve the query issue of the serverless SQL pool. The solution must minimize impact on the users.

What should you in the recommendation?

A.

Update the statistics for the serverless SQL pool.

B.

Move the data from the serverless SQL pool to a dedicated Apache Spark pool.

C.

Execute the sp_sec_process_daca_limic stored procedure for the serverless SQL pool.

D.

Move the data from the serverless SQL pool to a dedicated SQL pool.

Full Access
Question # 7

You need to recommend a solution for the analysts in the Finance and Accounting business unit to mitigate the increase in maintenance of their assets in the Power Bl tenant.

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

NOTE: Each correct selection is worth one point.

A.

Use Microsoft Purview to search for datasets that contain the relevant data.

B.

Perform impact analysis on the relevant data source.

C.

Create a live connection to a Power Bl dataset.

D.

Create a Power Bl template app.

Full Access
Question # 8

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.

Full Access
Question # 9

The group registers the Power Bl tenant as a data source1.

You need to ensure that all the analysts can view the assets in the Power Bl tenant The solution must meet the technical requirements for Microsoft Purview and Power BI.

What should you do?

A.

Create a scan.

B.

Deploy a Power Bl gateway.

C.

Search the data catalog.

D.

Create a linked service.

Full Access
Question # 10

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.

Full Access
Question # 11

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.

Full Access
Question # 12

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.

Full Access
Question # 13

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.

Full Access
Question # 14

What should you configure in the deployment pipeline?

A.

a backward deployment

B.

a selective deployment

C.

auto-binding

D.

a data source rule

Full Access
Question # 15

You need to create the customized Power Bl 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.

Full Access
Question # 16

You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column.

pfflag = IF('Calendar'[Date] < TOOAYQ, "Past", "Future")

You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:

• Returns the fiscal prior year-to-date value for [sales Amount]

• Uses a fiscal year end of June 30

• Produces no result for dates in the future

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.

Full Access