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

• Question 1:

  You need to integrate the external data source to support the planned changes.

  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.

  Select and Place:

  

  Correct Answer:

  

• Question 2:

  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.

  Select and Place:

  

  Correct Answer:

  

• Question 3:

  You need to implement object-level security (OLS) in the Power Bl dataset for the sales associates.

  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.

  Select and Place:

  

  Correct Answer:

  

  

• Question 4:

  You need to build a Transact-SQL query to implement the planned changes for the internal users.

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

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 5:

  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.

  Hot Area:

  

  Correct Answer:

  

• Question 6:

  You need to create Power Bl 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.

  Select and Place:

  

  Correct Answer:

  

• Question 7:

  HOTSPOT

  You manage a dataset that contains the two data sources as shown in the following table.

  

  When you attempt to refresh the dataset in powerbi.com, you receive the following error message: "[Unable to combine data] Add Columns is accessing data sources that have privacy levels which cannot be used together. Please rebuild this

  data combination."

  You discover that the dataset contains queries that fold data from the SharePoint folder to the Azure SQL database.

  You need to resolve the error. The solution must provide the highest privacy possible.

  Which privacy level should you select for each data source? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Private

  This Formula.Firewall error is the result of Power Query's Data Privacy Firewall (aka the Firewall)

  Note: Folding is a term that refers to converting expressions in M (such as filters, renames, joins, and so on) into operations against a raw data source (such as SQL, OData, and so on).

  Box 2: Organizational

  Organizational Limits the visibility of a data source to a trusted group of people. It is isolated from all Public data sources, but is visible to other Organizational data sources. A common example is a Microsoft Word document on an intranet SharePoint site with permissions enabled for a trusted group.

• Question 8:

  HOTSPOT

  You are using an Azure Synapse notebook to create a Python visual.

  You run the following code cell to import a dataset named Iris.

  

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

  

  You need to create the visual shown in the exhibit. (Click the Exhibit tab.)

  

  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.

  Hot Area:

  

  Correct Answer:

  

• Question 9:

  HOTSPOT

  You use Vertipaq Analyzer to analyze a model.

  The Relationships tab contains the results 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 10:

  HOTSPOT

  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.

  Hot Area:

  

  Correct Answer:

  

  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.