Practice Questions DS6-043–056
DS6-043 · Common Processes · Standard · recall
What is sharding in Chapter 6? - A. Copying the same entire database to multiple devices. - B. Combining autonomous databases into one federated view. - C. Isolating small chunks of a database so they can be updated independently of other shards. - D. Moving old data to long-term storage.
DS6-044 · Technology Support · Difficult · best-action
Which evaluation approach best matches Chapter 6 when selecting strategic DBMS software? - A. Choose the product with the most features regardless of workload. - B. Choose only on license price. - C. Standardize on one DBMS for every use case. - D. Evaluate both technical fit (architecture, volume/velocity, workload, function, platform, tools, performance, scale, resiliency) and organizational/vendor factors (risk appetite, skills, TCO, support, reputation, references).
DS6-045 · Operations · Standard · apply
A first-year storage estimate includes only table data. What is missing according to Chapter 6? - A. Capacity for indexes, logs, and redundant images such as mirrors, plus growth projections for following years. - B. Only user-training hours. - C. Only vendor support costs. - D. Only archive-retrieval time.
DS6-046 · Operations · Standard · apply
A system becomes heavily loaded at month end but is quiet on weekends. What type of requirement should the DBA recognize? - A. A federated-database requirement. - B. A predictable time-based usage pattern with peaks and valleys that can guide scheduling and resource controls. - C. A schema-on-read requirement. - D. A data-audit requirement.
DS6-047 · Continuity · Difficult · best-action
After a disaster, several databases must be restored. What should determine the restoration order? - A. Database size only. - B. Alphabetical database name. - C. Business criticality: essential operational databases first, less critical databases later, and some copies may not need restoration at all. - D. The age of the DBMS software.
DS6-048 · Continuity · Difficult · apply
Daily backups complete successfully, but no one has ever restored from them. What is the strongest Chapter 6 conclusion? - A. The backup program is fully adequate because jobs succeeded. - B. Switch every backup to cold backup immediately. - C. Move the database into a federated architecture. - D. Recoverability is not proven; periodically test data recovery on non-production or failover infrastructure.
DS6-049 · Configuration · Difficult · distinguish
Which pairing correctly distinguishes the two configuration audit types? - A. Physical configuration audit checks installation against detailed design; functional configuration audit checks whether required performance attributes are achieved. - B. Physical checks performance; functional checks installation. - C. Physical checks licensing; functional checks retention. - D. They are interchangeable terms.
DS6-050 · Operations · Standard · apply
A DBA receives a physical model and must add database-specific indexes, constraints, partitions, capacity estimates, and storage allocation. Which Chapter 6 activity is this? - A. Evaluate Database Technology. - B. Implement Physical Data Models. - C. Manage Test Data Sets. - D. Information Asset Tracking.
DS6-051 · Performance · Foundational · understand
Why does Chapter 6 say an unavailable database has a performance measure of zero? - A. Because availability is the only performance metric. - B. Because query optimization is irrelevant when a database is available. - C. Because database performance depends on two interdependent facets: availability and speed. - D. Because SLA targets apply only to outages.
DS6-052 · Performance · Difficult · apply
Queries slow down after large insert/delete activity, and the query optimizer is choosing poor plans. Which cause should be investigated first? - A. Federation coupling. - B. Retention period. - C. Schema ownership. - D. Inaccurate or stale database statistics caused by database volatility.
DS6-053 · Test Data · Standard · best-action
A test team wants to copy Production customer data containing protected fields into Test. What is the best Chapter 6 response? - A. Use appropriate sample/generated data and mask protected Production-derived data when restrictions require it. - B. Always copy Production data unchanged because Test is non-production. - C. Let testers write directly to Production instead. - D. Purge Production data after copying it.
DS6-054 · Migration · Standard · understand
Which statement best defines data migration in Chapter 6? - A. Combining business meaning across systems into a new semantic model. - B. Transferring data between storage types, formats, or computer systems with as little change as possible. - C. Keeping identical data on multiple devices at the same time. - D. Removing obsolete data irreversibly.
DS6-055 · Tools & Implementation · Difficult · apply
A team is preparing a DBMS upgrade. Which sequence best reflects Chapter 6's implementation guidance? - A. Install directly in Production to discover real issues quickly. - B. Skip readiness if the vendor supports the product. - C. Assess data-loss and technology-readiness risks, test the upgrade in lower environments first, use controlled scripts/processes, and promote to Production last. - D. Avoid scripts because one-off direct changes are faster.
DS6-056 · Governance · Expert-discrimination · apply
A manager wants two measures: average issue resolution time and whether stored research data met contractual storage requirements. Which pairing is correct? - A. Issue resolution time is a Storage metric; contractual compliance is Data validation. - B. Issue resolution time is an Operational metric; contractual compliance is a Performance metric. - C. Both are Data Quality metrics. - D. Issue resolution time is a Service metric; the contractual-compliance review is a Data audit.