1Z0-997-26 Practice Test 2 — 30 Questions

Question 1

When designing an enterprise-grade disaster recovery architecture on OCI, which THREE practices are recommended to ensure a successful failover and minimize operational risk during a disaster event? (Choose three.)

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Automate failover orchestration using tools like OCI Full Stack Disaster Recovery.. Best practices include regularly testing DR plans via drills, automating workflows with FSDR or runbooks, and ensuring identical resource capacity in the DR region.

Answer

Disable all health checks on load balancers to prevent false alarms during failover.

Answer

Rely solely on manual documentation stored on local laptops for failover steps.

Question 2

Which OCI networking component is required to securely connect a VCN in one OCI region to a VCN in another OCI region for cross-region Data Guard database replication?

Accepted Answer

Dynamic Routing Gateway (DRG) with Remote VCN Peering. Remote VCN peering using Dynamic Routing Gateways (DRGs) in both regions connects VCNs across regions.

Answer

Internet Gateway (IGW)

Answer

NAT Gateway

Answer

Local Peering Gateway (LPG)

Question 3

Which OCI service can be used to monitor the health and performance of your load balancers and backend compute instances across multiple availability domains, triggering alarms if health checks fail?

Accepted Answer

OCI Monitoring service with Alarm definitions. OCI Monitoring service collects metrics and logs from resources like Load Balancers and Compute instances, allowing you to create alarms based on metric thresholds.

Answer

OCI DNS Traffic Management

Answer

OCI Audit service

Answer

OCI Vault service

Question 4

Which THREE factors should an architect evaluate when determining Recovery Point Objective (RPO) and Recovery Time Objective (RTO) for an OCI database disaster recovery solution? (Choose three.)

Accepted Answer

Level of automation configured for failover (e.g., Fast-Start Failover vs. manual scripts). RPO and RTO are driven by business tolerance for data loss, network throughput/latency constraints for replication, and the degree of automation (like FSFO or FSDR) applied to failover procedures.

Answer

The color scheme and layout of the OCI Console dashboard

Answer

The default tenant tenancy OCID string length

Question 5

An architect is designing a multi-region disaster recovery architecture for an application running on OCI Compute. The database layer uses Oracle Data Guard. For the application tier, what is the recommended approach to handle stateless application servers in the DR region?

Accepted Answer

Pre-provision compute instances in a stopped state or use instance pools with standby configuration, activating them during a disaster event.. Stateless application servers in the DR region can be pre-provisioned in a stopped state or dynamically provisioned using instance pools and autoscaling, reducing costs while maintaining readiness.

Answer

Run all application servers at full capacity in both regions simultaneously with active write locks.

Answer

Store application binaries solely in Object Storage and compile them on the fly using user-data scripts during failover.

Answer

Rely entirely on manual creation of compute instances via the OCI console after an outage occurs.

Question 6

An enterprise application uses an Oracle Exadata Database Service on Dedicated Infrastructure with Maximum Availability Architecture (MAA). A catastrophic regional disaster occurs, and you must initiate a failover to the standby region. What is the expected behavior of Active Data Guard during this process?

Accepted Answer

The standby database converts to the primary role, opens for read/write operations, and stops applying redo from the old primary.. During a failover, the standby database is transitioned to become the primary role, opening for read/write traffic while breaking the replication relationship with the former primary.

Answer

The standby database automatically initiates a flashback database operation to sync with object storage backups before opening.

Answer

Active Data Guard remains in read-only mode until a manual database restore command is issued.

Answer

The database becomes inaccessible until Full Stack Disaster Recovery automatically reprovisions the storage cells.

Question 7

You are configuring a Data Guard association between two Oracle Base Database Systems in different OCI regions. The primary database encounters an unplanned outage, and you perform a manual failover. What action must you take afterward if you wish to restore the original architecture with the old primary as the new standby?

Accepted Answer

Recreate or reinstate the former primary database (using Flashback Database or backup restoration) to convert it into a valid standby.. After a failover, the old primary database is no longer in sync and cannot act as a standard standby without being reinstated or rebuilt (e.g., using Flashback Database or re-creating the standby).

Answer

