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

Questions 1–5

1. 1expert · hard

   A DBA is managing a database where multiple developers are making schema changes. The DBA has noticed that the development database has drifted from the version control baseline. Some changes were made directly to the database and not committed. What is the best course of action to resolve this?

   • AUse a schema comparison tool to identify the drift, then create migration scripts for the uncommitted changes and commit them to version control.
   • BRun a stress test on the development database to see if the drift causes performance issues.
   • CIgnore the drift and continue development, as the version control baseline is not important.
   • DRevert the development database to the version control baseline, discarding all uncommitted changes.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A database administrator is responsible for managing the schema for a large application. The team has a policy that all schema changes must be reviewed and tested before being applied to production. The DBA has just created a new index on a large table to improve query performance. What is the next step in the change management process?

   • AApply the index directly to the production database to resolve the performance issue immediately.
   • BCommit the change script to version control and run a stress test in a test environment to ensure the index improves performance without causing issues.
   • CDocument the change in a shared document but do not test it.
   • DValidate the schema against the design document to ensure the index is allowed.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   A database administrator is reviewing a newly designed schema before deployment. Which activity best describes validating that the schema meets the documented design specifications?

   • AReviewing the database server's error logs for any failed login attempts
   • BRunning a query to measure the time it takes to return a sample of rows from the largest table
   • CBacking up the database to a secure location before making any changes
   • DComparing the schema's tables, columns, data types, and constraints against the approved design document
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is the primary purpose of using version control for database schemas?

   • ATo encrypt sensitive data in the database
   • BTo back up the entire database daily
   • CTo automatically optimize query performance
   • DTo track changes to schema objects and enable rollback to previous versions
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A DBA is setting up a new application server that needs to connect to an existing database. The DBA has configured the connection string with the correct hostname, port, and credentials. What is the next step to ensure the application can communicate with the database?

   • AValidate the database schema against the application's requirements.
   • BTest the connectivity from the application server to the database using a tool like telnet or a database client.
   • CCommit the connection string to version control.
   • DRun a stress test on the database to ensure it can handle the new application's load.
   Reveal Solution Discussion Select an answer first