Microsoft Microsoft Certified: Azure Enterprise Data Analyst Associate DP-500 Questions & Answers

• Question 11:

  HOTSPOT

  You have an Azure Synapse workspace named Workspace1.

  You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and display the top five.

  How should you complete the code? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 12:

  HOTSPOT

  You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips.

  You need to create a chart that will show the total trip distance according to the number of passengers as shown in the following exhibit.

  

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

  Hot Area:

  

  Correct Answer:

  

• Question 13:

  HOTSPOT

  You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen2 account.

  You need to query all the files in the `csv/taxi/' folder and all its subfolders. All the files are in CSV format and have a header row.

  How should you complete the query? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: BULK 'csv/taxi*.CSV',

  *.CSV to get all the CSV files.

  Box 2: FIRSTROW=2

  As there is a header we should read from the second line.

  Note: FIRSTROW = 'first_row'

  Specifies the number of the first row to load. The default is 1 and indicates the first row in the specified data file. The row numbers are determined by counting the row terminators.

  FIRSTROW is 1-based.

  Incorrect:

  Not FIRSTROW=1. FIRSTROW=1 is used when there is no header.

• Question 14:

  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.

  Hot Area:

  

  Correct Answer:

  

• Question 15:

  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.

  Hot Area:

  

  Correct Answer:

  

• Question 16:

  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.

  Hot Area:

  

  Correct Answer:

  

• Question 17:

  The IT group registers the Power BI tenant as a data source in Microsoft Purview.

  You need to ensure that all the analysts can view the assets in the Power BI tenant. The solution must meet the technical requirements for Microsoft Purview and Power BI.

  What should you do?

  A. Create a scan.

  B. Deploy a Power BI gateway.

  C. Search the data catalog.

  D. Create a linked service.

  Correct Answer: A

• Question 18:

  You need to recommend changes to the Power BI tenant to meet the technical requirements for external data sharing. Which tenant setting should you recommend disabling?

  A. Allow shareable links to grant access to everyone in your organization.

  B. Allow Azure Active Directory guest users to edit and manage content in the organization.

  C. Users can reassign personal workspaces.

  D. Show Azure Active Directory guests in lists of suggested people.

  Correct Answer: A

• Question 19:

  The new process for deploying Power BI reports and datasets to the User Experience workspace must ensure that the datasets point to the lake database to which the relevant dataset is deployed. The views in each lake database must present the data in a tabular format.

  You need to meet the technical requirements for deploying reports and datasets to the User Experience workspace.

  What should you do?

  A. From the Corporate Data Models and User Experience workspaces, select Allow contributors to update the app.

  B. From the Corporate Data Models and User Experience workspace, set License mode to Premium per user.

  C. From the Tenant settings, set Allow specific users to turn on external data sharing to Enable.

  D. From the Developer settings, set Allow service principals to use Power BI APIs to Enable.

  Correct Answer: D

• Question 20:

  You have an Azure SQL database named DB1.

  You have a Power BI tenant that contains 20 workspaces. Multiple workspaces contain datasets that use DB1 as a data source.

  You need to identity how many datasets use DB1 as a data source across the tenant.

  What should you use?

  A. an XLMA endpoint

  B. the Power BI REST API

  C. Power BI data source files

  D. lineage view

  Correct Answer: D