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?

The correct answer is A. Load compressed files with Direct Path loading. 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

Storage Server Software

Question

Options

ALoad compressed files with Direct Path loading
BSort incoming data on a column with a low cardinality
CUse DBFS and external flies to load the data
DUse Data Pump to load data

How the community answered

(39 responses)

A
77% (30)
B
13% (5)
C
8% (3)
D
3% (1)

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 SQLLDR

Topics

#Hybrid Columnar Compression#Direct Path load#compression best practices#data loading

Community Discussion

No community discussion yet for this question.

Full 1Z0-536 Practice