Microsoft Microsoft Certifications DP-500 Questions & Answers

• Question 121:

  You have a Power BI report that contains a card. The card displays the value for year-to-date revenue.

  You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.

  What should you do?

  A. Convert the card into a text box.

  B. Populate the alt text by using conditional formatting with a DAX measure.

  C. Add the value to the chart title text.

  D. Populate the alt text with a static value.

  Correct Answer: B

• Question 122:

  You have a Power BI Premium capacity.

  From the Power BI Premium Capacity Metrics app, you discover the following:

  There is insufficient CPU to execute dataset refreshes.

  Out-of-memory throttling occurs when the dataset is waiting.

  You need to recommend a solution to resolve the performance issues.

  Solution: You scale up the capacity.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 123:

  You have a Power BI Premium capacity.

  From the Power BI Premium Capacity Metrics app, you discover the following:

  There is insufficient CPU to execute dataset refreshes.

  Out-of-memory throttling occurs when the dataset is waiting.

  You need to recommend a solution to resolve the performance issues.

  Solution: You move the datasets to a larger capacity.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 124:

  You have a Power BI Premium capacity.

  From the Power BI Premium Capacity Metrics app, you discover the following:

  There is insufficient CPU to execute dataset refreshes.

  Out-of-memory throttling occurs when the dataset is waiting.

  You need to recommend a solution to resolve the performance issues.

  Solution: You assign Premium per user licenses to all workspace members.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 125:

  You have an Azure Synapse Analytics notebook.

  You run the %%sql magic command to render data into an Apache Spark DataFrame named df1, and then you run the following code.

  display(df1, summary = true)

  Which three attributes will be returned by the command? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. type

  B. range

  C. missing

  D. unique

  E. ordinal

  Correct Answer: ACD

• Question 126:

  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.

  Correct Answer: B

• Question 127:

  You have a Power BI tenant and an Azure subscription named Sub1. The Power BI tenant and Sub1 are linked to a single Azure AD tenant.

  In Sub1, you create a storage account named storage1.

  You need to configure a Power BI workspace to store dataflows in storage1. The solution must use the principle of least privilege.

  Which three roles should you assign for storage1? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Reader

  B. Storage Blob Data Contributor

  C. Contributor

  D. Owner

  E. Storage Blob Data Owner

  F. Storage Blob Data Reader

  Correct Answer: DEF

• Question 128:

  From Power Query Editor, you profile the data shown in the following exhibit.

  

  The IoT GUID and IoT ID columns are unique to each row in the query.

  You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

  Solution: You remove the IoT GUID column and retain the IoT ID column.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 129:

  You have a Power BI tenant that is linked to an Azure AD tenant. The tenant contains a group named Group1.

  You create a paginated report that does NOT use row-level security (RLS).

  You need to send a copy of the report to Group1 every Monday at 9 AM UTC.

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

  NOTE: Each correct selection is worth one point.

  A. Create a subscription for Group1.

  B. Publish the paginated report to a Pro workspace.

  C. Create a data alert for Group1.

  D. Publish the paginated report to a Premium Per User workspace.

  Correct Answer: AD

• Question 130:

  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.

  Correct Answer: BC