CDC in Databricks

Which property of ACID Transactions ensures that each statement in a transaction is treated as a single unit?

• 
  Consistency

• Durability

• Atomicity

• 
  Isolation

Which property of ACID Transactions ensures that concurrent transactions don't interfere with each other?

• Durability

• Atomicity

• 
  Consistency

• 
  Isolation

Which of the following factors contribute to the strength of Spark?

• Structured streaming, distributed computing, automatic data partitioning

• 
  Structured streaming, cloud integration, fault tolerance through replication, lazy evaluation

• 
  Distributed computing, resilient distributed dataset, in-memory processing, lazy evaluation

• 
  Distributed computing, cloud integration, in-memory processing, GPU acceleration

How does Delta Lake ensure ACID compliance?

• By using a distributed ledger for transaction management

• 
  By enforcing strict data consistency rules

• By leveraging the transaction log and versioning

• 
  By isolating data processing tasks

A company needs to analyze customer behavior in real-time to personalize marketing campaigns. Which is the correct processing type for them?

• Batch Processing

• Stream Processing

• Micro-batch Processing

• Incremental Processing

What technique is commonly used in data warehousing to improve query performance by reducing the number of joins required?

• Data Sharding

• Data Normalization

• Data Denormalization

• Data Partitioning

What is the primary advantage of using a data lake architecture over a data warehouse for storing and processing large volumes of raw data?

• Centralized Data Storage

• ACID Transactions

• Schema-on-Read Flexibility

• Structured Data Models

What technique is commonly used to optimize query performance in data warehouses by organizing data into smaller, more manageable chunks?

• Data Sharding

• Data Partitioning

• Data Replication

• Data Denormalization

What is the primary benefit of using a data warehouse for business analytics compared to traditional relational databases?

• Scalability

• Real-Time Processing

• Transaction Processing

• Historical Data Analysis

What does CDC stand for?

• Continuous Data Conversion

• Cascading Data Catalog

• Change Data Capture

• Cloud Data Collection