D427A ITEC 2117
Data Management Applications
Final Assessment (Qns & Ans)
2025
General Instructions
1. Read All Questions Carefully: Make sure you understand each question.
2. Time Management: You have a specific amount of time to complete the exam.
Keep an eye on the clock and pace yourself.
3. Allowed Materials: Only use materials that are explicitly allowed. Unauthorized
materials can lead to disqualification.
4. ANS Format: Follow the required format for your ANS. For example, multiple-
choice questions might need you to select the best ANS, while essay questions
require detailed responses.
5. Academic Integrity: Adhere to the university's honor code. Any form of cheating or
plagiarism is strictly prohibited.
6. Technical Requirements: Ensure your computer and internet connection are
stable. For online exams, you might need a webcam and microphone for proctoring
purposes.
7. Submission: Submit your ANS before the time expires. Late submissions might
not be accepted.
©2024/2025
,1. Which of the following best describes a data warehouse?
a) A storage system for temporary data
b) A centralized repository of integrated data from multiple
sources
c) A live database used for transactional purposes
d) A storage location for unstructured data
Correct ANS: b
Rationale: A data warehouse is designed to aggregate and
store data from various sources for analytical processing.
2. What is the primary purpose of ETL (Extract, Transform,
Load)?
a) Automate data entry tasks
b) Store data in cloud environments
c) Prepare data for analysis by integrating it from multiple
sources
d) Secure sensitive data
Correct ANS: c
©2024/2025
, Rationale: ETL refers to the process of collecting data from
different sources, transforming it into a suitable format, and
loading it into a target database.
3. In which type of database do the relationships between data
points generally resemble a tree structure?
a) Hierarchical database
b) Relational database
c) NoSQL database
d) Object-oriented database
Correct ANS: a
Rationale: Hierarchical databases organize data in a parent-
child relationship, resembling a tree structure.
4. Which of the following is a characteristic of a NoSQL
database?
a) Fixed schema
b) Relationships defined by foreign keys
c) Scalability and flexibility
d) Strong consistency
Correct ANS: c
©2024/2025
Data Management Applications
Final Assessment (Qns & Ans)
2025
General Instructions
1. Read All Questions Carefully: Make sure you understand each question.
2. Time Management: You have a specific amount of time to complete the exam.
Keep an eye on the clock and pace yourself.
3. Allowed Materials: Only use materials that are explicitly allowed. Unauthorized
materials can lead to disqualification.
4. ANS Format: Follow the required format for your ANS. For example, multiple-
choice questions might need you to select the best ANS, while essay questions
require detailed responses.
5. Academic Integrity: Adhere to the university's honor code. Any form of cheating or
plagiarism is strictly prohibited.
6. Technical Requirements: Ensure your computer and internet connection are
stable. For online exams, you might need a webcam and microphone for proctoring
purposes.
7. Submission: Submit your ANS before the time expires. Late submissions might
not be accepted.
©2024/2025
,1. Which of the following best describes a data warehouse?
a) A storage system for temporary data
b) A centralized repository of integrated data from multiple
sources
c) A live database used for transactional purposes
d) A storage location for unstructured data
Correct ANS: b
Rationale: A data warehouse is designed to aggregate and
store data from various sources for analytical processing.
2. What is the primary purpose of ETL (Extract, Transform,
Load)?
a) Automate data entry tasks
b) Store data in cloud environments
c) Prepare data for analysis by integrating it from multiple
sources
d) Secure sensitive data
Correct ANS: c
©2024/2025
, Rationale: ETL refers to the process of collecting data from
different sources, transforming it into a suitable format, and
loading it into a target database.
3. In which type of database do the relationships between data
points generally resemble a tree structure?
a) Hierarchical database
b) Relational database
c) NoSQL database
d) Object-oriented database
Correct ANS: a
Rationale: Hierarchical databases organize data in a parent-
child relationship, resembling a tree structure.
4. Which of the following is a characteristic of a NoSQL
database?
a) Fixed schema
b) Relationships defined by foreign keys
c) Scalability and flexibility
d) Strong consistency
Correct ANS: c
©2024/2025
