A database administrator is documenting the steps for performing a weekly database backup. The document must be clear enough for a junior administrator to follow without prior knowledge. Which component is essential to include in this standard operating procedure?

The vendor's contact information for support

The detailed step-by-step instructions, including commands and expected outcomes

The list of database users and their permissions

A database designer is creating an ERD for a university system. The system tracks Students, Courses, and Enrollments. Each student can enroll in many courses, and each course can have many students. The designer needs to record the grade a student receives in a course. Which approach correctly models this scenario?

Create a many-to-many relationship between Students and Courses, with grade as an attribute of that relationship

Create a one-to-many relationship from Students to Courses, with grade as an attribute of the Student entity

Create an Enrollments entity with foreign keys to Students and Courses, and include grade as an attribute

Create a one-to-many relationship from Courses to Students, with grade as an attribute of the Course entity

A database designer is creating an ERD for a hospital system. The system tracks Patients, Doctors, and Appointments. Each patient can have many appointments, each doctor can have many appointments, and each appointment involves one patient and one doctor. The designer also needs to record the diagnosis for each appointment. Which approach correctly models this scenario?

Create a many-to-many relationship between Patients and Doctors, with diagnosis as an attribute of that relationship

Create an Appointments entity with foreign keys to Patients and Doctors, and include diagnosis as an attribute

Create a one-to-many relationship from Patients to Doctors, with diagnosis as an attribute of the Patient entity

Create a one-to-many relationship from Doctors to Patients, with diagnosis as an attribute of the Doctor entity

CompTIADataSys+

Domain 3Objective 3

Documentation and Tools DS0-001 Practice Questions (Page 3)

Part of the Database management and maintenance domain, which accounts for 25% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~9–15 in this domain), expect 2–4 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

8concepts

25%of the exam

Questions 11–15

11foundation · easy
A database designer is creating an ERD for a library system. The system has 'Books' and 'Authors' entities, and a book can have multiple authors while an author can write multiple books. Which type of relationship should be represented between these two entities?
Select an answer first
12application · medium
A database administrator is documenting the steps for performing a weekly database backup. The document must be clear enough for a junior administrator to follow without prior knowledge. Which component is essential to include in this standard operating procedure?
Select an answer first
13expert · hard
A database designer is creating an ERD for a university system. The system tracks Students, Courses, and Enrollments. Each student can enroll in many courses, and each course can have many students. The designer needs to record the grade a student receives in a course. Which approach correctly models this scenario?
Select an answer first
14expert · hard
A database designer is creating an ERD for a hospital system. The system tracks Patients, Doctors, and Appointments. Each patient can have many appointments, each doctor can have many appointments, and each appointment involves one patient and one doctor. The designer also needs to record the diagnosis for each appointment. Which approach correctly models this scenario?
Select an answer first
15foundation · easy
What does a rectangle represent in a standard entity-relationship diagram?
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.

Documentation and Tools DS0-001 Practice Questions (Page 3)

Questions 11–15

A database designer is creating an ERD for a library system. The system has 'Books' and 'Authors' entities, and a book can have multiple authors while an author can write multiple books. Which type of relationship should be represented between these two entities?

A database administrator is documenting the steps for performing a weekly database backup. The document must be clear enough for a junior administrator to follow without prior knowledge. Which component is essential to include in this standard operating procedure?

What does a rectangle represent in a standard entity-relationship diagram?

Keep studying — Database management and maintenance