nerdexam
Oracle

1Z0-060 · Question #2

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage…

The correct answer is A. ASM disk groups with ASM disks consisting of Exadata Grid Disks. E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays. HCC requires the use of Oracle Storage Exadata(A), Pillar Axiom(G)or Sun ZFS Storage Appliance (ZFSSA). Hybrid Columnar Compression, initially only available on Exadata, has been extended to supportPillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle…

New Features for Storage

Question

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?

Options

  • AASM disk groups with ASM disks consisting of Exadata Grid Disks.
  • BASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
  • CASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
  • DDatabase files stored in ZFS and accessed using conventional NFS mounts.
  • EDatabase files stored in ZFS and accessed using the Oracle Direct NFS feature
  • FDatabase files stored in any file system and accessed using the Oracle Direct NFS feature
  • GASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

How the community answered

(28 responses)
  • A
    82% (23)
  • C
    4% (1)
  • D
    4% (1)
  • F
    11% (3)

Explanation

HCC requires the use of Oracle Storage Exadata(A), Pillar Axiom(G)or Sun ZFS Storage Appliance (ZFSSA). *Hybrid Columnar Compression, initially only available on Exadata, has been extended to supportPillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above *Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, betterperformance than traditional NFS clients, and offers consistent configuration across platforms.

Topics

#Hybrid Columnar Compression#In-Database Archiving#ASM disk groups#HCC storage options

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice