Your customer wants to use Hybrid Columnar Compression to get maximum compression on their
data. Which option represents a best practice for achieving this goal?
A.
Load compressed files with Direct Path loading
B.
Sort incoming data on a column with a low cardinality
C.
Use DBFS and external flies to load the data
D.
Use Data Pump to load data
Explanation:
Hybrid Columnar Compressed Tables
• New approach to compressed table storage
• Useful for data that is bulk loaded and queried
• Update activity is light
Data loaded using Direct Load uses Hybrid Columnar
Compression
• Parallel DML, INSERT /*+ APPEND */, Direct Path SQL*LDR
Reference: http://www.oracle.com/technetwork/database/features/availability/311358-132337.pdf