Data Warehouse MCQs

 1) ______________ means must have a single, enterprise-wide view.
A) Integrated     B) Data Integrity               C) Credible          D) Accessible
Correct Ans: Integrated

2) The ____________ exists to answer questions users have about the business, the performance of the various operations, the business trends, and about what can be done to improve the business.
A) Data Mining                 B) Data Integrity               C) Data warehouse          D) Data Science
Correct Ans: Data warehouse

3) The __________________ nature of the data in a data warehouse allows for analysis of the past
A) time-variant B) Subject oriented          C) nonvolatile data          D) Integrated data
Correct Ans: time-variant

4) ____________ refers to the level of detail. Depending on the requirements, multiple levels of detail may be present.
A) Data granularity          B) Data Integrity               C) time variant   D) Accessibility
Correct Ans: Data granularity

5) ____________ function has to deal with numerous data sources.
A) Data Extraction           B) Data Archived               C) Data Stagging               D) Data Transformation
Correct Ans: Data Extraction

6) The ______________- is the navigational map of the data warehouse. It enables the end-users to find information from the data warehouse.
A) Operational metadata    B) end-user metadata    C) Extraction metadata    D) Transformation metadata
Correct Ans: end-user metadata

7) Address, street block, city quadrant, county, state, and zone are examples of______________.
A) spatial data   B) Temporal data             C) Data Visualization       D) Data Mining
Correct Ans: spatial data

8) Visualizations are no longer ____________.
A) static               B) Dynamic         C) Both A & B     D) None of these
Correct Ans: Static

9) ______________ are capable of accessing heterogeneous data sources on different platforms
A) Crossing subject areas                         B) Aggregate awareness           
C) Multiple heterogeneous sources          D) Overcoming SQL limitations
Correct Ans: Multiple heterogeneous sources

10) _____________ is a technology dealing with the merging of data from disparate sources.
A) Data fusion    B) Data Integrity               C) Multidimensional analysis       D) Data Extraction
Correct Ans: Data Fusion

11) A ________________ system must store all such knowledge in a knowledge repository, sometimes called a knowledge warehouse.
A) knowledge management         B) Data Management      C) Data Analysis D) Data Integrity
Correct Ans: knowledge management

12) SDLC Stands for _______________.
A) System Development life cycle             B) System Design life cycle          
C) System Deployment life cycle                D) Server Development life cycle
Correct Ans: System Development life cycle

13) ____________ Stage Provide input for enhancements; test and accept enhancements.
A) Design            B) Construction  C) Deployment   D) Maintenance
Correct Ans: Maintenance

14) The ______________ will provide you with all the data structures, individual data elements, attributes, value domains, and relationships among fields and data structures.
A) DBAs               B) User Dept       C) Project Manager         D) maintenance Dept
Correct Ans: DBAs (Database Administrator)

15) _________ is a joint process, with all the concerned groups getting together for a well-defined purpose.
A) DBAs               B) JAD                  C) IT                      D) Research
Correct Ans: JAD (Joint application development)

16) Data Staging consist of ___________.
A) Growth potential        B) Data Cleansing             C) External data                D) Front end applications
Correct Ans: Data Cleansing

17) In _____________ the data volumes and load frequencies determine the strengths in the areas of data loading, recovery, and restart.
A) Data Loads    B) Data Integrity               C) Data Cleansing             D) Data repositories location
Correct Ans: Data Loads

18) The structure that brings all the components of a data warehouse together is known as the ______________.
A) Lifecycle         B) architecture   C) Framework    D) Phases
Correct Ans: architecture

19) ________________ moves all the extracted data to the staging area, and preparing the data for loading into the data warehouse repository.
A) Data Acquisition         B) Data Flow       C) Data Storage                D) Stagging area
Correct Ans: Data Acquisition

20) Operational infrastructure to support each architectural component consists of___
A) People            B) Procedures     C) Training          D) All of these
Correct Ans: All of these