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.

Replace the single-value cards with a multi-row card.

Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.

Change the report theme to monochromatic.

Replace the single-value cards with a multi-row card.

Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.

Replace all the filters on the Filters pane with visual slicers on the report page.

You deploy a tabular model named DM! to a Power Bl Premium capacity. DM1 was created as an import model.You change a fact table named Table1 into a hybrid table.What else occurred on DM1 automatically after the change?

A DirectQuery partition was added to Table1.

Dimension tables that relate to Table1 were changed to dual storage mode.

A related aggregation table was created.

Table1 was removed from the scheduled refresh.

A DirectQuery partition was added to Table1.

You have a Power Bl tenantYou invite an external consultant to work in the tenant.You need to grant the consultant access to the tenant. The solution must meet the following requirements;* The consultant must be able to consume, create, and update reports and datasets.* The consultant must access content by using Azure AD B2B.Which settings should you enable in the Power Bl Admin portal? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Allow Azure Active Directory guest users to access Power Bl

Allow Azure Active Directory guest users to edit and manage content in the organization

Invite external users to your organization

Allow Azure Active Directory guest users to access Power Bl

Allow Azure Active Directory guest users to edit and manage content in the organization

You have a Power Bl report hosted on the Power Bl service. The report displays expenses by department for department managers and contains a line chart that shows expenses by month. You need to ensure that users can choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?

Enable report readers to personalize visuals.

Add a column chart, a bookmark, and a button for users to choose a visual.

Enable report readers to personalize visuals.

Create a separate report page for users to view a column chart.

Create a mobile report that contains a column chad.

You have an Azure Synapse Analytics dedicated SQL pool and a Microsoft Purview account. The Microsoft Purview account has been granted sufficient permissions to the dedicated SQL pool. You need to ensure that the SQL pool is scanned by Microsoft Purview.What should you do first?

Create a data share connection.

You have a Power Bl tenant that is linked to an Azure AD tenant. The tenant contains a group named Group1.You create a paginated report that does NOT use row-level security (RLS).You need to send a copy of the report to Group1 every Monday at 9 AM UTCWhich two actions should you include in the solution? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Create a subscription for Group1

Publish the paginated report to a Pro workspace.

Create a subscription for Group1

Publish the paginated report to a Pro workspace.

Create a data alert for Group1.

Publish the paginated report to a Premium Per User workspace.

You have a Power Bl report that contains a card. The card displays the value for year-to-date revenue.You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.What should you do?

Populate the alt text by using conditional formatting with a DAX measure.

Convert the card into a text box.

Populate the alt text by using conditional formatting with a DAX measure.

Add the value to the chart title text.

Populate the alt text with a static value.

You are creating a Power Bl report that will contain multiple visuals.You need to ensure that the report is accessible to users who use a screen reader.Which two configurations should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

consistent colors for each visual

consistent fonts for each visual

You have a Power Bl workspace named workspace1 that contains three reports and two dataflows.You have an Azure Data Lake Storage account named storage1.You need to integrate workspace1 and storage1.What should you do first?

In storage1, create a folder named dataflows.

Delete the dataflows from workspace1.

In storage1, create a folder named reports.

Delete the reports from workspace1.

Microsoft DP-500 Practice Test 4 - Free Online Exam Prep & Questions

Home / Microsoft / DP-500 / Practice Test 4

Ask Question

00:00:00

Show Answer

Training mode

Report Issue

Restart test

Question 1 / 40

HOTSPOT

You are using an Azure Synapse notebook to create a Python visual.

You run the following code cell to import a dataset named Iris.

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

Microsoft DP-500 image Question 95 90372 10022024015933000000

You need to create the visual shown in the exhibit. (Click the Exhibit tab.)

Microsoft DP-500 image Question 95 90372 10022024015933000000

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

Score Report

Your Score: 0%
Time: 00:00:00

100

DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

Vendor:

Microsoft

Exam Questions:

162

Learners

2.370

Last Updated

March - 2025

Language

English

Microsoft DP-500 Practice Test 4

Question

Microsoft DP-500 Practice Tests

Practice Tests