DP-500 Exam Questions

What should you configure in the deployment pipeline?

You need to implement object-level security (OLS) in the Power BI dataset for the sales associates. Which three actions should you perform in sequence? To answer, move the appropri...

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

You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative eff...

You need to recommend a solution to add new fields to the financial data Power BI dataset with data from the Microsoft SQL Server data warehouse. What should you include in the rec...

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

You need to integrate the external data source to support the planned changes. Which three actions should you perform in sequence? To answer, move the appropriate actions from the...

You have the following Python code in an Apache Spark notebook. ```python import matplotlib.pyplot as plt import numpy as np ys = 100 * np.random.rand(100) x = [x for x in range(le...

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

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

You have a kiosk that displays a Power BI report page. The report uses a dataset that uses Import storage mode. You need to ensure that the report page updates all the visuals ever...

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?

You have a Power BI 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:...

You need to provide users with a reproducible method to connect to a data source and transform the data by using an AI function. The solution must meet the following requirement: -...

You are planning a Power BI solution for a customer. The customer will have 200 Power BI users. The customer identifies the following requirements: - Ensure that all the users can...

You have a 1.2-GB Power BI dataset. You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes...

You have live Power BI reports that contain R script data sources and R visuals. You need to publish the reports to the Power BI service and configure a daily refresh of datasets....

You have new security and governance protocols for Power BI reports and datasets. The new protocols must meet the following requirements: - New reports can be embedded only in loca...

You have an Azure Synapse Analytics serverless SQL pool. You need to catalog the serverless SQL pool by using Azure Purview. Which three actions should you perform? Each correct an...

You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will contain more than 20 million rows partitioned by date. The table will be...

You have a Power BI dataset named Dataset1 that uses DirectQuery against an Azure SQL database named DB1. DB1 is a transactional database in the third normal form. You need to reco...

You are building a Power BI dataset that will use two data sources. The dataset has a query that uses a web data source. The web data source uses anonymous authentication. You need...

You have a file named File1.txt that has the following characteristics: - A header row - Tab delimited values - UNIX-style line endings You need to read File1.txt by using an Azure...

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

Users indicate that when they build reports from the data model, the reports take a long time to load. You need to recommend a solution to reduce the load times of the reports. Sol...

You have a Power BI dataset named Dataset1. In Dataset1, you currently have 50 measures that use the same time intelligence logic. You need to reduce the number of measures, while...

You have a Power BI dataset named Dataset1. In Dataset1, you currently have 50 measures that use the same time intelligence logic. You need to reduce the number of measures, while...

You have a Power BI dataset named Dataset1. In Dataset1, you currently have 50 measures that use the same time intelligence logic. You need to reduce the number of measures, while...

You open a Power BI 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 pag...

You have a Power BI dataset that contains the following measure. YTD Year-over-Year Var = DIVIDE ( ( [Sales Amount] - CALCULATE ( [Sales], SAMEPERIODLASTYEAR ( 'Calendar'[Date] ),...

You are implementing a reporting solution that has the following requirements: - Reports for external customers must support 500 concurrent requests. - The data for these reports i...

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

You discover a poorly performing measure in a Power BI data model. You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engin...

You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join operations in the query. What should you review?

You need to store Power BI dataflows in an Azure Storage account. Which two prerequisites are required to support the configuration? Each correct answer presents part of the soluti...

You have a Power BI tenant that contains 10 workspaces. You need to create dataflows in three of the workspaces. The solution must ensure that data engineers can access the resulti...

You plan to modify a Power BI dataset. You open the Impact analysis panel for the dataset and select Notify contacts. Which contacts will be notified when you use the Notify contac...

You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need to modify the source control solution to use an Azure DevOps Git repository. What...

You manage a Power BI workspace named Workspace1 that contains five dataflows. You need to configure Workspace1 to store the dataflows in an Azure Data Lake Storage Gen2 account. W...

You are creating a Power BI single-page report. Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader. You need...

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual. What should...

You have a Power BI dataset that has only the necessary fields visible for report development. You need to ensure that end users see only 25 specific fields that they can use to pe...

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consum...

You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache Parquet format. A sample of the data is shown in the following table. You n...

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

You are optimizing a dataflow in a Power BI Premium capacity. The dataflow performs multiple joins. You need to reduce the load time of the dataflow. Which two actions should you p...

Users indicate that when they build reports from the data model, the reports take a long time to load. You need to recommend a solution to reduce the load times of the reports. Sol...

You have a Power BI dataset that contains the following measures: - Budget - Actuals - Forecast You need provide users with the ability to use a slicer to switch between the measur...

You have a Power BI 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...

The detail table is named FactSales and the aggregation table is named FactSales(Agg). You need to aggregate SalesAmount for each store. Which type of summarization should you use...