DP-200 Azure Data Processing and Pipelines 2

Question 1

In Azure Databricks, what is a Delta Lake table?

Accepted Answer

An ACID-compliant storage layer built on Parquet files with a transaction log

Answer

A proprietary binary format incompatible with Spark

Answer

A real-time streaming sink only

Answer

A NoSQL document store

Question 2

What Azure Databricks feature allows you to query the state of a Delta table at a previous point in time?

Accepted Answer

Time travel

Answer

Schema evolution

Answer

Z-ordering

Answer

Auto Loader

Question 3

In Azure Databricks, which command is used to optimize a Delta table by compacting small files into larger ones?

Accepted Answer

OPTIMIZE

Answer

VACUUM

Answer

ANALYZE

Answer

COMPACT

Question 4

What does the VACUUM command do on a Delta Lake table?

Accepted Answer

Removes old data files no longer referenced by the transaction log

Answer

Compacts small files into larger Parquet files

Answer

Rebuilds statistics for query optimization

Answer

Applies schema changes to all partitions

Question 5

Which Azure service is used to ingest high-velocity streaming data such as telemetry from millions of IoT devices before processing in Azure Databricks?

Accepted Answer

Azure Event Hubs

Answer

Azure Service Bus

Answer

Azure Notification Hubs

Answer

Azure Relay

Question 6

What is the primary benefit of using Azure Data Factory's data flow (mapping data flow) over a custom Spark script?

Accepted Answer

Codeless, visually designed transformations that run on Spark clusters

Answer

Lower memory usage

Answer

Faster execution than hand-written Spark code

Answer

Support for real-time streaming only