ADY201m (FPTU_AI) Questions and Answers 2024
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. ** Answ** a. in star schema some dimension tables are
normalized.
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 ** Answ** a. data
acquisition, data storage, information delivery
Data warehouse architecture is just an overall guideline. It is not a blueprint for the data
warehouse.
A. True
B. False ** Answ** b. false
Which is NOT Business Metadata?
A. Data models of source systems
B. Connectivity procedures
C. Security and access privileges
D. Data transformation business rules ** Answ** a. data models of source systems
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 ** Answ** e. requirement changes
............systems focus on individual events.
A. Data warehouse
B. OLTP
C. Business system
D. OLAP ** Answ** b. oltp
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 ** Answ** d. all the others
,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 ** Answ** b. only statement 2
Which dimension does a data warehouse usually have? A. Time
B. Category
C. User
D. Invoice ** Answ** a. time
Which is NOT metadata?
A. Rows in tables
B. Keys of tables
C. Attributes in tables
D. Tables in data warehouse ** Answ** a. rows in tables
Accurate requirements definition in a data warehouse project is many times more
important than in other types of projects.
A. True
B. False ** Answ** a. true
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 ** Answ** d. all
the others
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 ** Answ** B
............ may answer questions on overall process.
A. OLTP
B. OLAP
C. Business Intelligence
D. Data warehouse ** Answ** d. data warehouse
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 ** Answ** b. only statement 2
The term metadata refers to...............
A. "data about data"
B. "structure of data"
C. "quality of data"
D."how big data is" ** Answ** a. "data about data"
Dimension tables contain the ...... of analysis.
A. criterions
B. measurements
C. facts
D. values ** Answ** a. criterions
Which is NOT Technical Metadata?
A. Data transformation business rules
B. Data aggregation rules
C. Data cleansing rules
D. Data models of source systems ** Answ** a. data transformation business rules
OLTP is stand for Online Transaction Processing.
A. True
B. False ** Answ** a. true
Fact tables generally occupy the most of the storage capacity.
A. True
B. False ** Answ** a. true
In the dimensional model, the attributes of the data warehouse are divided
into ..........and dimension tables A. center
B. fact
C. summary
D. aggregate ** Answ** b. fact
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 ** Answ** d. all the others
The importance of metadata is the same in a data warehouse as it is in an operational
system.
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. ** Answ** a. in star schema some dimension tables are
normalized.
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 ** Answ** a. data
acquisition, data storage, information delivery
Data warehouse architecture is just an overall guideline. It is not a blueprint for the data
warehouse.
A. True
B. False ** Answ** b. false
Which is NOT Business Metadata?
A. Data models of source systems
B. Connectivity procedures
C. Security and access privileges
D. Data transformation business rules ** Answ** a. data models of source systems
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 ** Answ** e. requirement changes
............systems focus on individual events.
A. Data warehouse
B. OLTP
C. Business system
D. OLAP ** Answ** b. oltp
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 ** Answ** d. all the others
,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 ** Answ** b. only statement 2
Which dimension does a data warehouse usually have? A. Time
B. Category
C. User
D. Invoice ** Answ** a. time
Which is NOT metadata?
A. Rows in tables
B. Keys of tables
C. Attributes in tables
D. Tables in data warehouse ** Answ** a. rows in tables
Accurate requirements definition in a data warehouse project is many times more
important than in other types of projects.
A. True
B. False ** Answ** a. true
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 ** Answ** d. all
the others
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 ** Answ** B
............ may answer questions on overall process.
A. OLTP
B. OLAP
C. Business Intelligence
D. Data warehouse ** Answ** d. data warehouse
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 ** Answ** b. only statement 2
The term metadata refers to...............
A. "data about data"
B. "structure of data"
C. "quality of data"
D."how big data is" ** Answ** a. "data about data"
Dimension tables contain the ...... of analysis.
A. criterions
B. measurements
C. facts
D. values ** Answ** a. criterions
Which is NOT Technical Metadata?
A. Data transformation business rules
B. Data aggregation rules
C. Data cleansing rules
D. Data models of source systems ** Answ** a. data transformation business rules
OLTP is stand for Online Transaction Processing.
A. True
B. False ** Answ** a. true
Fact tables generally occupy the most of the storage capacity.
A. True
B. False ** Answ** a. true
In the dimensional model, the attributes of the data warehouse are divided
into ..........and dimension tables A. center
B. fact
C. summary
D. aggregate ** Answ** b. fact
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 ** Answ** d. all the others
The importance of metadata is the same in a data warehouse as it is in an operational
system.
