Microsoft Microsoft Certifications DP-500 Questions & Answers

• Question 61:

  You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need to modify the source control solution to use an Azure DevOps Git repository. What should you do first?

  A. Disconnect from the GitHub repository.

  B. Create a new pull request.

  C. Change the workspace to live mode.

  D. Change the active branch.

  Correct Answer: A

• Question 62:

  You have new security and governance protocols for Power Bl reports and datasets. The new protocols must meet the following requirements.

  New reports can be embedded only in locations that require authentication.

  Live connections are permitted only for workspaces that use Premium capacity datasets.

  Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  A. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on- premises datasets.

  B. From the Premium per user settings, set XMLA Endpoint to Off.

  C. From Embed Codes, delete all the codes.

  D. From Capacity settings, set XMLA Endpoint to Read Write.

  E. From Tenant settings, set Publish to web to Disable.

  Correct Answer: BCE

• Question 63:

  You have a Power Bl dataset named Datasetl.

  In Dataset1, 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 DAX Studio, you write a query that uses grouping sets.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 64:

  You need to provide users with a reproducible method to connect to a data source and transform the data by using an Al function. The solution must meet the following requirement

  Minimize development effort.

  Avoid including data in the file.

  Which type of file should you create?

  A. PBIDS

  B. PBIX

  C. PBIT

  Correct Answer: C

• Question 65:

  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 define the collation for businessName and surveyName as Latim_Generai_100_BiN2_UTF8.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 66:

  You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You need to present the data distribution statistics from a DataFrame in a tabular view. Which method should you invoke on the DataFrame?

  A. freqltems

  B. explain

  C. rollup

  D. summary

  Correct Answer: D

• Question 67:

  You have a Power Bl dataset named Dataset1.

  In Dataset1, 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 create a hierarchy.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 68:

  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 normalizing the data model.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 69:

  You are optimizing a Power Bl data model by using DAX Studio.

  You need to capture the query events generated by a Power Bl Desktop report.

  What should you use?

  A. the DMV list

  B. a Query Plan trace

  C. an All Queries trace

  D. a Server Timings trace

  Correct Answer: C

• Question 70:

  You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset.

  During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB."

  You need to ensure that you can refresh the dataset.

  What should you do?

  A. Turn on Large dataset storage format.

  B. Connect Workspace1 to an Azure Data Lake Storage Gen2 account

  C. Change License mode to Premium per user.

  D. Change the location of the Premium capacity.

  Correct Answer: A