Data Engineering - 6 (take home)

What does ETL stand for in the context of data processing?

• A) Extract, Translate, Load

• B) Extract, Transform, Load

• C) Export, Transform, Load

• D) Extract, Transform, Link

In an ETL pipeline, what is the purpose of the 'Transform' phase?

• A) To read and collect data from different sources

• B) To clean and transform the collected data

• C) To load the transformed data into a data warehouse

• D) To visualize the data for analysis

Which of the following is NOT a typical task performed during the 'Transform' phase of an ETL pipeline?

• A) Data cleaning

• B) Data integration

• C) Data normalization

• D) Data visualization

What is the basic unit of storage in a relational database?

• A) Cell

• D) Column

• B) Table

• C) Row

In a relational database, what does a row represent?

• A) A relation

• B) An attribute

• C) A record

• D) A field

What is the purpose of the PRIMARY KEY constraint in a relational database?

• A) To ensure that each row in a table has a unique identifier

• B) To create a relationship between two tables

• C) To define a default value for a column

• D) To enforce data integrity rules

What is the purpose of the FOREIGN KEY constraint in a relational database?

• A) To ensure that each row in a table has a unique identifier

• B) To create a relationship between two tables

• C) To define a default value for a column

• D) To enforce data integrity rules

In SQL, which command is used to create a new table?

• A) CREATE TABLE

• B) NEW TABLE

• C) INSERT TABLE

• D) DEFINE TABLE

In SQL, what keyword filters rows based on a specific condition?

• A) FILTER

• B) SELECT

• C) WHERE

• D) CONDITION

Which type of SQL JOIN returns only the rows that have matching values in both tables?

• A) INNER JOIN

• B) OUTER JOIN

• C) LEFT JOIN

• D) RIGHT JOIN