Data Warehousing Questions & Answers | DWH | MCQ

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

Feedback
Your answer is correct.
The correct answer is: Business metadata

Question 2
_________ is not associated with data cleaning process.
Select one:
Deduplication
Domain consistency
Segmentation
Disambiguation
Feedback
Your answer is correct.
The correct answer is: Segmentation

Question 3
___________ is a good alternative to the star schema.
A. Star schema.
B. Snowflake schema.
C. Fact constellation.
D. Star-snowflake schema.
Feedback
Your answer is correct.
The correct answer is:

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

Feedback
Your answer is correct.
The correct answer is: The data that describes the transactions in the fact table

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
Feedback
Your answer is correct.
The correct answer is: One-to-many

Question 6
__________ predicts future trends & behaviors, allowing business managers to make knowledge-driven decisions
Select one:
Meta data
Data mart
Data warehouse
Data Mining
Feedback
Your answer is correct.
The correct answer is: Data Mining

Question 6
Expansion for DSS in DW is
Select one:
Decisive Strategic System
Data Support System
Data Store System
Decision Support system
Feedback
Your answer is correct.
The correct answer is: Decision Support system

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
Feedback
Your answer is correct.
The correct answer is: Organized around important subject areas

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
Feedback
Your answer is correct.
The correct answer is: can be normalised but often is not

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
Feedback
Your answer is correct.
The correct answer is: Decision support

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
Feedback
Your answer is correct.
The correct answer is: takes preprocessed transaction data and stores in a way that is optimised for analysis

Question 11
Data warehouse contains ________data that is seldom found in the operational environment
Select one:
informational
normalized
denormalized
summary
Feedback
Your answer is correct.
The correct answer is: summary

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
Feedback
Your answer is correct.
The correct answer is: A data warehouse is valuable only if the organisation has an interest in analysing historical data

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
Feedback
Your answer is correct.
The correct answer is: Adding data for the sake of it may well degrade the effectiveness of DW

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
Feedback
Your answer is correct.
The correct answer is: capturing a subset of the data contained in operational systems

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
Feedback
Your answer is correct.
The correct answer is: The fact table of a data warehouse is the main store of all of the recorded transactions over time

Question 16
Fact tables are described by which of the following?
Select one:
Partially normalized
Completely denormalized
Partially denormalized
Completely normalized
Feedback
Your answer is correct.
The correct answer is: Completely normalized

Question 17
_______ are numeric measurements or values that represent a specific business aspect or activity
Select one:
Dimensions
Schemas
Facts
Tables
Feedback
Your answer is correct.
The correct answer is: Facts

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
Feedback
Your answer is correct.
The correct answer is: it is additive over every dimension of its dimensionality

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
Feedback
Your answer is correct.
The correct answer is: The level of detail of the data stored in a data warehouse

Question 20
Data cubes can grow to n-number of dimensions, thus becoming _______
Select one:
Hypercubes
Star Cubes
Dimensional Cubes
Solid cubes
Feedback
Your answer is correct.
The correct answer is: Hypercubes

Question 21
_____describes the data contained in the data warehouse
Select one:
Relational data
Operational data
Informational data
Meta data
Feedback
Your answer is correct.
The correct answer is: Meta data

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
Feedback
Your answer is correct.
The correct answer is: A system that is used to run the business in real time and is based on current data

Question 23
Treating incorrect or missing data is called as _______.
Select one:
Preprocessing
Interpretation
Selection
Transformation
Feedback
Your answer is correct.
The correct answer is: Preprocessing

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
Feedback
Your answer is correct.
The correct answer is: Replication

Question 25
When you ________ the data, you are aggregating the data to a higher level
Select one:
Slice
Roll up
Accumulate
Drill down
Feedback
Your answer is correct.
The correct answer is: Roll up

Question 26
______ is a measurement of the density of the data held in the data cube
Select one:
Mass
Sparsity
Compactness
Concentration
Feedback
Your answer is correct.
The correct answer is: Sparsity

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
Feedback
Your answer is correct.
The correct answer is: A star schema

Question 28
______ is a data transformation.
Select one:
Re-format
Selection
Projection
Comparison
Feedback
Your answer is correct.
The correct answer is: Re-format

One Reply to “Data Warehousing Questions & Answers | DWH | MCQ

  1. hey there and thank you for your info – I’ve definitely picked up something new from right here. I did however expertise some technical issues using this site, since I experienced to reload the site lots of times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I’m complaining, but slow loading instances times will sometimes affect your placement in google and can damage your quality score if advertising and marketing with Adwords. Anyway I am adding this RSS to my email and could look out for much more of your respective intriguing content. Make sure you update this again soon..

Comments are closed.