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

Question 7 (Misc. Questions)

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.

Select all that apply, then click Submit answer.

○
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.

Reference / correct answer:

Execute foldable operations before non-foldable operations.

Place the ingestion operations and transformation operations in separate dataflows.

Using the compute engine to improve performance

Take the following steps to enable workloads trigger the compute engine, and always improve performance:

For computed and linked entities in the same workspace:

Ensure you perform the operations that fold, such as merges, joins, conversion, and others.

For ingestion focus on getting the data into the storage as fast as possible, using filters only if they reduce the overall dataset size. It's best practice to keep your transformation logic separate from this step, and allow the engine to focus on the initial gathering of ingredients. Next, separate your transformation and business logic into a separate dataflow in the same workspace, using linked or computed entities; doing so allows for the engine to activate and accelerate your computations. In our analogy, it's like food preparation in the kitchen: food preparation is typically a separate and distinct step from gathering your raw ingredients, and a pre-requisite for putting the food in the oven. Similarly, your logic needs to be prepared separately before it can take advantage of the compute engine.

Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-workload-configuration

Question 8 (Misc. Questions)

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?

Select an option, then click Submit answer.

○
parameter rules
○
selective deployment
○
auto-binding across pipelines
○
data source rules

Question 9 (Misc. Questions)

You have a Power Bl report that contains one visual.

You need to provide users with the ability to change the visual type without affecting the view for other users.

What should you do?

Select an option, then click Submit answer.

○
From Report setting, select Personalize visuals.
○
From Tabular Editor, create a new perspective.
○
From the Bookmarks pane, select Focus mode, and then select Add.
○
From Visual options in Report settings, select Use the modern visual header with updated styling options.

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