Prepare DP-600 Exam with Using DP-600 Dump Questions

1. 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?

2. HOTSPOT

You have a Fabric tenant.

You plan to create a Fabric notebook that will use Spark DataFrames to generate Microsoft Power Bl visuals.

You run the following code.





For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

3. You have a Fabric tenant that contains a warehouse.

You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD).

You need to recommend which columns to add to the table. The columns must NOT already exist in the source.

Which three types of columns should you recommend? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

4. HOTSPOT

You have a Fabric warehouse that contains a table named Sales.Products. Sales.Products contains the following columns.





You need to write a T-SQL query that will return the following columns.





How should you complete the code? To answer, select the appropriate options in the answer area.

5. DRAG DROP

You are implementing two dimension tables named Customers and Products in a Fabric warehouse.

You need to use slowly changing dimension (SCO) to manage the versioning of data.

The solution must meet the requirements shown in the following table.





Which type of SCD should you use for each table? To answer, drag the appropriate SCD types to the correct tables. Each SCD type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

6. What should you use to implement calculation groups for the Research division semantic models?

7. DRAG DROP

You are creating a dataflow in Fabric to ingest data from an Azure SQL database by using a T-SQL statement.

You need to ensure that any foldable Power Query transformation steps are processed by the Microsoft SQL Server engine.

How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

8. You have source data in a folder on a local computer.

You need to create a solution that will use Fabric to populate a data store.

The solution must meet the following requirements:

• Support the use of dataflows to load and append data to the data store.

• Ensure that Delta tables are V-Order optimized and compacted automatically.

Which type of data store should you use?

9. In Microsoft Fabric, which tools are essential for the exploration and analysis of data? (Choose three.

10. HOTSPOT

You have a Microsoft Power Bl semantic model.

You plan to implement calculation groups.

You need to create a calculation item that will change the context from the selected date to month-to-date (MTD).

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

11. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Fabric tenant that contains a lakehouse named Lakehousel. Lakehousel contains a Delta table named Customer.

When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table.

You need to identify whether maintenance tasks were performed on Customer.

Solution: You run the following Spark SQL statement:

DESCRIBE DETAIL customer

Does this meet the goal?

12. You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a subfolder named Subfolder1 that contains CSV files. You need to convert the CSV files into the delta format that has V-Order optimization enabled.

What should you do from Lakehouse explorer?

13. HOTSPOT

You have a data warehouse that contains a table named Stage. Customers. Stage-Customers contains all the customer record updates from a customer relationship management (CRM) system. There can be multiple updates per customer

You need to write a T-SQL query that will return the customer ID, name, postal code, and the last updated time of the most recent row for each customer ID.

How should you complete the code? To answer, select the appropriate options in the answer area, NOTE Each correct selection is worth one point.

14. HOTSPOT

You have an Azure Data Lake Storage Gen2 account named storage! that contains a Parquet file named sales.parquet.

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

Using a notebook in Workspace1, you need to load the content of the file to the default lakehouse. The solution must ensure that the content will display automatically as a table named Sales in Lakehouse explorer.

How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

15. You have a Fabric tenant that contains a lakehouse named Lakehouse! Lakehouse1 contains a Delta

table that has one million Parquet files.

You need to remove files that were NOT referenced by the table during the past 30 days. The solution must ensure that the transaction log remains consistent, and the ACID properties of the table are maintained

What should you do?

16. Which of the following is NOT a core component of Microsoft Fabric's analytics solutions?

17. When configuring a data lake in Microsoft Fabric, which security feature ensures that only authorized users can access specific data?

18. You have a Fabric tenant that contains a Microsoft Power Bl report.

You are exploring a new semantic model.

You need to display the following column statistics:

• Count

• Average

• Null count

• Distinct count

• Standard deviation

Which Power Query function should you run?

19. You are analyzing customer purchases in a Fabric notebook by using PySpanc

You have the following

DataFrames:





You need to join the DataFrames on the customer_id column. The solution must minimize data shuffling. You write the following code.





Which code should you run to populate the results DataFrame?

A)





B)





C)





D)

20. You have a Fabric tenant that uses a Microsoft tower Bl Premium capacity. You need to enable scale-out for a semantic model.

What should you do first?

21. You have a Microsoft Fabric tenant that contains a dataflow.

You are exploring a new semantic model.

From Power Query, you need to view column information as shown in the following exhibit.





Which three Data view options should you select? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

A. Enable column profile

B. Show column quality details

C. Show column profile in details pane

