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

• Question 141:

  You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You need to present the data distribution statistics from a DataFrame in a tabular view. Which method should you invoke on the DataFrame?

  A. freqItems

  B. sample

  C. corr

  D. describe

  Correct Answer: D

• Question 142:

  You have a Power BI report that contains a bar chart. The bar chart displays sales by country.

  You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader.

  What should you configure on the bar chart?

  A. conditional formatting

  B. the layer order

  C. alt text

  D. the tab order

  Correct Answer: C

• Question 143:

  You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You need to present the data distribution statistics from a Data Frame in a tabular view. Which method should you invoke on the Data Frame?

  A. sample

  B. describe

  C. freqItems

  D. explain

  Correct Answer: B

• Question 144:

  You are planning a Power BI solution for a customer.

  The customer will have 200 Power BI users. The customer identifies the following requirements:

  Ensure that all the users can create paginated reports.

  Ensure that the users can create reports containing AI visuals.

  Provide autoscaling of the CPU resources during heavy usage spikes.

  You need to recommend a Power BI solution for the customer. The solution must minimize costs.

  What should you recommend?

  A. a Power BI Premium per capacity

  B. Power BI Report Server

  C. Power BI Premium per user

  D. Power BI Pro per user

  Correct Answer: A

• Question 145:

  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.

  Correct Answer: AC

• Question 146:

  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

  Correct Answer: D

• Question 147:

  You need to identify the root cause of the data refresh issue. What should you use?

  A. the Usage Metrics Report in powerbi.com

  B. Query Diagnostics in Power Query Editor

  C. Performance analyzer in Power Bl Desktop

  Correct Answer: B

• Question 148:

  Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution.

  A. Synapse Studio

  B. DAX Studio

  C. Azure Data Studio

  D. Performance analyzer in Power Bl Desktop

  Correct Answer: BD

• Question 149:

  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.

  Correct Answer: A

• Question 150:

  What should you configure in the deployment pipeline?

  A. a backward deployment

  B. a selective deployment

  C. auto-binding

  D. a data source rule

  Correct Answer: D