DP-500

DRAG DROP You have a Power Bl dataset. The dataset contains data that is updated frequently. You need to improve the performance of the dataset by using incremental refreshes. Which four actions should you perform in sequence to enable the incremental refreshes? To answer, move the appropriate actions from the...

You have an Azure Synapse Analytics dedicated SQL pool. You need to ensure that the SQL pool is scanned by Azure Purview. What should you do first?A . Register a data source.B . Search the data catalog.C . Create a data share connection.D . Create a data policy.View AnswerAnswer: B

You are configuring a Power Bl report for accessibility as shown in the following table. You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency . Which two settings should you configure in the Customize theme...

You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses Import storage mode. You need to ensure that the report page updates all the visuals every 30 minutes . Which two actions should you perform? Each correct answer presents part of the...

You need to recommend a solution for the customer workspaces to support the planned changes. Which two configurations should you include in the recommendation? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . Set Use datasets across workspaces to EnabledB . Publish...

You have a Power Bl report that contains one visual. You need to provide users with the ability to change the visual type without affecting the view for other users. What should you do?A . From Report setting, select Personalize visuals.B . From Tabular Editor, create a new perspective.C ....

DRAG DROP You are using DAX Studio to query an XMLA endpoint. You need to identify the duplicate values in a column named Email in a table named Subscription. How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used...

HOTSPOT You need to populate the CustomersWithProductScore table. How should you complete the stored procedure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:

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?A . freqltemsB . explainC . rollupD . summaryView AnswerAnswer: D

You have a Power Bl dataset that uses DirectQuery against an Azure SQL database. Multiple reports use the dataset. A database administrator reports that too many queries are being sent from Power Bl to the database. You need to reduce the number of queries sent to the database. The solution...