1Z0-997-26 Practice Exam 3 — 20 Questions

Question 1

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?

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

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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.

Question 11

Which TWO features of OCI Object Storage contribute to its high durability and reliability for disaster recovery workflows? (Choose two.)

Accepted Answer

Object versioning support to protect against accidental deletion or overwriting.. Object Storage stores data redundantly across multiple fault domains/ADs and offers lifecycle management / versioning capabilities.

Answer

Restricting bucket access exclusively to local console sessions.

Answer

Storing all objects on a single physical disk inside a single compute instance.

Answer

Requiring manual user replication scripts for every individual file uploaded.

Question 12

You need to migrate a 50 TB Oracle Database from on-premises to Exadata Database Service on Dedicated Infrastructure with minimal downtime. The source database is operating on AIX and uses big-endian architecture, while OCI Exadata runs on little-endian Linux. Which migration method handles cross-platform endian conversion most efficiently?

Accepted Answer

RMAN Transportable Tablespaces with cross-platform data file conversion. Transportable Tablespaces with RMAN CONVERT DATAFILE provide the most efficient method for cross-platform migrations when endianness differs between source and target architectures.

Answer

Direct database clone via SQL*Developer migration wizard

Answer

Oracle GoldenGate initial load using SQL direct paths

Answer

Standard Oracle Data Pump export and import over direct database links

Question 13

Which TWO editions of Oracle Database are available when deploying an Oracle Base Database system on OCI? (Choose two.)

Accepted Answer

Oracle Database Enterprise Edition (EE). Standard Edition 2 and Enterprise Edition are core editions available for Oracle Base Database systems.

Answer

Oracle Database Micro Edition (ME)

Answer

Oracle Database Web Edition (WE)

Answer

Oracle Database Personal Edition (PE)

Question 14

An organization running an Oracle Exadata Database Service requires compliance auditing where all database administrative actions and sensitive data queries must be logged, tamper-proof, and retained in an isolated repository. Which combination of OCI and Oracle Database features provides this capability?

Accepted Answer

Oracle Data Safe combined with Database Unified Audit policies. Oracle Audit Vault and Database Firewall (AVDF) or OCI Audit combined with Oracle Data Safe and Database Unified Audit provides robust, tamper-proof auditing and compliance reporting.

Answer

OCI Object Storage unversioned buckets with public read permissions

Answer

Oracle Data Pump export logs stored in local temporary directories

Answer

Standard Linux syslog daemon writing to local disk partitions

Question 15

An enterprise application running on Oracle Autonomous Transaction Processing (ATP) requires dedicated infrastructure isolation for compliance reasons. You need to provision an Autonomous Database on Dedicated Exadata Infrastructure. Which architectural step is mandatory before you can provision the database instance?

Accepted Answer

Create an Autonomous Exadata Infrastructure resource in your compartment and virtual cloud network.. Before provisioning an Autonomous Database on Dedicated Exadata Infrastructure, you must first create an Autonomous Exadata Infrastructure resource within a specific availability domain or fault domains, which reserves the underlying compute and storage resources.

Answer

Contact Oracle Support to manually allocate physical rack boundaries in your tenancy region.

Answer

Create a Pluggable Database (PDB) manually via SQL*Plus on an existing multitenant container database.

Answer

Provision a standard Exadata Cloud Service cluster using the Database management service console.

Question 16

When designing high availability for an Oracle RAC (Real Application Clusters) database deployed on OCI Exadata Database Service, which THREE architectural characteristics ensure fault tolerance and uptime? (Choose three.)

Accepted Answer

Multi-node database clustering across distinct Fault Domains or Availability Domains. RAC on Exadata leverages multiple database nodes across fault domains, transparent application failover (TAF/Application Continuity), and shared storage across redundant storage cells.

Answer

Running the entire cluster on a single Oracle Linux compute instance without Grid Infrastructure

Answer

Storing all database data on a single local NVMe drive on node 1

Question 17

You are migrating an on-premises Oracle Database (version 19c) to Oracle Autonomous Database (Serverless) using Oracle Data Pump. Which action is mandatory to ensure compatibility before generating the Data Pump export dump file?

Accepted Answer

Run the DBMS_CLOUD.PREPARE_FOR_AUTONOMOUS PL/SQL package on the source database. When migrating to Autonomous Database using Data Pump, you must run the DBMS_CLOUD.PREPARE_FOR_AUTONOMOUS procedure or use the Autonomous Database Migration tool to check and convert incompatible tablespaces, segments, and objects.

Answer

Disable Automatic Workload Repository (AWR) collection on the source database

Answer

Convert the source database into an Oracle Multitenant Container Database with a single pluggable database

Answer

Manually drop all custom triggers and indexes to prevent import failures

Question 18

Which TWO backup destinations are natively supported when configuring automated backups for Oracle Base Database systems on OCI? (Choose two.)

Accepted Answer

OCI Object Storage Archive tier (for long-term retention policies). Base Database systems support backups directly to OCI Object Storage (Standard bucket) or OCI Object Storage Classic / Archive storage tiers.

Answer

Local unformatted swap partitions on the database host

Answer

Public GitHub code repositories

Answer

Local USB flash drives plugged into the database VM guest node

Question 19

An enterprise is implementing a multi-database architecture utilizing Oracle GoldenGate microservices on OCI Compute instances to replicate data between an operational Exadata database and an analytical Autonomous Data Warehouse. Which network security construct must be configured to allow communication between the GoldenGate deployment and the Autonomous Database instance?

Accepted Answer

Configure VCN security lists or Network Security Groups (NSGs) allowing outbound TCP port 1522 and inbound mTLS traffic, and supply the ADB wallet. Autonomous Database requires mTLS connections and specific egress/ingress rules; when using GoldenGate to connect to Autonomous Database, the GoldenGate subnet must allow outbound traffic and connect using the appropriate wallet and port 1522.

Answer

Expose an API Gateway with public IP routing directly to the database undo tablespace

Answer

Configure a Local Peering Gateway with remote VCN route tables pointing to port 22

Answer

Attach an Internet Gateway directly to the Autonomous Database private IP address

Question 20

You are performing maintenance on an OCI Load Balancer backend set. You want to temporarily stop sending traffic to a specific backend server without immediately dropping active persistent connections. What feature should you use?

Accepted Answer

Enable Connection Draining on the backend server.. Draining allows a load balancer to stop sending *new* requests to a backend server while allowing existing persistent connections to complete gracefully.

Answer

Set the backend server weight to zero without enabling draining.

Answer

Delete the backend server from the backend set immediately.

Answer

Modify the security list to drop all TCP packets on port 443.