Practice Data Warehousing Questions and Answers

• In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?
• Which of the following best describes the primary function of a database index?
• Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
• Which of the following best defines the concept of the "Internet of Things" (IoT)?
• Which analytics type is focused on predicting future outcomes?
• What is meant by 'cardinality' in data modeling?
• A surrogate key is:
• Which SQL clause is used to summarize data?
• Data cleansing is primarily concerned with:
• Which of the following best describes a fact constellation schema in a data warehouse?
• 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 of the following best describes a Data Warehouse?
• What is the primary function of ETL in a data warehouse environment?
• Which schema in data warehousing uses a central fact table connected to dimension tables?
• Which of the following is NOT a characteristic of OLAP systems?
• In a data cube, what does "slice" operation do?
• What does "drill-down" operation in OLAP do?
• Which process ensures data in a data warehouse is consistent and clean?
• Which type of schema normalizes dimension tables into multiple related tables?
• Which process loads data from multiple sources into a data warehouse?
• Which of these is NOT an ensemble method?
• A star schema in a data warehouse consists of:
• ETL stands for:
• Which OLAP operation allows users to view data at different levels of granularity?
• A snowflake schema is different from a star schema because:
• Metadata in data warehousing refers to:
• Which of the following is a real-time data warehouse application?
• Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
• In a star schema, what is the main advantage of using surrogate keys in fact tables?
• Fact constellation schema is best described as:
• In OLAP, “Slice and Dice” means:
• A Fact Constellation Schema is also called:
• Surrogate keys are used in data warehouses because:
• Which of the following stores historical data for analysis?
• What is a data mart?
• Which OLAP operation summarizes data along a dimension?
• Which type of OLAP allows analysis of multidimensional data stored in relational databases?