1Z0-054 practice - PrepKeys

Q1 Multiple choice

Which three statements are true about performance analysis by SQL Performance Analyzer? (Choose three.)

Select all that apply.

A
It detects changes in SQL execution plans.
B
It shows only the overall impact on workload.
C
It produces results that can be used to create the SQL plan baseline.
D
It generates recommendations to run SQL Tuning Advisor to tune regressed SQL statements.
E
The importance of SQL statements to be analyzed is based on the size of the objects accessed.