A database administrator is managing a schema for a customer relationship management (CRM) application. The team uses a version control system for all schema changes. A developer has just submitted a change that adds a new column to the 'customers' table. What is the best practice for the DBA to follow to ensure the change is tracked and can be applied consistently?

Manually update the database in each environment without recording the change.

Apply the change directly to the production database and then document it in a wiki.

Validate the schema against the design document and then apply the change only to production.

Create a new migration script for the change, commit it to version control, and apply it to the development environment.

Which metric is most important to monitor during a database stress test?

Color of the database server's status LED

Response time under increasing load

A DBA is managing a database where the schema is version-controlled. A developer has made a change to a table and wants to deploy it to the test environment. The DBA needs to ensure the change is applied correctly and the application can still connect. What is the best process?

Apply the migration script from version control to the test database, then test the application's connectivity.

Apply the change directly to the test database and then update the version control system.

Run a stress test on the test database to ensure it can handle the load.

Validate the schema against the design document and then apply the change.

CompTIADataSys+

Domain 2Objective 2

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

Part of the Database deployment domain, which accounts for 16% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~6–10 in this domain), expect 2–3 from this objective — we provide 26 practice questions to prepare you well beyond it. (estimate)

26questions here

6free pages

4concepts

16%of the exam

Questions 16–20

16application · medium
A database administrator is managing a schema for a customer relationship management (CRM) application. The team uses a version control system for all schema changes. A developer has just submitted a change that adds a new column to the 'customers' table. What is the best practice for the DBA to follow to ensure the change is tracked and can be applied consistently?
Select an answer first
17foundation · easy
Which metric is most important to monitor during a database stress test?
Select an answer first
18application · medium
A DBA is managing a database where the schema is version-controlled. A developer has made a change to a table and wants to deploy it to the test environment. The DBA needs to ensure the change is applied correctly and the application can still connect. What is the best process?
Select an answer first
19foundation · easy
A developer reports that an application cannot connect to the database. Which test should be performed first to isolate the issue?
Select an answer first
20foundation · easy
A database administrator wants to evaluate how a database performs when the number of concurrent users exceeds the expected maximum. Which type of testing is most appropriate?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DS0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DS0-001” is a trademark of its owner, used for identification only.

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

Questions 16–20

Which metric is most important to monitor during a database stress test?

A DBA is managing a database where the schema is version-controlled. A developer has made a change to a table and wants to deploy it to the test environment. The DBA needs to ensure the change is applied correctly and the application can still connect. What is the best process?

A developer reports that an application cannot connect to the database. Which test should be performed first to isolate the issue?

A database administrator wants to evaluate how a database performs when the number of concurrent users exceeds the expected maximum. Which type of testing is most appropriate?

Keep studying — Database deployment