DAC Big Data & Cloud Analytics 5

Question 1

Which characteristic distinguishes a 'lakehouse' architecture?

Accepted Answer

Combines data lake storage with warehouse-style management and ACID transactions

Answer

Stores only unstructured images

Answer

Runs exclusively on-premises

Answer

Replaces the need for any SQL

Question 2

What is the primary purpose of Apache Airflow in a data platform?

Accepted Answer

Orchestrate and schedule data pipeline workflows

Answer

Serve web pages to users

Answer

Store binary blobs

Answer

Provide a firewall

Question 3

In cloud cost management for analytics, what does 'query cost' in serverless warehouses like BigQuery usually depend on?

Accepted Answer

The amount of data scanned by the query

Answer

The color of the dashboard

Answer

The number of users logged in

Answer

The length of the table name

Question 4

Which technique reduces data scanned by only reading columns needed for a query?

Accepted Answer

Columnar storage / column pruning

Answer

Full table row scans

Answer

Random sampling

Answer

Disabling indexes

Question 5

What does 'schema-on-read' mean in a big data context?

Accepted Answer

Structure is applied when data is queried, not when stored

Answer

Data must be fully modeled before ingestion

Answer

Schemas can never change

Answer

Only images can be stored

Question 6

Which AWS service lets you run SQL queries directly against data stored in S3 without loading it into a database?

Accepted Answer

Amazon Athena

Answer

Amazon SNS

Answer

Amazon Lambda@Edge

Answer

Amazon Cognito

Question 7

In distributed computing, what is 'data skew' and why is it a problem?

Accepted Answer

Uneven distribution of data causing some nodes to overload

Answer

Data being perfectly balanced across nodes

Answer

Encrypting data twice

Answer

Deleting old partitions