Implementation and Testing DS0-001 Practice Questions (Page 6)

Questions 26–26

1. 26application · medium

   A development team has been working on a new e-commerce database schema. They have been making changes directly to the development instance. Before promoting the schema to the staging environment, the DBA needs to confirm that the schema in development matches the approved design document, which specifies table names, column data types, and constraints. Which approach should the DBA use to validate the schema?

   • AReview the version control commit history to see who made the last change.
   • BCompare the schema in development against the design document using a schema comparison tool.
   • CRun a stress test on the development database to verify it can handle the expected load.
   • DCheck the database error logs for any schema-related warnings.
   Reveal Solution Discussion Select an answer first