Tag - DP-500 exam

You have a Power Bl workspace that contains one dataset and four reports that connect to the dataset. The dataset uses Import storage mode and contains the following data sources: • A CSV file in an Azure Storage account • An Azure Database for PostgreSQL database You plan to use...

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 need to recommend changes to the Power Bl tenant to meet the technical requirements for external data sharing. Which tenant setting should you recommend disabling?A . Allow shareable links to grant access to everyone in your organizationB . Allow Azure Active Directory guest users to edit and manage content...

You are creating a Python visual in Power Bl Desktop. You need to retrieve the value of a column named Unit Price from a DataFrame. How should you reference the Unit Price column in the Python code?A . pandas.DataFrame('Unit Price')B . dataset['Unit Price']C . data = [Unit Price]D . ('Unit...

HOTSPOT You need to recommend a security solution for the Power Bl tenant to control external data sharing. The solution must meet the technical requirements. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:

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

HOTSPOT You need to build a Transact-SQL query to implement the planned changes for the internal users. How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: PREDICT Provide internal...

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

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 need to optimize the workflow for the creation of reports and the adjustment of tables by the enterprise analytics team. What should you do?A . Add a tenant-level storage connection to Power BlB . Create a linked service in workspace1.C . Create an integration runtime in workspace1.D . From...