1Z0-485 · Question #82
You are using Hybrid Columnar Compression for a table stored in a tablespace that is contained in an Exadata-based ASM diskgroup. Identify three statements that correctly explain where the…
The correct answer is A. Decompression can be done on the database servers. B. Compression can be done on the Exadata storage servers. D. Decompression can be done on the Exadata storage servers. Exadata storage provides an advanced compression technology, Hybrid Columnar Compression, that typically provides 10x, and higher, levels of data compression. The Exadata Storage Server (Exadata storage or Exadata cells) is used as the storage for the Oracle Database in the…
Question
You are using Hybrid Columnar Compression for a table stored in a tablespace that is contained in an Exadata-based ASM diskgroup. Identify three statements that correctly explain where the compression and decompression can be done.
Options
- ADecompression can be done on the database servers.
- BCompression can be done on the Exadata storage servers.
- CCompression can be done on the database servers.
- DDecompression can be done on the Exadata storage servers.
How the community answered
(32 responses)- A81% (26)
- C19% (6)
Explanation
- Exadata storage provides an advanced compression technology, Hybrid Columnar Compression, that typically provides 10x, and higher, levels of data compression. * The Exadata Storage Server (Exadata storage or Exadata cells) is used as the storage for the Oracle Database in the Database Machine. It runs the Exadata Storage Server Software that provides the unique and powerful Exadata technology including Smart Scan, Smart Flash Cache, Smart Flash Logging, IO Resource Manager, Storage Indexes and Hybrid Columnar / Queries run directly on Hybrid Columnar Compressed data does not require the data to be / Data that is required to satisfy a query predicate does not need to be decompressed; only the columns and rows being returned to the client are decompressed in memory / The decompression process typically takes place on the Oracle Exadata Storage Server in order to maximize performance and offload processing from the database server. Exam Questions, Study Guides, Practice Tests. Lead the way to help you pass any IT Certification exams, 100% Pass Guaranteed or Full Refund. Especially Cisco, Microsoft, CompTIA, Citrix, EMC, HP, Oracle, VMware, Juniper, Check Point, LPI, Nortel, EXIN and so on. Our Slogan: First Test, First Pass. Help you to pass any IT Certification exams at the first try. You can reach us at any of the email addresses listed below. Any problems about IT certification or our products, you could rely upon us, we will give you satisfactory answers in 24 hours.
Topics
Community Discussion
No community discussion yet for this question.