The DP-500 practice test trains you in implementing enterprise-scale data analytics solutions in Microsoft Azure and Microsoft Power BI.
Why should I take the DP-500 exam?
The Microsoft DP-500 certification exam has been designed to provide candidates with the uniqueopportunity to demonstrate their subject matterexpertise in implementing enterprise-scale data analytics solutions in Microsoft Azure and Microsoft Power BI. The DP-500 certification exam is aimed at data analysts with advanced Power BI skills and requires you to be able to query and transform data, implement and manage data models, and explore and visualize data. Although there is no official pre-requisite certification to take this exam, the DP-900 would give you a solid foundation in core data concepts and related Microsoft Azure data services. If you pass the DP-500 certification exam, you will obtain the Azure Enterprise Data Analyst Associate certification.
The DP-500 practice test includes two different modes: certification and practice mode. Certification mode allows you to assess your knowledge and discover your weak areas, with practice mode allowing you to focus on the areas that need development.
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.
Practice tests are an informal exam simulation of the actual test that are designed to prepare you better for what to expect on the real exam. A MeasureUp practice test contains approximately 150 questions covering the exam objective domains. In a MeasureUp practice test there are two specific test-taking modes to prepare students for their certification: Certification Mode and Practice Mode.
The Practice Mode allows users to highly customize the testing environment. They may choose how many questions they want to include in their assessment, the maximum time allowed to complete the test, the possibility to randomize the question order, and select how and which questions will be shown in the test.
The Certification Mode simulates the actual testing environment users will encounter when taking a certification exam. They are timed and prevent users from requesting the answers and explanations to questions until after the test.
How does it work?
Take a look at our video to see exactly how MeasureUp’s practice tests work.
Why should you trust MeasureUp over free Learning material?
MeasureUp
Free learning material
A greater number of questions, so more opportunities to learn.
A small proportion of questions to introduce the exam.
Detailed explanations with online references of correct and incorrect answers.
Brief or no explanations of both correct and incorrect answer options.
A total of fourteen different question types.
Limited types of questions out of all the ones you'll find on the exam.
Customize the test based on your needs. Certification & Practice Mode.
Just one type of assessment, without customization options and without a time countdown.
Will studying with a MeasureUp practice test improve my chances of passing at the first attempt?
Yes. MeasureUp's practice tests have beenspeciallydesigned to help you both save time and pass at the first attempt. The test is fully customizable, allowing you to discover and focus on your weak areas. This makes the learning process quicker and smoother. Also, as the style, objectives, question type, and difficulty are the same as those found on the official exam, you can be confident that when you pass the practice test twice in Certification Mode, you are examready.
What can I expect to earn if I pass the DP-500 exam?
On passing the DP-500 and obtaining a job as a mid-level data analyst, you can expect to earn a salary in the United States of approximately $100,000.
Source: Nigel Franks International.
Continue growing with MeasureUp’s learning material. Explore the Data and AI learning path.
The MeasureUp DP-500 practice test is the most realistic simulation of the actual certification exam on the market, giving you the perfect opportunity to pass the official exam on the first go. With our Test Pass Guarantee, you can be sure of success as we offer all of your money back if you do not pass.The DP-500 practice test has been created by leading experts in the field of implementing data analytics solutions in Azure and Power BI.
Why should you trust DP-500 Practice Test fromMeasureUp over free learning material?
The MeasureUp DP-500 practice test possesses many benefits over free learning material, including:
More questions, so more opportunities to learn.
Detailed explanations with online references of correct and incorrect answers.
A total of fourteen different question types, simulating the look and feel of the real exam.
Customizable based on your needs. Certification & Practice Modes.
Test Pass Guarantee.
Created, reviewed, and edited by experts.
How to use the DP-500 Practice Test?
You can use the DP-500 practice test in two different modes: certification and practice mode. The first gives you the possibility to assess your knowledge and discover your areas for development, and the second allows you to focus on these areas, ensuring you spend your time wisely. We first recommend you take the DP-500 practice test in certification mode. By studying the generated report on completing the test, you will get a helpful overview of which areas require further attention. You should then take the test in practice mode in order to develop those areas. Once you are confident you have improved your knowledge in these areas, you can re-take the test in certification mode and, on passing two times in a row with a score of 90%, you know you are examready!
Will the questions be the same as the actual exam?
Although the questions will emulate those of the official exam in terms of style, content, and level of difficulty, for reasons of copyright they will not be identical. This will allow you to fully understand the content you are studying so that, no matter how the questions are focused, you can be confident you are covering the same material and that you will have no problem in passing the exam.
DP-500 CERTIFICATION EXAM
What is the DP-500?
The DP-500 practice test tests your ability to implement enterprise-scale data analytics solutions in Microsoft Azure and Microsoft Power BI.
How difficult is the DP-500?
The DP-500 certification exam is an Associate-level examination, which means it is of an intermediate difficulty within the Azure technology certification path. A less advanced certification within the same learning path is the DP-900.
How to pass DP-500 exam?
Review the DP-500 exam domains carefully.
Create your study plan for your preparation.
Enroll for the MeasureUp practice tests. Our practice tests emulate the actual exam in terms of style, format, skill sets, question structure, and difficulty level, and can be taken in two different formats: practice mode and certification mode.
Practice, practice, practice! After looking at all the questions available in the test, checking the correct answers, reviewing the explanations regarding all the different answer options, and consulting the carefully chosen references, it is now time to use the test’s Certification Mode. This is the closest experience you’ll get to the real exam. And when you pass the Certification Mode twice consecutively with a score of 90% or more, that means you are… Exam ready!
Is DP-500 worth it?
If you want to validate your skills in implementing enterprise-scale data analytics solutions in Microsoft Azure and Microsoft Power BI and be able to gain recognition for your skills and up-to-date knowledge.
How many questions are in the DP-500?
The DP-500 exam contains between 50 and 60 questions.
What is the difference between thePL-300 and the DP-500?
The PL-300 concentrates on self-service analytics in Power BI, whereas the DP-500 is focused on enterprise-scale data analytics.
https://www.measureup.com/microsoft-dp-500-practice-test.html8470Microsoft Practice Test DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI<b>Questions:</b> 120 <br><b>Release Date:</b> 10/2022 <br><b>Job Role:</b> Data Analyst <br><b>Language:</b> English <br><br><p><span class="TextRun SCXW118473430 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW118473430 BCX8">Th</span><span class="NormalTextRun SCXW118473430 BCX8">e DP-</span><span class="NormalTextRun SCXW118473430 BCX8">5</span><span class="NormalTextRun SCXW118473430 BCX8">00 practice</span><span class="NormalTextRun SCXW118473430 BCX8"> test </span><span class="NormalTextRun SCXW118473430 BCX8">contains</span><span class="NormalTextRun SCXW118473430 BCX8"> 1</span><span class="NormalTextRun SCXW118473430 BCX8">20</span><span class="NormalTextRun SCXW118473430 BCX8"> questions and covers the following </span><span class="NormalTextRun SCXW118473430 BCX8">objectives</span><span class="NormalTextRun SCXW118473430 BCX8">:</span></span><span class="EOP SCXW118473430 BCX8" data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></p>
<h3><span class="TextRun SCXW78902027 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW78902027 BCX8" data-ccp-parastyle="heading 1">Implement and manage a data analytics environment –33 </span><span class="NormalTextRun SCXW78902027 BCX8" data-ccp-parastyle="heading 1">questions</span></span><span class="EOP SCXW78902027 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":240,"335559739":0,"335559740":259}"> </span></h3>
<h4><span style="color: #0780c2; line-height: 10px;"><span class="TextRun SCXW120651955 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW120651955 BCX8" data-ccp-parastyle="heading 2">Govern and administer a data analytics </span><span class="NormalTextRun SCXW120651955 BCX8" data-ccp-parastyle="heading 2">environment</span><span class="NormalTextRun SCXW120651955 BCX8" data-ccp-parastyle="heading 2"> </span></span><span class="EOP SCXW120651955 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></h4>
<ul style="font-weight: 400;">
<li data-leveltext="" data-font="Symbol" data-listid="88" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Manage Power BI assets by using Azure Purview </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="88" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Identify data sources in Azure by using Azure Purview </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="88" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Recommend settings in the Power BI admin portal </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="88" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Recommend a monitoring and auditing solution for a data analytics environment, including Power BI REST API and PowerShell cmdlets </span></li>
</ul>
<p> </p>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW66304830 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW66304830 BCX8">Integrate an analytics platform into an existing IT </span><span class="NormalTextRun SCXW66304830 BCX8">infrastructure</span></span><span class="TextRun SCXW66304830 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW66304830 BCX8"> </span></span><span class="EOP SCXW66304830 BCX8" data-ccp-props="{"201341983":0,"335559685":0,"335559739":160,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="89" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Identify requirements for a solution, including features, performance, and licensing strategy </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="89" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Configure and manage Power BI capacity </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="89" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Recommend and configure an on-premises gateway in Power BI </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="89" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Recommend and configure a Power BI tenant or workspace to integrate with Azure Data Lake Storage Gen2 </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="89" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="5" data-aria-level="1"><span data-contrast="auto">Integrate an existing Power BI workspace into Azure Synapse Analytics </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
</ul>
<p> </p>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW174966051 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW174966051 BCX8" data-ccp-parastyle="heading 2">Manage the analytics development </span><span class="NormalTextRun SCXW174966051 BCX8" data-ccp-parastyle="heading 2">lifecycle</span><span class="NormalTextRun SCXW174966051 BCX8" data-ccp-parastyle="heading 2"> </span></span><span class="EOP SCXW174966051 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":40,"335559739":0,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="90" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Commit code and artifacts to a source control repository in Azure Synapse Analytics </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="90" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Recommend a deployment strategy for Power BI assets </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="90" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Recommend a source control strategy for Power BI assets </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="90" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Implement and manage deployment pipelines in Power BI </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
</ul>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="90" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Perform impact analysis of downstream dependencies from dataflows and datasets </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="90" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Recommend automation solutions for the analytics development lifecycle, including Power BI REST API and PowerShell cmdlets </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="90" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Deploy and manage datasets by using the XMLA endpoint </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="90" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Create reusable assets, including Power BI templates, Power BI data source (.pbids) files, and shared datasets </span></li>
</ul>
<p> </p>
<h3><span class="TextRun SCXW42865325 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW42865325 BCX8" data-ccp-parastyle="heading 1">Query and transform data</span><span class="NormalTextRun SCXW42865325 BCX8" data-ccp-parastyle="heading 1"> –28 </span><span class="NormalTextRun SCXW42865325 BCX8" data-ccp-parastyle="heading 1">questions</span></span><span class="EOP SCXW42865325 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":240,"335559739":0,"335559740":259}"> </span></h3>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW172972200 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW172972200 BCX8">Query data by using Azure Synapse Analytics </span></span><span class="EOP SCXW172972200 BCX8" data-ccp-props="{"201341983":0,"335559685":10,"335559739":160,"335559740":257,"335559991":10}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="91" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Identify an appropriate Azure Synapse pool when analyzing data </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="91" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Recommend appropriate file types for querying serverless SQL pools </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="91" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Query relational data sources in dedicated or serverless SQL pools, including querying partitioned data sources </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="91" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Use a machine learning </span><span data-contrast="auto">PREDICT </span><span data-contrast="auto">function in a query </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
</ul>
<p><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></p>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW26008655 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW26008655 BCX8">Ingest and transform data by using Power BI </span></span><span class="EOP SCXW26008655 BCX8" data-ccp-props="{"201341983":0,"335559685":0,"335559739":160,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="92" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Identify data loading performance bottlenecks in Power Query or data sources </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="92" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Implement performance improvements in Power Query and data sources </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="92" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Create and manage scalable Power BI dataflows </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="92" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Identify and manage privacy settings on data sources </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="92" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Create queries, functions, and parameters by using the Power Query Advanced Editor </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="92" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Query advanced data sources, including JSON, Parquet, APIs, and Azure Machine Learning models </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
</ul>
<p> </p>
<h3><span class="TextRun SCXW198002359 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW198002359 BCX8" data-ccp-parastyle="heading 1">Implement and manage data models</span><span class="NormalTextRun SCXW198002359 BCX8" data-ccp-parastyle="heading 1"> –30 </span><span class="NormalTextRun SCXW198002359 BCX8" data-ccp-parastyle="heading 1">questions</span><span class="NormalTextRun SCXW198002359 BCX8" data-ccp-parastyle="heading 1"> </span></span><span class="EOP SCXW198002359 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":240,"335559739":0,"335559740":259}"> </span></h3>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW30088224 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW30088224 BCX8">Design and build tabular </span><span class="NormalTextRun SCXW30088224 BCX8">models</span><span class="NormalTextRun SCXW30088224 BCX8"> </span></span><span class="EOP SCXW30088224 BCX8" data-ccp-props="{"201341983":0,"335559685":10,"335559739":160,"335559740":257,"335559991":10}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="93" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Choose when to use DirectQuery for Power BI datasets </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="93" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Choose when to use external tools, including DAX Studio and Tabular Editor 2 </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="93" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Create calculation groups </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="93" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Write calculations that use DAX variables and functions, for example handling blanks or errors, creating virtual relationships, and working with iterators </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="93" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Design and build a large format dataset </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="93" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Design and build composite models, including aggregations </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="93" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Design and implement enterprise-scale row-level security and object-level security </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
</ul>
<p> </p>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW239013844 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW239013844 BCX8">Optimize enterprise-scale data </span><span class="NormalTextRun SCXW239013844 BCX8">models</span><span class="NormalTextRun SCXW239013844 BCX8"> </span></span><span class="EOP SCXW239013844 BCX8" data-ccp-props="{"201341983":0,"335559685":0,"335559739":160,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="94" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Identify and implement performance improvements in queries and report visuals</span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="94" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Troubleshoot DAX performance by using DAX Studio </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="94" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Optimize a data model by using Tabular Editor 2 </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="94" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Analyze data model efficiency by using VertiPaq Analyzer </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="94" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Implement incremental refresh </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="94" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Optimize a data model by using denormalization </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
</ul>
<p> </p>
<h3><span class="TextRun SCXW198002359 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW198002359 BCX8" data-ccp-parastyle="heading 1"><span class="TextRun SCXW21455797 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="auto"><span class="NormalTextRun SCXW21455797 BCX8" data-ccp-parastyle="heading 1">Explore and visualize data</span><span class="NormalTextRun SCXW21455797 BCX8" data-ccp-parastyle="heading 1"> –29 </span><span class="NormalTextRun SCXW21455797 BCX8" data-ccp-parastyle="heading 1">questions</span><span class="NormalTextRun SCXW21455797 BCX8" data-ccp-parastyle="heading 1"> </span></span><span class="EOP SCXW21455797 BCX8" data-ccp-props="{"134245418":true,"134245529":true,"201341983":0,"335559738":240,"335559739":0,"335559740":259}"> </span></span></span></h3>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW16226003 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW16226003 BCX8">Explore data by using Azure Synapse Analytics </span></span><span class="EOP SCXW16226003 BCX8" data-ccp-props="{"201341983":0,"335559685":10,"335559739":160,"335559740":257,"335559991":10}"> </span></span></h4>
<ul style="font-weight: 400;">
<li data-leveltext="" data-font="Symbol" data-listid="95" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Explore data by using native visuals in Spark notebooks </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="95" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Explore and visualize data by using the Azure Synapse SQL results pane </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
</ul>
<p> </p>
<h4 aria-level="3"><span style="color: #0780c2;"><span class="TextRun SCXW42942261 BCX8" lang="EN-US" xml:lang="EN-US" data-contrast="none"><span class="NormalTextRun SCXW42942261 BCX8">Visualize data by using Power BI </span></span><span class="EOP SCXW42942261 BCX8" data-ccp-props="{"201341983":0,"335559685":0,"335559739":160,"335559740":259}"> </span></span></h4>
<ul>
<li data-leveltext="" data-font="Symbol" data-listid="96" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Create and import a custom report theme </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="96" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Create R or Python visuals in Power BI </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="96" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Connect to and query datasets by using the XMLA endpoint </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="96" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Design and configure Power BI reports for accessibility </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="96" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Enable personalized visuals in a report </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="96" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Configure automatic page refresh </span><span data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="96" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":720,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Create and distribute paginated reports in Power BI Report Builder</span></li>
</ul>
<p><span data-ccp-props="{"201341983":0,"335559739":0,"335559740":240}"> </span></p>
<p><strong>Notes:</strong></p>
<ul style="font-weight: 400;">
<li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":360,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">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.</span><span data-ccp-props="{"201341983":0,"335559685":720,"335559739":0,"335559740":240}"> </span></li>
<li data-leveltext="" data-font="Symbol" data-listid="17" data-list-defn-props="{"335552541":1,"335559684":-2,"335559685":360,"335559991":360,"469769226":"Symbol","469769242":[8226],"469777803":"left","469777804":"","469777815":"hybridMultilevel"}" aria-setsize="-1" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Most questions cover features that are general availability (GA). The exam may contain questions on Preview features if those features are commonly used.</span><span data-ccp-props="{"201341983":0,"335559685":720,"335559739":0,"335559740":240}"> </span></li>
</ul>
<p> </p>
<p> </p> <u><a target="_blank" href="https://docs.measureup.com/knowledgebase/system-requirements/">System Requirements</a></u>https://www.measureup.com/media/catalog/product/m/i/microsoft_dp-500_pt_1.png69.3instock9969.33029.7Microsoft151https://www.measureup.com/media/catalog/product/m/i/microsoft_dp-500_pt_1.png8485/measureup/measureup/Microsoft/measureup/Microsoft/Microsoft Technical/measureup/Microsoft/Microsoft Technical/Microsoft Practice Tests2022-10-26T06:46:07+0000