Microsoft Microsoft Certifications DP-500 Questions & Answers

• Question 81:

  You have five Power Bl reports that contain R script data sources and R visuals.

  You need to publish the reports to the Power Bl service and configure a daily refresh of datasets.

  What should you include in the solution?

  A. a Power Bl Embedded capacity

  B. an on-premises data gateway (standard mode)

  C. a workspace that connects to an Azure Data Lake Storage Gen2 account

  D. an on-premises data gateway (personal mode)

  Correct Answer: D

• Question 82:

  You are creating a Python visual in Power Bl Desktop.

  You need to retrieve the value of a column named Unit Price from a DataFrame.

  How should you reference the Unit Price column in the Python code?

  A. pandas.DataFrame('Unit Price')

  B. dataset['Unit Price']

  C. data = [Unit Price]

  D. ('Unit Price')

  Correct Answer: B

• Question 83:

  You use Azure Synapse Analytics and Apache Spark notebooks to You need to use PySpark to gain access to the visual libraries. Which Python libraries should you use?

  A. Seaborn only

  B. Matplotlib and Seaborn

  C. Matplotlib only

  D. Matplotlib and TensorFlow

  E. TensorFlow only

  F. Seaborn and TensorFlow

  Correct Answer: B

• Question 84:

  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

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

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

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

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

  Correct Answer: AC

• Question 85:

  You are running a diagnostic against a query as shown in the following exhibit.

  

  What can you identify from the diagnostics query?

  A. All the query steps are folding.

  B. Elevated permissions are being used to query records.

  C. The query is timing out.

  D. Some query steps are folding.

  Correct Answer: A

• Question 86:

  You have a Power Bl dataset that contains the following measure.

  

  You need to improve the performance of the measure without affecting the logic or the results. What should you do?

  A. Replace both calculate functions by using a variable that contains the calculate function.

  B. Remove the alternative result of blank( ) from the divide function.

  C. Create a variable and replace the values for [sales Amount].

  D. Remove "calendar'[Flag] = "YTD" from the code.

  Correct Answer: A

• Question 87:

  You plan to modify a Power Bl dataset.

  You open the Impact analysis panel for the dataset and select Notify contacts.

  Which contacts will be notified when you use the Notify contacts feature?

  A. any users that accessed a report that uses the dataset within the last 30 days

  B. the workspace admins of any workspace that uses the dataset

  C. the Power Bl admins

  D. all the workspace members of any workspace that uses the dataset

  Correct Answer: B

• Question 88:

  You have the Power BI 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 denormalizing the data model. Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 89:

  You are creating a Power 81 single-page report.

  Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.

  You need to ensure that the users can consume content on a report page in a logical order.

  What should you configure on the report page?

  A. the bookmark order

  B. the X position

  C. the layer order

  D. the tab order

  Correct Answer: D

• Question 90:

  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 moving all the measures to a calculation group. Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B