Free Microsoft DP-500 Exam Dumps Questions & Answers

You have a Power BI tenant.
You plan to register the tenant in an Azure Purview account.
You need to ensure that you can scan the tenant by using Azure Purview.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.From the Power Bl Admin center, set Share content with external users to Enabled.
• B.From the Power Bl Admin center, set Allow live connections to Enabled.
• C.From the Power Bl Admin center, set Allow service principals to use read-only Power Bl admin APIs to Enabled.
• D.From the Azure Active Directory admin center, create a security group.
• E.From the Microsoft 365 admin center, create a Microsoft 365 group.

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?

• A.Search the data catalog.
• B.Create a data policy.
• C.Register a data source.
• D.Create a data share connection.

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?

• A.displayHTML()
• B.%%lsmagic
• C.%%configure
• D.display(df)
• E.display(df, summary=true)

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 Query query in a Power Bl report. The query maps source database columns to the input columns of a time series machine learning model.
You discover that the model fails to process a source time field.
You need to ensure that the model processes the field.
Solution: You add a Power Query step to convert the time column into an integer column that represents the number of seconds.
Does this meet the requirement?

• A.No
• B.Yes

You open a Power Bl Desktop report that contains an imported data model and a single report page.
You open Performance analyzer, start recording, and refresh the visuals on the page. The recording produces the results shown in the following exhibit

What can you identify from the results?

• A.Unoptimized DAX queries cause the page to load slowly.
• B.The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
• C.The Actual/Forecast Billable Hrs YTD visual displays the most data.
• D.When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.