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

Questions 21–25

1. 21application · medium

   A company is deploying a new application that will be used by employees across the globe. The DBA needs to ensure that the database can handle the expected number of concurrent connections from the application. What is the most important test to perform?

   • AA connectivity test from a single client to the database.
   • BA review of the version control system to ensure all changes are tracked.
   • CA stress test that simulates the expected number of concurrent connections and measures the database's performance.
   • DA schema validation to ensure the schema is correct.
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A company has separate development, test, and production environments for its database. The DBA has just updated the connection string in the application configuration for the test environment to point to a new database server. What is the most important thing to do next?

   • AValidate the schema on the new database server.
   • BTest the database connectivity from the application in the test environment to the new database server.
   • CUpdate the version control system with the new connection string.
   • DRun a stress test on the new database server.
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A company is preparing to launch a new online ticketing system. The database team needs to determine if the database can handle the anticipated peak load of 5,000 concurrent users during a popular event sale. They have set up a test environment that mirrors production. What is the most appropriate first step to evaluate this?

   • ATest database connectivity from the application server to the database server.
   • BCheck the version control system for the latest database scripts.
   • CRun a stress test that simulates 5,000 concurrent users performing typical transactions.
   • DReview the database schema for normalization.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A financial services company is deploying a new reporting database. The reporting team has specified that certain queries must return results within 2 seconds, even when the database is under heavy load. The DBA needs to ensure the database meets this requirement before going live. What should the DBA do?

   • AReview the version control history for the schema changes.
   • BPerform a stress test that simulates the expected heavy load and measure the response times of the critical queries.
   • CTest the database connectivity from the reporting application.
   • DValidate the database schema against the reporting requirements.
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   A database is experiencing slow query performance during peak hours. The DBA suspects that a new index is not being used by the query optimizer. The DBA has already validated the schema and confirmed the index exists. What is the most likely reason the index is not being used?

   • AThe index was not committed to version control.
   • BThe database connectivity is not working correctly.
   • CThe query optimizer has decided that using the index is not the most efficient execution plan for the query.
   • DThe schema validation failed.
   Reveal Solution Discussion Select an answer first