2022 Valid DP-500 test answers & Microsoft Exam PDF [Q29-Q45]

2022 Valid DP-500 test answers & Microsoft Exam PDF

Free Microsoft DP-500 Exam Questions and Answer from Training Expert ActualPDF

Skills measured

Implement and manage a data analytics environment (25–30%)
Explore and visualize data (20–25%)
Query and transform data (20–25%)
Implement and manage data models (25–30%)

NEW QUESTION 29
You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the
Microsoft SQL Server data warehouse.
What should you include in the recommendation?

A. Azure Purview
B. the on-premises data gateway
C. Site-to-Site VPN
D. an XMLA endpoint

Answer: B

NEW QUESTION 30
You need to save Power Bl dataflows in an Azure Storage account.
Which two prerequisites are required to support the configuration? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.

A. The connection must be created by a user that is assigned the Storage Blob Data Owner role.
B. The storage account must be protected by using an Azure Firewall.
C. The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.
D. Dataflows must exist already for any directly connected Power Bl workspaces.
E. The storage account must have hierarchical namespace enabled.

Answer: A,E

NEW QUESTION 31
You develop a solution that uses a Power Bl Premium capacity. The capacity contains a dataset that is
expected to consume 50 GB of memory.
Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl
service? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Publish the complete dataset.
B. Invoke a refresh to load historical data based on the incremental refresh policy.
C. Restart the capacity.
D. Increase the Max Offline Dataset Size setting.
E. Publish an initial dataset that is less than 10 GB.

Answer: A,C

NEW QUESTION 32
Note: This question is part of a scries 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 creating a perspective that contains the commonly used fields.
Does this meet the goal?

A. No
B. Yes

Answer: A

NEW QUESTION 33
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 34
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 before being published, and the main branch must be used
for publishing resource
* The workspace templates must be stored in the publish branch.
* A branch named dev123 will be created to support the development of a new feature.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 35
You have a Power Bl report that contains the visual shown in the following exhibit.

You need to make the visual more accessible to users who have color vision deficiency. What should you do?

A. Change the red background color to orange.
B. Change the font color of values in the Sales column to white.
C. Add icons to represent the sales status of each product.
D. Add additional measures to the table values.

Answer: A

NEW QUESTION 36
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. a workspace that connects to an Azure Data Lake Storage Gen2 account
B. an on-premises data gateway (personal mode)
C. an on-premises data gateway (standard mode)
D. a Power Bl Embedded capacity

Answer: B

NEW QUESTION 37
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. DirectQuery for the external customers and import for the security team.
B. Import 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 DirectQuery for the security team.

Answer: A

NEW QUESTION 38
You have a shared dataset in Power Bl named Dataset1.
You have an on-premises Microsoft SQL Server database named DB1.
You need to ensure that Dataset1 refreshes data from DB1.
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:

NEW QUESTION 39
You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one
report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and
Forecast.
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.

Answer:

Explanation:

NEW QUESTION 40
You are creating a Power Bl 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 script editor.
You need to create the scatter chart.
How should you complete the Python code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 41
You need to recommend a solution for the customer workspaces to support the planned changes.
Which two configurations should you include in the recommendation? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.

A. Publish the financial data to the web.
B. Grant the Build permission for the financial data to each customer.
C. Configure the FinData workspace to use a Power Bl Premium capacity.
D. Set Use datasets across workspaces to Enabled

Answer: B

NEW QUESTION 42
You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already
been created. The solution must minimize development and administrative effort.
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.

Answer:

Explanation:

NEW QUESTION 43
You have the following code in an Azure Synapse notebook.

Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the code.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION 44
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and
Commission. A sample of the data in the Sales table is shown in the following table.

A sample of the data in the Commission table is shown in the following table.

You need to merge the tables by using Power Query Editor without losing any rows in the Sales table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.