Perfect Microsoft DP-500 Practice Exam Questions To Test Yourself

Perfect Microsoft DP-500 Practice Exam Questions To Test Yourself

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?

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





Which type of chart will the code produce?

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?

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.

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

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.

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?

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.




 

Share this post

Leave a Reply

Your email address will not be published.