1Z0-485 · Question #12
In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?
The correct answer is B. Execute alter table ... cell_flash_cache=keep on heavily scanned tables. 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…
Question
In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?
Options
- AEnable Smart Flash Log.
- BExecute alter table ... cell_flash_cache=keep on heavily scanned tables.
- CEnable Write Back Flash Cache.
- DCreate an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.
How the community answered
(60 responses)- A3% (2)
- B72% (43)
- C8% (5)
- D17% (10)
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 Cache software automatically caches objects read, in large table scans, in the flash cache based on how frequently the objects are read. Previously, the default behavior was to bypass the flash cache for such large sequential scans.
Topics
Community Discussion
No community discussion yet for this question.