Data warehouse Quiz | Data Warehouse Questions & Answers

Questions
21 The load and index is which of the following?
A A process to reject data from the data warehouse and to create the necessary indexes
B A process to load the data in the data warehouse and to create the necessary indexes
C A process to upgrade the quality of data after it is moved into a data warehouse
D A process to upgrade the quality of data before it is moved into a data warehouse

Answer: A process to load the data in the data warehouse and to create the necessary indexes
22 The extract process is which of the following?
A Capturing all of the data contained in various operational systems
B Capturing a subset of the data contained in various operational systems
C Capturing all of the data contained in various decision support systems
D Capturing a subset of the data contained in various decision support systems

Answer: Capturing a subset of the data contained in various operational systems

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
23 A star schema has what type of relationship between a dimension and fact table?
A Many-to-many
B One-to-one
C One-to-many
D All of the above.

Answer: One-to-many
24 Transient data is which of the following?
A Data in which changes to existing records cause the previous version of the records to be eliminated
B Data in which changes to existing records do not cause the previous version of the records to be eliminated
C Data that are never altered or deleted once they have been added
D Data that are never deleted once they have been added

Answer: Data in which changes to existing records cause the previous version of the records to be eliminated
25 A multifield transformation does which of the following?
A Converts data from one field into multiple fields
B Converts data from multiple fields into one field
C Converts data from multiple fields into multiple fields
D All of the above

Answer: All of the above
26 Data dictionary is
A Large collection of data mostly stored in a computer system
B The removal of noise errors and incorrect input from a database
C The systematic description of the syntactic structure of a specific database. It describes the structure of the attributes the tables and foreign key relations hips.
D oNone of theseut

Answer: The systematic description of the syntactic structure of a specific database. It describes the structure of the attributes the tables and foreign key relations hips.
27 Data warehouse is
A The actual discovery phase of a knowledge discovery process
B The stage of selecting the right data for a KDD process
C A subject-oriented integrated time variant non-volatile collection of data in support of management
D None of these

Answer: A subject-oriented integrated time variant non-volatile collection of data in support of management
28 Data cleaning is
A Large collection of data mostly stored in a computer system
B The removal of noise errors and incorrect input from a database
C The systematic description of the syntactic structure of a specific database. It describes the structure of the attributes the tables and foreign key relationships.
D None of

Answer: The removal of noise errors and incorrect input from a database
29 Decision support systems (DSS) is
A A family of relational database management systems marketed by IBM
B Interactive systems that enable decision makers to use databases and models on a computer in order to solve ill-structured problems
C It consists of nodes and branches starting from a single root node. Each node represents a test, or decision
D None of these

Answer: Interactive systems that enable decision makers to use databases and models on a computer in order to solve ill-structured problems
30 The data Warehouse is______.
A read write only.
B write only.
C read only.
D none.

Answer: read write only.
31 __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.
A Web Mining.
B Data Warehousing.
C Data Mining.
D Text Mining.

Answer: Data Warehousing.
32 . Data warehouse architecture is based on .......................
A DBMS
B RDBMS
C Sybase
D SQL Server

Answer: RDBMS
33 . ..........................supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting.
A Information processing
B Analytical processing
C Data mining
D Transaction processing

Answer:Analytical processing
34 . The core of the multidimensional model is the ....................... , which consists of a large set of facts and a number of dimensions.
A Multidimensional cube
B Dimensions cube
C Data cube
D Data model

Answer:Data cube
35 The data from the operational environment enter ........................ of data warehouse.
A Current detail data
B Older detail data
C Lightly Summarized data
D Highly summarized data

Answer: Current detail data
36 A data warehouse is ......................
A updated by end users.
B contains numerous naming conventions and formats
C organized around important subject areas
D contain only current data

Answer: organized around important subject areas
37 Business Intelligence and data warehousing is used for ..............
A Forecasting
B Data Mining
C Analysis of large volumes of product sales data
D All of the above

Answer: All of the above
38 Data warehouse contains ................ data that is never found in the operational environment.
A normalized
B informational
C summary
D denormalized

Answer: summary
39 ................... are responsible for running queries and reports against data warehouse tables.
A Hardware
B Software
C End users
D Middle ware

Answer: End users
40 The biggest drawback of the level indicator in the classic star schema is that is limits ............
A Flexibility
B Quantify
C Qualify
D Ability

Answer: Flexibility
ADRE 3.0 Complete Study Material