DAC Big Data & Cloud Analytics 4

Question 1

What is a common advantage of separating storage from compute in cloud analytics architectures?

Accepted Answer

Each can scale independently to control cost

Answer

Data can never be deleted

Answer

Queries always run on a single node

Answer

It eliminates the need for security

Question 2

In MapReduce, what is the role of the 'reduce' phase?

Accepted Answer

Aggregate and combine intermediate results by key

Answer

Split the input file into blocks

Answer

Assign nodes to the cluster

Answer

Encrypt the final output

Question 3

Which concept describes ingesting data continuously as it is generated rather than in scheduled batches?

Accepted Answer

Real-time streaming ingestion

Answer

Nightly ETL batch

Answer

Manual CSV upload

Answer

Quarterly archival

Question 4

A data engineer needs sub-millisecond key-based lookups for a caching layer. Which store fits best?

Accepted Answer

Redis (in-memory key-value store)

Answer

A relational OLAP cube

Answer

A flat archived log file

Answer

A columnar data warehouse

Question 5

What is the main benefit of partitioning a large table in a cloud data warehouse?

Accepted Answer

Queries can prune irrelevant partitions to scan less data

Answer

It automatically encrypts the table

Answer

It removes duplicate rows

Answer

It converts the table to JSON

Question 6

Which term refers to the process of extracting, transforming, and loading data into a warehouse?

Accepted Answer

ETL

Answer

DNS

Answer

TCP

Answer

SSL

Question 7

In a modern 'ELT' pattern, where does the transformation typically happen compared to ETL?

Accepted Answer

Inside the target warehouse after loading raw data

Answer

Before extraction from the source

Answer

Only on the client browser

Answer

Never — data stays untransformed