ADE ADE Cloud & Big Data Technologies 2

Question 1

What does the term 'data lakehouse' refer to?

Accepted Answer

An architecture combining the flexibility of data lakes with the management features of data warehouses

Answer

A data lake used exclusively for house pricing data

Answer

A physical on-premise data storage facility

Answer

A backup solution for data warehouses

Question 2

Which Apache technology is used for distributed message streaming and serves as a backbone for real-time data pipelines?

Accepted Answer

Apache Kafka

Answer

Apache Flink

Answer

Apache Hive

Answer

Apache Sqoop

Question 3

In cloud-based big data architectures, what is 'schema-on-read'?

Accepted Answer

Defining the schema when data is read rather than when it is stored

Answer

Applying schema validation before data is loaded into storage

Answer

Using a fixed schema for all data lake files

Answer

Reading schema definitions from a central metadata catalog

Question 4

Which Azure service is used to orchestrate large-scale data movement and transformation pipelines?

Accepted Answer

Azure Data Factory

Answer

Azure Databricks

Answer

Azure Event Hubs

Answer

Azure HDInsight

Question 5

What is the primary advantage of using columnar storage over row-based storage for analytical workloads?

Accepted Answer

Improved read performance for aggregate queries on specific columns

Answer

Faster inserts of individual records

Answer

Better support for transactional updates

Answer

Lower memory usage during data loading

Question 6

Which AWS service provides a fully managed ETL service that automatically generates ETL code?

Accepted Answer

AWS Glue

Answer

AWS Lambda

Answer

Amazon EMR

Answer

Amazon Athena