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
Advertisement
Article and Schedule Quiz Start Test!

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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 2.0 FULL LENGTH MOCK TEST

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!
Advertisement
Assam Direct Recruitment Test Series