Data Warehouse
Tests knowledge of data warehouse concepts including architecture types, ETL processes, OLAP, dimensional modeling (star and snowflake schemas), and data quality management.
Questions
Which of the following forms of data warehouse system works with multiple architecture?
- Data marts
- Executive information system
- Internal data
- Production data
- Federated data warehouse architecture
Which of the following forms of data will be referred in data warehouse when a user is moving from a file-oriented system to a modern system supported with relational database tables?
- Data loading
- Data extraction
- Data transformation
- Archived data
- External data
Which of the following is a category of software technology that enables analysts, managers and executes to gain insight into data through fast, consistent and interactive manners?
- System catalog
- OLAP
- Database schema
- DBA
- Physical storage
Which of the following forms of data warehouse provides views of operational databases that are materialised for efficient access?
- Enterprise-wide data warehouse
- Virtual data warehouse
- Data marts
- Star schema
- Online analytical processing
Which of the following methods is the act of detecting and correcting corrupt or inaccurate records from a record set, table or database?
- Data management
- Data enrichment
- Data cleansing
- Data profiling
- Data capture
Which of the following data quality tools provides a single environment that seamlessly integrates data quality within the data integration process?
- SAS (Statistical Analysis System)
- Informatics
- Orcale 10g Warehouse builder
- MySAP business intelligence
- Data quality
Which of the following forms of data allows data to be modeled and viewed in multiple dimensions?
- OLAP
- Data cube
- Data modeling
- Views
- Triggers
Which of the following methods in physical design structures should be used with highly redundant data such as tables with many foreign keys?
- Table spaces
- Partitioned tables
- Views
- Data segment compression
- Integrity constraints
Which of the following tasks in data transformation includes the types of data manipulation a user need to perform on the selected parts of source records?
- Selection
- Conversion
- Summarisation
- Splitting/Joining
- Enrichment
Which of the following types of logical extraction method extracts only the data that has changed, since a well defined event back in history?
- Full extraction
- Incremental extraction
- Online extraction
- Offline extraction
- Flat files
Which of the following data models describes data from a high level and defines the problem rather than the solution from the business point of view?
- Logical data model
- Physical data model
- Conceptual data model
- Dimensional modeling
- E-R modeling
Which of the following schema in data warehouse is a method of normalising the dimension tables in a star schema?
- Fact constellation schema
- Sub-schema
- Data dictionary
- Snowflake schema
- Star schema
Which of the following properties of data warehouse is not correct?
- Data warehouses are not usually relational but multidimensional.
- Data warehouses cannot be indexed.
- Data warehouses exist as persistent storage.
- These provides specific support of functionality.
- These provides large amounts of integrated and often temporal data.