Description

Questions: 120
Release Date: 10/2022
Job Role: Data Analyst
Language: English

The DP-500 practice test contains 120 questions and covers the following objectives: 

Implement and manage a data analytics environment –33 questions 

Govern and administer a data analytics environment  

• Manage Power BI assets by using Azure Purview   
• Identify data sources in Azure by using Azure Purview  
• Recommend settings in the Power BI admin portal  
• Recommend a monitoring and auditing solution for a data analytics environment, including Power BI REST API and PowerShell cmdlets 

Integrate an analytics platform into an existing IT infrastructure  

• Identify requirements for a solution, including features, performance, and licensing strategy  
• Configure and manage Power BI capacity  
• Recommend and configure an on-premises gateway in Power BI  
• Recommend and configure a Power BI tenant or workspace to integrate with Azure Data Lake Storage Gen2  
• Integrate an existing Power BI workspace into Azure Synapse Analytics  

Manage the analytics development lifecycle  

• Commit code and artifacts to a source control repository in Azure Synapse Analytics  
• Recommend a deployment strategy for Power BI assets  
• Recommend a source control strategy for Power BI assets  
• Implement and manage deployment pipelines in Power BI  

• Perform impact analysis of downstream dependencies from dataflows and datasets   
• Recommend automation solutions for the analytics development lifecycle, including Power BI REST API and PowerShell cmdlets   
• Deploy and manage datasets by using the XMLA endpoint  
• Create reusable assets, including Power BI templates, Power BI data source (.pbids) files, and shared datasets 

Query and transform data –28 questions 

Query data by using Azure Synapse Analytics  

• Identify an appropriate Azure Synapse pool when analyzing data  
• Recommend appropriate file types for querying serverless SQL pools  
• Query relational data sources in dedicated or serverless SQL pools, including querying partitioned data sources  
• Use a machine learning PREDICT function in a query  

Ingest and transform data by using Power BI  

• Identify data loading performance bottlenecks in Power Query or data sources  
• Implement performance improvements in Power Query and data sources  
• Create and manage scalable Power BI dataflows  
• Identify and manage privacy settings on data sources  
• Create queries, functions, and parameters by using the Power Query Advanced Editor 
• Query advanced data sources, including JSON, Parquet, APIs, and Azure Machine Learning models  

Implement and manage data models –30 questions  

Design and build tabular models   

• Choose when to use DirectQuery for Power BI datasets   
• Choose when to use external tools, including DAX Studio and Tabular Editor 2  
• Create calculation groups  
• Write calculations that use DAX variables and functions, for example handling blanks or errors, creating virtual relationships, and working with iterators  
• Design and build a large format dataset  
• Design and build composite models, including aggregations  
• Design and implement enterprise-scale row-level security and object-level security  

Optimize enterprise-scale data models  

• Identify and implement performance improvements in queries and report visuals 
• Troubleshoot DAX performance by using DAX Studio   
• Optimize a data model by using Tabular Editor 2  
• Analyze data model efficiency by using VertiPaq Analyzer  
• Implement incremental refresh  
• Optimize a data model by using denormalization  

Explore and visualize data –29 questions  

Explore data by using Azure Synapse Analytics  

• Explore data by using native visuals in Spark notebooks   
• Explore and visualize data by using the Azure Synapse SQL results pane  

Visualize data by using Power BI  

• Create and import a custom report theme  
• Create R or Python visuals in Power BI  
• Connect to and query datasets by using the XMLA endpoint  
• Design and configure Power BI reports for accessibility  
• Enable personalized visuals in a report  
• Configure automatic page refresh  
• Create and distribute paginated reports in Power BI Report Builder

Notes:

• The bullets that follow each of the skills measured are intended to illustrate how we are assessing that skill. Related topics may be covered in the exam. 
• Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.