Skip to content

Rapid Recall 24–45

  1. Archive vs purge vs retention?
  2. CDC vs replication?
  3. Active vs passive replication?
  4. Mirroring vs log shipping?
  5. Resiliency vs recovery?
  6. Immediate vs critical vs non-critical recovery?
  7. Name five usage-pattern types.
  8. What must capacity estimates include besides table data?
  9. Why test recovery?
  10. Four SCM procedures?
  11. Physical vs functional configuration audit?
  12. Performance = what two facets?
  13. Name five common performance causes.
  14. Transaction vs batch performance?
  15. What rule applies before denormalizing an OLTP database?
  16. How should protected Production data be handled in testing?
  17. Define data migration.
  18. Name four tool categories.
  19. Three techniques?
  20. Two readiness-risk themes?
  21. Four metric families?
  22. Data audit vs data validation?

Minimum self-check targets

  • retention = duration; archive = retrievable relocation; purge = irreversible removal;
  • CDC = deltas; replication = copies; sharding = chunks;
  • passive replication = primary → secondaries; mirroring = near-current; log shipping = periodic logs;
  • resiliency = continue; recovery = restore;
  • capacity includes data + indexes + logs + redundant images + growth;
  • recovery tests prove backups/procedures are usable;
  • SCM = identification · change control · status accounting · audits;
  • physical audit = installed as designed; functional audit = required attributes achieved;
  • performance = availability + speed;
  • diagnose memory, locks/deadlocks, statistics, SQL/joins, indexes, server load/capacity, volatility, runaway workload before structural redesign;
  • protected Production-derived test data may require sampling/masking/protection;
  • migration = transfer between storage/type/format/system with as little change as possible;
  • tools = modeling, monitoring, management, developer support;
  • techniques = lower environments first, physical naming standards, script changes;
  • readiness themes = data-loss risk + technology/skills readiness;
  • metrics = Storage / Performance / Operational / Service;
  • audit = compliance/method criteria; validation = quality/usability acceptance.

← Rapid Recall 1–23 · Blank-Page →