Microsoft Certification Azure Data Fundamentals (DP-900) 2 — Questions and Answers
Question 1: Which Azure service is a fully managed data integration and ETL pipeline service?
- Azure Synapse Analytics
- Azure Data Factory (Correct answer)
- Azure Databricks
- Azure Stream Analytics
Correct answer: Azure Data Factory
Azure Data Factory is a cloud-based ETL and data integration service that enables you to create, schedule, and orchestrate data-driven workflows.
Question 2: What is Azure Synapse Analytics primarily designed for?
- Real-time event streaming and messaging
- Integrated analytics combining data warehousing and big data processing (Correct answer)
- Document storage and content retrieval
- Deploying and managing containerized applications
Correct answer: Integrated analytics combining data warehousing and big data processing
Azure Synapse Analytics is an integrated analytics service that unifies data warehousing, big data analytics, and data integration into a single platform.
Question 3: Which Azure storage service is best suited for storing large amounts of unstructured data such as images, videos, and log files?
- Azure SQL Database
- Azure Table Storage
- Azure Queue Storage
- Azure Blob Storage (Correct answer)
Correct answer: Azure Blob Storage
Azure Blob Storage is designed for storing massive amounts of unstructured object data, including images, videos, documents, and backups.
Question 4: What is Azure Cosmos DB best known for?
- Strict relational schema enforcement
- Globally distributed, multi-model NoSQL database with low latency (Correct answer)
- Batch analytics on petabytes of historical data
- Managed SQL Server instances with Always On availability
Correct answer: Globally distributed, multi-model NoSQL database with low latency
Azure Cosmos DB is a globally distributed, multi-model NoSQL database designed for high availability, low latency, and automatic scalability worldwide.
Question 5: Which Azure service provides real-time analytics on fast-moving streaming data from IoT devices and applications?
- Azure Data Factory
- Azure Synapse Analytics
- Azure Stream Analytics (Correct answer)
- Azure Databricks
Correct answer: Azure Stream Analytics
Azure Stream Analytics is a real-time event-processing engine that analyzes streaming data from IoT devices, applications, and other sources.
Question 6: What type of data store is Azure Table Storage?
- Relational database with foreign key constraints
- Document store with JSON support
- NoSQL key-value store for semi-structured data (Correct answer)
- Graph database for relationship mapping
Correct answer: NoSQL key-value store for semi-structured data
Azure Table Storage is a NoSQL key-value store that can hold large amounts of semi-structured data without requiring a fixed schema.
Question 7: What is the primary function of Azure Databricks?
- Managing Azure AD identities and access
- Big data processing and machine learning using Apache Spark (Correct answer)
- Relational database management and SQL optimization
- Network traffic analysis and DDoS protection
Correct answer: Big data processing and machine learning using Apache Spark
Azure Databricks is an Apache Spark-based analytics platform optimized for big data processing, collaborative data science, and machine learning workloads.
Microsoft Certification Azure Data Fundamentals (DP-900) 2
Which Azure service is a fully managed data integration and ETL pipeline service?