DP-500 V3

You need to provide users with a reproducible method to connect to a data source and transform the data by using an Al function. The solution must meet the following requirement • Minimize development effort. • Avoid including data in the file. Which type of file should you create?A ....

DRAG DROP You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one report. You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast. Which four actions should you perform in sequence?...

DRAG DROP You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in the following table. Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each pool type may be used once, more than once, or...

You have a dataset that contains a table named UserPermissions. UserPermissions contains the following data. You plan to create a security role named User Security for the dataset. You need to filter the dataset based on the current users. What should you include in the DAX expression?A . [UserPermissions] -...

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 ....

What should you configure in the deployment pipeline?A . a backward deploymentB . a selective deploymentC . auto-bindingD . a data source ruleView AnswerAnswer: D Explanation: Development Process Requirements Litware identifies the following development process requirements: SQLDW and datalake1 will act as the development environment. Once feature development is complete,...

You have the following Python code in an Apache Spark notebook. Which type of chart will the code produce?A . a stacked bar chartB . a pie chartC . a bar chartD . an area chartView AnswerAnswer: D Explanation: The matplotlib.pyplot.fill_between function fills the area between two horizontal curves. 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: A

You have a Power Bl data model. You need to refresh the data from the source every 15 minutes. What should you do first?A . Enable the XMLA endpoint.B . Define an incremental refresh policy.C . Change the storage mode of the dataset.D . Configure a scheduled refresh.View AnswerAnswer: D...

DRAG DROP You are using DAX Studio to query an XMLA endpoint. How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used once, more than once. may need to drag the split bar between panes or scroll to view...