Deal of the Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft DP-500 Exam

Certification Provider: Microsoft
Exam Name: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Number of questions in our database: 114
Exam Version: May. 28, 2023
DP-500 Exam Official Topics:
  • Topic 1: Perform impact analysis of downstream dependencies from dataflows and datasets/ Manage Power BI assets by using Azure Purview
  • Topic 2: Create queries, functions, and parameters by using the Power Query Advanced Editor/ Identify and implement performance improvements in queries and report visuals
  • Topic 3: Identify requirements for a solution, including features, performance, and licensing strategy/ Recommend and configure an on-premises gateway in Power BI
  • Topic 4: Identify data loading performance bottlenecks in Power Query or data sources/ Integrate an existing Power BI workspace into Azure Synapse Analytics
  • Topic 5: Explore and visualize data by using the Azure Synapse SQL results pane/ Deploy and manage datasets by using the XMLA endpoint
  • Topic 6: Integrate an analytics platform into an existing IT infrastructure/ Create and distribute paginated reports in Power BI Report Builder
  • Topic 7: Recommend appropriate file types for querying serverless SQL pools/ Commit code and artifacts to a source control repository in Azure Synapse Analytics
  • Topic 8: Design and configure Power BI reports for accessibility/ Implement performance improvements in Power Query and data sources
  • Topic 9: Design and implement enterprise-scale row-level security and object-level security/ Analyze data model efficiency by using VertiPaq Analyzer
  • Topic 10: Query advanced data sources, including JSON, Parquet, APIs, and Azure Machine Learning models/ Connect to and query datasets by using the XMLA endpoint
  • Topic 11: Identify an appropriate Azure Synapse pool when analyzing data/ Design and build composite models, including aggregations
  • Topic 12: Explore data by using native visuals in Spark notebooks/ Explore data by using Azure Synapse Analytics

Free Microsoft DP-500 Exam Actual Questions

The questions for DP-500 were last updated On May. 28, 2023

Question #1

You are creating a Power 81 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 to ensure that the users can consume content on a report page in a logical order.

What should you configure on the report page?

Reveal Solution Hide Solution
Correct Answer: D

Tab order is the order in which users interact with the items on a page using the keyboard. Generally, we want tab order to be predictable and to closely match the visual order on the page (unless there is a good reason to deviate).

Note: If you are using the keyboard to navigate in a Power BI report, the order in which you arrive at visuals will not follow your vision unless you set the new tab order property. If you have low or no vision, this becomes an even bigger issue because you may not be able to see that you are navigating visuals out of visual order because the screen reader just reads whatever comes next.

Question #2

You have a Power BI Premium capacity.

You need to increase the number of virtual cores associated to the capacity.

Which role do you need?

Reveal Solution Hide Solution
Correct Answer: D

Change capacity size

Power BI admins and global administrators can change Power BI Premium capacity. Capacity admins who are not a Power BI admin or global administrator don't have this option.

Question #3

You are attempting to configure certification for a Power BI dataset and discover that the certification setting for the dataset is unavailable.

What are two possible causes of the issue? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution
Question #4

You have a Power Bl report that contains the table shown in the following exhibit.

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 consumers of reports who have color vision deficiency. What should you do?

Reveal Solution Hide Solution
Correct Answer: A

Report accessibility checklist, All Visuals.

* Ensure alt text is added to all non-decorative visuals on the page.

* Avoid using color as the only means of conveying information. Use text or icons to supplement or replace the color.

* Check that your report page works for users with color vision deficiency.

* Etc.

Question #5

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 method should you invoke on the DataFrame?

Reveal Solution Hide Solution
Correct Answer: B

pandas.DataFrame.corr computes pairwise correlation of columns, excluding NA/null values.


* freqItems


Finding frequent items for columns, possibly with false positives. Using the frequent element count algorithm described in, proposed by Karp, Schenker, and Papadimitriou.'

* summary is used for index.

* There is no panda method for rollup. Rollup would not be correct anyway.

Unlock all DP-500 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now
Disscuss Microsoft DP-500 Topics, Questions or Ask Anything Related

Save Cancel