Data Engineering MCQ
Except for one, they are data technologies found in Google Cloud.
Correct!
Wrong!
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.
Correct!
Wrong!
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?
Correct!
Wrong!
The unique, meaningless, and sequential numbers generated by the system and attached to data warehouse tables are referred to as:
Correct!
Wrong!
Each row in a Star Schema ________  table represents an event that occurred at a specific time (such as a client opening a contract)
Correct!
Wrong!
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?
Correct!
Wrong!
What term does not have the same meaning as ETL?
Correct!
Wrong!