Down To Date Designing And Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure And Microsoft Power BI DP-500 Exams

NEW QUESTION 1

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 2

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 3

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 4

You have the following code in an Azure Synapse notebook.

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

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 5

You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips.
You need to create a chart that will show the total trip distance according to the number of passengers as shown in the following exhibit.

How should you configure the chart? 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 6

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 7

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.

Answer: A

NEW QUESTION 8

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

Answer: D

NEW QUESTION 9

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 10

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

Answer: A

NEW QUESTION 11

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 12

You need to recommend an automated solution to monitor Power Bl user activity. The solution must meet the following requirements:
• Security admins must identify when users export reports from Power Bl within five days of a new sensitivity label being applied to the artifacts in Power Bl.
• Power Bl admins must identify updates or changes to the Power Bl capacity.
• The principle of least privilege must be used.
Which log should you include in the recommendation for each group? 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 13

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.

Answer: A

NEW QUESTION 14

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

Answer: AB

NEW QUESTION 15

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

Answer: D

NEW QUESTION 16

You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?

• A. PIVOT
• B. GROUPING
• C. PREDICT
• D. CAST

Answer: A

NEW QUESTION 17

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.

Answer: D

NEW QUESTION 18

You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. A sample of the data in the Sales table is shown in the following table.

A sample of the data in the Commission table is shown in the following table.

You need to merge the tables by using Power Query Editor without losing any rows in the Sales table. How should you complete the query? 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 19
......