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

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.

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?

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?

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 shown in the following exhibit.

From Power Query Editor, you profile the data shown in the following exhibit

The loT GUIO 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 remove the loT GUID column and retain the loT ID column.

Does this meet the goal?

You have an Azure subscription that contains an Azure Synapse Analytics workspace. You create an Azure Data Lake and upload a CSV file named Filel.csv. You need to use Synapse Studio to query the data in Filel.csv by using a serverless SQL pool. Which Transact-SQL operator should you include in the query?

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?

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?