Run a simple 'SWITCHOVER' command to reverse roles without any data synchronization checks.

Answer

Modify the listener.ora file manually via SSH and restart the clusterware.

Answer

Delete the standby database and provision a brand-new VCN in the primary region.

Question 8

You are managing an Oracle Base Database Service instance and need to configure Data Guard to provide disaster recovery in another OCI region. Which prerequisite must be met before creating the Data Guard association?

Accepted Answer

Establish network connectivity between the primary and standby VCNs using a DRG and remote VCN peering.. Cross-region Data Guard requires remote VCN peering via a Dynamic Routing Gateway (DRG) or local peering if regional, and proper security list/NSG rules allowing traffic on ports such as 1521.

Answer

Ensure the standby database has a larger shape than the primary database.

Answer

Manually install the Oracle Data Guard binaries on the standby database compute instance prior to association.

Answer

Convert the primary database to an Autonomous Database instance.

Question 9

Your organization has a strict Recovery Point Objective (RPO) of 5 minutes and Recovery Time Objective (RTO) of 15 minutes for a multi-tier application. The database tier uses Oracle Data Guard. During a test drill, you notice that redo transport lag spikes to 8 minutes. What is the most likely architectural bottleneck causing this issue?

Accepted Answer

Inadequate cross-region network bandwidth or high latency causing redo transport congestion.. Redo transport lag exceeding RPO is frequently caused by insufficient network bandwidth or high latency between regions, preventing synchronous or fast asynchronous redo shipping from keeping pace with transaction volume.

Answer

Exceeded OCI Block Volume IOPS limits on the standby database's local NVMe scratchpad.

Answer

Misconfigured OCI IAM policy allowing read-only access to database backups.

Answer

Incorrect OCI Load Balancer SSL certificate configuration on the web tier.

Question 10

An application deployed across two OCI regions uses a DNS-based traffic management steering policy. A database failure occurs in the primary region, and the application must failover to the secondary region. What is the primary limitation of relying solely on DNS Traffic Management for disaster recovery failover?

Accepted Answer

Client-side caching and DNS TTL expiration delays can cause continued traffic routing to the failed region.. DNS failover relies on TTL (Time to Live) values, which can cause clients to continue sending traffic to the failed primary region until the TTL expires, leading to a delay in RTO.

Answer

DNS steering policies cannot route traffic across different geographic regions.

Answer

DNS records are permanently immutable once created in OCI.

Answer

DNS routing requires public IP addresses to be configured on the database backends.

Question 11

An architect is configuring an OCI Full Stack Disaster Recovery plan. The plan includes a step to run a custom script on an application server during a failover drill. Which OCI service executes this custom script?

Accepted Answer

OCI Functions or OCI Compute instance run-command actions orchestrated by Full Stack DR.. OCI Full Stack Disaster Recovery integrates with OCI Functions or custom scripts executed via instance agent / run command to perform pre-checks and custom automation steps.

Answer

Oracle Autonomous Linux Auto-Update Daemon

Answer

OCI Resource Manager Terraform apply jobs exclusively

Answer

OCI Streaming Service consumer groups

Question 12

Which OCI storage service provides massively scalable, highly durable regional object storage that is ideal for storing database backups and disaster recovery artifacts?

Accepted Answer

OCI Object Storage. OCI Object Storage is a regional, highly durable service designed for unstructured data storage, frequently used for backups and DR.

Answer

OCI Block Volume

Answer

Local NVMe Scratch Disks

Answer

OCI Boot Volumes

Question 13

Which THREE strategies are recommended when planning a large-scale database migration (exceeding 100 TB) from on-premises to Exadata Database Service on Dedicated Infrastructure with minimal downtime? (Choose three.)

Accepted Answer

Leveraging Transportable Tablespaces (TTS) combined with RMAN cross-platform conversion. Large-scale database migrations exceeding 100 TB benefit from transportable tablespaces, physical standby creation via RMAN, and Zero Downtime Migration (ZDM).

Answer

Copying database files across the public internet using standard FTP without encryption

Answer

Exporting the entire 100 TB database into a single plaintext SQL script using SQL*Developer

Question 14

