DP-900 Azure Databricks 2 — Questions and Answers
Question 1: What is the Azure Databricks workspace?
- A storage account for Databricks data
- An environment that organizes notebooks, clusters, jobs, and data into a unified interface (Correct answer)
- A dedicated Azure Virtual Network for Databricks
- A database schema within Azure SQL
Correct answer: An environment that organizes notebooks, clusters, jobs, and data into a unified interface
The Azure Databricks workspace is a unified environment that organizes assets such as notebooks, clusters, jobs, libraries, and data, enabling team collaboration.
Question 2: Which feature of Delta Lake allows users to query data as it existed at a previous point in time?
- Data masking
- Time travel (Correct answer)
- Partitioning
- Auto-clustering
Correct answer: Time travel
Delta Lake's time travel feature uses a transaction log to let users query historical versions of data using a timestamp or version number.
Question 3: What is MLflow in the context of Azure Databricks?
- A data pipeline orchestration tool
- An open-source platform for managing the machine learning lifecycle including experiments and model registry (Correct answer)
- A SQL query optimizer
- A real-time streaming analytics service
Correct answer: An open-source platform for managing the machine learning lifecycle including experiments and model registry
MLflow is an open-source platform integrated into Azure Databricks that helps manage the ML lifecycle, including experiment tracking, model versioning, and deployment.
Question 4: How are Azure Databricks clusters billed?
- A flat monthly subscription regardless of usage
- Based on Databricks Units (DBUs) consumed during cluster operation (Correct answer)
- Per notebook cell executed
- Based on the number of notebooks in the workspace
Correct answer: Based on Databricks Units (DBUs) consumed during cluster operation
Azure Databricks uses a consumption-based model where you are billed for Databricks Units (DBUs), which represent processing capability per hour, combined with underlying VM costs.
Question 5: What is a Databricks Job?
- A SQL stored procedure in Azure SQL Database
- A scheduled or triggered execution of a notebook or JAR on a cluster (Correct answer)
- A data migration task in Azure Data Factory
- A background service running in Azure App Service
Correct answer: A scheduled or triggered execution of a notebook or JAR on a cluster
A Databricks Job is a way to schedule or trigger the automated execution of notebooks, Python scripts, or JAR files on a cluster for production workloads.
Question 6: Which two types of clusters does Azure Databricks offer?
- Hot clusters and cold clusters
- All-purpose clusters and job clusters (Correct answer)
- Shared clusters and private clusters
- CPU clusters and GPU clusters
Correct answer: All-purpose clusters and job clusters
Azure Databricks offers all-purpose clusters for interactive development and collaboration, and job clusters that are created for a single job and terminated after the job completes.
Question 7: What file format does Delta Lake use to physically store data?
- CSV
- JSON
- Parquet (Correct answer)
- ORC
Correct answer: Parquet
Delta Lake stores data in Parquet file format, which is a columnar storage format optimized for analytics workloads, combined with a transaction log for ACID compliance.
What is the Azure Databricks workspace?