DP-500 Exam Questions

You have a Power BI dataset. The dataset contains data that is updated frequently. You need to improve the performance of the dataset by using incremental refreshes. Which four act...

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

You have the following code in an Azure Synapse notebook. ```python import matplotlib.pyplot as plt x1 = [2, 3, 4] y1 = [5, 9, 5] x2 = [1, 2, 3, 4, 5] y2 = [2, 3, 4] y3 = [6, 8, 7]...

You have the following code in an Azure Synapse notebook: ```python import matplotlib.pyplot as plt x1 = [1, 3, 4, 5, 6, 7, 9] y1 = [4, 7, 2, 4, 7, 8, 3] x2 = [2, 4, 6, 8, 10] y2 =...

You are creating a Power BI Desktop report. You add a Python visual to the report page. You plan to create a scatter chart to visualize the data. You add Python code to the Python...

You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements: - Code must always be merged to the main branch befo...

You need to recommend an automated solution to monitor Power BI user activity. The solution must meet the following requirements: - Security admins must identify when users export...

Based on a query dependency diagram where 'Orders' is load-disabled and dependent queries 'Order Details', 'Customer', 'Shipper' are loaded, when the dataset refreshes, the Orders...

Based on a query dependency diagram, which action will reduce data refresh times for this model?

You are configuring Azure Synapse Analytics pools to support an Azure Active Directory group (Group1) with the requirement to 'Analyze data to create and train machine learning mod...

You are configuring Azure Synapse Analytics pools to support an Azure Active Directory group (Group2) with the requirement to 'Execute complex queries with multiple joins against r...

You are configuring Azure Synapse Analytics pools to support an Azure Active Directory group (Group3) with the requirement to 'Query and load data from Apache Parquet files stored...

You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. Sample data for Sales (OrderID, SalesPerson, Amount) and Commis...

You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. Sample data for Sales (OrderID, SalesPerson, Amount) and Commis...

You are building a Power BI dataset with a Calendar table and a calculated column `pfFlag = IF ('Calendar'[Date] < TODAY(), "Past", "Future")`. You need a measure for fiscal prior...

You are building a Power BI dataset with a Calendar table and a calculated column `pfFlag = IF ('Calendar'[Date] < TODAY(), "Past", "Future")`. You need a measure for fiscal prior...

You plan to create a Power BI report that will use an OData feed as the data source. You will retrieve all the entities from two different collections by using the same service roo...

The query uses the hierarchical namespace of the storage account. Select Yes if the statement is true. Otherwise, select No.

The query uses a custom function to load file data. Select Yes if the statement is true. Otherwise, select No.

Changing the source to use AzureStorage.DataLake will reduce the load time of the query. Select Yes if the statement is true. Otherwise, select No.

You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements. What should you do?

Which three actions should you include in the recommendation? Each correct answer presents part of the solution.

How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?

You need to create a measure to count orders for the market basket analysis. How should you complete the DAX expression? To answer, select the appropriate options in the answer are...

You need to identify the root cause of the data refresh issue. What should you use?

Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution.

You need to recommend a solution to resolve the query issue of the serverless SQL pool. The solution must minimize impact on the users. What should you do?

The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.) You need to minimize the model size by eliminating invalid relationsh...

You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset. You need to recommend an Azure Synapse Analytics pool f...

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

BI service to an Azure SQL database since the creation of the deployment pipeline. An investigation into the issue identifies the following: - One of the datasets is larger than 1...

You have a Power BI report that contains a bar chart. The bar chart displays sales by country. You need to ensure that a summary of the data shown on the bar chart is accessible by...

You have an Azure Synapse Analytics dedicated SQL pool and a Microsoft Purview account. The Microsoft Purview account has been granted sufficient permissions to the dedicated SQL p...

You have a Power BI tenant. You need to ensure that all reports use a consistent set of colors and fonts. The solution must ensure that the colors and fonts can be applied to exist...

You need to use Power BI to ingest data from an API. The API requires that an API key be passed in the headers of the request. Which type of authentication should you use?

The IoT GUID and IoT ID columns are unique to each row in the query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance....

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

You have a Power BI report hosted on the Power BI service. The report displays expenses by department for department managers and contains a line chart that shows expenses by month...

You have a PostgreSQL database named db1. You have a group of data analysts that will create Power BI datasets. Each analyst will use data from a different schema in db1. You need...

Hotspot Question You are creating a Power BI dataset from a data source. You want to publish this dataset to Power BI in order to build reports in Azure Synapse Studio. You create...

You need to verify that your PBIDS file is functional. For each of the following statements, select Yes if the statement is true. Otherwise, select No. ```yaml version: "0.1", conn...

Which of the following service or tools enables you to scan the entire Power BI Tenant and browse Power BI assets, explore enhanced Power BI dataset metadata, and visualize end-to-...

You are assigned to explore data by using Azure Synapse Analytics. You have decided to use Synapse Spark notebook to explore the data. You can read the data using Spark's Dataframe...

Which of the following file types is NOT supported by the Serverless SQL Pool in Azure Synapse Analytics?

Assume that you are the only Azure Enterprise Data Analyst in your team. Your Project Manager has asked you to look at some techniques to improve data loading for relational data s...

Which of the following is not a valid option to analyze data using Azure Synapse Analytics?

Which of the two scenarios from the list below can be implemented using DirectQuery mode in Power BI? (Choose two) A. When a report needs to be refreshed frequently based on the us...

As a Lead Azure Enterprise Data Analyst, you have been asked to select an external tool that can support the features or functionalities listed below: - Ability to easily build, ma...

Assume that you are responsible for designing a deployment pipeline for your project's Power BI assets. As part of the deployment strategy which item from the following list CAN NO...

As an Azure enterprise Data Analyst, you are assigned to create a custom theme that can be used for your Power BI Reports. You have decided to create a new theme that matches your...