Microsoft Microsoft Certifications DP-500 Questions & Answers

• Question 111:

  You discover a poorly performing measure in a Power Bl data model.

  You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine.

  What should you use?

  A. Tabular Editor

  B. Performance analyzer in Power Bl Desktop

  C. Vertipaq Analyzer

  D. DAX Studio

  Correct Answer: D

  Although Vertipaq Analyzer is part of DAX Stuidio, Vertipaq Analyzer only shows details about the tables and columns, not the time it took for each engine to execute the query.

• Question 112:

  You have an Azure Synapse Analytics serverless SQL pool.

  You need to catalog the serverless SQL pool by using Azure Purview.

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

  NOTE: Each correct selection is worth one point.

  A. Create a managed identity in Azure Active Directory (Azure AD).

  B. Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.

  C. Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.

  D. Register a data source.

  E. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.

  Correct Answer: BDE

• Question 113:

  You have a Power Bl workspace named Workspacel that contains five dataflows.

  You need to configure Workspacel to store the dataflows in an Azure Data Lake Storage Gen2 account

  What should you do first?

  A. Delete the dataflow queries.

  B. From the Power Bl Admin portal, enable tenant-level storage.

  C. Disable load for all dataflow queries.

  D. Change the Data source settings in the dataflow queries.

  Correct Answer: A

• Question 114:

  You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?

  A. PIVOT

  B. GROUPING

  C. PREDICT

  D. CAST

  Correct Answer: C

• Question 115:

  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.

  Correct Answer: B

• Question 116:

  The enterprise analytics team needs to resolve the DAX measure performance issues. What should the team do first?

  A. Use Performance analyzer in Power BI 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.

  Correct Answer: A

• Question 117:

  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 BI 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 BI dataset.

  D. Create a Power BI template app.

  Correct Answer: BD

• Question 118:

  The enterprise analytics team needs to notify the report owners of the planned changes. The solution must minimize administrative effort. What should the team do?

  A. Locate all the downstream reports, identify all the users that are assigned the Admin role, and then send an email to each user.

  B. Write a PowerShell script to access the Power BI API that retrieves a list of downstream reports and a list of workspace administrators, and then send an email to each workspace administrator.

  C. Perform impact analysis on the Financial Model dataset to notify the workspace contacts.

  D. Perform impact analysis feature on the lake database data source to notify the workspace contacts.

  Correct Answer: C

• Question 119:

  You have a Power BI report named Report1. Report1 is connected to an imported dataset that contains a matrix. The matrix displays five measures.

  When users view the report, they discover that the matrix is slow to render.

  You need to review the execution times and durations in the formula engine and the storage engine for the DAX query executed by the matrix.

  What should you use?

  A. DAX Studio

  B. SQL Server Profiler

  C. Performance analyzer

  D. Vertipaq Analyzer

  Correct Answer: A

• Question 120:

  You are creating a Power BI report that will contain multiple visuals.

  You need to ensure that the report is accessible to users who use a screen reader.

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

  NOTE: Each correct selection is worth one point.

  A. consistent colors for each visual

  B. consistent fonts for each visual

  C. alt text for each visual

  D. the tab order for each page

  E. Play Axis for each page

  Correct Answer: CD