Data and Analytics Big Data and Cloud Analytics 2

Question 1

What is Google BigQuery's primary architectural advantage?

Accepted Answer

Serverless, scalable analytics separating storage from compute

Answer

BigQuery's serverless architecture separates storage from compute, allowing independent scaling and eliminating infrastructure management.

Question 2

What is Apache Kafka primarily used for?

Accepted Answer

Real-time data streaming and event-driven pipelines

Answer

Apache Kafka is a distributed event streaming platform used for high-throughput, real-time data pipelines and stream processing.

Question 3

What is the purpose of a CDN (Content Delivery Network) in analytics applications?

Accepted Answer

To reduce latency by caching content closer to users geographically

Answer

A CDN distributes cached content across geographically dispersed servers to reduce latency and improve load times for end users.

Question 4

What does 'schema-on-read' mean in the context of data lakes?

Accepted Answer

Schema is applied when data is queried, not when it's stored

Answer

Schema-on-read means raw data is stored without a fixed structure, and the schema is applied dynamically when the data is queried.

Question 5

What is Snowflake's multi-cluster, shared data architecture?

Accepted Answer

Separate storage and compute layers allowing multiple independent query engines

Answer

Snowflake separates storage from compute, allowing multiple virtual warehouses to independently access the same data without contention.

Data and Analytics Practice Test