Microsoft DP-600 Exam Practice Test Instant Access

Question 1

You need to provide Power Bl developers with access to the pipeline. The solution must meet the following requirements:

* Ensure that the developers can deploy items to the workspaces for Development and Test.

* Prevent the developers from deploying items to the workspace for Production.

* Follow the principle of least privilege.

Which three levels of access should you assign to the developers? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

ABuild permission to the production semantic models

BAdmin access to the deployment pipeline

CViewer access to the Development and Test workspaces

DViewer access to the Production workspace

EContributor access to the Development and Test workspaces

FContributor access to the Production workspace

Answer : B, D, E

To meet the requirements, developers should have Admin access to the deployment pipeline (B), Contributor access to the Development and Test workspaces (E), and Viewer access to the Production workspace (D). This setup ensures they can perform necessary actions in development and test environments without having the ability to affect production. Reference = The Power BI documentation on workspace access levels and deployment pipelines provides guidelines on assigning appropriate permissions.

Question 2

What should you recommend using to ingest the customer data into the data store in the AnatyticsPOC workspace?

Aa stored procedure

Ba pipeline that contains a KQL activity

Ca Spark notebook

Da dataflow

Answer : D

For ingesting customer data into the data store in the AnalyticsPOC workspace, a dataflow (D) should be recommended. Dataflows are designed within the Power BI service to ingest, cleanse, transform, and load data into the Power BI environment. They allow for the low-code ingestion and transformation of data as needed by Litware's technical requirements. Reference = You can learn more about dataflows and their use in Power BI environments in Microsoft's Power BI documentation.

Question 3

You have a Fabric tenant that contains a workspace named Workspace1.

You plan to deploy a semantic model named Model1 by using the XMLA endpoint.

You need to optimize the deployment of Model1. The solution must minimize how long it takes to deploy Model1.

What should you do in Workspace1?

ASelect Small semantic model storage format.

BSelect Users can edit data models in the Power BI service.

CSet Enable Cache for Shortcuts to On.

DSelect Large semantic model storage format.

Answer : A

Question 4

You have a Fabric tenant

You plan to create a data pipeline named Pipeline1. Pipeline1 will include two activities that will execute in sequence. You need to ensure that a failure of the first activity will NOT block the second activity. Which conditional path should you configure between the first activity and the second activity?

AUpon Completion

BUpon Success

CUpon Skip

DUpon Failure

Answer : A

Question 5

You need to recommend a solution to prepare the tenant for the PoC.

Which two actions should you recommend performing from the Fabric Admin portal? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

AEnable the Users can try Microsoft Fabric paid features option for specific security groups.

BEnable the Allow Azure Active Directory guest users to access Microsoft Fabric option for specific security groups.

CEnable the Users can create Fabric items option and exclude specific security groups.

DEnable the Users can try Microsoft Fabric paid features option for the entire organization.

EEnable the Users can create Fabric items option for specific security groups.

Answer : A, E

The PoC is planned to be completed using a Fabric trial capacity, which implies that users involved in the PoC should be able to try paid features. However, this should be limited to specific security groups involved in the PoC to prevent the entire organization from accessing these features before the trial is proven successful (A). The ability for users to create Fabric items should also be enabled for specific security groups to ensure that only the relevant team members participating in the PoC can create items in the Fabric environment (E).

Question 6

You have a Fabric tenant that contains a semantic model named Model1. Model1 uses Import mode. Model1 contains a table named Orders. Orders has 100 million rows and the following fields.

You need to reduce the memory used by Model! and the time it takes to refresh the model. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

ASplit OrderDateTime into separate date and time columns.

BReplace TotalQuantity with a calculated column.

CConvert Quantity into the Text data type.

DReplace TotalSalesAmount with a measure.

Answer : B, D

To reduce memory usage and refresh time, splitting the OrderDateTime into separate date and time columns (A) can help optimize the model because date/time data types can be more memory-intensive than separate date and time columns. Moreover, replacing TotalSalesAmount with a measure (D) instead of a calculated column ensures that the calculation is performed at query time, which can reduce the size of the model as the value is not stored but calculated on the fly. Reference = The best practices for optimizing Power BI models are detailed in the Power BI documentation, which recommends using measures for calculations that don't need to be stored and adjusting data types to improve performance.

Question 7

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily.

You create a Microsoft Power Bl semantic model named Modell that uses the CSV files as a data source. You configure incremental refresh for Model 1 and publish the model to a Premium capacity in the Fabric tenant.

When you initiate a refresh of Model1, the refresh fails after running out of resources.

What is a possible cause of the failure?

AQuery folding is occurring.

BOnly refresh complete days is selected.

CXMLA Endpoint is set to Read Only.

DQuery folding is NOT occurring.

EThe data type of the column used to partition the data has changed.

Answer : D

A possible cause for the failure is that query folding is NOT occurring (D). Query folding helps optimize refresh by pushing down the query logic to the source system, reducing the amount of data processed and transferred, hence conserving resources. Reference = The Power BI documentation on incremental refresh and query folding provides detailed information on this topic.

Microsoft Implementing Analytics Solutions Using Microsoft Fabric DP-600 Exam Practice Test