Data Engineering Introduction To Data Engineering 2

Question 1

What is the primary role of a data engineer in an organization?

Accepted Answer

Building and maintaining data pipelines and infrastructure

Answer

Designing marketing campaigns

Answer

Writing front-end user interfaces

Answer

Managing payroll systems

Question 2

Which process describes Extract, Transform, Load (ETL)?

Accepted Answer

Pulling data from sources, reshaping it, then storing it in a target system

Answer

Loading raw data first, then querying it directly

Answer

Encrypting data before transmission

Answer

Compressing files for backup

Question 3

What distinguishes a data warehouse from a data lake?

Accepted Answer

A warehouse stores structured, schema-defined data while a lake stores raw data of any format

Answer

A warehouse is always cheaper than a lake

Answer

A lake can only store images

Answer

A warehouse cannot be queried with SQL

Question 4

Which of the following is a common batch processing framework?

Accepted Answer

Apache Spark

Answer

React

Answer

Photoshop

Answer

Nginx

Question 5

What does 'data normalization' aim to reduce in a relational database?

Accepted Answer

Data redundancy and update anomalies

Answer

Network latency

Answer

CPU temperature

Answer

Screen resolution

Question 6

Which term describes data processed continuously as it arrives?

Accepted Answer

Stream processing

Answer

Batch archiving

Answer

Cold storage

Answer

Manual entry

Question 7

What is the purpose of a schema in a database?

Accepted Answer

To define the structure, types, and relationships of the data

Answer

To encrypt the database files

Answer

To speed up the network card

Answer

To render charts automatically