Exam 1z0-064 topic 1 question 9 discussion

Actual exam question from Oracle's 1z0-064

Question #: 9
Topic #: 1

You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already created a test system with Oracle Database 12c, having the same structure and data as the production database, along with new schema objects to be added to the production database.
You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version.
Which two methods would you use to achieve this? (Choose two.)

A. Create an SQL Tuning Set (STS) for the SQL statements on the production database and submit as input to the SQL Tuning Advisor on the test database.
B. Create an STS for the SQL statements on the production database and submit as input to the SQL Performance Analyzer with the parameter first set to 11.2.0.1, and then to 12.1.0.1 on the test database. OPTIMIZER_FEATURES_ENABLE
C. Generate an Automatic Workload Repository (AWR) compare periods report with snapshots taken before and after schema changes on the test database.
D. Capture the production database workload, replay it on the test system by using Database Replay, and analyze by using the workload replay compare period report.
E. Create an STS for the SQL statements on the production database and submit as input to the SQL Access Advisor on the test database.
F. Create an STS for the SQL statements on the production database before and after changes and submit as input to the SQL Performance Analyzer on the test

Show Suggested Answer

Suggested Answer: AD 🗳️

by adz07 at Jan. 25, 2024, 10:28 a.m.

Comments

Submit Cancel

adz07

1 year ago

i think, BD SQL Performance Analyzer and Database Replay is best for this scenario. Although F doesn't seem to make sense, since it mentioned to create STS before and After the Change. This should be done in test before doing any change in prod to prevent any degradation in the performance.

upvoted 1 times

...

Exam 1z0-064 All Questions

View all questions & answers for the 1z0-064 exam

Exam 1z0-064 topic 1 question 9 discussion

Comments

adz07

SY0-701