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

On-premise storage for security

Answer

Native integration with Excel

Answer

Built-in machine learning only

Question 2

What is Apache Kafka primarily used for?

Accepted Answer

Real-time data streaming and event-driven pipelines

Answer

Batch processing historical data

Answer

Relational data storage

Answer

Data visualization

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

To store analytical models

Answer

To process big data queries

Answer

To encrypt data at rest

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

Data schema is enforced when data is written

Answer

All data must follow a predefined schema

Answer

Schema validation happens at the database layer

Question 5

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

Accepted Answer

Separate storage and compute layers allowing multiple independent query engines

Answer

Multiple databases sharing one compute cluster

Answer

A peer-to-peer distributed computing model

Answer

A single cluster serving all workloads

Question 6

What is the purpose of data partitioning in big data systems?

Accepted Answer

To divide large datasets into smaller chunks for faster parallel processing

Answer

To encrypt sensitive data

Answer

To replicate data across regions

Answer

To compress data for storage efficiency