Which of the following explains the approach the administrator should use when conducting the stress test?

A database administrator is conducting a stress test and providing feedback to a team that is developing an application that uses the Entity Framework.

Which of the following explains the approach the administrator should use when conducting the stress test?
A . Capture business logic, check the performance of codes, and report findings.
B . Check the clustered and non-clustered indexes, and report findings.
C . Review application tables and columns, and report findings.
D . Write queries directly into the database and report findings.

View Answer

Answer: A

Explanation:

The approach that the administrator should use when conducting the stress test is to capture business logic, check the performance of codes, and report findings. This will help the administrator to evaluate how well the application handles high volumes of data and transactions, identify any bottlenecks or errors in the code, and provide feedback to the development team on how to improve the application’s efficiency and reliability. The other options are either too narrow or too broad in scope, and do not address the specific needs of an application that uses the Entity Framework.

Reference: CompTIA DataSys+ Course Outline, Domain 4.0 Data and Database Security, Objective 4.3 Given a scenario, monitor database performance and security.