Question
Data warehouse metadata primarily
describes:Solution
Metadata defines sources, transformations, schema, and meaning of warehouse data.
In a data warehouse, which type of table stores quantitative data for analysis?
Which operation in OLAP allows selecting a single dimension from a cube?
Which schema uses multiple fact tables sharing dimension tables?
A star schema in a data warehouse consists of:
Which of the following best defines the concept of the "Internet of Things" (IoT)?
Which OLAP operation rotates the data axes to provide an alternative presentation?
Which type of OLAP allows analysis of multidimensional data stored in relational databases?
Which clause is used to sort the results in SQL?
In a star schema, what is the main advantage of using surrogate keys in fact tables?
Which type of slowly changing dimension (SCD) preserves full history by adding a new row for each change and using effective date ranges?
