Practice Questions DS6-029–042
DS6-029 · Organization · Foundational · recall
Which structure defines a hierarchical database in Chapter 6? - A. A tree with mandatory parent/child relationships in which a parent can have many children but each child has only one parent. - B. A set of rows and columns based on relational algebra. - C. A graph with unrestricted many-to-many edges. - D. A schema-on-read key-value store.
DS6-030 · Organization · Standard · understand
Which clue most strongly identifies relational database organization in Chapter 6? - A. Schema on read with arbitrary graph/network structures. - B. Schema on write, row orientation, and data organized through relations/tuples commonly accessed with SQL. - C. Only time-series values with no predefined schema. - D. Subject-predicate-object triples.
DS6-031 · Organization · Standard · understand
Which statement best describes non-relational / NoSQL organization in Chapter 6? - A. It must always be row-oriented. - B. It cannot support SQL in any form. - C. It can use schema on read and less constrained consistency models, with storage structures such as trees, graphs, networks, or key-value pairs. - D. It always provides stronger transaction guarantees than ACID systems.
DS6-032 · Organization · Difficult · apply
An OLAP workload scans a few columns across millions of rows to compute aggregates. Which layout is the better Chapter 6 fit? - A. Row-oriented. - B. Hierarchical only. - C. Flat-file only. - D. Column-oriented.
DS6-033 · Organization · Standard · distinguish
What is the difference between valid time and transaction time? - A. Valid time is when a fact is true in the real world; transaction time is when the fact stored in the database is considered true. - B. Valid time is backup time; transaction time is query time. - C. Valid time is user-entered; transaction time is system-generated. - D. They are synonyms in a bi-temporal database.
DS6-034 · Organization · Standard · recall
Which database type is optimized for geometric objects and operations such as distance, area, overlap, and buffers? - A. Temporal database. - B. Spatial database. - C. Key-value database. - D. Federated database.
DS6-035 · Organization · Difficult · distinguish
Which choice correctly distinguishes a key-value store from a triplestore? - A. A key-value store is always relational; a triplestore is always hierarchical. - B. A triplestore is a backup format; a key-value store is a replication method. - C. A key-value store retrieves values by keys; a triplestore stores subject-predicate-object triples for semantic relationships. - D. They are two names for the same NoSQL pattern.
DS6-036 · Common Processes · Standard · apply
Records are rarely used but must remain retrievable later. What Chapter 6 process is the best fit? - A. Purging. - B. Sharding. - C. Database abstraction. - D. Archiving.
DS6-037 · Common Processes · Difficult · apply
A secondary system needs only the rows that changed since yesterday, identified through update timestamps or logs. What process is this? - A. Change Data Capture (CDC). - B. Full refresh. - C. Purging. - D. Federation.
DS6-038 · Common Processes · Standard · understand
Which statement best describes purging? - A. Moving data to cheaper storage while keeping it retrievable. - B. Completely removing obsolete/unneeded data from storage so it cannot be recovered. - C. Keeping data available for a required time period. - D. Maintaining another synchronized copy.
DS6-039 · Common Processes · Difficult · distinguish
Which description matches passive replication? - A. Every replica recreates and stores the same data from every other replica. - B. Only changed rows are detected using a last-update timestamp. - C. A single primary replica is updated and its resulting state is propagated to secondary replicas. - D. Users query autonomous sources through a combined view without copying.
DS6-040 · Common Processes · Difficult · apply
A secondary server receives and applies copies of the primary database's transaction logs every fifteen minutes. What pattern is this? - A. Mirroring. - B. Sharding. - C. Active federation. - D. Log shipping.
DS6-041 · Common Processes · Standard · understand
What does database resiliency measure? - A. How tolerant the system is to error conditions while continuing to function as expected. - B. How quickly archived data can be purged. - C. How many replicas exist across geographic distances. - D. How long data must be retained.
DS6-042 · Common Processes · Standard · apply
A regulation requires records to remain available for seven years and to be deleted afterward. Which operational concept should drive the design? - A. Database abstraction. - B. Data retention policy, which then drives archiving and purging specifications. - C. Schema ownership. - D. Query optimization.