Oracle
1Z0-054 · Question #51
1Z0-054 Question #51: Real Exam Question with Answer & Explanation
The correct answer is A. Preprocess the captured workload for the specified target database version. D. Resolve all external references such as database links, external tables, and directory objects. E. Restore the replay database to match the capture database at the start of the workload capture.. See the full explanation below for the reasoning.
Question
You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP) system.The applications running on the database use connection pooling to connect to the database to perform transactions. The company wants to upgrade the CPU and the memory for the machine on which the database is running. To test the realistic workload on the new machine with increased CPU and memory, you identified the peak workload time for the database and captured the workload on the production system. You set up the test machine with the upgraded CPU and memory and installed the database with the same version as production. Which three actions would you perform to accomplish the realistic replay of the peak workload on the test machine? (Choose three.)
Options
- APreprocess the captured workload for the specified target database version.
- BSet up as many replay clients as there are actual clients to the production system.
- CSet up all the replay clients on the same machine on which the test database is running.
- DResolve all external references such as database links, external tables, and directory objects.
- ERestore the replay database to match the capture database at the start of the workload capture.
Community Discussion
No community discussion yet for this question.