In looking to improve query performance for your Data Warehouse, select the best way that Exadata’s Flash Cache feature can be leveraged?

In looking to improve query performance for your Data Warehouse, select the best way that
Exadata’s Flash Cache feature can be leveraged?

A.
Enable Smart Flash Log.

B.
Execute alter table … cell_flash_cache=keep on heavily scanned tables.

C.
Enable Write Back Flash Cache.

D.
Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.

Explanation:
In earlier releases, database administrators had to mark an object as KEEP to have
it cached in flash cache for large scan workloads. This feature primarily benefits table scan
intensive workloads such as Data Warehouses and Data Marts. Random I/Os such as those
performed for Online Transactional Processing (OLTP)continue to be cached in the flash cache
the same way as in earlier releases.
Note: With the Exadata Storage Server Software 11.2.3.3.0 and above, the Exadata Smart Flash
Cachesoftware automatically caches objects read, in large table scans, in the flash cache based
on howfrequently the objects are read. Previously, the default behavior was to bypass the flash
cache forsuch large sequential scans.