Microsoft Microsoft Certifications DP-500 Questions & Answers

• Question 101:

  You need to save Power Bl dataflows in an Azure Storage account.

  Which two prerequisites are required to support the configuration? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. The storage account must be protected by using an Azure Firewall.

  B. The connection must be created by a user that is assigned the Storage Blob Data Owner role.

  C. The storage account must have hierarchical namespace enabled.

  D. Dataflows must exist already for any directly connected Power Bl workspaces.

  E. The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.

  Correct Answer: BC

• Question 102:

  You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses Import storage mode. You need to ensure that the report page updates all the visuals every 30 minutes. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  A. Enable Power Bl embedded.

  B. Configure the data sources to use DirectQuery.

  C. Configure the data sources to use a streaming dataset

  D. Select Auto page refresh.

  E. Enable the XMIA endpoint.

  F. Add a Microsoft Power Automate visual to the report page.

  Correct Answer: BD

• Question 103:

  You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.

  The queries use open row set and infer the schema shown in the following table.

  

  You need to recommend changes to the queries to reduce I/O reads and tempdb usage.

  Solution: You recommend using openrowset with to explicitly specify the maximum length for businessName and surveyName.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 104:

  You have a Power Bl dataset that uses DirectQuery against an Azure SQL database.

  Multiple reports use the dataset.

  A database administrator reports that too many queries are being sent from Power Bl to the database.

  You need to reduce the number of queries sent to the database. The solution must meet the following requirements:

  DirectQuery must continue to be used.

  Visual interactions in all the reports must remain as they are configured currently.

  Consumers of the reports must only be allowed to apply filters from the Filter pane.

  Which two settings should you select? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Disabling cross highlighting/filtering by default

  B. Add a single Apply button to the filter pane to apply changes at once

  C. Add an Apply button to each slicer to apply changes when you're ready

  D. Add Apply buttons to all basic filters to apply changes when you're ready

  E. Ignore the Privacy Levels and potentially improve performance

  Correct Answer: BC

• Question 105:

  You are implementing a reporting solution that has the following requirements:

  Reports for external customers must support 500 concurrent requests. The data for these reports is approximately 7 GB and is stored in Azure Synapse Analytics. Reports for the security team use data that must have local security rules

  applied at the database level to restrict access. The data being reviewed is 2 GB.

  Which storage mode provides the best response time for each group of users?

  A. DirectQuery for the external customers and import for the security team.

  B. DirectQuery for the external customers and DirectQuery for the security team.

  C. Import for the external customers and DirectQuery for the security team.

  D. Import for the external customers and import for the security team.

  Correct Answer: C

• Question 106:

  You are planning a Power Bl solution for a customer.

  The customer will have 200 Power Bl users. The customer identifies the following requirements:

  Ensure that all the users can create paginated reports.

  Ensure that the users can create reports containing Al visuals.

  Provide autoscaling of the CPU resources during heavy usage spikes.

  You need to recommend a Power Bl solution for the customer. The solution must minimize costs. What should you recommend?

  A. Power Bl Premium per user

  B. a Power Bl Premium per capacity

  C. Power Bl Pro per user

  D. Power Bl Report Server

  Correct Answer: A

• Question 107:

  You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.

  The queries use open row set and infer the schema shown in the following table.

  

  You need to recommend changes to the queries to reduce I/O reads and tempdb usage.

  Solution: You recommend defining a data source and view for the Parquet files. You recommend updating the query to use the view.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 108:

  You have a Power Bl dataset named Datasetl.

  In Datasetl, you currently have 50 measures that use the same time intelligence logic.

  You need to reduce the number of measures, while maintaining the current functionality.

  Solution: From Power Bl Desktop, you group the measures in a display folder.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 109:

  You have a file named File1.txt that has the following characteristics: A header row Tab delimited values UNIX-style line endings

  You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.

  Which query should you execute?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 110:

  You open a Power Bl Desktop report that contains an imported data model and a single report page.

  You open Performance analyzer, start recording, and refresh the visuals on the page. The recording produces the results shown in the following exhibit

  

  What can you identify from the results?

  A. The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.

  B. The Actual/Forecast Billable Hrs YTD visual displays the most data.

  C. Unoptimized DAX queries cause the page to load slowly.

  D. When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.

  Correct Answer: D