Microsoft DP-500 Practice Test - Questions Answers, Page 14

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 ft. As a result, these questions will not appear in the review screen.

From Power Query Editor, you profile the data shown in 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 split the loT DateTime column into a column named Date and a column named Time.

Does this meet the goal?

You deploy a tabular model named DM! to a Power Bl Premium capacity. DM1 was created as an import model.

You change a fact table named Table1 into a hybrid table.

What else occurred on DM1 automatically after the change?

You have a Power Bl 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 Bl Admin portal? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

HOTSPOT

You are enhancing a Power Bl model that has DAX calculations.

You need to create a DAX measure that returns the year-to-date total sales from the same date from the previous calendar year.

How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power Bl report hosted on the Power Bl service. The report displays expenses by department for department managers and contains a line chart that shows expenses by month. You need to ensure that users can choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?

You have an Azure Synapse Analytics dedicated SQL pool and a Microsoft Purview account. The Microsoft Purview account has been granted sufficient permissions to the dedicated SQL pool. You need to ensure that the SQL pool is scanned by Microsoft Purview.

What should you do first?

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

HOTSPOT

You have an Azure Synapse Analytics workspace that contains an Apache Spark pool. You create a notebook and configure a cell that runs the following SparkSQL query.

SELECT ProductID, ProductName, Category From products.

You need to create a column chart by using the built-in charting capability. The solution must visualize the distribution of product IDs across product categories.

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?