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 capacity

You have a 2-GB Power Bl dataset.You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes to the dataset from powerbi.com.Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point

Turn on Large dataset storage format.

Enable service principal authentication for read-only admin APIs.

Turn on Large dataset storage format.

Connect the target workspace to an Azure Data Lake Storage Gen2 account.

You have five Power Bl reports that contain R script data sources and R visuals.You need to publish the reports to the Power Bl service and configure a daily refresh of datasets.What should you include in the solution?

an on-premises data gateway (standard mode)

a workspace that connects to an Azure Data Lake Storage Gen2 account

an on-premises data gateway (personal mode)

You have new security and governance protocols for Power Bl reports and datasets. The new protocols must meet the following requirements.• New reports can be embedded only in locations that require authentication.• Live connections are permitted only for workspaces that use Premium capacity datasets.Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.

From Capacity settings, set XMLA Endpoint to Read Write.

From Tenant settings, set Publish to web to Disable.

From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.

From the Premium per user settings, set XMLA Endpoint to Off.

From Embed Codes, delete all the codes.

From Capacity settings, set XMLA Endpoint to Read Write.

From Tenant settings, set Publish to web to Disable.

You have an Azure Synapse Analytics serverless SQL pool.You need to catalog the serverless SQL pool by using Azure Purview.Which three actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Create a managed identity in Azure Active Directory (Azure AD).

Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.

Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.

Create a managed identity in Azure Active Directory (Azure AD).

Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.

Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.

Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.

You are running a diagnostic against a query as shown in the following exhibit. What can you identify from the diagnostics query?

All the query steps are folding.

Elevated permissions are being used to query records.

You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL database named DB1. DB1 is a transactional database in the third normal form.You need to recommend a solution to minimize how long it takes to execute the query. The solution must maintain the current functionality. What should you include in the recommendation?

Create calculated columns in Dataset1.

Remove the relationships from Dataset1.

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?

When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.

The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.

The Actual/Forecast Billable Hrs YTD visual displays the most data.

Unoptimized DAX queries cause the page to load slowly.

When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.

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?

Replace both calculate functions by using a variable that contains the calculate function.

Remove the alternative result of blank( ) from the divide function.

Create a variable and replace the values for [sales Amount].

Remove "calendar'[Flag] = "YTD" from the code.

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?

DirectQuery for the external customers and import for the security team.

DirectQuery for the external customers and DirectQuery for the security team.

Import for the external customers and DirectQuery for the security team.

Import for the external customers and import for the security team.

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?

Performance analyzer in Power Bl Desktop

You need to save Power Bl dataflows in an Azure Storage account.Which two prerequisites are required to support the configuration? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

The connection must be created by a user that is assigned the Storage Blob Data Owner role.

The storage account must have hierarchical namespace enabled.

The storage account must be protected by using an Azure Firewall.

The connection must be created by a user that is assigned the Storage Blob Data Owner role.

The storage account must have hierarchical namespace enabled.

Dataflows must exist already for any directly connected Power Bl workspaces.

The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.

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

Associate the Power Bl tenant to an Azure Data Lake Storage account.

Create and save the dataflows to an Azure Data Lake Storage account.

Associate the Power Bl tenant to an Azure Data Lake Storage account.

Add the managed identity for Data Factory as a member of the workspaces.

Create and save the dataflows to an Azure Data Lake Storage account.

Create and save the dataflows to the internal storage of Power BL

You plan to modify a Power Bl dataset.You open the Impact analysis panel for the dataset and select Notify contacts.Which contacts will be notified when you use the Notify contacts feature?

all the workspace members of any workspace that uses the dataset

any users that accessed a report that uses the dataset within the last 30 days

the workspace admins of any workspace that uses the dataset

all the workspace members of any workspace that uses the dataset

You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need to modify the source control solution to use an Azure DevOps Git repository. What should you do first?

Disconnect from the GitHub repository.

Change the workspace to live mode.

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?

From the Power Bl Admin portal, enable tenant-level storage.

Disable load for all dataflow queries.

Change the Data source settings in the dataflow queries.

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?

Configure a distinct color for each series.

Replace long text with abbreviations and acronyms.

Configure a unique marker for each series.

Configure a distinct color for each series.

Move important information to a tooltip.

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?

Hide all the fields in the dataset.

From Tabular Editor, create a new role.

Hide all the fields in the dataset.

Configure object-level security (OLS).

From Tabular Editor, create a new perspective.

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?

Add alt text to explain the information that each color conveys.

Move the conditional formatting icons to a tooltip report.

Change the icons to use a different shape for each color.

Remove the icons and use red, yellow, and green background colors instead.

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.

Execute foldable operations before non-foldable operations.

Place the ingestion operations and transformation operations in separate dataflows.

Reduce the memory assigned to the dataflows.

Execute non-foldable operations before foldable operations.

Execute foldable operations before non-foldable operations.

Place the ingestion operations and transformation operations in a single dataflow.

Place the ingestion operations and transformation operations in separate dataflows.

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

Question 1 / 40

You have a Power Bl workspace that contains one dataset and four reports that connect to the dataset. The dataset uses Import storage mode and contains the following data sources:

• A CSV file in an Azure Storage account

• An Azure Database for PostgreSQL database

You plan to use deployment pipelines to promote the content from development to test to production. There will be different data source locations for each stage. What should you include in the deployment pipeline to ensure that the appropriate data source locations are used during each stage?

parameter rules

selective deployment

auto-binding across pipelines

data source rules

Comment (0)

Microsoft DP-500 Practice Test 2

Question

Microsoft DP-500 Practice Tests

Practice Tests