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

• Question 31:

  DRAG DROP

  You plan to create a Power Bl report that will use an OData feed as the data source. You will retrieve all the entities from two different collections by using the same service root

  The OData feed is still in development. The location of the feed will change once development is complete.

  The report will be published before the OData feed development is complete.

  You need to minimize development effort to change the data source once the location 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 32:

  DRAG DROP

  You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in the following table.

  

  Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each pool type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 33:

  DRAG DROP

  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.

  Select and Place:

  

  Correct Answer:

  

• Question 34:

  DRAG DROP

  You have a Power Bl dataset that contains the following measures:

  Budget Actuals Forecast

  You create a report that contains 10 visuals.

  You need provide users with the ability to use a slicer to switch between the measures in two visuals only.

  You create a dedicated measure named cg Measure switch.

  How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or

  scroll to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 35:

  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.

  Select and Place:

  

  Correct Answer:

  

• Question 36:

  DRAG DROP

  You have a Power Bl dataset. The dataset contains data that is updated frequently.

  You need to improve the performance of the dataset by using incremental refreshes.

  Which four actions should you perform in sequence to enable the incremental refreshes? 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 37:

  DRAG DROP

  You are using DAX Studio to query an XMLA endpoint.

  You need to identify the duplicate values in a column named Email in a table named Subscription.

  How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used once, more than once. may need to drag the split bar between panes or scroll to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 38:

  You have a development workspace in the Power BI service.

  You plan to use Tabular Editor to develop and deploy a new dataset, and then use Power BI Desktop to create and publish a report to the Power BI service.

  Which three components should you include in the solution? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. the Read Write XMLA endpoint in a capacity

  B. a Premium Per User workspace

  C. the Read Write XMLA endpoint in the tenant

  D. a .pbix file that has an imported dataset

  E. a .pbix file that has a live connection

  Correct Answer: ABD

• Question 39:

  You have a Power BI tenant.

  You plan to publish 10 paginated reports that will be used by a team of business analysts.

  You need to create a new workspace for the reports. The solution must minimize costs.

  Which license mode should you select for the new workspace?

  A. Pro

  B. Premium per user

  C. Embedded

  D. Premium per capacity

  Correct Answer: A

• Question 40:

  You are creating a Power BI deployment pipeline that will be used to deploy a paginated report.

  You need to ensure that the paginated report is updated to point to the correct dataset for each stage.

  What should you configure in the deployment pipeline?

  A. a data source rule

  B. a dataflow

  C. a selective deployment

  D. a parameter rule

  Correct Answer: A