Practice Questions

---

Question 1

What is the primary purpose of Azure Databricks?

A. Hosting relational databases
B. Managing file shares
C. Processing large-scale data using Apache Spark
D. Running virtual machines

✅ Answer: C

Explanation:
Azure Databricks is built on Apache Spark for large-scale data processing.

---

Question 2

Which feature is a key characteristic of Azure Databricks?

A. Fixed schema relational tables
B. Distributed data processing
C. File-based storage only
D. Limited scalability

✅ Answer: B

Explanation:
Databricks uses distributed computing to process large datasets efficiently.

---

Question 3

Which scenario is BEST suited for Azure Databricks?

A. Hosting a transactional database
B. Running large-scale ETL pipelines and machine learning models
C. Managing shared file storage
D. Serving static web pages

✅ Answer: B

Explanation:
Databricks is ideal for data engineering and machine learning at scale.

---

Question 4

What is Microsoft Fabric primarily designed for?

A. Running operating systems
B. Providing a unified, end-to-end analytics platform
C. Managing virtual networks
D. Hosting relational databases only

✅ Answer: B

Explanation:
Microsoft Fabric integrates multiple analytics capabilities into one unified platform.

---

Question 5

Which component of Microsoft Fabric serves as a unified data storage layer?

A. Azure Blob Storage
B. SQL Database
C. OneLake
D. Azure Files

✅ Answer: C

Explanation:
OneLake is the centralized storage layer within Microsoft Fabric.

---

Question 6

Which service is BEST suited for organizations that want a single platform for data engineering, data warehousing, and BI?

A. Azure Virtual Machines
B. Azure Databricks
C. Microsoft Fabric
D. Azure Table Storage

✅ Answer: C

Explanation:
Fabric provides an end-to-end unified analytics experience.

---

Question 7

Which of the following best describes the difference between Azure Databricks and Microsoft Fabric?

A. Databricks is for storage, Fabric is for compute
B. Databricks focuses on big data processing, Fabric provides a unified analytics platform
C. Fabric only supports relational data, Databricks does not
D. Databricks cannot scale, Fabric can

✅ Answer: B

Explanation:
Databricks focuses on processing and ML, while Fabric provides end-to-end analytics.

---

Question 8

Which programming environments are commonly supported in Azure Databricks notebooks?

A. HTML and CSS only
B. Python, SQL, Scala, and R
C. JavaScript only
D. PowerShell only

✅ Answer: B

Explanation:
Databricks notebooks support multiple languages including Python, SQL, Scala, and R.

---

Question 9

Which scenario is NOT ideal for Azure Databricks?

A. Large-scale data transformation
B. Machine learning model training
C. Managing simple file shares
D. Processing streaming data

✅ Answer: C

Explanation:
Databricks is not designed for file-sharing scenarios.

---

Question 10

Which statement about Microsoft Fabric is TRUE?

A. It requires manual infrastructure management
B. It is a SaaS-based unified analytics platform
C. It only supports batch processing
D. It replaces all Azure services

✅ Answer: B

Explanation:
Microsoft Fabric is a fully managed SaaS platform that integrates analytics services.

---

✅ Quick Exam Takeaways

✔ Azure Databricks

• Apache Spark-based
• Distributed processing
• Data engineering & machine learning

✔ Microsoft Fabric

• Unified analytics platform
• End-to-end solution (data + analytics + BI)
• Includes OneLake storage

✔ Key differences:

• Databricks → processing & ML
• Fabric → all-in-one analytics platform

✔ Exam tip:
👉 Big data processing → Azure Databricks
👉 Unified analytics platform → Microsoft Fabric

---

Go to the DP-900 Exam Prep Hub main page.