, Question 1
A financial services firm is migrating its legacy batch-processing mainframe
workloads to a hybrid cloud. Which architectural shift most directly reduces
the risk of a single point of failure while preserving transactional integrity?
A. Replacing the mainframe with a single high-availability virtual
machine cluster
B. Implementing a distributed ledger across on-premises and cloud nodes
C. Adopting a multi-region active-active deployment with synchronous
replication
D. Outsourcing all processing to a third-party SaaS provider with a 99.9%
SLA
Correct Answer: C - Adopting a multi-region active-active
deployment with synchronous replication
RATIONALE
An active-active multi-region deployment with synchronous
replication ensures no single point of failure and maintains
transactional consistency across sites. Option A still has a single
cluster as a failure domain; B introduces consensus overhead and is
not a drop-in for batch integrity; D outsources control and may not
meet strict transactional requirements.
Question 2
Which software development methodology characteristic best explains why a
team would choose Agile over Waterfall for a project with rapidly changing
requirements?
A. Agile mandates a fixed scope and schedule from the outset
B. Agile delivers working increments iteratively, allowing scope
adjustment
C. Agile eliminates the need for documentation and testing
D. Agile requires a single, upfront architectural design phase
Page 2
,Correct Answer: B - Agile delivers working increments
iteratively, allowing scope adjustment
RATIONALE
Agile's iterative delivery of working software enables continuous
feedback and scope adaptation, directly addressing volatile
requirements. Waterfall's sequential phases assume stable
requirements. Options A, C, and D misrepresent Agile principles.
Question 3
In a relational database, a table has a composite primary key (OrderID,
ProductID). A developer adds a foreign key constraint referencing
Orders(OrderID). Which anomaly does this constraint primarily prevent?
A. Insertion of an order detail without a corresponding order
B. Update of a product price without updating inventory
C. Deletion of a product referenced by an order detail
D. Insertion of a duplicate product name in the Products table
Correct Answer: A - Insertion of an order detail without a
corresponding order
RATIONALE
The foreign key ensures referential integrity: an order detail cannot
reference a non-existent order. Option B concerns a different table
relationship; C would require a foreign key on ProductID; D is a
uniqueness constraint, not referential integrity.
Question 4
A hospital's IT team must ensure that electronic protected health information
(ePHI) remains confidential during transmission over a public network. Which
combination of controls best satisfies HIPAA's technical safeguards?
A. Data-at-rest encryption and role-based access control
B. TLS encryption in transit and unique user identification with audit
Page 3
, controls
C. Network segmentation and physical security cameras
D. Full-disk encryption and automatic session termination
Correct Answer: B - TLS encryption in transit and unique user
identification with audit controls
RATIONALE
HIPAA technical safeguards for transmission security require
encryption in transit (e.g., TLS) and access controls such as unique
user IDs and audit logs. Options A and D focus on data-at-rest or
physical controls; C addresses physical and network controls but not
transmission encryption.
Question 5
Which statement accurately distinguishes a compiler from an interpreter in
terms of execution and error reporting?
A. A compiler translates the entire program to machine code before
execution, reporting all syntax errors at once
B. An interpreter translates line-by-line and reports all errors before
execution begins
C. A compiler executes source code directly without producing an
intermediate file
D. An interpreter produces an executable file that can run independently
of the interpreter
Correct Answer: A - A compiler translates the entire program to
machine code before execution, reporting all syntax errors at once
RATIONALE
Compilers translate the whole program into machine code and report
syntax errors after parsing the entire source. Interpreters execute
line-by-line, halting at the first error, and do not produce standalone
executables. Options B, C, and D misstate these behaviors.
Page 4
A financial services firm is migrating its legacy batch-processing mainframe
workloads to a hybrid cloud. Which architectural shift most directly reduces
the risk of a single point of failure while preserving transactional integrity?
A. Replacing the mainframe with a single high-availability virtual
machine cluster
B. Implementing a distributed ledger across on-premises and cloud nodes
C. Adopting a multi-region active-active deployment with synchronous
replication
D. Outsourcing all processing to a third-party SaaS provider with a 99.9%
SLA
Correct Answer: C - Adopting a multi-region active-active
deployment with synchronous replication
RATIONALE
An active-active multi-region deployment with synchronous
replication ensures no single point of failure and maintains
transactional consistency across sites. Option A still has a single
cluster as a failure domain; B introduces consensus overhead and is
not a drop-in for batch integrity; D outsources control and may not
meet strict transactional requirements.
Question 2
Which software development methodology characteristic best explains why a
team would choose Agile over Waterfall for a project with rapidly changing
requirements?
A. Agile mandates a fixed scope and schedule from the outset
B. Agile delivers working increments iteratively, allowing scope
adjustment
C. Agile eliminates the need for documentation and testing
D. Agile requires a single, upfront architectural design phase
Page 2
,Correct Answer: B - Agile delivers working increments
iteratively, allowing scope adjustment
RATIONALE
Agile's iterative delivery of working software enables continuous
feedback and scope adaptation, directly addressing volatile
requirements. Waterfall's sequential phases assume stable
requirements. Options A, C, and D misrepresent Agile principles.
Question 3
In a relational database, a table has a composite primary key (OrderID,
ProductID). A developer adds a foreign key constraint referencing
Orders(OrderID). Which anomaly does this constraint primarily prevent?
A. Insertion of an order detail without a corresponding order
B. Update of a product price without updating inventory
C. Deletion of a product referenced by an order detail
D. Insertion of a duplicate product name in the Products table
Correct Answer: A - Insertion of an order detail without a
corresponding order
RATIONALE
The foreign key ensures referential integrity: an order detail cannot
reference a non-existent order. Option B concerns a different table
relationship; C would require a foreign key on ProductID; D is a
uniqueness constraint, not referential integrity.
Question 4
A hospital's IT team must ensure that electronic protected health information
(ePHI) remains confidential during transmission over a public network. Which
combination of controls best satisfies HIPAA's technical safeguards?
A. Data-at-rest encryption and role-based access control
B. TLS encryption in transit and unique user identification with audit
Page 3
, controls
C. Network segmentation and physical security cameras
D. Full-disk encryption and automatic session termination
Correct Answer: B - TLS encryption in transit and unique user
identification with audit controls
RATIONALE
HIPAA technical safeguards for transmission security require
encryption in transit (e.g., TLS) and access controls such as unique
user IDs and audit logs. Options A and D focus on data-at-rest or
physical controls; C addresses physical and network controls but not
transmission encryption.
Question 5
Which statement accurately distinguishes a compiler from an interpreter in
terms of execution and error reporting?
A. A compiler translates the entire program to machine code before
execution, reporting all syntax errors at once
B. An interpreter translates line-by-line and reports all errors before
execution begins
C. A compiler executes source code directly without producing an
intermediate file
D. An interpreter produces an executable file that can run independently
of the interpreter
Correct Answer: A - A compiler translates the entire program to
machine code before execution, reporting all syntax errors at once
RATIONALE
Compilers translate the whole program into machine code and report
syntax errors after parsing the entire source. Interpreters execute
line-by-line, halting at the first error, and do not produce standalone
executables. Options B, C, and D misstate these behaviors.
Page 4
