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 lakehouse merges the low-cost storage of data lakes with ACID transactions, schema enforcement, and BI support from 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 Kafka is a distributed event streaming platform used to build real-time data pipelines and streaming applications at scale.

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

Schema-on-read means data is stored in raw form and the schema is applied at query time, providing flexibility for diverse data types.

Question 4

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

Accepted Answer

Azure Data Factory

Answer

Azure Data Factory is a cloud-based ETL and data integration service for creating data-driven workflows to orchestrate data movement and transformation.

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

Columnar storage allows analytical queries to read only the columns needed, drastically reducing I/O and improving aggregate query performance.

ADE - Associate Data Engineer Certification Practice Test

ADE - Associate Data Engineer Certification Practice Test

ADE ADE Cloud & Big Data Technologies 2