Data Warehousing | DWH | MCQ

In this Data warehousing mcqs set you will find out mcq question on data warehouse with answers and will help to clear any data warehouse objective exam.We will cover these topics such as data warehousing, what is data warehousing, snowflakes in data warehousing, definition data warehousing, data warehousing definition, definition of data warehousing, data warehousing concept, concepts of data warehousing, enterprise data warehouse, data warehouse defined, edw, analytical data warehouse, data warehouse models, data warehouse technology and so on.

Question 1
__________ contains information that gives users an easy-to-understand perspective of the
information stored in the data warehouse
Select one:
Financial metadata
Operational metadata
Technical metadata
Business metadata
Show Answer

Question 2
_________ is not associated with data cleaning process.
Select one:
Deduplication
Domain consistency
Segmentation
Disambiguation
Show Answer

Question 4
Dimensionality refers to
Select one:
Cardinality of key values in a star schema
The data that describes the transactions in the fact table
The level of detail of data that is held in the fact table
The level of detail of data that is held in the dimension table
Show Answer

Question 5
A star schema has what type of relationship from a dimension to the fact table?
Select one:
Many-to-many
Many-to-one
One-to-one
One-to-many
Show Answer
Question 6
__________ predicts future trends & behaviors, allowing business managers to make knowledge-driven decisions
Select one:
Meta data
Data mart
Data warehouse
Data Mining
Show Answer
Question 6
Expansion for DSS in DW is
Select one:
Decisive Strategic System
Data Support System
Data Store System
Decision Support system
Show Answer
Question 7
A data warehouse is described by which of the following?
Select one:
Can be updated by end users
Contains only current data
Contains numerous naming conventions and formats
Organized around important subject areas
Show Answer
Question 8
Data in a data warehouse
Select one:
in a flat file format
can be normalised but often is not
must be in normalised form to at least 3NF
must be in normalised form to at least 2NF
Show Answer
Question 9
The main organisational justification for implementing a data warehouse is to provide
Select one:
ETL from operation systems to strategic systems
Large scale transaction processing
Storing large volumes of data
Decision support
Show Answer
Question 10
A data warehouse
Select one:
must import data from transactional systems whenever significant changes occur in the transactional data
works on live transactional data to provide up to date and valid results
takes regular copies of transaction data
takes preprocessed transaction data and stores in a way that is optimised for analysis
Show Answer
Question 11
Data warehouse contains ________data that is seldom found in the operational environment
Select one:
informational
normalized
denormalized
summary
Show Answer
Question 12
Which of the following statements about DW is true?
Select one:
A data warehouse is necessary to all those organisations that are using relational OLTP
A data warehouse is useful to all organisations that currently use OLTP
A data warehouse is valuable to the organisations that need to keep an audit trail of their activities
A data warehouse is valuable only if the organisation has an interest in analysing historical data
Show Answer
Question 13
What is true of storing data in DW?
Select one:
A DW automatically makes a copy of every transaction recorded in OLTP systems
Adding data for the sake of it may well degrade the effectiveness of DW
A DW is a relatively straighttforward thing to set up
The more data a data warehouse has, the better it is
Show Answer
Question 14
The extract process is _______
Select one:
capturing a subset of the data contained in operational systems
capturing a subset of the data contained in various decision support systems
capturing all of the data contained in various decision support systems
capturing of the data contained in all operational systems
Show Answer
Question 15
Which statement best describes fact table
Select one:
A fact table describes the transactions stored in a DW
The fact table of a DW is the main store of descriptions of the transactions
A fact table describes the granularity of data in a DW
The fact table of a data warehouse is the main store of all of the recorded transactions over time
Show Answer
Question 16
Fact tables are described by which of the following?
Select one:
Partially normalized
Completely denormalized
Partially denormalized
Completely normalized
Show Answer
Question 17
_______ are numeric measurements or values that represent a specific business aspect or activity
Select one:
Dimensions
Schemas
Facts
Tables
Show Answer
Question 18
A fact is said to be fully additive if __________.
Select one:
additive over atleast one of the dimensions
Only numeric measures are used
All possible summaries are stored
it is additive over every dimension of its dimensionality
Show Answer
Question 19
Granularity refers to
Select one:
The level of detail of the data stored in a data warehouse
The number of fact tables in a data warehouse
The number of dimensions in a data warehouse
The level of detail of the data descriptions held in a data warehouse
Show Answer
Question 20
Data cubes can grow to n-number of dimensions, thus becoming _______
Select one:
Hypercubes
Star Cubes
Dimensional Cubes
Solid cubes
Show Answer
Question 21
_____describes the data contained in the data warehouse
Select one:
Relational data
Operational data
Informational data
Meta data
Show Answer
Question 22
An operational system is which of the following?
Select one:
A system that is used to run the business in real time and is based on current data
A system that is used to run the business in real time and is based on historical data
A system that is used to support decision making and is based on historical data
A system that is used to support decision making and is based on current data
Show Answer
Question 23
Treating incorrect or missing data is called as _______.
Select one:
Preprocessing
Interpretation
Selection
Transformation
Show Answer
Question 24
______ makes a copy of a table and places it in a different location, to improve access time
Select one:
Archive
Replication
Partitioning
Aggregation
Show Answer
Question 25
When you ________ the data, you are aggregating the data to a higher level
Select one:
Slice
Roll up
Accumulate
Drill down
Show Answer
Question 26
______ is a measurement of the density of the data held in the data cube
Select one:
Mass
Sparsity
Compactness
Concentration
Show Answer
Question 27
A fact table in the centre with dimension tables directly linked to it
Select one:
A star schema
A starflake schema
A snowflake schema
A constellation
Show Answer
Question 28
______ is a data transformation.
Select one:
Re-format
Selection
Projection
Comparison
Show Answer