Microsoft Microsoft Certifications DP-500 Questions & Answers

• Question 71:

  You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will contain more than 20 million rows partitioned by date. The table will be shared with the SQL engines.

  You need to minimize how long it takes for a serverless SQL pool to execute a query data against the table.

  In which file format should you recommend storing the table data?

  A. JSON

  B. Apache Parquet

  C. CSV

  D. Delta

  Correct Answer: B

• Question 72:

  You have a 2-GB Power Bl dataset.

  You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes to the dataset from powerbi.com.

  Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point

  A. Enable service principal authentication for read-only admin APIs.

  B. Turn on Large dataset storage format.

  C. Connect the target workspace to an Azure Data Lake Storage Gen2 account.

  D. Enable XMLA read-write.

  Correct Answer: BD

• Question 73:

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

  

  Which type of chart will the code produce?

  A. a stacked bar chart

  B. a pie chart

  C. a bar chart

  D. an area chart

  Correct Answer: C

• Question 74:

  You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL database named DB1. DB1 is a transactional database in the third normal form.

  You need to recommend a solution to minimize how long it takes to execute the query. The solution must maintain the current functionality. What should you include in the recommendation?

  A. Create calculated columns in Dataset1.

  B. Remove the relationships from Dataset1.

  C. Normalize the tables in DB1.

  D. Denormalize the tables in DB1.

  Correct Answer: D

• Question 75:

  You have an Azure Synapse Analytics dedicated SQL pool.

  You need to ensure that the SQL pool is scanned by Azure Purview.

  What should you do first?

  A. Register a data source.

  B. Search the data catalog.

  C. Create a data share connection.

  D. Create a data policy.

  Correct Answer: A

• Question 76:

  You are configuring a Power Bl report for accessibility as shown in the following table.

  

  You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  A. Theme colors

  B. Sentiment colors

  C. Divergent colors

  D. First-level elements colors

  Correct Answer: BC

• Question 77:

  You have a Power Bl dataset that has only the necessary fields visible for report development.

  You need to ensure that end users see only 25 specific fields that they can use to personalize visuals.

  What should you do?

  A. From Tabular Editor, create a new role.

  B. Hide all the fields in the dataset.

  C. Configure object-level security (OLS).

  D. From Tabular Editor, create a new perspective.

  Correct Answer: D

• Question 78:

  You have a Power Bl data model.

  You need to refresh the data from the source every 15 minutes.

  What should you do first?

  A. Enable the XMLA endpoint.

  B. Define an incremental refresh policy.

  C. Change the storage mode of the dataset.

  D. Configure a scheduled refresh.

  Correct Answer: A

• Question 79:

  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?

  A. parameter rules

  B. selective deployment

  C. auto-binding across pipelines

  D. data source rules

  Correct Answer: A

• Question 80:

  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 creating a perspective that contains the commonly used fields.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B