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

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.

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.

From Power Query Editor, you profile the data s

the following exhibit

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

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

Solution: You change the loT DateTime column to the date data type.

Does this meet the goal?

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

You need to use Power Bl to ingest data from an API. The API requires that an API key be passed in the headers of the request.

Which type of authentication should you use?

You have a Power Bl tenant.

You need to ensure that all reports use a consistent set of co applied to existing reports.

colors and fonts. The solution must ensure that the colors and fonts can be

What should you create?

You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data.

You need to review statistics for a DataFrame that includes:

The column name

The column type

The number of distinct values

Whether the column has missing values

Which function should you use?

You have two Power BI reports named Report1 and Report2.

Report1 connects to a shared dataset named Dataset1.

Report2 connects to a local dataset that has the same structure as Dataset1. Report2 contains several calculated tables and parameters.

You need to prepare Report2 to use Dataset1.

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

NOTE: Each correct selection is worth one point.