When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?
Correct Answer:
C
As soon as the Hard Disk failure is noticed by the MS (Management Server) background process on the Cell, it will raise an alert that will also be published to Grid Control, if configured. Immediately, due to Pro-Active Disk Quarantine, the ASM-, Grid- and Celldisks get dropped. ASM rebalancing is triggered. You as the responsible Admin notice the alert and order a replacement Disk resp. use a Spare Disk to plug it into the Cell after you plugged out the damaged one. The Cell can stay online, because the Hard Disks are hot-pluggable.
No further administrative work to be done, typically.
Which is a best practice for High Availability (HA) in an Exadata environment?
Correct Answer:
C
Exadata storage cells include Oracle Hardware Assisted Resilient Data (HARD) to provide a
unique level of validation for Oracle block data structures such as data block address, checksum.
and magic numbers prior to allowing a write to physical disks. HARD validation with Exadata is
automatic (setting DB_BLOCK_CHECKSUM is required to enable checksum validation). The
HARD checks transparently handle all cases including Oracle ASM disk rebalance operations and disk failures.
Incorrect:
Not A: The checksum is used to validate that a block is not physically corrupt, detecting corruptions caused by underlying disks, storage systems, or I/O systems. Checksums do not ensure logical consistency of the block contents.
Not B: MAA recommends that you set DB_BLOCK_CHECKING=MEDIUM or FULL on the physical standby as a minimum practice to prevent the standby from various logical block corruptions.
Not D: The recommendation is:
On the primary database: DB_LOST_WRITE_PROTECT=TYPICAL (default TYPICAL on Exadata) On the Data Guard Physical Standby Database: DB_LOST_WRITE_PROTECT=TYPICAL Not E: Protection from a broad range of, but not all disasters
While not a full disaster recovery (DR) solution, an Extended Distance
Oracle RAC or Oracle RAC One Node deployment will provide protection from a broad range of
disasters. For a full DR protection Oracle recommends deploying an Oracle RAC together with a local and a remote Oracle Data Guard setup as described in the Maximum Availability Architecture (MAA).
When should you use Hybrid Columnar Compression?
Correct Answer:
C
It is recommended that HCC be enabled on tables or partitions with no or infrequent DML operations
Exadata Database Machine offers an Intelligent Platform Management Interface for the various components in the Exadata product. Which option is true?
Correct Answer:
A
IPMI – short for Intelligent Platform Management Interface - is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It’s not an Exadata command but rather a general Linux one.
To power on a cell or database server, issue this from another server:
# ipmitool -H prolcel01-ilom -U root chassis power on
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:# shutdown -h -y now
Which Exadata feature uses Flash as a parallel write cache to Disk Controller Cache?
Correct Answer:
D
Smart Flash Logging takes advantage of the flash memory in Exadata storage to speed up log writes.