D. Enable details pane

E. Show column value distribution

22. You have a Fabric tenant that contains a data pipeline.

You need to ensure that the pipeline runs every four hours on Mondays and Fridays.

To what should you set Repeat for the schedule?

23. 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?

24. DRAG DROP

You create a semantic model by using Microsoft Power Bl Desktop.

The model contains one security role named SalesRegionManager and the following tables:

• Sales

• SalesRegion

• Sales Ad dress

You need to modify the model to ensure that users assigned the SalesRegionManager role cannot see a column named Address in Sales Address.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

25. HOTSPOT

You have a Fabric tenant that contains a semantic model. The model contains data about retail stores.

You need to write a DAX query that will be executed by using the XMLA endpoint. The query must return the total amount of sales from the same period last year.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

26. You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode.

You suspect that some DAX queries load unnecessary columns into memory.

You need to identify the frequently used columns that are loaded into memory.

What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

27. Topic 2, Contoso, ltd.



Overview

Contoso, ltd. is a US-based health supplements company, Contoso has two divisions named Sales and Research. The Sales division contains two departments named Online Sales and Retail Sales. The Research division assigns internally developed product lines to individual teams of researchers and analysts.



Identity Environment

Contoso has a Microsoft Entra tenant named contoso.com. The tenant contains two groups named ResearchReviewersGroupi and ReseachReviewefsGfoup2.



Data Environment

Contoso has the following data environment

• The Sales division uses a Microsoft Power B1 Premium capacity.

• The semantic model of the Online Sales department includes a fact table named Orders that uses import mode. In the system of origin, the OrderlD value represents the sequence in which orders are created.

• The Research department uses an on-premises. third-party data warehousing product.

• Fabric is enabled for contoso.com.

• An Azure Data Lake Storage Gen2 storage account named storage1 contains Research division data for a product line named Producthne1. The data is in the delta format.

• A Data Lake Storage Gen2 storage account named storage2 contains Research division data for a product line named Productline2. The data is in the CSV format.



Planned Changes

Contoso plans to make the following changes:

• Enable support for Fabric in the Power Bl Premium capacity used by the Sales division.

• Make all the data for the Sales division and the Research division available in Fabric.

• For the Research division, create two Fabric workspaces named Producttmelws and Productline2ws.

• in Productlinelws. create a lakehouse named LakehouseV

• In Lakehouse1. create a shortcut to storage1 named ResearchProduct.



Data Analytics Requirements

Contoso identifies the following data analytics requirements:

• All the workspaces for the Sales division and the Research division must support all Fabric experiences.

• The Research division workspaces must use a dedicated, on-demand capacity that has per-minute billing.

• The Research division workspaces must be grouped together logically to support OneLake data hub filtering based on the department name.

• For the Research division workspaces, the members of ResearchRevtewersGroupl must be able to read lakehouse and warehouse data and shortcuts by using SQL endpoints.

• For the Research division workspaces, the members of ResearchReviewersGroup2 must be able to read lakehouse data by using Lakehouse explorer.

• All the semantic models and reports for the Research division must use version control that supports branching



Data Preparation Requirements

Contoso identifies the following data preparation requirements:

• The Research division data for Producthne2 must be retrieved from Lakehouset by using Fabric notebooks.

• All the Research division data in the lakehouses must be presented as managed tables in Lakehouse explorer.



Semantic Model Requirements

Contoso identifies the following requirements for implementing and managing semantic models;

• The number of rows added to the Orders table during refreshes must be minimized.

• The semantic models in the Research division workspaces must use Direct Lake mode.



General Requirements

Contoso identifies the following high-level requirements that must be considered for all solutions:

• Follow the principle of least privilege when applicable

• Minimize implementation and maintenance effort when possible.



Which syntax should you use in a notebook to access the Research division data for Productlinel?

A)





B)





C)





D)

28. You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. Report1 includes a Python visual. Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed. You need all rows to appear in the visual.

What should you do?

29. HOTSPOT

You have a Fabric warehouse that contains a table named Sales.Orders. Sales.Orders contains the following columns.





You need to write a T-SQL query that will return the following columns.





How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

30. You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dawset named DS1. You need to ensure read-write access to DS1 is available by using the XMLA endpoint.

What should be modified first?

31. HOTSPOT

You need to resolve the issue with the pricing group classification.

How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

32. Which type of data store should you recommend in the Analytics POC workspace?

33. Which Power BI component is used to integrate and transform data from various data sources?