Podcast
Questions and Answers
What is metadata in the context of a data warehouse?
What is metadata in the context of a data warehouse?
- The actual data stored in the warehouse
- Data refreshed from the warehouse
- Data used to represent other data (correct)
- Data extracted from operational databases
Which term refers to the data ownership information, business definition, and changing policies in a data warehouse system?
Which term refers to the data ownership information, business definition, and changing policies in a data warehouse system?
- Metadata repository
- Data lineage
- Business metadata (correct)
- Operational metadata
What does currency of data refer to in a data warehouse system?
What does currency of data refer to in a data warehouse system?
- The source of the data
- The status of the data (active, archived, purged) (correct)
- The physical form of the data
- The age of the data
Which task is NOT part of data loading in a data warehouse system?
Which task is NOT part of data loading in a data warehouse system?
In a data warehouse system, what does metadata act as?
In a data warehouse system, what does metadata act as?
What does operational metadata include in a metadata repository?
What does operational metadata include in a metadata repository?
Which term describes the history of data migrated and transformations applied in a data warehouse system?
Which term describes the history of data migrated and transformations applied in a data warehouse system?
What is the function of a metadata repository in a data warehouse system?
What is the function of a metadata repository in a data warehouse system?
When referring to 'data partitioning' in a data warehouse system, what does it involve?
When referring to 'data partitioning' in a data warehouse system, what does it involve?
Which term describes updating data from external sources to a data warehouse system?
Which term describes updating data from external sources to a data warehouse system?
Flashcards are hidden until you start studying
