nerdexam
Citrix

1Y0-401 · Question #145

How should the architect implement database high availability in an Oracle database?

The correct answer is C. By using Oracle FailSafe. To implement high availability for an Oracle database, an architect should use Oracle FailSafe, which provides clustering capabilities specifically for Windows environments.

Design Operational Management and Security

Question

How should the architect implement database high availability in an Oracle database?

Options

  • ABy using Oracle RAC
  • BBy using Oracle DataGuard
  • CBy using Oracle FailSafe
  • DBy using Oracle Automatic Storage Management

How the community answered

(23 responses)
  • A
    13% (3)
  • B
    4% (1)
  • C
    78% (18)
  • D
    4% (1)

Why each option

To implement high availability for an Oracle database, an architect should use Oracle FailSafe, which provides clustering capabilities specifically for Windows environments.

ABy using Oracle RAC

Oracle Real Application Clusters (RAC) provides active-active high availability and scalability across multiple database instances accessing shared storage, which is a different architectural approach than FailSafe's active-passive clustering.

BBy using Oracle DataGuard

Oracle Data Guard focuses on disaster recovery and maintaining one or more standby databases for failover, typically to a geographically separate location, rather than local active-passive clustering for immediate high availability within a local cluster.

CBy using Oracle FailSafeCorrect

Oracle FailSafe is a high-availability solution that integrates with Microsoft Cluster Service (MSCS) to protect Oracle databases, applications, and other services on a Windows platform. It enables automatic failover of an Oracle database instance to another node in a cluster, ensuring continuous operation.

DBy using Oracle Automatic Storage Management

Oracle Automatic Storage Management (ASM) is a storage management solution for Oracle database files that improves performance and reliability of storage but does not provide database instance or application-level high availability on its own.

Concept tested: Oracle Database High Availability solutions

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/racfa/overview-of-oracle-failsafe.html

Topics

#database high availability#Oracle FailSafe

Community Discussion

No community discussion yet for this question.

Full 1Y0-401 Practice