After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in
the SPA output. Identify the two actions that you would suggest for these regressed SQL
statements. (Choose two.)
A.
Running SQL Access Advisor
B.
Adding them to SQL Plan Baseline
C.
Submitting them to SQL Tuning Advisor
D.
Running Automatic Database Diagnostic Monitor (ADDM)
Fixing Regressed SQL Statements:
If the performance analysis performed by SQL Performance Analyzer reveals regressed SQL statements, then you can make changes to remedy the problem. For example, you can fix regressed SQL by running SQL Tuning Advisor or using SQL plan baselines. You can then repeat the process of executing the SQL statements and comparing its performance to the first execution. Repeat these steps until you are satisfied with the outcome of the analysis.
A is wrong. SQL access advisor is about adding indexes
B is right. SQL Plan Baseline is a way
C is right.
D is wrong.
So B.C. are correct.
I`ve taken exam this day and pass.
All question from this dump were im exam, answers also match.