Microsoft Microsoft Certified: Azure Enterprise Data Analyst Associate DP-500 Questions & Answers

• Question 151:

  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.

  Correct Answer: B

  The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in SQLDW up to three days after being created. The records do NOT change after three days.

• Question 152:

  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.

  Correct Answer: A

• Question 153:

  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.

  Correct Answer: ABC