Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?
A.
SQL Access Advisor recommendations are automatically implemented.
B.
Individual SQL Access Advisor recommendations can be scheduled for implementation.
C.
All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D.
SQL Access Advisor recommendations are automatically scheduled for implementation during the
maintenance window.
E.
None of the above.
Explanation:
Implementing the SQL Access Advisor Recommendations (link)
A SQL Access Advisor recommendation can range from a simple suggestion to a complex solution that
requires partitioning a set of existing base tables and implementing a set of database objects such as indexes,
materialized views, and materialized view logs. You can select the recommendations for implementation and
schedule when the job should be executed.