D426 ITEC 2116 Data Mgt Foundations FA Review 2025 (Qns & Ans).

D426 ITEC 2116 Data Management Foundations

Final Assessment Review (Qns & Ans)

2025




Which of the following is a key characteristic of a NoSQL
database?
a) ACID transactions
b) Relational data model
c) Horizontal scalability
d) Strict schema enforcement


ANS: c) Horizontal scalability

©2025

, Rationale: NoSQL databases are designed to scale horizontally
across many servers, unlike traditional relational databases.


What is the primary benefit of using a data lake?
a) Enforcing strict data governance policies
b) Storing structured data only
c) Centralized data storage for various data types and sources
d) Real-time data processing


ANS: c) Centralized data storage for various data types and
sources
Rationale: Data lakes allow for the storage of raw,
unstructured, and structured data in a central repository.


Which AWS service is commonly used for data warehousing?
a) Amazon S3
b) Amazon RDS
c) Amazon Redshift
d) Amazon DynamoDB


ANS: c) Amazon Redshift

©2025

, Rationale: Amazon Redshift is a fully managed, petabyte-scale
data warehouse service.


What does the term "data governance" primarily refer to?
a) The technical aspects of data storage
b) The policies and procedures for managing data quality and
security
c) The process of data migration
d) The physical location of data centers


ANS: b) The policies and procedures for managing data quality
and security
Rationale: Data governance encompasses the rules,
responsibilities, and processes to ensure data is managed
effectively.


What is the main advantage of using a columnar database?
a) Optimized for write operations
b) Efficient for analytical queries
c) Suitable for real-time transactions
d) Requires less storage space


©2025