DBW301 – Final Exam Questions and
Correct Answers, 277Q&A, 2025/2026.
100% Verified.
A
Regarding to Star schema, which statement is NOT true?
A. In star schema some dimension tables are normalized.
B. In star schema each dimension is represented with only one dimension table.
C. There is a fact table at the centre. This fact table contains the keys to each of dimension.
D. None of the others.
A
What are the three major areas in the data warehouse?
A. Data Acquisition, Data storage, Information delivery
B. Data Collection, Data storage, Information delivery
C. Data Acquisition, Database, Reporting System
D. Data Acquisition, Data storage, Business Intelligence
B
Data warehouse architecture is just an overall guideline. It is not a blueprint for the data warehouse.
A. True
B. False
A
Which is NOT Business Metadata?
A. Data models of source systems
B. Connectivity procedures
C. Security and access privileges
D. Data transformation business rules
E
Which is NOT a key issue while planning for your data warehouse?
A. setting proper expectations
B. assessing risks
C. deciding between top-down or bottom-up approaches
D. choosing from vendor solutions.
E. requirement changes
B
............systems focus on individual events.
A. Data warehouse
B. OLTP
,C. Business system
D. OLAP
D
Which statement(s) is (are) related to Dimensional Modeling?
A. Captures critical measures
B. Views along dimensions
C. Intuitive to business users
D. All the others
B
Which statement(s) is (are) correct?
1) Metadata provides information on predefined queries.
2) A metadata repository is like a general purpose directory tool.
A. Only statement 1
B. Only statement 2
C. Both statement 1 and 2
D. None of the others
A
Which dimension does a data warehouse usually have?
A. Time
B. Category
C. User
D. Invoice
A
Which is NOT metadata?
A. Rows in tables
B. Keys of tables
C. Attributes in tables
D. Tables in data warehouse
A
Accurate requirements definition in a data warehouse project is many times more important than in
other types of projects.
A. True
B. False
D
In a fact table, there are 3 kinds of attributes:
(choose one answer only)
A. Dimension foreign keys
B. Degenerated dimensions
C. Facts
D. All the others
B
,Which is the traditional data warehouse project life cycle?
A. 1)Requirements definition 2)Project plan 3)Design 4)Construction 5)Deployment 6)Growth and
maintenance
B. 1)Project plan 2)Requirements definition 3)Design 4)Construction 5)Deployment 6)Growth and
maintenance
C. 1)Project plan 2)Requirements definition 3)Design 4)Construction 5)Deployment
D. None of the others
D
............ may answer questions on overall process.
A. OLTP
B. OLAP
C. Business Intelligence
D. Data warehouse
B
Which statement(s) is (are) correct?
1) Maintaining metadata in a modern data warehouse is just for documentation.
2) Metadata is needed by IT for data warehouse administration.
A. Only statement 1
B. Only statement 2
C. Both statement 1 and 2
D. None of the others
A
The term metadata refers to...............
A. "data about data"
B. "structure of data"
C. "quality of data"
D."how big data is"
A
Dimension tables contain the ...... of analysis.
A. criterions
B. measurements
C. facts
D. values
A
Which is NOT Technical Metadata?
A. Data transformation business rules
B. Data aggregation rules
C. Data cleansing rules
D. Data models of source systems
A
, OLTP is stand for Online Transaction Processing.
A. True
B. False
A
Fact tables generally occupy the most of the storage capacity.
A. True
B. False
B
In the dimensional model, the attributes of the data warehouse are divided into ..........and
dimension tables
A. center
B. fact
C. summary
D. aggregate
D
Which statement(s) is (are) related to Entity-Relationship Modeling?
(choose one answer only)
A. Removes data redundancy
B. Ensures data consistency
C. Expresses microscopic relationships
D. All the others
B
The importance of metadata is the same in a data warehouse as it is in an operational system.
A. True
B. False
B
Justification the benefits of a data warehouse through stiff ROI (Return on investment) calculations is
always easy.
A. True
B. False
A
......... reveals business trends.
A. Data warehouse
B. OLTP
C. Business system
D. OLAP
A
Business metadata comes from sources more varied than those for technical metadata.
A. True
B. False
Correct Answers, 277Q&A, 2025/2026.
100% Verified.
A
Regarding to Star schema, which statement is NOT true?
A. In star schema some dimension tables are normalized.
B. In star schema each dimension is represented with only one dimension table.
C. There is a fact table at the centre. This fact table contains the keys to each of dimension.
D. None of the others.
A
What are the three major areas in the data warehouse?
A. Data Acquisition, Data storage, Information delivery
B. Data Collection, Data storage, Information delivery
C. Data Acquisition, Database, Reporting System
D. Data Acquisition, Data storage, Business Intelligence
B
Data warehouse architecture is just an overall guideline. It is not a blueprint for the data warehouse.
A. True
B. False
A
Which is NOT Business Metadata?
A. Data models of source systems
B. Connectivity procedures
C. Security and access privileges
D. Data transformation business rules
E
Which is NOT a key issue while planning for your data warehouse?
A. setting proper expectations
B. assessing risks
C. deciding between top-down or bottom-up approaches
D. choosing from vendor solutions.
E. requirement changes
B
............systems focus on individual events.
A. Data warehouse
B. OLTP
,C. Business system
D. OLAP
D
Which statement(s) is (are) related to Dimensional Modeling?
A. Captures critical measures
B. Views along dimensions
C. Intuitive to business users
D. All the others
B
Which statement(s) is (are) correct?
1) Metadata provides information on predefined queries.
2) A metadata repository is like a general purpose directory tool.
A. Only statement 1
B. Only statement 2
C. Both statement 1 and 2
D. None of the others
A
Which dimension does a data warehouse usually have?
A. Time
B. Category
C. User
D. Invoice
A
Which is NOT metadata?
A. Rows in tables
B. Keys of tables
C. Attributes in tables
D. Tables in data warehouse
A
Accurate requirements definition in a data warehouse project is many times more important than in
other types of projects.
A. True
B. False
D
In a fact table, there are 3 kinds of attributes:
(choose one answer only)
A. Dimension foreign keys
B. Degenerated dimensions
C. Facts
D. All the others
B
,Which is the traditional data warehouse project life cycle?
A. 1)Requirements definition 2)Project plan 3)Design 4)Construction 5)Deployment 6)Growth and
maintenance
B. 1)Project plan 2)Requirements definition 3)Design 4)Construction 5)Deployment 6)Growth and
maintenance
C. 1)Project plan 2)Requirements definition 3)Design 4)Construction 5)Deployment
D. None of the others
D
............ may answer questions on overall process.
A. OLTP
B. OLAP
C. Business Intelligence
D. Data warehouse
B
Which statement(s) is (are) correct?
1) Maintaining metadata in a modern data warehouse is just for documentation.
2) Metadata is needed by IT for data warehouse administration.
A. Only statement 1
B. Only statement 2
C. Both statement 1 and 2
D. None of the others
A
The term metadata refers to...............
A. "data about data"
B. "structure of data"
C. "quality of data"
D."how big data is"
A
Dimension tables contain the ...... of analysis.
A. criterions
B. measurements
C. facts
D. values
A
Which is NOT Technical Metadata?
A. Data transformation business rules
B. Data aggregation rules
C. Data cleansing rules
D. Data models of source systems
A
, OLTP is stand for Online Transaction Processing.
A. True
B. False
A
Fact tables generally occupy the most of the storage capacity.
A. True
B. False
B
In the dimensional model, the attributes of the data warehouse are divided into ..........and
dimension tables
A. center
B. fact
C. summary
D. aggregate
D
Which statement(s) is (are) related to Entity-Relationship Modeling?
(choose one answer only)
A. Removes data redundancy
B. Ensures data consistency
C. Expresses microscopic relationships
D. All the others
B
The importance of metadata is the same in a data warehouse as it is in an operational system.
A. True
B. False
B
Justification the benefits of a data warehouse through stiff ROI (Return on investment) calculations is
always easy.
A. True
B. False
A
......... reveals business trends.
A. Data warehouse
B. OLTP
C. Business system
D. OLAP
A
Business metadata comes from sources more varied than those for technical metadata.
A. True
B. False
