CS – D326 DTMG 3179 Advanced Data
Management
Comprehensive Objective Assessment (Qns &
Ans)
2025
Question 1:
Case Scenario:
A multinational enterprise deploys a distributed data management
system across several geographic regions to achieve low latency
and high availability. However, during network partitions, the
system experiences significant data consistency issues.
Question:
Which property does the system most likely sacrifice to ensure
continued operation during a network partition, according to the
CAP theorem?
a) Latency
©2025
,b) Partition tolerance
c) Consistency
d) Scalability
Correct ANS: c) Consistency
Rationale:
The CAP theorem states that in the event of a network partition, a
distributed system must choose between consistency and
availability. In this scenario, to maintain high availability and
partition tolerance, the system sacrifices immediate consistency,
often relying on eventual consistency instead.
---
Question 2:
Case Scenario:
A large organization is modernizing its data architecture by
integrating both a data warehouse and a data lake. They need to
provide near real-time insights while still processing large
historical data sets for in-depth analytics.
Question:
©2025
,Which architectural approach is best suited to achieve these dual
aims?
a) Batch processing only
b) Lambda architecture
c) Data replication with periodic snapshotting
d) Strict ETL pipelines
Correct ANS: b) Lambda architecture
Rationale:
Lambda architecture splits processing into two layers: a batch
layer for historical, large-scale data processing and a speed (real-
time) layer for current data. This dual approach ensures both real-
time analytics and in-depth historical analysis.
---
Question 3:
Case Scenario:
A social media start-up opts for a NoSQL database system to
handle unpredictable, high-volume unstructured data. The system
must support horizontal scaling and flexible schema designs.
©2025
, Question:
Which feature is most critical in NoSQL databases for this
scenario?
a) Strict ACID compliance
b) Fixed schema
c) Horizontal scalability
d) Vertical scaling
Correct ANS: c) Horizontal scalability
Rationale:
NoSQL databases are designed to scale out by distributing data
across multiple servers (horizontal scaling) to handle high
volumes of unstructured data with flexible schema requirements.
Strict ACID and fixed schemas are more typical of traditional
relational systems.
---
Question 4:
Case Scenario:
A financial institution implements a distributed transaction system
over its replicated databases. To maintain consistency across
©2025
Management
Comprehensive Objective Assessment (Qns &
Ans)
2025
Question 1:
Case Scenario:
A multinational enterprise deploys a distributed data management
system across several geographic regions to achieve low latency
and high availability. However, during network partitions, the
system experiences significant data consistency issues.
Question:
Which property does the system most likely sacrifice to ensure
continued operation during a network partition, according to the
CAP theorem?
a) Latency
©2025
,b) Partition tolerance
c) Consistency
d) Scalability
Correct ANS: c) Consistency
Rationale:
The CAP theorem states that in the event of a network partition, a
distributed system must choose between consistency and
availability. In this scenario, to maintain high availability and
partition tolerance, the system sacrifices immediate consistency,
often relying on eventual consistency instead.
---
Question 2:
Case Scenario:
A large organization is modernizing its data architecture by
integrating both a data warehouse and a data lake. They need to
provide near real-time insights while still processing large
historical data sets for in-depth analytics.
Question:
©2025
,Which architectural approach is best suited to achieve these dual
aims?
a) Batch processing only
b) Lambda architecture
c) Data replication with periodic snapshotting
d) Strict ETL pipelines
Correct ANS: b) Lambda architecture
Rationale:
Lambda architecture splits processing into two layers: a batch
layer for historical, large-scale data processing and a speed (real-
time) layer for current data. This dual approach ensures both real-
time analytics and in-depth historical analysis.
---
Question 3:
Case Scenario:
A social media start-up opts for a NoSQL database system to
handle unpredictable, high-volume unstructured data. The system
must support horizontal scaling and flexible schema designs.
©2025
, Question:
Which feature is most critical in NoSQL databases for this
scenario?
a) Strict ACID compliance
b) Fixed schema
c) Horizontal scalability
d) Vertical scaling
Correct ANS: c) Horizontal scalability
Rationale:
NoSQL databases are designed to scale out by distributing data
across multiple servers (horizontal scaling) to handle high
volumes of unstructured data with flexible schema requirements.
Strict ACID and fixed schemas are more typical of traditional
relational systems.
---
Question 4:
Case Scenario:
A financial institution implements a distributed transaction system
over its replicated databases. To maintain consistency across
©2025
