Data Engineering MCQ

Question 1

What term does not have the same meaning as ETL?

Accepted Answer

To translate

Answer

Load

Answer

Extract

Answer

Transform

Question 2

Except for one, they are data technologies found in Google Cloud.

Accepted Answer

Kinesis

Answer

Bigquery

Answer

GCS

Answer

Dataflow

Question 3

In a data warehouse, a ______ stores and manages both current and historical data over time. It is regarded and implemented as one of the most critical ETL tasks in tracking dimension record history.

Accepted Answer

Slowly Changing Dimension (SCD)

Answer

Incremental Changing Dimension (ICD)

Answer

Change Data Capture (CDC)

Answer

Delta Records Capture (DRC)

Question 4

The unique, meaningless, and sequential numbers generated by the system and attached to data warehouse tables are referred to as:

Accepted Answer

Surrogate Keys

Answer

Natural or business keys

Answer

Source keys

Answer

BKEYS / BMAP

Question 5

You have a BigQuery table that contains information about customer purchases, such as the date of purchase, the type of product purchased, the product name, and several other descriptive attributes. There is roughly three years of data. You typically query data by month, followed by customer. You want to scan as little data as possible. How would you set the table?

Accepted Answer

Partition by purchase date and cluster by customer

Answer

Partition by purchase date and cluster by product

Answer

Partition by customer and cluster by product

Answer

Partition by customer and cluster by purchase date

Question 6

Each row in a Star Schema  ________  table represents an event that occurred at a specific time (such as a client opening a contract)

Accepted Answer

Fact Table

Answer

Dimension Table

Answer

Staging Table

Answer

Primary Table

Question 7

You're creating a data pipeline to feed into a sales data mart. The project's sponsor has previously experienced quality control issues and has developed a set of rules for filtering out bad data before it enters the data mart. At what point in the data pipeline would you put those rules in place?

Accepted Answer

Transformation

Answer

Extract

Answer

Storage

Answer

Analysis