Data Warehouse

Description: data warehouse
Number of Questions: 15
Created by:
Tags: datawarehouse Database
Attempted 0/15 Correct 0 Score 0

Which of the following forms of data warehouse system works with multiple architecture?

  1. Data marts

  2. Executive information system

  3. Internal data

  4. Production data

  5. Federated data warehouse architecture


Correct Option: E
Explanation:

This form of data warehouse system works with multiple 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?

  1. Data loading

  2. Data extraction

  3. Data transformation

  4. Archived data

  5. External data


Correct Option: C
Explanation:

This form 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.

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?

  1. System catalog

  2. OLAP

  3. Database schema

  4. DBA

  5. Physical storage


Correct Option: B
Explanation:

This is a category of software technology that enables analysts, managers and executes to gain insight into data through fast, consistent and interactive manner.

Which of the following forms of data warehouse provides views of operational databases that are materialised for efficient access?

  1. Enterprise-wide data warehouse

  2. Virtual data warehouse

  3. Data marts

  4. Star schema

  5. Online analytical processing


Correct Option: B
Explanation:

This form of data warehouse provides views of operational databases that are materialised for efficient access.

Which of the following forms of RAID technology is popular for video and image production, and editing pre-press applications and other applications requiring high bandwidth?

  1. RAID 1

  2. RAID 5

  3. RAID 0

  4. RAID 2

  5. RAID 4


Correct Option: C
Explanation:

This technology is popular for video and image production and editing, pre-press applications and other applications requiring high bandwidth.

Which of the following methods is the act of detecting and correcting corrupt or inaccurate records from a record set, table or database?

  1. Data management

  2. Data enrichment

  3. Data cleansing

  4. Data profiling

  5. Data capture


Correct Option: C
Explanation:

This method is the act of detecting and correcting corrupt or inaccurate records from a record set, table or database.

Which of the following is the process in RAID technology that refers to writing the same data to two disk drives connected to the same controller?

  1. Disk mirroring

  2. Disk duplexing

  3. Parity checking

  4. Disk striping

  5. Data modeling


Correct Option: A
Explanation:

This is the process in RAID technology that refers to writing the same data to two disk drives connected to the same controller.

Which of the following data quality tools provides a single environment that seamlessly integrates data quality within the data integration process?

  1. SAS (Statistical Analysis System)

  2. Informatics

  3. Orcale 10g Warehouse builder

  4. MySAP business intelligence

  5. Data quality


Correct Option: A
Explanation:

This is the data quality tool that provides a single environment that seamlessly integrates data quality within the data integration process.

Which of the following forms of data allows data to be modeled and viewed in multiple dimensions?

  1. OLAP

  2. Data cube

  3. Data modeling

  4. Views

  5. Triggers


Correct Option: B
Explanation:

This form of data allows data to be modeled and viewed in multiple dimensions.

Which of the following methods in physical design structures should be used with highly redundant data such as tables with many foreign keys?

  1. Table spaces

  2. Partitioned tables

  3. Views

  4. Data segment compression

  5. Integrity constraints


Correct Option: D
Explanation:

This method in physical design structures should be used with highly redundant data such as tables with many foreign keys.

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?

  1. Selection

  2. Conversion

  3. Summarisation

  4. Splitting/Joining

  5. Enrichment


Correct Option: D
Explanation:

This task in data transformation includes the types of data manipulation a user need to perform on the selected parts of source records.

Which of the following types of logical extraction method extracts only the data that has changed, since a well defined event back in history?

  1. Full extraction

  2. Incremental extraction

  3. Online extraction

  4. Offline extraction

  5. Flat files


Correct Option: B
Explanation:

This type of logical extraction method extracts only the data that has changed, since a well defined event back in history.

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?

  1. Logical data model

  2. Physical data model

  3. Conceptual data model

  4. Dimensional modeling

  5. E-R modeling


Correct Option: C
Explanation:

This data model describes data from a high level and defines the problem rather than the solution from the business point of view.

Which of the following schema in data warehouse is a method of normalising the dimension tables in a star schema?

  1. Fact constellation schema

  2. Sub-schema

  3. Data dictionary

  4. Snowflake schema

  5. Star schema


Correct Option: D
Explanation:

This schema in data warehouse is a method of normalising the dimension tables in a star schema.

Which of the following properties of data warehouse is not correct?

  1. Data warehouses are not usually relational but multidimensional.

  2. Data warehouses cannot be indexed.

  3. Data warehouses exist as persistent storage.

  4. These provides specific support of functionality.

  5. These provides large amounts of integrated and often temporal data.


Correct Option: B
Explanation:

This property of data warehouse is not correct as data warehouses can be indexed to optimise performance.

- Hide questions