Maintain the analytics development lifecycle
13 practice questions under this official exam objective (DP-600), each with the answer key, an option-by-option explanation and instant feedback.
Questions under this objective
13 total · page 1 of 1Which Languages Support PREDICT Function in Fabric Notebook
Microsoft Fabric notebooks support the PREDICT function for machine learning model scoring using specific Spark-based languages. This page establishes
How to Minimize Data Copying When Cloning a Table in Fabric?
Creating a zero-copy clone of a table in a Microsoft Fabric warehouse minimizes data movement and storage costs. The CREATE TABLE AS CLONE OF statemen
Fabric Pipeline Activity Conditional Path Configuration
This page explains how to configure conditional paths between activities in a Microsoft Fabric data pipeline. It establishes that the Upon Completion
Using EXPLAIN vs DESCRIBE HISTORY for Delta Table Maintenance
The EXPLAIN statement in Spark SQL is used to display the execution plan of a query, not the maintenance history of a Delta table. This page establish
Identify Delta Table Maintenance with DESCRIBE HISTORY
Running DESCRIBE HISTORY on a Delta table in Microsoft Fabric reveals its operation history, including maintenance tasks like OPTIMIZE and VACUUM. Thi
What File Format Saves Power BI as Individual Text Files?
Power BI Project (PBIP) format saves semantic models and reports as individual plain text files in a folder hierarchy, making it ideal for version con
Removing Unreferenced Delta Table Files in Fabric
This page explains how to safely remove unreferenced Parquet files from a Delta table in a Microsoft Fabric lakehouse while preserving ACID properties
Does REFRESH TABLE Identify Delta Table Maintenance?
Running REFRESH TABLE on a Delta table only updates cached metadata and does not reveal if maintenance tasks like OPTIMIZE or VACUUM were performed. T
Which Power BI File to Gitignore to Prevent Data Push
When using Azure DevOps for version control with Power BI, preventing data values from data sources from being pushed to the repository requires ignor
Fabric Data Factory Stored Procedure Activity
The Lookup activity in Fabric Data Factory is used to execute a stored procedure or query and retrieve its output. This page confirms why the Lookup a
How to Sequence Data Loading Activities in Fabric
To execute data loading activities in a specific sequence within a Fabric workspace, you should use a pipeline with dependencies between activities. T
Which Power BI File Format Contains No Data
A Power BI Template (PBIT) file is used to create multiple reports with predefined connections and formatting without containing actual data. This pag
Identify Delta Table Maintenance with Spark SQL
Running DESCRIBE DETAIL on a Delta table reveals its metadata and configuration, but it does not show the history of maintenance operations. This page