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

You have a Power Bl workspace named Workspacel that contains five dataflows.

You need to configure Workspacel to store the dataflows in an Azure Data Lake Storage Gen2 account What should you do first?

You are creating a Power 81 single-page report.

Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.

You need to ensure that the users can consume content on a report page in a logical order.

What should you configure on the report page?

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual. What should you do?

You have a Power Bl dataset that has only the necessary fields visible for report development.

You need to ensure that end users see only 25 specific fields that they can use to personalize visuals.

What should you do?

You have a Power Bl report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache Parquet format. A sample of the data is shown in the following table.

You need to create a Transact-SQL query that will return the source IP address.

Which function should you use in the select statement to retrieve the source IP address?

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?

You are optimizing a dataflow in a Power Bl Premium capacity. The dataflow performs multiple joins.

You need to reduce the load time of the dataflow.

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

Each correct selection is worth one point.

Note: This question is part of a scries 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 creating a perspective that contains the commonly used fields.

Does this meet the goal?