nerdexam
Oracle

1Z0-050 · Question #94

Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production…

The correct answer is C. 1, 4, 5, 3 (2 is not required.). See the full explanation below for the reasoning.

Question

Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the test machine. Note the following steps that you may require to replay the database workload: 1) Preprocess the captured workload. 2) Restart the database in RESTRICTED mode. 3) Set up the Replay Clients. 4) Restore the test database to the point when the capture started. 5) Remap connections. Arrange the steps required in the correct sequence to accomplish this task on the test machine.

Options

  • A2, 1, 5, 3, 4
  • B1, 2, 4, 5, 3
  • C1, 4, 5, 3 (2 is not required.)
  • D1, 2, 4, 5 (3 is not required.)
  • E1, 4, 3, 5 (2 is not required.)

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    81% (21)
  • D
    12% (3)

Community Discussion

8
Anjali D.Anjali D.Jan 14, 2026

The correct answer is C, the sequence being preprocess the workload first, restore the test database to the capture start point, remap connections for the RAC environment, then set up the Replay Clients. Restarting in RESTRICTED mode is not actually required for workload replay, and the Replay Clients come last because they cannot be configured until the database is restored and connections are remapped. Does anyone in the group remember seeing RESTRICTED mode come up in the official Oracle docs for this workflow, or did we all land on the same conclusion that it just does not belong here?

8
Carlos M.Carlos M.Jan 15, 2026

Restricted mode is called out in older 11g replay guides as an optional step for ensuring no stray sessions interfere, so it is not total noise, but you are right that it is not a required sequence step and does not belong in the ordered list.

0
Dervla O.Dervla O.Jan 8, 2026

The stem is testing whether you know that RESTRICTED mode is not part of the Database Replay workflow, and B is the trap that catches people who hear "replay on a controlled test system" and assume you lock the database down first. Read it twice and you will notice the stem never introduces any scenario that would call for restricted mode, so any option containing step 2 is already suspect. Preprocessing the capture files has to come first because the replay engine cannot read raw capture data, full stop, and after that you restore to the capture start point so you have a clean baseline, then remap connections to fit the test environment, then stand up your replay clients and go. C is the answer, and the parenthetical in C is doing real work here, it is not just a footnote, it is the whole point of the question. If you are torn between B and C on test day, ask yourself whether the question gave you any reason to restrict access to the database, and if the answer is no, eliminate every option that includes step 2.

2
Carlos M.Carlos M.Dec 22, 2025

Has to be A, restart restricted before remapping anything makes total sense.

0
Dervla O.Dervla O.Dec 24, 2025

The restart restriction applies only to the specific subsystem being reconfigured, not to the entire process, which is why C holds up under the stem's exact wording. A is a common pull because it sounds procedurally safe, but the question is testing sequence logic, not general caution.

0
Brenda K.Brenda K.Dec 27, 2025

Two is first because you cannot preprocess without a running database, fight me.

0
Anjali D.Anjali D.Dec 28, 2025

Brenda, I hear you, but the group landed on C because that step can actually be completed before the database instance is active, so the dependency you're describing runs in the other direction. Happy to walk through the sequence again if it helps clarify where option 2 fits later in the order.

0
Mei-Ling H.Mei-Ling H.Jan 22, 2026

The correct sequence is C: preprocess first, restore the database to the capture point, remap connections, then set up the Replay Clients, and step 2 (RESTRICTED mode restart) is NOT required for workload replay. A lot of people get tripped up by step 2 because some Oracle maintenance tasks do require RESTRICTED mode, so it looks familiar and "safe" to include, but the Database Replay process does not mandate it. The word "required" in the question is the qualifier to watch here, since technically you could put the database in RESTRICTED mode, but the documented replay procedure does not list it as a required step. Also notice option B tries to sneak in that RESTRICTED restart between preprocess and restore, which breaks the logical order anyway because you obviously need to restore to the capture SCN before you can remap connections or start clients.

0
Full 1Z0-050 Practice