DP-600 Sample Questions & Answers

You are the Fabric Administrator for a healthcare organization. You need to implement a security strategy for a new workspace named 'PatientAnalytics'. The workspace will contain a Lakehouse with sensitive patient admission data. The requirements are:

1. Data Engineers must be able to create and edit notebooks and pipelines.
2. Data Analysts must be able to build Power BI reports using the default semantic model but MUST NOT be able to view the underlying files in the Lakehouse explorer or run notebooks.
3. Compliance Officers need to view reports but cannot edit them.

Which combination of Workspace Roles should you assign to meet these requirements with the Principle of Least Privilege?

A manufacturing company is designing a data ingestion strategy for their Fabric environment. They have a legacy on-premises SQL Server that processes 500,000 transactions per hour. They need to ingest this data into a Fabric Lakehouse every 15 minutes to support near real-time dashboarding. The solution must minimize load on the source server and support schema drift if new columns are added to the source tables.

Which ingestion method should you recommend?

You are optimizing a semantic model in Fabric that uses Direct Lake mode. The model connects to a Delta table in a Lakehouse containing 500 million rows. Users report that a specific report page is loading slowly. Upon investigation using the Performance Analyzer, you notice that the DAX queries are falling back to DirectQuery mode.

Which of the following scenarios would cause Direct Lake to fall back to DirectQuery?

You are designing a data warehouse schema for a retail organization in Microsoft Fabric. The warehouse will store sales transactions. The Sales fact table is expected to grow by 10 million rows per month. You need to design the table to optimize query performance for reports that filter by OrderDate and Region.

Which T-SQL command should you use to create the table?

You are implementing version control for a Fabric workspace using the new Git integration features. You have connected your workspace to an Azure DevOps repository. You create a new branch named 'feature/sales-update' and make changes to a semantic model and a report.

What is the correct sequence of actions to promote these changes to the 'main' branch and update the Production workspace? (Select the order of steps)

You need to perform a one-time migration of 5 TB of historical logs from an Amazon S3 bucket to a Microsoft Fabric Lakehouse. The data is in Parquet format. You want to make this data available in Fabric as quickly as possible without duplicating the storage costs immediately.

Which feature should you use?

Case Study: Northwind Traders

Northwind Traders is a global logistics company. They are modernizing their analytics stack using Microsoft Fabric.

Current Situation:
Northwind has three main data sources:

1. ERP System: Azure SQL Database (Relational, high volume).
2. IoT Sensors: JSON logs streaming from delivery trucks (Semi-structured, high velocity).
3. Partner Data: CSV files dropped daily into an Azure Data Lake Storage Gen2 container.

Requirements:

• Requirement A: The IoT sensor data needs to be analyzed in near real-time to detect vehicle anomalies.
• Requirement B: The ERP data needs to be joined with Partner Data for monthly financial reporting. The finance team prefers writing T-SQL.
• Requirement C: The data engineering team wants to use Python for complex transformations on the Partner Data before it is available to Finance.

Question:
Based on Requirement A, which Fabric item is best suited to store and analyze the high-velocity IoT sensor logs?

Referring to the Northwind Traders case study, consider Requirement B and C (ERP data joined with Partner Data, using Python for transformation but T-SQL for final reporting).

Which architectural pattern should you implement?