Practice Questions DS6-015–028
DS6-015 · Architecture · Difficult · distinguish
Which clue most strongly indicates a tightly coupled federated system? - A. Each component constructs its own federated schema and users need location knowledge. - B. All component databases lose autonomy under one DBMS. - C. An integrated federated schema is constructed and published for the component systems. - D. Every update is copied to all nodes immediately.
DS6-016 · Architecture · Standard · apply
A cloud provider installs and maintains the database while the application owner pays according to usage. Which model is this? - A. Virtual machine image. - B. Managed database hosting. - C. Federated database. - D. Database-as-a-Service (DaaS).
DS6-017 · Processing · Foundational · recall
Which ACID property means that all operations in a transaction are performed or none are? - A. Atomicity. - B. Consistency. - C. Isolation. - D. Durability.
DS6-018 · Processing · Standard · recall
Which expansion matches BASE in Chapter 6? - A. Backup, Availability, Storage, Execution. - B. Basically Available, Soft state, Eventual consistency. - C. Basically Atomic, Strongly consistent, Eventually durable. - D. Balanced Access, Scalable Execution.
DS6-019 · Processing · Standard · understand
What does the CAP theorem help explain in Chapter 6? - A. The four guarantees of a relational transaction. - B. The three stages of backup and recovery. - C. Trade-offs among Consistency, Availability, and Partition tolerance in distributed systems. - D. The relationship cardinality between database entities.
DS6-020 · Processing · Difficult · best-action
A proposed database technology has no transaction commit/rollback capability but is being considered for a point-of-sale workload. What is the best response? - A. Use it because every database technology can support every workload. - B. Use it only if the application team owns support. - C. Choose it if licensing is cheaper. - D. Reject or reconsider it for this workload because the technology does not provide the transaction capability the operational use requires.
DS6-021 · Storage Media · Standard · distinguish
Which description best fits an in-memory database? - A. Data is loaded from persistent storage into volatile memory and processing occurs in memory for faster response. - B. Data is always stored only on magnetic disk. - C. Data is split into independent shards for replication. - D. Data is organized only as key-value pairs.
DS6-022 · Storage Media · Standard · apply
A dataset contains heavy repetition within columns, and the goal is to reduce I/O bandwidth through compression. Which storage approach best fits? - A. Cold backup. - B. Columnar compression. - C. Hierarchical storage. - D. Database abstraction.
DS6-023 · Storage Media · Foundational · recall
Why does Chapter 6 describe flash/SSD as attractive? - A. It guarantees eventual consistency. - B. It removes the need for backup. - C. It combines memory-like access speed with persistent storage characteristics. - D. It is always cheaper than disk.
DS6-024 · Storage Media · Standard · understand
What is a Storage Area Network (SAN) in the Chapter 6 discussion? - A. A federated query layer across autonomous databases. - B. A schema that isolates sensitive database objects. - C. A special test environment for storage changes. - D. A collection of disk arrays used for managed storage, where data movement may occur on the backplane rather than over the network.
DS6-025 · Environments · Standard · apply
Which statement best matches the Production environment rule? - A. Production is mission-critical, should not be used for development/testing, and database changes there must follow strict controlled processes. - B. Production is the preferred place to test urgent patches. - C. Developers may implement Production database changes if a DBA approves verbally. - D. Production should always be smaller than Test to reduce risk.
DS6-026 · Environments · Standard · apply
Where should a new database patch normally be applied first? - A. Production. - B. Development. - C. Sandbox only. - D. A remote recovery site.
DS6-027 · Environments · Standard · distinguish
What is the strongest Chapter 6 requirement for a performance-test environment? - A. It should always use synthetic data only. - B. It may write test results directly into Production. - C. It should closely resemble Production and ideally not be scaled down in the resources that affect the test. - D. It should be deliberately different from Production to expose portability issues.
DS6-028 · Environments · Standard · apply
Which situation best fits a sandbox environment? - A. Mission-critical live processing. - B. Formal UAT with controlled test cases. - C. Off-site restore of backups after a disaster. - D. Users experiment with hypotheses or proof-of-concepts in an isolated area that may read Production data but must not write back to Production.