Courseiva
DatabaseshardMultiple ChoiceObjective-mapped

1Z0-997-26 Databases Practice Question

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?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

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 analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Configure VCN security lists or Network Security Groups (NSGs) allowing outbound TCP port 1522 and inbound mTLS traffic, and supply the ADB wallet

    Why this is correct

    Correct. Port 1522 is standard for Autonomous Database TCPS/mTLS connections, requiring appropriate NSG rules and the client wallet.

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

    Why it's wrong here

    Incorrect. API Gateways do not manage direct TNS database connections.

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

    Why it's wrong here

    Incorrect. Port 22 is for SSH, not database replication traffic.

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

    Why it's wrong here

    Incorrect. Autonomous Database instances do not attach directly to Internet Gateways; private endpoints or service gateways are used.

Visual reference

192.168.1.0 /24 256 addresses (254 usable) 192.168.1.0 /25 Subnet A 128 addr (126 usable) 192.168.1.128 /25 Subnet B 128 addr (126 usable) Borrowing 1 bit from host portion creates 2 subnets (/25)

About these practice questions

One of 344 original 1Z0-997-26 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written and reviewed by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

Last reviewed August 2026 · checked against the official Oracle exam blueprint

This 1Z0-997-26 practice question is part of Courseiva's free Oracle certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the 1Z0-997-26 exam.