DS0-001 · Question #6
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 correct answer is A. Capture business logic, check the performance of codes, and report findings. Entity Framework is an Object-Relational Mapper (ORM) that generates SQL from application code. During a stress test, the DBA's role is to capture how the application's business logic translates into database workload - checking query execution times, resource consumption (CPU…
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?
Options
- ACapture business logic, check the performance of codes, and report findings.
- BCheck the clustered and non-clustered indexes, and report findings.
- CReview application tables and columns, and report findings.
- DWrite queries directly into the database and report findings.
How the community answered
(39 responses)- A92% (36)
- C3% (1)
- D5% (2)
Explanation
Entity Framework is an Object-Relational Mapper (ORM) that generates SQL from application code. During a stress test, the DBA's role is to capture how the application's business logic translates into database workload - checking query execution times, resource consumption (CPU, memory, I/O), locking behavior, and throughput - and report findings back to the developers. This is choice A. Checking indexes (B) or reviewing tables and columns (C) are separate tuning activities, not the core purpose of a stress test. Writing queries directly into the database (D) bypasses the ORM entirely, which would not reflect how the application actually interacts with the database under load.
Topics
Community Discussion
No community discussion yet for this question.