A library is designing a database to manage books, members, and loans. A member can borrow multiple books, and a book can be borrowed by multiple members over time. The team needs to represent this many-to-many relationship correctly. What should they include in the ERD?

A direct many-to-many relationship between Members and Books

A one-to-many relationship from Members to Books

A one-to-one relationship between Members and Books

An associative entity (e.g., Loans) that connects Members and Books

A startup is building a social media analytics platform. They expect unpredictable traffic spikes and need to store large amounts of unstructured JSON data. The team wants to minimize operational overhead and scale horizontally without manual intervention. Which database architecture best meets these requirements?

A data warehouse optimized for complex analytical queries on structured data

A relational database with a fixed schema and vertical scaling on a single server

An in-memory cache used as the primary database for all data

A NoSQL document database with automatic sharding and a flexible schema

A multinational corporation is designing a database for employee records. Different countries have different data privacy laws, and the HR department needs to report on employee data in various ways. The data dictionary must support these diverse needs. What is the most important consideration when creating the data dictionary?

Using a single standard data type for all attributes to simplify the dictionary

Focusing only on technical attributes like data types and lengths

Creating a separate data dictionary for each country

Including data classification and privacy requirements for each attribute

A financial firm is designing a database for transaction processing. The design team has made several decisions about indexing, partitioning, and data retention. The project manager wants to ensure that future developers can understand the rationale behind these decisions and that the design can be implemented consistently. What should the team produce?

A comprehensive design document that includes the ERD, data dictionary, and explanations of design decisions

A list of all SQL scripts used to create the tables

A presentation summarizing the project timeline

An email to stakeholders confirming the design is complete

During the requirement gathering phase for a new database system, which activity is most directly associated with this phase?

Creating the physical storage layout for the database files

Interviewing stakeholders to identify data storage and reporting needs

Writing SQL queries to test the database performance

Defining the data types for each column in the tables

CompTIADataSys+

Domain 2Objective 1

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

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 16–20

16application · medium
A library is designing a database to manage books, members, and loans. A member can borrow multiple books, and a book can be borrowed by multiple members over time. The team needs to represent this many-to-many relationship correctly. What should they include in the ERD?
Select an answer first
17application · medium
A startup is building a social media analytics platform. They expect unpredictable traffic spikes and need to store large amounts of unstructured JSON data. The team wants to minimize operational overhead and scale horizontally without manual intervention. Which database architecture best meets these requirements?
Select an answer first
18expert · hard
A multinational corporation is designing a database for employee records. Different countries have different data privacy laws, and the HR department needs to report on employee data in various ways. The data dictionary must support these diverse needs. What is the most important consideration when creating the data dictionary?
Select an answer first
19application · medium
A financial firm is designing a database for transaction processing. The design team has made several decisions about indexing, partitioning, and data retention. The project manager wants to ensure that future developers can understand the rationale behind these decisions and that the design can be implemented consistently. What should the team produce?
Select an answer first
20foundation · easy
During the requirement gathering phase for a new database system, which activity is most directly associated with this phase?
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 4)

Questions 16–20

A library is designing a database to manage books, members, and loans. A member can borrow multiple books, and a book can be borrowed by multiple members over time. The team needs to represent this many-to-many relationship correctly. What should they include in the ERD?

During the requirement gathering phase for a new database system, which activity is most directly associated with this phase?

Keep studying — Database deployment