Which two are true concerning Columnar Flash Caching?
A.
It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.
B.
It automatically transforms ROW STORE COMPRESS compressed data into a pure columnar format
during Exadata Smart Flash Cache population.
C.
Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in
both formats at the same time.
D.
It is enabled by default.
E.
It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during
Exadata Smart Flash Cache population.
F.
It improves single-row lookup performance.
Explanation:
D: In-Memory Columnar Caching on cells is enabled by default when the INMEMORY_SIZE is configured. You do not need to do anything to get this enhancement.
E: Columnar Flash Caching implements a dual format architecture in Exadata flash by automatically transforming frequently scanned Hybrid Columnar Compressed data into a pure columnar format as it is loaded into the flash cache.
Incorrect Answers:
F: Columnar Flash Caching accelerates reporting and analytic queries while maintaining excellent performance for OLTP style single row lookups.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-monitoring.htm#SAGUG20883
http://www.oracle.com/technetwork/database/exadata/exadata-x5-8-ds-2745934.pdf