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

The enterprise analytics team needs to notify the report owners of the planned changes. The solution must minimize administrative effort.What should the team do?

• Locate all the downstream reports, identify all the users That are assigned the Admin role, and then send an email to each user.
• Write a PowerShell script to access the Power Bl API that retrieves a list of downstream reports and a list of workspace administrators, and then send an email to each workspace administrator.
• Perform impact analysis on the Financial Model dataset to notify the workspace contacts.
• Perform impact analysis feature on the lake database data source to notify the workspace contacts.

You use Azure Synapse Analytics and Apache Spark notebooks to You need to use PySpark to gain access to the visual libraries. Which Python libraries should you use?

• Seaborn only
• Matplotlib and Seaborn
• Matplotlib only
• Matplotlib and TensorFlow
• TensorFlow only
• Seaborn and TensorFlow

You are optimizing a Power Bl data model by using DAX Studio.You need to capture the query events generated by a Power Bl Desktop report. What should you use?

• the DMV list
• a Query Plan trace
• an All Queries trace
• a Server Timings trace

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.

• consistent colors for each visual
• consistent fonts for each visual
• alt text for each visual
• the tab order for each page
• Play Axis for each page

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?

• freqlcems
• cov
• summary
• rollup

The enterprise analytics team needs to resolve the DAX measure performance issues. What should the team do first?

• Use Performance analyzer in Power Bl Desktop to get the DAX durations.
• Use DAX Studio to get detailed statistics on the server timings.
• Use DAX Studio to review the Vertipaq Analyzer metrics.
• Use Tabular Editor to create calculation groups.

You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?

• PIVOT
• GROUPING
• PREDICT
• CAST

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?

• freqItems
• corr
• sample
• describe

You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset.During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB."You need to ensure that you can refresh the dataset. What should you do?

• Turn on Large dataset storage format.
• Connect Workspace1 to an Azure Data Lake Storage Gen2 account
• Change License mode to Premium per user.
• Change the location of the Premium capacity.

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?

• freqltems
• explain
• rollup
• describe