Identify two database options that would help in enabling such a strategy.

One goal of your Information Lifecycle Management strategy using Oracle’s ILM capabilities is to
reduce cost or online storage. Identify two database options that would help in enabling such a
strategy.

A.
RAC and Advanced Compression

B.
RAC and Partitioning

C.
Partitioning and Advanced Compression

D.
RAC One and Advanced Compression

Explanation:
Advanced compression:
Advanced Compression, an option introduced in Oracle Database 11 g Enterprise Edition, offers a
comprehensive set of compression capabilities to help organizations reduce costs, while
maintaining or improving performance. It significantly reduces the storage footprint of databases
through compression of structured data (numbers, characters) as well as unstructured data
(documents, spreadsheets, XML and other files). It provides enhanced compression for database

backups and also includes network compression capabilities for faster synchronization of standby
databases.
Archival Compression:
* Built on HCC technology
* Compression algorithm optimized for maximum storage savings
* Benefits any application with data retention requirements
* Best approach for ILM and data archival
Partitioning:
There are a number of benefits to partitioning data. Partitioning provides an easy way to distribute
the data across appropriate storage devices depending on its usage, while still keeping the data
online and stored on the most cost-effective device. Since partitioning is completely transparent to
anyone accessing the data, no application changes are required, thus partitioning can be
implemented at any time.
Note There is a wide variety of information held in an organization today, for example it
could be an email message, a picture, or an order in an Online Transaction
Processing System. Therefore, once the type of data being retained has been
identified, you already have an understanding of what its evolution and final destiny
is likely to be.
The challenge now before all organizations, is to understand how their data evolves
and grows, monitor how its usage changes over time, and decide how long it should
survive. In addition, the evolving rules and regulations such as Sarbanes-Oxley,
place additional constraints on the data that is being retained and some
organizations now require that data is deleted when there is no longer a legal
requirement to keep it, to avoid expensive e-discovery when the data is requested
for a legal matter.
Implementing ILM using Oracle Database 11g Page 4 Information Lifecycle Management (ILM) is
designed to address these issues, with
a combination of processes, policies, software and hardware so that the appropriate
technology can be used for each phase of the lifecycle of the data.1
Reference: Oracle Database VLDB and Partitioning Guide, 11g Release 1 (11.1), 5 Using
Partitioning for Information Lifecycle Management