Microsoft Certification Azure Data Fundamentals (DP-900) 2

Question 1

Which Azure service is a fully managed data integration and ETL pipeline service?

Accepted Answer

Azure Data Factory

Answer

Azure Synapse Analytics

Answer

Azure Databricks

Answer

Azure Stream Analytics

Question 2

What is Azure Synapse Analytics primarily designed for?

Accepted Answer

Integrated analytics combining data warehousing and big data processing

Answer

Real-time event streaming and messaging

Answer

Document storage and content retrieval

Answer

Deploying and managing containerized applications

Question 3

Which Azure storage service is best suited for storing large amounts of unstructured data such as images, videos, and log files?

Accepted Answer

Azure Blob Storage

Answer

Azure SQL Database

Answer

Azure Table Storage

Answer

Azure Queue Storage

Question 4

What is Azure Cosmos DB best known for?

Accepted Answer

Globally distributed, multi-model NoSQL database with low latency

Answer

Strict relational schema enforcement

Answer

Batch analytics on petabytes of historical data

Answer

Managed SQL Server instances with Always On availability

Question 5

Which Azure service provides real-time analytics on fast-moving streaming data from IoT devices and applications?

Accepted Answer

Azure Stream Analytics

Answer

Azure Data Factory

Answer

Azure Synapse Analytics

Answer

Azure Databricks

Question 6

What type of data store is Azure Table Storage?

Accepted Answer

NoSQL key-value store for semi-structured data

Answer

Relational database with foreign key constraints

Answer

Document store with JSON support

Answer

Graph database for relationship mapping

Question 7

What is the primary function of Azure Databricks?

Accepted Answer

Big data processing and machine learning using Apache Spark

Answer

Managing Azure AD identities and access

Answer

Relational database management and SQL optimization

Answer

Network traffic analysis and DDoS protection