Perfect Microsoft DP-500 Practice Exam Questions To Test Yourself

test2022-07-05T07:20:59+00:00

By test DP-500 free dumps, DP-500 questions and answers, Microsoft DP-500 Practice Exam 0 Comments

DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI exam is the required exam to get Microsoft Certified: Azure Enterprise Data Analyst Associate Certification. FreeTestShare Microsoft DP-500 Practice Exam assists you in improving your exam preparation by providing you with the most accurate questions. Our Microsoft DP-500 Practice Exam Questions are up to date and feature actual test questions and answers, allowing you to pass your exam quickly. We ensure that if you use the most accurate Microsoft DP-500 Practice Exam from FreeTestShare, you will pass the exam on the first try!

Take this free DP-500 practice exam right now to see how well you know yourself.

Page 1 of 3

1. 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?

Delete the dataflow queries.

From the Power Bl Admin portal, enable tenant-level storage.

Disable load for all dataflow queries.

Change the Data source settings in the dataflow queries.

2. You have the following Python code in an Apache Spark notebook.

Which type of chart will the code produce?

a stacked bar chart

a pie chart

a bar chart

an area chart

3. You have a Power Bl workspace that contains one dataset and four reports that connect to the

dataset.

The dataset uses Import storage mode and contains the following data sources:

• A CSV file in an Azure Storage account

• An Azure Database for PostgreSQL database

You plan to use deployment pipelines to promote the content from development to test to production. There will be different data source locations for each stage .

What should you include in the deployment pipeline to ensure that the appropriate data source locations are used during each stage?

parameter rules

selective deployment

auto-binding across pipelines

data source rules

4. HOTSPOT

You need to populate the CustomersWithProductScore table.

How should you complete the stored procedure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

5. You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses Import storage mode. You need to ensure that the report page updates all the visuals every 30 minutes .

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Enable Power Bl embedded.

Configure the data sources to use DirectQuery.

Configure the data sources to use a streaming dataset

Select Auto page refresh.

Enable the XMIA endpoint.

Add a Microsoft Power Automate visual to the report page.

6. You have a Power Bl tenant that contains 10 workspaces.

You need to create dataflows in three of the workspaces. The solution must ensure that data engineers can access the resulting data by using Azure Data Factory.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point

Associate the Power Bl tenant to an Azure Data Lake Storage account.

Add the managed identity for Data Factory as a member of the workspaces.

Create and save the dataflows to an Azure Data Lake Storage account.

Create and save the dataflows to the internal storage of Power BL

7. 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.

The storage account must be protected by using an Azure Firewall.

The connection must be created by a user that is assigned the Storage Blob Data Owner role.

The storage account must have hierarchical namespace enabled.

Dataflows must exist already for any directly connected Power Bl workspaces.

The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.

8. HOTSPOT

You are configuring an aggregation table as shown in the following exhibit.

The detail table is named FactSales and the aggregation table is named FactSales(Agg).

You need to aggregate SalesAmount for each store.

Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

9. 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?

Yes

10. HOTSPOT

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.

Page 2 of 3

11. HOTSPOT

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.

12. You have a file named File1.txt that has the following characteristics:

• A header row

• Tab delimited values

• UNIX-style line endings

You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.

Which query should you execute?

A)

Option A

Option B

Option C

Option D

13. DRAG DROP

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.

14. HOTSPOT

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.

15. 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?

Yes

16. 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?

freqltems

explain

rollup

summary

17. You have a Power Bl dataset that uses DirectQuery against an Azure SQL database.

Multiple reports use the dataset.

A database administrator reports that too many queries are being sent from Power Bl to the database.

You need to reduce the number of queries sent to the database.

The solution must meet the following requirements:

• DirectQuery must continue to be used.

• Visual interactions in all the reports must remain as they are configured currently.

• Consumers of the reports must only be allowed to apply filters from the Filter pane .

Which two settings should you select? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Disabling cross highlighting/filtering by default

Add a single Apply button to the filter pane to apply changes at once

Add an Apply button to each slicer to apply changes when you're ready

Add Apply buttons to all basic filters to apply changes when you're ready

Ignore the Privacy Levels and potentially improve performance

18. 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 defining a data source and view for the Parquet files. You recommend updating the query to use the view.

Does this meet the goal?

Yes

19. What should you configure in the deployment pipeline?

a backward deployment

a selective deployment

auto-binding

a data source rule

20. You are building a Power Bl dataset that will use two data sources.

The dataset has a query that uses a web data source. The web data source uses anonymous authentication.

You need to ensure that the query can be used by all the other queries in the dataset.

Which privacy level should you select for the data source?

Public

Organizational

Private

None

Page 3 of 3

21. DRAG DROP

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.