You have been asked to use table compression for two large tables. Given are the details of
the tables: TheTRANS_DETtable:
✑ The table is used byanOLTP application.
✑ High volume insert and update operations are performed on the table.
✑ The table is frequently queried using index range scans.
TheTRANS_HISTORYtable:
✑ The table is used by a DSS application.
✑ High volume bulk loads are performed on the table.
✑ The table is used to store archival data on which large table full-table scans (FTS) are
performed. Which row store compression would you recommend for these tables with
minimal overhead on performance?(Choose the best answer.)
A.
basic table compression for both the tables
B.
advanced row compression for both the tables
C.
basic table compression for theTRANS_HISTORYtable and advanced row compression
for theTRANS_DETtable
D.
basic table compression for theTRANS_DETtable and advanced row compression for
theTRANS_HISTORYtable
E.
warehouse compression for theTRANS_DETtable and archive compression for
theTRANS_HISTORYtable
I think B
B
should’t be C? basic is for DSS and advanced row for OLTP ?
I think Micch is right. Answer is C.
Basic compression designed for DSS and DW and works only on bulk loads.
Advanced compression works with DML and is designed for OLTP systems.
B – wrong,
I choose B on my exam, and scorereport showed it was wrong.
C – Basic Compression which only compressed data that was loaded using bulk load operations. Advanced Row Compression, a feature of Advanced Compression, allows data to be compressed during all types of data manipulation operations, including conventional DML such as INSERT and UPDATE. In addition, Advanced Row Compression reduces the associated compression overhead of write operations making it suitable for transactional/OLTP environments.
Logically must be C!
Basic Compression => Read only tables and partitions in Data Warehouseenvironments or “inactive” data partitions in OLTP environments
Advanced Row Compression => Active tables and partitions in OLTP and Data Warehouse environments
Advanced LOB Compression and Deduplication => Non-relational data in OLTP and Data Warehouse environments
Advanced Network Compression and Data Guard Redo Transport Compression => All environments
RMAN/Data Pump Backup Compression => All environments
Index Compression Indexes on tables for OLTP and Data Warehouse
Hybrid Columnar Compression – Query Level => Query mostly tables and partitions in OLTP and Data Warehouse environments
Hybrid Columnar Compression – Archive Level => “Inactive” data tables/partitions in OLTP and Data Warehouse environments
B would be OK in real like because “who can the most can the less”
I think they want us to demonstrate the use case of basic and advanced, even if advanced can work for both
So C is my choice
C