The Secret Of Microsoft DP-500 Exam Answers

NEW QUESTION 1

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

Answer: D

NEW QUESTION 2

You are building a Power Bl dataset that will use two data sources.
The dataset has a query that uses a web data source. The web data source uses anonymous authentication. You need to ensure that the query can be used by all the other queries in the dataset.
Which privacy level should you select for the data source?

• A. Public
• B. Organizational
• C. Private
• D. None

Answer: C

NEW QUESTION 3

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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

Answer: A

NEW QUESTION 4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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 Tabular Editor, you create a calculation group.
Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 5

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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

Answer: B

NEW QUESTION 6

You have a Power Bl report that contains one visual.
You need to provide users with the ability to change the visual type without affecting the view for other users. What should you do?

• A. From Report setting, select Personalize visuals.
• B. From Tabular Editor, create a new perspective.
• C. From the Bookmarks pane, select Focus mode, and then select Add.
• D. From Visual options in Report settings, select Use the modern visual header with updated styling options.

Answer: A

NEW QUESTION 7

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

Answer: C

NEW QUESTION 8

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.

Answer: B

NEW QUESTION 9

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.

Answer: D

NEW QUESTION 10

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 11

You discover a poorly performing measure in a Power Bl data model.
You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine.
What should you use?

• A. Tabular Editor
• B. Performance analyzer in Power Bl Desktop
• C. Vertipaq Analyzer
• D. DAX Studio

Answer: B

NEW QUESTION 12

You have a Power Bl dataset that has the query dependencies shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 13

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.

Answer: A

NEW QUESTION 14

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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

Answer: B

NEW QUESTION 15

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.

Answer: C

NEW QUESTION 16

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 17

You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column.
pfflag = IF('Calendar'[Date] < TOOAYQ, "Past", "Future")
You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:
• Returns the fiscal prior year-to-date value for [sales Amount]
• Uses a fiscal year end of June 30
• Produces no result for dates in the future
How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 18
......