What is the primary purpose of an entity relationship diagram (ERD)?

To visually represent the database structure and relationships between entities

To store the actual data in a graphical format

To define user interface layouts for database applications

To list all database backup procedures

A global e-commerce company is designing a database to support millions of users and high transaction volumes. They need low-latency access for users in different regions and must ensure data consistency for orders. The team is evaluating a distributed database with eventual consistency. What is the main trade-off they must consider?

Distributed databases are always more expensive than centralized ones

The database will not be able to handle high transaction volumes

Users in different regions will experience different performance

Eventual consistency may lead to temporary inconsistencies in order data, which could affect customer trust

Which of the following is typically included in a data dictionary entry for a table column?

The number of rows in the table

The physical disk location of the column

The SQL query used to create the table

A hospital is designing a database for patient appointments. They need to track patients, doctors, and appointments. A patient can have multiple appointments, and a doctor can have multiple appointments. The team is debating whether to include an 'appointment' entity as an associative entity or to create a direct many-to-many relationship. What is the best approach?

Create a one-to-one relationship between Patients and Doctors

Create a one-to-many relationship from Patients to Doctors

Create an associative entity 'Appointment' with attributes like date, time, and status

Create a direct many-to-many relationship between Patients and Doctors

CompTIADataSys+

Domain 2Objective 1

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

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 26–29

26foundation · easy
What is the primary purpose of an entity relationship diagram (ERD)?
Select an answer first
27expert · hard
A global e-commerce company is designing a database to support millions of users and high transaction volumes. They need low-latency access for users in different regions and must ensure data consistency for orders. The team is evaluating a distributed database with eventual consistency. What is the main trade-off they must consider?
Select an answer first
28foundation · easy
Which of the following is typically included in a data dictionary entry for a table column?
Select an answer first
29expert · medium
A hospital is designing a database for patient appointments. They need to track patients, doctors, and appointments. A patient can have multiple appointments, and a doctor can have multiple appointments. The team is debating whether to include an 'appointment' entity as an associative entity or to create a direct many-to-many relationship. What is the best approach?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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 6)

Questions 26–29

What is the primary purpose of an entity relationship diagram (ERD)?

Which of the following is typically included in a data dictionary entry for a table column?

Keep studying — Database deployment