Practice Questions DS6-001–014
Record answer · confidence 1–5 · time · review flag before checking the key.
DS6-001 · Introduction · Foundational · recall
Which statement best matches Chapter 6's definition of Data Storage and Operations? - A. The design, implementation, and support of stored data to maximize its value throughout its lifecycle. - B. The creation of conceptual and logical models before database design. - C. The governance of data ownership and policy decision rights. - D. The integration of data from multiple sources into common analytical structures.
DS6-002 · Introduction · Foundational · recall
What does Chapter 6 identify as the primary business driver for Data Storage and Operations? - A. Data monetization. - B. Business continuity. - C. Data literacy. - D. Metadata standardization.
DS6-003 · Introduction · Foundational · recall
Which set contains the three Chapter 6 goals? - A. Define data ownership, steward roles, and escalation paths. - B. Normalize data, create keys, and maintain conceptual models. - C. Manage data availability throughout the lifecycle, ensure integrity of data assets, and manage transaction performance. - D. Classify data, set retention labels, and publish a glossary.
DS6-004 · Introduction · Standard · apply
A project team asks the DBA to enforce every database standard even when a justified exception would prevent project failure. Which Chapter 6 principle gives the best guidance? - A. Never deviate from database standards once approved. - B. Let developers ignore all DBA standards if deadlines are tight. - C. Move responsibility entirely to the vendor. - D. Apply best practices as requirements, but allow justified deviations when acceptable reasons exist; standards should not threaten project success.
DS6-005 · Core Terms · Foundational · distinguish
A team is discussing one running execution of DBMS software that controls access to a particular storage area. What term fits best? - A. Instance. - B. Database. - C. Schema. - D. Node.
DS6-006 · Core Terms · Standard · apply
An organization wants to isolate sensitive objects with a distinct owner and access list inside a database. Which construct is the most direct fit? - A. Instance. - B. Schema. - C. Node. - D. Database abstraction layer.
DS6-007 · Core Terms · Standard · distinguish
What is the main trade-off Chapter 6 associates with database abstraction through a common API such as ODBC? - A. It guarantees ACID behavior across every database. - B. It eliminates the need for database schemas. - C. It improves portability across databases but may prevent use of product-specific functions not common to all databases. - D. It duplicates data to every participating database.
DS6-008 · Lifecycle · Standard · best-action
A developer requests a direct Production database change with no approved change request and no back-out plan. What is the best Chapter 6 response? - A. Proceed if the developer confirms the change is small. - B. Apply the change and document it afterward. - C. Copy Production to a sandbox and make the same change there only. - D. Use a controlled, documented, auditable change process with approval and a back-out plan before Production implementation.
DS6-009 · Roles · Standard · apply
Which responsibility most strongly identifies a Production DBA? - A. Performance/reliability monitoring plus backup, recovery, failover, and production maintenance. - B. Designing conceptual business data models. - C. Administering only stored procedures and UDFs. - D. Managing storage-array hardware independently of database applications.
DS6-010 · Roles · Standard · distinguish
What most clearly distinguishes an Application DBA in Chapter 6? - A. Responsibility only for production server hardware. - B. Responsibility for one or more application databases across environments, often as an integral member of the application support team. - C. Exclusive responsibility for all enterprise database standards. - D. Specialization in storage arrays rather than databases.
DS6-011 · Roles · Standard · recall
A specialist plans, implements, tests, and promotes reuse of stored procedures, triggers, and user-defined functions. Which role is this? - A. Production DBA. - B. Application DBA. - C. Procedural DBA. - D. Network Storage Administrator.
DS6-012 · Roles · Foundational · recall
What is the primary focus of a Network Storage Administrator (NSA)? - A. Conceptual data models and business vocabulary. - B. Stored procedures and triggers inside the DBMS. - C. Data-quality acceptance criteria. - D. The hardware and software supporting data storage arrays.
DS6-013 · Architecture · Standard · apply
A database keeps all data in one system in one place. What is the most direct operational risk identified by Chapter 6? - A. If that centralized system is unavailable, there may be no alternative way to access the data. - B. The data cannot be restricted. - C. The system cannot use SQL. - D. The database must be federated.
DS6-014 · Architecture · Difficult · apply
Several autonomous databases must appear as one combined database without duplicating the source data. Which architecture best fits? - A. Centralized database. - B. Federated database system. - C. Non-federated distributed database. - D. Mirrored database.