New (2024) Download free DP-500 PDF for Microsoft Practice Tests
100% Free DP-500 Files For passing the exam Quickly
Microsoft DP-500 certification exam is designed for professionals who are interested in demonstrating their expertise in designing and implementing enterprise-scale analytics solutions using Microsoft Azure and Microsoft Power BI. Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI certification is ideal for individuals who are seeking to demonstrate their skills in data engineering, data analysis, and visualization using Microsoft technologies.
NEW QUESTION # 83
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions
will not appear in the review screen.
You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files
by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business
names, survey names, and participant counts. The database is configured to use the default collation.
The queries use open row set and infer the schema shown in the following table.
You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend using openrowset with to explicitly specify the maximum length for businessName
and surveyName.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 84
You need to identify the root cause of the data refresh issue.
What should you use?
- A. Performance analyzer in Power Bl Desktop
- B. Query Diagnostics in Power Query Editor
- C. the Usage Metrics Report in powerbi.com
Answer: B
Explanation:
Users indicate that the data in Power BI reports is stale. You discover that the refresh process of the Power BI model occasionally times out.
With Query Diagnostics, you can achieve a better understanding of what Power Query is doing at authoring and at refresh time in Power BI Desktop. While we'll be expanding on this feature in the future, including adding the ability to use it during full refreshes, at this time you can use it to understand what sort of queries you're emitting, what slowdowns you might run into during authoring refresh, and what kind of background events are happening.
NEW QUESTION # 85
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?
- A. Power Platform admin
- B. Power Bl workspace admin
- C. Power Bl admin
- D. capacity admin
Answer: C
Explanation:
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.
NEW QUESTION # 86
You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)
The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)
You need to reduce the model size by eliminating invalid relationships.
Which column should you remove?
- A. Sales[Sales Amount]
- B. Sales[RowlD]
- C. Plan[RowlD]
- D. Sales[Sales ID]
Answer: D
Explanation:
Explanation
Sales[Row ID] has 858,786 missing keys and 858,789 Max From Cardinality.
Note: The Max From Cardinality column defines the cost of the relationship which is the amount of time DAX needs to transfer the filters from the dimensions table to the fact table.
Reference: https://blog.enterprisedna.co/vertipaq-analyzer-tutorial-relationships-referential-integrity/
NEW QUESTION # 87
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 question sets might have more than one
correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions
will not appear in the review screen.
You have the Power Bl data model shown in the exhibit. (Click the Exhibit tab.)
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.
Solution: You recommend moving all the measures to a calculation group.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 88
You have a Power Bl report that contains a card. The card displays the value for year-to-date revenue.
You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.
What should you do?
- A. Convert the card into a text box.
- B. Populate the alt text by using conditional formatting with a DAX measure.
- C. Add the value to the chart title text.
- D. Populate the alt text with a static value.
Answer: B
NEW QUESTION # 89
You have a Power Bl dataset that has the query dependencies shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the graphic.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 90
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 pool. You need to ensure that the SQL pool is scanned by Microsoft Purview.
What should you do first?
- A. Search the data catalog.
- B. Register a data source.
- C. Create a data share connection.
- D. Create a data policy.
Answer: B
NEW QUESTION # 91
You have a Power Bl dataset that contains the following measures:
* Budget
* Actuals
* Forecast
You create a report that contains 10 visuals.
You need provide users with the ability to use a slicer to switch between the measures in two visuals only.
You create a dedicated measure named cg Measure switch.
How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/selectedvalue-function
NEW QUESTION # 92
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?
- A. summary
- B. freqlcems
- C. rollup
- D. corr
Answer: D
Explanation:
pandas.DataFrame.corr computes pairwise correlation of columns, excluding NA/null values.
Incorrect:
* freqItems
pyspark.sql.DataFrame.freqItems
Finding frequent items for columns, possibly with false positives. Using the frequent element count algorithm described in https://doi.org/10.1145/762471.762473, proposed by Karp, Schenker, and Papadimitriou.'
* summary is used for index.
* There is no panda method for rollup. Rollup would not be correct anyway.
NEW QUESTION # 93
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 question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power Bl 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 maintaining the current functionality.
Solution: From Tabular Editor, you create a calculation group.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
Explanation
Solution: From DAX Studio, you write a query that uses grouping sets.
A grouping is a set of discrete values that are used to group measure fields.
Reference: https://docs.microsoft.com/en-us/power-bi/developer/visuals/capabilities
NEW QUESTION # 94
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?
- A. describe
- B. explain
- C. rollup
- D. freqltems
Answer: A
Explanation:
Explanation
The aggregating statistic can be calculated for multiple columns at the same time with the describe function.
Example:
titanic[["Age", "Fare"]].describe()
Out[6]:
Age Fare
count 714.000000 891.000000
mean 29.699118 32.204208
std 14.526497 49.693429
min 0.420000 0.000000
25% 20.125000 7.910400
50% 28.000000 14.454200
75% 38.000000 31.000000
max 80.000000 512.329200
Reference: https://pandas.pydata.org/docs/getting_started/intro_tutorials/06_calculate_statistics.html
NEW QUESTION # 95
You are configuring a Power Bl report for accessibility as shown in the following table.
You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A. Divergent colors
- B. First-level elements colors
- C. Theme colors
- D. Sentiment colors
Answer: C,D
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes
NEW QUESTION # 96
You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails contains three date columns named OrderDate, CreatedOnDate, and ModifiedDate.
You need to implement an incremental refresh of SalesDetails. The solution must ensure that OrderDate starts on or after the beginning of the prior year.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Answer:
Explanation:
Explanation
Graphical user interface, text, application, chat or text message Description automatically generated
Step 1: Create RangeStart and RangeEndDateTime parameters.
When configuring incremental refresh in Power BI Desktop, you first create two Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd. These parameters, defined in the Manage Parameters dialog in Power Query Editor are initially used to filter the data loaded into the Power BI Desktop model table to include only those rows with a date/time within that period.
Step 2: Add an applied step that adds a custom date filter OrderDate is Between RangeStart and RangeEnd.
With RangeStart and RangeEnd parameters defined, you then apply custom Date filters on your table's date column. The filters you apply select a subset of data that will be loaded into the model when you click Apply.
Step 3: Configure an incremental refresh to archive data that starts two years before the refresh date.
After filters have been applied and a subset of data has been loaded into the model, you then define an incremental refresh policy for the table. After the model is published to the service, the policy is used by the service to create and manage table partitions and perform refresh operations. To define the policy, you will use the Incremental refresh and real-time data dialog box to specify both required settings and optional settings.
Step 4: Add an applied step that filters OrderDate to the start of the prior year.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
NEW QUESTION # 97
You have an Azure Synapse notebook.
You need to create the visual shown in the following exhibit.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: fill_between
atplotlib.pyplot.fill_between fills the area between two horizontal curves.
The curves are defined by the points (x, y1) and (x, y2). This creates one or multiple polygons describing the filled area.
Box 2: suptitle
Set the title of the visual.
suptitle adds a centred title to the figure.
Reference:
https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.fill_between.html#matplotlib.pyplot.fill_between
https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.suptitle.html#matplotlib.pyplot.suptitle
NEW QUESTION # 98
You have a Power Bl workspace named Workspacel that contains five dataflows.
You need to configure Workspacel to store the dataflows in an Azure Data Lake Storage Gen2 account
What should you do first?
- A. Change the Data source settings in the dataflow queries.
- B. Disable load for all dataflow queries.
- C. Delete the dataflow queries.
- D. From the Power Bl Admin portal, enable tenant-level storage.
Answer: A
NEW QUESTION # 99
You plan to modify a Power Bl dataset.
You open the Impact analysis panel for the dataset and select Notify contacts.
Which contacts will be notified when you use the Notify contacts feature?
- A. all the workspace members of any workspace that uses the dataset
- B. the workspace admins of any workspace that uses the dataset
- C. any users that accessed a report that uses the dataset within the last 30 days
- D. the Power Bl admins
Answer: A
Explanation:
Notify contacts
If you've made a change to a dataset or are thinking about making a change, you might want to contact the relevant users to tell them about it. When you notify contacts, an email is sent to the contact lists of all the impacted workspaces. Your name appears on the email so the contacts can find you and reply back in a new email thread.
NEW QUESTION # 100
You have an Azure Synapse notebook.
You need to create the visual shown in the following exhibit.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: fill_between
atplotlib.pyplot.fill_between fills the area between two horizontal curves.
The curves are defined by the points (x, y1) and (x, y2). This creates one or multiple polygons describing the filled area.
Box 2: suptitle
Set the title of the visual.
suptitle adds a centred title to the figure.
Reference:
https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.fill_between.html#matplotlib.pyplot.fill_between
https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.suptitle.html#matplotlib.pyplot.suptitle
NEW QUESTION # 101
You have five Power Bl reports that contain R script data sources and R visuals.
You need to publish the reports to the Power Bl service and configure a daily refresh of datasets.
What should you include in the solution?
- A. an on-premises data gateway (standard mode)
- B. an on-premises data gateway (personal mode)
- C. a Power Bl Embedded capacity
- D. a workspace that connects to an Azure Data Lake Storage Gen2 account
Answer: B
Explanation:
Explanation
To schedule refresh of your R visuals or dataset, enable scheduled refresh and install an on-premises data gateway (personal mode) on the computer containing the workbook and R.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-r-in-query-editor
NEW QUESTION # 102
You have a 2-GB Power Bl 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 to the dataset from powerbi.com.
Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
- A. Enable XMLA read-write.
- B. Turn on Large dataset storage format.
- C. Enable service principal authentication for read-only admin APIs.
- D. Connect the target workspace to an Azure Data Lake Storage Gen2 account.
Answer: A,B
Explanation:
Optimize datasets for write operations by enabling large models
When using the XMLA endpoint for dataset management with write operations, it's recommended you enable the dataset for large models. This reduces the overhead of write operations, which can make them considerably faster. For datasets over 1 GB in size (after compression), the difference can be significant.
Tabular Editor supports Azure Analysis Services and Power BI Premium Datasets through XMLA read/write.
Note: Tabular Editor - An open-source tool for creating, maintaining, and managing tabular models using an intuitive, lightweight editor. A hierarchical view shows all objects in your tabular model. Objects are organized by display folders with support for multi-select property editing and DAX syntax highlighting. XMLA read-only is required for query operations. Read-write is required for metadata operations.
Reference:
https://tabulareditor.github.io/
NEW QUESTION # 103
You need to create Power BI reports that will display data based on the customers' subscription level.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation
Step 1: Create row-level security (RLS) roles
Create roles
Note: Provide all the customers with their own Power BI workspace to create their own reports. Each workspace will use the new dataset in the FinData workspace.
Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data.
Deploy prebuilt datasets to Power BI to simplify the query experience of the customers.
Step 2: Create a DAX expression
Consider a model with two roles: The first role, named Workers, restricts access to all Payroll table rows by using the following rule expression:
FALSE()
Note: A rule will return no table rows when its expression evaluates to false.
Yet, a second role, named Managers, allows access to all Payroll table rows by using the following rule expression:
TRUE()
Take care: Should a report user map to both roles, they'll see all Payroll table rows.
Step 3: Add members to row-level security (RLS) roles
Configure role mappings
Once [the model is] published to Power BI, you must map members to dataset roles.
Reference: https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
NEW QUESTION # 104
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 is approximately 7 GB and is stored in Azure Synapse Analytics.
* Reports for the security team use data that must have local security rules applied at the database level to restrict access. The data being reviewed is 2 GB.
Which storage mode provides the best response time for each group of users?
- A. Import for the external customers and DirectQuery for the security team.
- B. DirectQuery for the external customers and import for the security team.
- C. DirectQuery for the external customers and DirectQuery for the security team.
- D. Import for the external customers and import for the security team.
Answer: B
Explanation:
Explanation
With DirectQuery, queries are sent back to your Azure Synapse Analytics in real time as you explore the data.
Real-time queries, combined with the scale of Synapse Analytics enables users to create dynamic reports in minutes against terabytes of data.
Need import for the security team for local security rules.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-data-warehouse-with-direct-connect
NEW QUESTION # 105
......
Microsoft DP-500 exam is part of the Microsoft Certified: Azure Data Engineer Associate certification, which validates the candidate's expertise in designing and implementing data solutions using Azure. Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI certification is highly valued by employers looking for professionals who can use Azure services to build scalable data solutions that deliver business value. Candidates who pass the Microsoft DP-500 exam and earn the Azure Data Engineer Associate certification are prepared for roles such as data engineer, data architect, and business intelligence analyst.
DP-500 Premium Exam Engine - Download Free PDF Questions: https://www.passleader.top/Microsoft/DP-500-exam-braindumps.html
DP-500 Dumps Questions Study Exam Guide : https://drive.google.com/open?id=14UrsHT0nNVqkSV9anB0pbwqd0TwYdAzU