When designing high availability across multiple Availability Domains in an OCI region, how should database or application subnets be configured to ensure fault tolerance?

Accepted Answer

Create regional subnets so that instances can be placed across multiple Availability Domains.. Subnets in OCI can be regional or AD-specific. For high availability across ADs, architects should deploy regional subnets or span instances across multiple AD-specific subnets.

Answer

Restrict all subnets to a single Availability Domain to prevent cross-AD latency.

Answer

Disable security lists on subnets to allow uninterrupted cross-AD replication traffic.

Answer

Attach all VNICs directly to the Dynamic Routing Gateway without using subnets.

Question 15

An enterprise application hosted on OCI requires high availability across multiple fault domains within a single availability domain. Which resource placement strategy should you use for your application compute instances?

Accepted Answer

Distribute instances evenly across three different Fault Domains.. Fault domains provide anti-affinity within an availability domain. Distributing instances across different fault domains ensures they do not share physical hardware, power, or top-of-rack switch infrastructure.

Answer

Configure a dedicated virtual cloud network for each fault domain.

Answer

Attach all instances to separate Internet Gateways.

Answer

Place all instances in Fault Domain 1 to optimize network latency.

Question 16

What is the primary purpose of OCI Database Actions (SQL Developer Web) when working with an Oracle Autonomous Database?

Accepted Answer

To provide a web-based development and management interface for executing SQL, querying data, and managing database users. OCI Database Actions provides a web-based interface for running SQL queries, developing PL/SQL, managing users, and loading data into Autonomous Database.

Answer

To configure physical Exadata storage cell disks and flash cache parameters

Answer

To monitor physical VCN packet drops and firewall logs

Answer

To manage OCI IAM user groups and federation settings across enterprise identity providers

Question 17

When planning a migration of Oracle databases to Oracle Autonomous Database (Serverless), which THREE migration methods or tools are natively supported or recommended by Oracle?

Accepted Answer

Oracle SQL Developer migration workbench / Data Loading features.. Autonomous Database Serverless supports specific migration paths including Oracle Zero Downtime Migration, Data Pump, and SQL Developer migration assistants.

Answer

Directly attaching on-premises ASM disk groups via iSCSI to the Autonomous container.

Answer

Direct physical RMAN full database restore to Autonomous storage.

Question 18

Which TWO OCI networking features help achieve high availability for applications accessing external services or on-premises datacenters? (Choose two.)

Accepted Answer

Redundant FastConnect virtual circuits terminating on separate DRG ports or diverse provider locations.. FastConnect redundant circuits and redundant IPSec VPN tunnels provide highly available hybrid connectivity.

Answer

Disabling Dynamic Routing Gateway route propagation.

Answer

Single public Internet Gateway attached without backup routes.

Answer

Using local peering gateways for on-premises connections.

Question 19

Which THREE operational tasks should be included in a comprehensive disaster recovery runbook when utilizing OCI Full Stack Disaster Recovery for an enterprise application? (Choose three.)

Accepted Answer

Executing pre-checks in the target DR region to validate resource readiness and configurations. An FSDR runbook should include verifying database synchronization, executing pre-checks before failover, starting application services via orchestrated plans, and updating DNS/load balancer routing.

Answer

Manually deleting all IAM policies in the primary region during normal operations

Answer

Format-all commands on primary database storage volumes prior to initiating DR

Question 20

Your organization uses OCI Full Stack Disaster Recovery to manage failovers between Region A and Region B. During a DR drill, you notice that a custom user-defined step failed because the dependent compute instance in Region B was not yet fully running. How should you resolve this dependency issue in the FSDR plan?

Accepted Answer

Edit the DR plan group and add a dependency or adjust the sequence order so that the start compute step completes before the custom script step.. OCI Full Stack Disaster Recovery allows you to configure plan groups and dependencies, ensuring that steps (such as running scripts or starting applications) wait until prerequisite infrastructure steps (like starting compute instances) complete successfully.

Answer

Manually SSH into each instance during the drill to run the script.

Answer

Increase the OCI Compute instance shape size in Region B to boot faster.

Answer

Disable all pre-checks in the FSDR plan settings.