Download PDF
Free download in PDF Data warehouse Multiple Choice Questions(MCQs) & Answers. These multiple choice questions on Computer Science are very useful for NIELIT, BCA, B.Sc. MCA, M.Sc. B.Tech, M.Tech, BE, ME students an interview for various positions like Web Developer, System Analyst etc.
(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
(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.
(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
(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.
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
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
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
38
Data warehouse contains ................ data that is never found in the operational environment.
[A]
normalized
[B]
informational
[C]
summary
[D]
denormalized
39
................... are responsible for running queries and reports against data warehouse tables.
[A]
Hardware
[B]
Software
[C]
End users
[D]
Middle ware
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
Please share this page