D326 DTMG 3179
Advanced Data Management
3.0 Credits
Objective Assessment Review (Qns &
Ans)
2025
©2025
, Multiple Choice Questions
Question 1:
A global enterprise uses a distributed database system for its analytics platform. To
understand the trade-offs between consistency, availability, and partition tolerance
in this environment, which theorem should the data architect refer to?
A. ACID Theorem
B. CAP Theorem
C. BASE Model
D. PACELC Model
Correct ANS: B. CAP Theorem
Rationale:
The CAP Theorem states that in any distributed system, you can guarantee only two
of the following three properties—Consistency, Availability, and Partition tolerance.
This is a fundamental principle in advanced distributed data management, guiding
decisions about system design when trade-offs are inevitable.
---
Question 2:
An analytics team is considering a column-oriented database for their data
warehouse to speed up aggregate queries over large datasets. What is the primary
advantage of using a column store over a row store in this context?
A. Improved transactional processing
B. Enhanced compression and faster read performance for aggregations
C. Better support for unstructured data
D. Simpler schema design
Correct ANS: B. Enhanced compression and faster read performance for
aggregations
Rationale:
Column-oriented databases store data column-by-column rather than row-by-row.
This layout significantly improves compression rates and accelerates aggregate
©2025
, queries (e.g., SUM, AVG) common in analytical workloads, making them ideal for
data warehousing scenarios.
---
Question 3:
In advanced data management systems that support spatial and multi-dimensional
queries, which specialized indexing technique is most appropriate?
A. B-Tree
B. Hash Indexing
C. R-Tree
D. Bitmap Indexing
Correct ANS: C. R-Tree
Rationale:
R-Trees use a tree-based structure designed specifically for spatial data and multi-
dimensional indexing. They efficiently handle range queries and nearest-neighbor
searches, which are common in applications dealing with geographical or complex
multidimensional data.
---
Question 4:
To address both real-time processing and large‑scale batch computations, an
analytics company adopts a layered architecture that combines a batch layer and a
speed layer. What is this architectural pattern called?
A. Kappa Architecture
B. Lambda Architecture
C. Delta Architecture
D. Omega Architecture
Correct ANS: B. Lambda Architecture
Rationale:
Lambda Architecture is designed to handle massive quantities of data by employing
a batch layer for comprehensive processing and a speed layer for real‑time
analytics. This dual approach enables systems to deliver both accurate historical
©2025
Advanced Data Management
3.0 Credits
Objective Assessment Review (Qns &
Ans)
2025
©2025
, Multiple Choice Questions
Question 1:
A global enterprise uses a distributed database system for its analytics platform. To
understand the trade-offs between consistency, availability, and partition tolerance
in this environment, which theorem should the data architect refer to?
A. ACID Theorem
B. CAP Theorem
C. BASE Model
D. PACELC Model
Correct ANS: B. CAP Theorem
Rationale:
The CAP Theorem states that in any distributed system, you can guarantee only two
of the following three properties—Consistency, Availability, and Partition tolerance.
This is a fundamental principle in advanced distributed data management, guiding
decisions about system design when trade-offs are inevitable.
---
Question 2:
An analytics team is considering a column-oriented database for their data
warehouse to speed up aggregate queries over large datasets. What is the primary
advantage of using a column store over a row store in this context?
A. Improved transactional processing
B. Enhanced compression and faster read performance for aggregations
C. Better support for unstructured data
D. Simpler schema design
Correct ANS: B. Enhanced compression and faster read performance for
aggregations
Rationale:
Column-oriented databases store data column-by-column rather than row-by-row.
This layout significantly improves compression rates and accelerates aggregate
©2025
, queries (e.g., SUM, AVG) common in analytical workloads, making them ideal for
data warehousing scenarios.
---
Question 3:
In advanced data management systems that support spatial and multi-dimensional
queries, which specialized indexing technique is most appropriate?
A. B-Tree
B. Hash Indexing
C. R-Tree
D. Bitmap Indexing
Correct ANS: C. R-Tree
Rationale:
R-Trees use a tree-based structure designed specifically for spatial data and multi-
dimensional indexing. They efficiently handle range queries and nearest-neighbor
searches, which are common in applications dealing with geographical or complex
multidimensional data.
---
Question 4:
To address both real-time processing and large‑scale batch computations, an
analytics company adopts a layered architecture that combines a batch layer and a
speed layer. What is this architectural pattern called?
A. Kappa Architecture
B. Lambda Architecture
C. Delta Architecture
D. Omega Architecture
Correct ANS: B. Lambda Architecture
Rationale:
Lambda Architecture is designed to handle massive quantities of data by employing
a batch layer for comprehensive processing and a speed layer for real‑time
analytics. This dual approach enables systems to deliver both accurate historical
©2025
