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

HOTSPOT

You use Vertipaq Analyzer to analyze a model.

The Relationships tab contains the results 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.

You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)

The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)

You need to reduce the model size by eliminating invalid relationships.

Which column should you remove?

You have a sales report as shown in the following exhibit.

The sales report has the following characteristics:

The measures are optimized.

The dataset uses import storage mode.

Data points, hierarchies, and fields cannot be removed or filtered from the report page.

From powerbi.com, users experience slow load times when viewing the report.

You need to reduce how long it takes for the report to load without affecting the data displayed in the report.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure Synapse Analytics workspace. You create an Azure Data Lake Storage Gen2 account and upload a CSV file named Filel.csv. You need to use Synapse Studio to query the data in

Filel.csv by using a serverless SQL pool. Which Transact-SQL operator should you include in the query?

DRAG DROP

You have a dataset that is populated from a list of business categories in

a source database. The list of categories changes over time.

You use Power Bl Report Builder to create a paginated report. The report has a report parameter named BusinessCategory.

You need to modify BusinessCategory to ensure that when the report opens, a drop-down list displays all the business categories, and all the business categories are selected.

How should you configure BusinessCategory? To answer, drag the appropriate options to the correct settings. Each option 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.

You have a Power Bl tenant.

You need to ensure that all reports use a consistent set of co applied to existing reports.

colors and fonts. The solution must ensure that the colors and fonts can be

What should you create?

You need to use Power Bl to ingest data from an API. The API requires that an API key be passed in the headers of the request.

Which type of authentication should you use?

You have a Power Bl report that contains a bar chart. The bar chart displays sales by country.

You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader.

What should you configure on the bar chart?

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.

From Power Query Editor, you profile the data s

the following exhibit

The loT GUID and loT ID columns are unique to each row in the query.

You need to analyze loT events by the hour and day of the year. The solution must improve dataset performance.

Solution: You change the loT DateTime column to the date data type.

Does this meet the goal?