A healthcare provider is designing a database for patient records. They need to ensure high availability, data integrity, and the ability to handle a growing number of patients. The team is considering a relational database with ACID transactions. What is the most important factor to consider when designing the architecture?

The use of a NoSQL database for horizontal scaling

The requirement for ACID transactions to ensure data integrity

The need for real-time analytics on patient data

The need to store unstructured data like medical images

A logistics company is planning a database to track shipments. Stakeholders include dispatchers, drivers, and customers. Dispatchers need real-time location updates, drivers need to update status from mobile devices, and customers need delivery notifications. The team is unsure about the volume of data and the frequency of updates. What is the first step in the planning process?

Gather and document detailed requirements from all stakeholders

Create a data dictionary for all possible data elements

Design the ERD based on the known entities and relationships

Select a database platform based on the company's existing technology stack

A government agency is planning a database for citizen services. They have a strict budget and limited IT staff. Stakeholders include case workers who need fast access to records, and auditors who require a complete history of changes. The agency also has a legal requirement to retain records for 10 years. The team is considering a relational database with an audit trail. What is the most significant trade-off they must address?

Determining whether to use a data dictionary or an ERD for documentation

Choosing between a relational database and a NoSQL database for flexibility

Deciding whether to use on-premises or cloud hosting to reduce costs

Balancing the need for fast access with the storage cost of retaining 10 years of audit data

What is the main purpose of compiling a database design document?

To store the actual data of the database

To provide a reference for implementation and future maintenance

To replace the need for a data dictionary

To provide a marketing overview of the database product

What is the primary purpose of a data dictionary?

To store the actual data records of the database

To manage database user permissions

To provide a centralized definition and description of all data elements

To optimize query execution plans

CompTIADataSys+

Domain 2Objective 1

Planning and Design DS0-001 Practice Questions (Page 1)

Part of the Database deployment domain, which accounts for 16% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~6–10 in this domain), expect 2–3 from this objective — we provide 29 practice questions to prepare you well beyond it. (estimate)

29questions here

6free pages

5concepts

16%of the exam

Questions 1–5

1application · medium
A healthcare provider is designing a database for patient records. They need to ensure high availability, data integrity, and the ability to handle a growing number of patients. The team is considering a relational database with ACID transactions. What is the most important factor to consider when designing the architecture?
Select an answer first
2application · easy
A logistics company is planning a database to track shipments. Stakeholders include dispatchers, drivers, and customers. Dispatchers need real-time location updates, drivers need to update status from mobile devices, and customers need delivery notifications. The team is unsure about the volume of data and the frequency of updates. What is the first step in the planning process?
Select an answer first
3expert · hard
A government agency is planning a database for citizen services. They have a strict budget and limited IT staff. Stakeholders include case workers who need fast access to records, and auditors who require a complete history of changes. The agency also has a legal requirement to retain records for 10 years. The team is considering a relational database with an audit trail. What is the most significant trade-off they must address?
Select an answer first
4foundation · easy
What is the main purpose of compiling a database design document?
Select an answer first
5foundation · easy
What is the primary purpose of a data dictionary?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DS0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DS0-001” is a trademark of its owner, used for identification only.

Planning and Design DS0-001 Practice Questions (Page 1)

Questions 1–5

What is the main purpose of compiling a database design document?

What is the primary purpose of a data dictionary?

Keep studying — Database deployment