1Z0-064 · Question #83
You have been asked to use table compression for two large tables. Given are the details of the tables: The TRANS_DET table: The table is used by an OLTP application. High volume insert and update…
The correct answer is A. basic table compression for both the tables. See the full explanation below for the reasoning.
Question
You have been asked to use table compression for two large tables. Given are the details of the tables:
The TRANS_DET table:
The table is used by an OLTP application. High volume insert and update operations are performed on the table. The table is frequently queried using index range scans. The TRANS_HISTORY table:
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.)
Options
- Abasic table compression for both the tables
- Badvanced row compression for both the tables
- Cbasic table compression for the TRANS_HISTORY table and advanced row compression for the
- Dbasic table compression for the TRANS_DET table and advanced row compression for the
- Ewarehouse compression for the TRANS_DET table and archive compression for the
How the community answered
(25 responses)- A84% (21)
- C8% (2)
- D4% (1)
- E4% (1)
Community Discussion
No community discussion yet for this question.