Question
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. Correct
- 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.
Explanation
With Entity Framework the application generates its SQL from code, so a stress test should exercise the real business logic under load, capture the queries the code produces, measure their performance and report the findings back to the developers. Reviewing indexes or tables alone is a static review rather than a stress test, and writing queries directly into the database bypasses the ORM-generated code that is actually under test.
