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

Questions 16–20

1. 16foundation · easy

   A database administrator is documenting the structure of a new database. Which resource provides a centralized, authoritative description of database objects such as tables, columns, and their relationships?

   • ASOP (Standard Operating Procedure)
   • BERD (Entity-Relationship Diagram)
   • CQuery plan
   • DData dictionary
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which of the following is a key benefit of having well-documented Standard Operating Procedures for database maintenance?

   • AEnsures tasks are performed consistently even when the primary DBA is unavailable
   • BGuarantees that no security breaches will occur
   • CEliminates the need for database backups
   • DAutomatically optimizes all database queries
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which of the following is a type of compliance documentation commonly used in database management?

   • AQuery optimization plans
   • BAudit logs
   • CERD diagrams
   • DData dictionary
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A company is required to retain database audit logs for a minimum of one year to meet regulatory requirements. Which compliance documentation should the company maintain to demonstrate this?

   • AThe ERD
   • BThe audit log retention policy
   • CThe data dictionary
   • DThe backup schedule
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A database administrator is writing an SOP for handling user access requests. The SOP must ensure that access is granted only after proper approval and that all actions are recorded for compliance. Which steps should be included in the SOP?

   • AGrant access, but do not log the action to avoid unnecessary documentation
   • BGrant access based on the requester's self-approval, then notify the manager
   • CVerify the request, obtain manager approval, grant access, and log the action
   • DGrant access immediately upon request, then document the request later
   Reveal Solution Discussion Select an answer first