Question
Which of the following is NOT a common OLAP
operation?Solution
OLAP operations are analytical (roll-up, drill-down, slice, dice, pivot); normalization is OLTP modeling practice, not OLAP analytical operation.
Which of the following best defines the concept of the "Internet of Things" (IoT)?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Data warehouse metadata primarily describes:
Which type of slowly changing dimension (SCD) preserves full history by adding a new row for each change and using effective date ranges?
Which of these is NOT an ensemble method?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
ETL stands for:
Which SQL keyword is used to combine results from two queries and remove duplicates?
Data cleansing is primarily concerned with:
