Microsoft DP-600 Exam Practice Test Instant Access

Question 1

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.

Question 2

You need to implement the date dimension in the data store. The solution must meet the technical requirements.

What are two ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

APopulate the date dimension table by using a dataflow.

BPopulate the date dimension table by using a Stored procedure activity in a pipeline.

CPopulate the date dimension view by using T-SQL.

DPopulate the date dimension table by using a Copy activity in a pipeline.

Answer : A, B

Both a dataflow (A) and a Stored procedure activity in a pipeline (B) are capable of creating and populating a date dimension table. A dataflow can perform the transformation needed to create the date dimension, and it aligns with the preference for using low-code tools for data ingestion when possible. A Stored procedure could be written to generate the necessary date dimension data and executed within a pipeline, which also adheres to the technical requirements for the PoC.

Question 3

You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?

Aan Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderlD column in the destination lakehouse

Ban Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of the OrderlD column in the destination lakehouse

Can Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderlD column in the destination lakehouse

Dan Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the minimum value of the OrderiD column m the
destination lakehouse

Answer : C

Question 4

You are creating a semantic model in Microsoft Power Bl Desktop.

You plan to make bulk changes to the model by using the Tabular Model Definition Language (TMDL) extension for Microsoft Visual Studio Code.

You need to save the semantic model to a file.

Which file format should you use?

APBIP

BPBIX

CPBIT

DPBIDS

Answer : B

When saving a semantic model to a file that can be edited using the Tabular Model Scripting Language (TMSL) extension for Visual Studio Code, the PBIX (Power BI Desktop) file format is the correct choice. The PBIX format contains the report, data model, and queries, and is the primary file format for editing in Power BI Desktop. Reference = Microsoft's documentation on Power BI file formats and Visual Studio Code provides further clarification on the usage of PBIX files.

Question 5

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 6

You need to ensure that Contoso can use version control to meet the data analytics requirements and the general requirements. What should you do?

AStore all the semantic models and reports in Data Lake Gen2 storage.

BModify the settings of the Research workspaces to use a GitHub repository.

CStore all the semantic models and reports in Microsoft OneDrive.

DModify the settings of the Research division workspaces to use an Azure Repos repository.

Answer : B

Question 7

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.

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