ExamGecko
Home / Microsoft / DP-500 / List of questions
Ask Question

Microsoft DP-500 Practice Test - Questions Answers, Page 9

Add to Whishlist

List of questions

Question 81

Report Export Collapse

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 Power Bl Desktop, you create a hierarchy.

Does this meet the goal?

Become a Premium Member for full access
  Unlock Premium Member

Question 82

Report Export Collapse

DRAG DROP

You have a Power Bl dataset that contains the following measures:

β€’ Budget

β€’ Actuals

β€’ Forecast

You create a report that contains 10 visuals.

You need provide users with the ability to use a slicer to switch between the measures in two visuals only.

You create a dedicated measure named cg Measure switch.

How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate values to the targets. Each value 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.


Become a Premium Member for full access
  Unlock Premium Member

Question 83

Report Export Collapse

DRAG DROP

You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one report.

You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.


Become a Premium Member for full access
  Unlock Premium Member

Question 84

Report Export Collapse

HOTSPOT

You are configuring an aggregation table as shown in the following exhibit.

Microsoft DP-500 image Question 58 90335 10022024015932000000

The detail table is named FactSales and the aggregation table is named FactSales(Agg).

You need to aggregate SalesAmount for each store.

Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the appropriate options in the answer area,

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 85

Report Export Collapse

DRAG DROP

You have a Power Bl dataset. The dataset contains data that is updated frequently.

You need to improve the performance of the dataset by using incremental refreshes.

Which four actions should you perform in sequence to enable the incremental refreshes? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.


Become a Premium Member for full access
  Unlock Premium Member

Question 86

Report Export Collapse

DRAG DROP

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.


Become a Premium Member for full access
  Unlock Premium Member

Question 87

Report Export Collapse

HOTSPOT

You have the following code in an Azure Synapse notebook.

Microsoft DP-500 image Question 61 90338 10022024015932000000

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.


Become a Premium Member for full access
  Unlock Premium Member

Question 88

Report Export Collapse

HOTSPOT

You have the following code in an Azure Synapse notebook.

Microsoft DP-500 image Question 62 90339 10022024015932000000

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.


Become a Premium Member for full access
  Unlock Premium Member

Question 89

Report Export Collapse

HOTSPOT

You are creating a Power Bl Desktop report.

You add a Python visual to the report page.

You plan to create a scatter chart to visualize the data.

You add Python code to the Python script editor.

You need to create the scatter chart.

How should you complete the Python code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member

Question 90

Report Export Collapse

HOTSPOT

You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements:

β€’ Code must always be merged to the main branch before being published, and the main branch must be used for publishing resource

β€’ The workspace templates must be stored in the publish branch.

β€’ A branch named dev123 will be created to support the development of a new feature.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Become a Premium Member for full access
  Unlock Premium Member
Total 162 questions
Go to page: of 17
Search

Related questions