Question
Which OLAP operation allows users to view data at
different levels of granularity?Solution
Drill-down increases detail (year → month), roll-up summarizes (month → year).
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:
