Free DP-600 sample questions
Here are free DP-600 sample questions with answers and explanations for each one. They cover data preparation, semantic models and governance in Microsoft Fabric. Use them to check your Fabric analytics skills before exam day.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 8 of 17 free sample questions.
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?
You are creating a PySpark notebook to clean a dataframe named `df_sales`. You need to remove rows where the `CustomerID` is null and drop any duplicate rows based on the `TransactionID` column. Which code snippet should you use?
You are managing a Power BI semantic model that contains a calculation group named 'Time Intelligence'. You have an explicit measure named `Total Sales`. You want to prevent the calculation group from applying to a specific measure named `Inventory Count` because it is a snapshot metric and should not be summed over time. What property should you configure in the Calculation Item DAX expression?
You are building a Star Schema in a Fabric Lakehouse. You have a `FactSales` table and a `DimProduct` table. You need to handle a Slowly Changing Dimension (SCD) Type 2 scenario for `DimProduct` using a PySpark notebook. The source system provides a full extract daily. Which Delta Lake feature facilitates merging the new data while maintaining history?
Which TWO items are required to successfully configure a deployment pipeline in Microsoft Fabric to deploy a Lakehouse and its associated Notebooks from Development to Test? (Select TWO)
9 more free samples are waiting
Create a free account to unlock the whole DP-600 sample bank, or get full access to all 209 practice questions in the simulator.