1Z0-997-26 Timed Practice Test 3 — 10 Questions

Question 1

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?

10 minute time limit — choose an answer to begin.

Accepted Answer

Create an Autonomous Exadata Infrastructure resource in your compartment and virtual cloud network.. Autonomous Database on Dedicated Exadata Infrastructure (ADB-D) requires a two-step provisioning model: first create the Autonomous Exadata Infrastructure (AEI) resource, which allocates the dedicated Exadata hardware in your compartment and VCN, then provision the Autonomous Container Database and finally the Autonomous Database on top of it. Without the AEI, there is no dedicated infrastructure to host the ADB, so this step is mandatory.

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 2

What is the primary function of an OCI Service Gateway?

Accepted Answer

To provide private access to Oracle public services without using public IP addresses or the internet. An OCI Service Gateway provides a private, secure path for resources in a VCN to access Oracle public services (such as Object Storage, Autonomous Database, and OCI Streaming) without traversing the internet or using public IP addresses. Traffic from the VCN to the service goes over the Oracle network fabric, staying private. This is the primary function of a Service Gateway in OCI networking.

Answer

To translate private IP addresses to public IP addresses for internet bound traffic

Answer

To connect on-premises datacenters to OCI via FastConnect

Answer

To load balance HTTP/HTTPS traffic across multiple backend servers

Question 3

When designing a high-availability and disaster recovery architecture for an enterprise Oracle Database on OCI, which THREE components or patterns are crucial for achieving optimal recovery and uptime? (Choose three.)

Accepted Answer

Automated and policy-driven backups to OCI Object Storage with cross-region replication. Option A is correct because automated, policy-driven backups written to OCI Object Storage and replicated across regions provide durable, off-site recovery points that survive regional failures and satisfy RPO/RTO objectives. Option C is correct because Oracle Data Guard maintains a synchronized standby database in a remote region, enabling fast failover and near-zero data loss for regional disaster recovery. Option E is correct because Oracle RAC spread across fault domains or availability domains provides local high availability by eliminating single points of failure and enabling instance-level failover within a region. Option B is incorrect because local ephemeral NVMe snapshots are tied to the compute instance and are lost if the host or region fails, so they cannot serve as a disaster recovery mechanism. Option D is incorrect because a single-node database VM cannot be stretched across regions, and unencrypted NFS mounts introduce security and latency problems that undermine both availability and compliance.

Answer

Relying solely on local ephemeral NVMe drive snapshots for disaster recovery

Answer

Stretching a single-node database VM across distinct cloud regions using unencrypted NFS mounts

Question 4

You need to connect multiple VCNs in different regions to a single on-premises datacenter via FastConnect. Which DRG feature enables you to route traffic efficiently across multiple VCNs and remote connections?

Accepted Answer

DRG attachments and DRG Route Tables. A Dynamic Routing Gateway (DRG) with attachments for each VCN and the on-premises FastConnect virtual circuit, combined with DRG Route Tables, enables centralized routing across multiple VCNs in different regions and the on-premises network. DRG Route Tables let you control which routes are imported and distributed per attachment.

Answer

Local Peering Gateway chaining

Answer

Internet Gateway route forwarding

Answer

Service Gateway cross-region peering

Question 5

When designing a multi-database architecture with Oracle GoldenGate for high availability and load distribution, which THREE architectural considerations are critical for success? (Choose three.)

Accepted Answer

Implementing Conflict Detection and Resolution (CDR) rules for active-active multi-master topologies. Option B is correct because in an active-active multi-master GoldenGate topology, the same rows can be modified on multiple nodes simultaneously, so Conflict Detection and Resolution (CDR) rules are essential to deterministically resolve update/delete conflicts and prevent data divergence. Option C is correct because each node must generate non-overlapping keys; using unique sequence offsets (or ranges) per node prevents primary key collisions when inserts from different replicas are applied to the same table. Option D is correct because DDL changes must be captured and replicated in a coordinated way (e.g., via DDL replication and synchronized apply order) so that table structures, columns, and indexes remain identical across nodes, avoiding extract/replicat failures and metadata mismatches. Option A is wrong because routing all writes to a single read-only replica without replication is not a GoldenGate HA/load-distribution design and would not propagate changes. Option E is wrong because disabling checkpointing removes recovery positioning, causing data loss and preventing reliable restart after failures.

