Top 20 MCQ Questions On Data Warehouse Architecture

Here is the collection of top 20 MCQ questions on data warehouse architecture includes multiple-choice questions on three-tier data warehouse architecture, data warehouse models, and the features of OLTP and OLAP systems. It also includes MCQ questions on the different schema of data warehouse, OLAP operations in the multidimensional data model, and the different types of OLAP servers.

1. State whether the following statements about the three-tier data warehouse architecture are True or False.
i) OLAP server is the middle tier of data warehouse architecture.
ii) The bottom tier of data warehouse architecture does not include a metadata repository.
A) i-True, ii-False
B) i-False, ii-True
C) i-True, ii-True
D) i-False, ii-False

2. The … of the data warehouse architecture contains query and reporting tools, analysis tools, and data mining tools.
A) bottom tier
B) middle tier
C) top tier
D) both B and C

3. Which of the following are the examples of gateways of the bottom tier of data warehouse architecture.
i) ODBC (Open Database Connection)
ii) OLEDB (Open-Linking and Embedding of Databases)
iii) JDBC (Java Database Connection)
A) i and ii only
B) ii and iii only
C) i and iii only
D) All i, ii and iii

4. Back-end tools and utilities are used to feed data into the … from operational databases or other external sources.
A) bottom tier
B) middle tier
C) top tier
D) both A and B

5. From the architecture point of view, there are… data warehouse models.
A) two
B) three
C) four
D) five

6. A … contains a subset of corporate-wide data that is of value to a specific group of users.
A) primary warehouse
B) virtual warehouse
C) enterprise warehouse
D) data mart

7. A … is a set of views over operational databases.
A) primary warehouse
B) virtual warehouse
C) enterprise warehouse
D) data mart

8. State whether the following statements about the enterprise warehouse are True or False.
i) Enterprise warehouse contains details as well as summarized data.
ii) It provides corporate-wide data integration.
A) i-True, ii-False
B) i-False, ii-True
C) i-True, ii-True
D) i-False, ii-False

9. State whether the following statements about the OLTP system are True.
i) Clerk, database administrators, and database professionals are the users of the OLTP system.
ii) It is used on long-term informational requirements.
iii) It has a short and simple transaction.
A) i and ii only
B) ii and iii only
C) i and iii only
D) All i, ii and iii

10. State whether the following statements about the OLAP system are True or False.
i) Knowledge workers such as managers, executive analysts are the users of the OLAP system.
ii) This system is used in day-to-day operations.
iii) The database size of the OLAP system will be 100GB to TB.
A) i-True, ii-False, iii-True
B) i-False, ii-True, iii-True
C) i-True, ii-True, iii-False
D) i-False, ii-False, iii-True

11. Multidimensional model of a data warehouse can exist in the form of the following schema.
i) Star Schema
ii) Snowflake Schema
iii) Fact Constellation Schema
A) i and ii only
B) ii and iii only
C) i and iii only
D) All i, ii and iii

12. In the … the dimension tables displayed in a radial pattern around the central fact table.
A) snowflake schema
B) star schema
C) fact schema
D) fact constellation schema

13. The dimension tables of the … model can be kept in the normalized form to reduce the redundancies.
A) snowflake schema
B) star schema
C) fact schema
D) fact constellation schema

14. State whether the following statements about the fact constellation schema are True or False.
i) The fact constellation schema is also called galaxy schema.
ii) The fact constellation schema allows dimension tables to be shared between fact tables.
iii) This kind of schema can be viewed as a collection of snowflakes.
A) i-True, ii-False, iii-True
B) i-False, ii-True, iii-True
C) i-True, ii-True, iii-False
D) i-False, ii-False, iii-True

15. Which of the following are the different OLAP operations performed in the multidimensional data model.
i) Roll-up
ii) Roll-down
iii) Drill-down
iv) Slice
A) i, ii, and iii only
B) ii, iii, and iv only
C) i, iii, and iv only
D) All i, ii, iii, and iv

16. When … operation is performed, one or more dimensions from the data cube are removed.
A) roll-up
B) roll-down
C) drill-down
D) drill-up

17. The … operation selects one particular dimension from a given cube and provides a new subcube.
A) drill
B) dice
C) pivot
D) slice

18. The … operation rotates the data axes in view in order to provide an alternative presentation of data.
A) drill
B) dice
C) pivot
D) slice

19. Which of the following are the different types of OLAP servers.
i) Relational OLAP
ii) Multidimensional OLAP
iii) Hybrid OLAP
iv) Specialized SQL Servers
A) i, ii, and iii only
B) ii, iii, and iv only
C) i, iii, and iv only
D) All i, ii, iii, and iv

20. … servers allow storing a large data volume of detailed information.
A) Relational OLAP
B) Multidimensional OLAP
C) Hybrid OLAP
D) Specialized SQL Servers

Answers: