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

Page: 1 / 14
Total 162 questions
Question 1

You have a Power Bl tenant and an Azure subscription named Sub1. The Power Bl 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 Bl 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.



Answer : A, B, D


Question 2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power Bl Premium capacity.

From the Power Bl 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?



Answer : A


Question 3

You have a Power BI report named Report1. Repor1 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?



Answer : A


Question 4

You are creating a Power Bl 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.



Answer : C, D


Question 5

You have a Power Bl 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?



Answer : B


Question 6

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.

The queries use open row set and infer the schema shown in the following table.

You need to recommend changes to the queries to reduce I/O reads and tempdb usage.

Solution: You recommend defining an external table for the Parquet files and updating the query to use the table

Does this meet the goal?



Answer : B


Question 7

You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset.

You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.

Which type of pool should you recommend?



Answer : D

In Azure Synapse, training machine learning models can be performed on the Apache Spark Pools with tools like PySpark/Python, Scala, or .NET.


Page:    1 / 14   
Total 162 questions