Answer

Routing all write transactions through a single read-only replica without replication

Answer

Disabling all checkpointing to maximize real-time packet loss tolerance

Question 6

An enterprise has workloads running in OCI and Google Cloud Platform (GCP). They require low-latency, private connectivity between OCI and GCP without traffic traversing the public internet. Which architectural design pattern achieves this?

Accepted Answer

Connect OCI FastConnect and GCP Interconnect using a Layer 2 software-defined interconnection provider like Megaport or Equinix Fabric.. OCI and GCP do not have a native direct interconnect between them, so private low-latency connectivity requires a Layer 2 fabric provider. FastConnect on the OCI side and Cloud Interconnect on the GCP side both terminate at the same Equinix Fabric or Megaport switch, where a virtual cross-connect joins the two circuits. This keeps traffic off the public internet and gives deterministic latency.

Answer

Peer an OCI Dynamic Routing Gateway directly to a GCP Virtual Private Cloud using a Google Cloud Interconnect cable.

Answer

Configure an OCI Internet Gateway to peer with GCP Cloud DNS.

Answer

Attach a GCP VPC as a secondary VCN in the OCI console.

Question 7

An organization has multiple child compartments under a parent compartment. A security architect needs to write an IAM policy that allows a specific developer group to manage compute instances across all child compartments without granting permissions at the root tenancy level. How should this policy be structured?

Accepted Answer

Allow group Developers to manage compute-instances in compartment ParentCompartment. OCI IAM policies are hierarchical: a policy statement that grants access at a parent compartment automatically applies to all child compartments within that hierarchy. By writing the policy at ParentCompartment, the developer group gets manage permissions on compute instances in all child compartments without granting tenancy-wide access. This follows the principle of least privilege while meeting the requirement.

Answer

Allow group Developers to manage compute-instances in tenancy

Answer

Allow group Developers to manage compute-instances in root

Answer

Write individual policies for every single child compartment separately without referencing the parent.

Question 8

Your OKE cluster has autoscaling enabled using the Kubernetes Cluster Autoscaler. However, during peak hours, new pods remain in 'Pending' state for 15 minutes before the cluster autoscaler provisions new worker nodes. How can you reduce this provisioning delay?

Accepted Answer

Deploy Kubernetes over-provisioning pods (pause pods) with lower priority to keep spare node capacity ready instantly.. Over-provisioning pods (low-priority pause pods) reserve spare capacity on existing nodes so that when a real workload pod is scheduled, it can immediately preempt the pause pod and start running without waiting for the Cluster Autoscaler to provision a new node. This eliminates the 15-minute node provisioning delay during peak hours.

Answer

Convert all worker nodes from virtual machines to bare metal shapes.

Answer

Increase the OCI Load Balancer bandwidth shape to maximum.

Answer

Disable OCI IAM token caching on worker nodes.

Question 9

Your security team mandates that all traffic entering your OCI VCN from the internet must be inspected by a next-generation firewall before reaching backend web servers. How should you design this architecture?

Accepted Answer

Route inbound traffic from the Internet Gateway through a firewall appliance subnet before forwarding it to backend subnets via route tables.. To force all inbound internet traffic through a next-generation firewall before it reaches backend web servers, you place the firewall appliance in its own subnet and use route tables to steer traffic: the Internet Gateway routes inbound traffic to the firewall subnet, and the firewall subnet's route table forwards inspected traffic to the backend subnet. This is the standard hub-and-spoke or DMZ architecture in OCI, where the firewall is the next hop for the backend subnet's ingress path.

Answer

Attach public IP addresses directly to all backend web servers.

Answer

Rely entirely on default VCN Security Lists without route table modifications.

Answer

Use OCI Object Storage to filter incoming HTTP packets.

Question 10

You are configuring an OCI Site-to-Site VPN. Your on-premises firewall requires static routing instead of BGP. Which OCI VPN mode must you select when creating the IPSec connection?

Accepted Answer

Static Routing mode. OCI Site-to-Site VPN supports two routing modes: Dynamic Routing (BGP) and Static Routing. When the on-premises firewall requires static routing, you must select Static Routing mode and manually specify the on-premises and OCI CIDR prefixes that should be routed over the tunnel.

Answer

Local Peering mode

Answer

Dynamic Routing (BGP) mode

Answer

FastConnect Partner mode