1Z0-997-26 Practice Test 4 — 25 Questions

Question 1

Which Autonomous Database workload type is specifically optimized for running complex analytical queries, machine learning, and data warehousing workloads?

Accepted Answer

Autonomous Data Warehouse (ADW). Autonomous Data Warehouse (ADW) is optimized for analytical queries, reporting, and data warehousing.

Answer

Autonomous JSON Database (AJD)

Answer

Autonomous Transaction Processing (ATP)

Answer

Autonomous Apex Application Development (APEX)

Question 2

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. GoldenGate architectures require conflict resolution, careful handling of DDL changes, and proper handling of sequences.

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 3

You are troubleshooting a cross-cloud connectivity issue between an OCI VCN and an Azure VNet via the OCI-Azure Interconnect. Traffic is dropping intermittently between the environments. Which THREE diagnostic steps or configuration checks should you perform?

Accepted Answer

Inspect OCI VCN route tables and Azure route tables to ensure return paths are correctly specified.. Troubleshooting the OCI-Azure Interconnect involves checking BGP route advertisement status, verifying Network Security Group (NSG) and route table rules on both clouds, and inspecting MTU matching across the circuit.

Answer

Attach an Internet Gateway to the Azure VNet to route private interconnect packets.

Answer

Configure an OCI Local Peering Gateway to bridge the Azure and OCI subnets.

Question 4

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.. Using a third-party network virtualization appliance (such as Megaport Cloud Router or Equinix Fabric) to bridge OCI FastConnect and GCP Interconnect provides private multicloud connectivity.

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 5

Which OCI tool should a cloud architect recommend for automating the lifecycle management, patching, and backing up of a fleet of Oracle Base Database systems across multiple compartments?

Accepted Answer

OCI Database Management service. OCI Database Management service provides comprehensive monitoring, fleet management, and operational insights for Oracle databases across OCI.

Answer

OCI Compute Instance Scheduler

Answer

Oracle Cloud Infrastructure GoldenGate deployment console

Answer

OCI Identity and Access Management (IAM) policies

Question 6

You are designing a multi-database architecture where applications require read-scaling across different geographic regions with minimal replication lag. You decide to deploy Autonomous Data Warehouse (ADW) instances across three regions connected via GoldenGate. Which feature of Autonomous Database can be leveraged alongside GoldenGate to prevent sequence cache duplication conflicts across regions?

Accepted Answer

Configuring autonomous database global sequences with specific increment and offset parameters. When deploying multi-region distributed writes or replication architectures, utilizing Oracle Database features such as sequence caching with ORDER and NOORDER or scaling ranges prevents primary key collisions across nodes.

Answer

Setting the database character set to AL32UTF8 to handle multi-region strings

Answer

Using Oracle Autonomous Health Framework to automatically resolve distributed deadlocks

Answer

Enabling Autonomous Data Guard in Snapshot Standby mode in all regions simultaneously

Question 7

Which OCI database service provides fully managed Oracle Database instances running on dedicated virtual machines with root access and granular control over operating system parameters?

Accepted Answer

Oracle Base Database service. Oracle Base Database service provides virtual machine database systems with full root access and OS-level control.

Answer

Oracle Exadata Database Service on Dedicated Infrastructure

Answer

OCI NoSQL Database service

Answer

Oracle Autonomous Database Serverless

Question 8

An architect is configuring disaster recovery for an Autonomous Database (Serverless) instance using Autonomous Data Guard. The primary database resides in the US East (Ashburn) region, and the standby is in US West (Phoenix). What is the behavior of the standby database regarding read operations?

Accepted Answer

The standby database can be accessed in read-only mode for reporting and queries. Autonomous Data Guard standby databases can be opened in read-only mode to offload reporting queries from the primary database.

Answer

The standby database automatically accepts write operations and replicates them back to the primary

Answer

The standby database accepts read-write transactions concurrently with the primary database

Answer

The standby database is completely inaccessible until a manual switchover or failover occurs

Question 9

An enterprise application uses an Oracle Autonomous Transaction Processing database and encounters intermittent application-level timeouts during peak concurrency spikes. Upon investigating, you notice that queued statements are waiting due to resource limits. Which Autonomous Database feature should you adjust to manage concurrency and statement queuing behavior?

Accepted Answer

Consumer groups and resource management rules via DBMS_RESOURCE_MANAGER or resource profile settings. Autonomous Database allows managing resource management rules and consumer groups, including setting parameters via DBMS_RESOURCE_MANAGER or adjusting CPU/concurrency profiles.

Answer

The physical memory size of the OCI Compute host instance running the application

Answer

Linux kernel swappiness parameters on the database host

Answer

OCI Virtual Cloud Network security list packet drop thresholds

Question 10

Your development team needs to scale up CPU cores for an Autonomous JSON Database instance dynamically without restarting the application or causing downtime. Which feature should you use?

Accepted Answer

Autonomous Database Elastic Resource Scaling.. Autonomous Database supports Elastic Resource Scaling, allowing users to scale CPU and storage independently and online without any database downtime.

Answer

Auto-scaling with Oracle Data Guard switchover.

Answer

OCI Compute Instance resizing via instance pool configuration.

Answer

Manual cold restart of the container database.

Question 11

You are configuring redundant OCI Site-to-Site VPN tunnels to your on-premises datacenter. OCI automatically provisions how many tunnels per VPN connection by default for high availability?

Accepted Answer

2 tunnels. Each OCI Site-to-Site VPN connection provides two redundant IPsec tunnels terminating on different Oracle-side VPN gateway public IPs.

Answer

8 tunnels

Answer

4 tunnels

Answer

1 tunnel

Question 12

An organization has configured an OCI-Azure Interconnect. Latency measurements between an OCI compute instance and an Azure VM exceed acceptable thresholds for a synchronous database replication application. Which diagnostic step should be taken first within OCI?

Accepted Answer

Verify the MTU settings across the OCI VCN, DRG, Azure VNet, and ExpressRoute gateway to check for fragmentation issues.. Checking the FastConnect virtual circuit status, monitoring traffic metrics, and checking for packet drops or incorrect routing paths via OCI Monitoring and Network Path Analyzer is the correct first diagnostic step.

Answer

Enable OCI Database Vault on the compute instances.

Answer

Replace the OCI Dynamic Routing Gateway with an Internet Gateway.

Answer

Recreate the Azure ExpressRoute circuit in a different Azure subscription.

Question 13

An architect is designing an Oracle Autonomous JSON Database instance to store flexible document workloads. Which feature is automatically enabled on Autonomous JSON Database that distinguishes it from general-purpose Autonomous Transaction Processing instances regarding storage management?

Accepted Answer

Storage and indexing are specifically optimized for JSON collections with restrictions on non-JSON relational tables. Autonomous JSON Database provides optimized storage and indexing specifically for JSON collections, allowing schema-less storage while maintaining relational capabilities, but restricts the creation of non-JSON relational tables.

Answer

Automatic conversion of all JSON documents into relational third-normal-form tables upon ingestion

Answer

Mandatory requirement to define fixed database schemas via JSON Schema validators before inserting data

Answer

Exclusion of automated backups to reduce operational overhead

Question 14

Which TWO actions are required when migrating an on-premises Oracle database to an Oracle Autonomous Database (Serverless) using Oracle Data Pump? (Choose two.)

Accepted Answer

Run the DBMS_CLOUD.PREPARE_FOR_AUTONOMOUS procedure on the source database to ensure compatibility. Migrating via Data Pump to Autonomous Database requires using a secure connection wallet and running pre-migration compatibility scripts.

Answer

Disable Transparent Data Encryption (TDE) on the source database before export

Answer

Manually format all source datafiles into Oracle ASM disk groups prior to export

Answer

Configure a direct NFS mount between the source server and the Autonomous Database storage tier

Question 15

You need to connect an on-premises datacenter to OCI using FastConnect with a Partner model. Which component must you configure in the OCI console before provisioning the virtual circuit with the FastConnect partner?

Accepted Answer

FastConnect Virtual Circuit with a partner provider. To set up a Partner FastConnect, you must create a Dynamic Routing Gateway (DRG) and a FastConnect virtual circuit specifying the partner provider.

Answer

Local Peering Gateway

Answer

Customer-Premises Equipment (CPE) object

Answer

Internet Gateway

Question 16

An enterprise multicloud architect is planning disaster recovery for workloads running across OCI and AWS. Which THREE strategies are commonly employed for cross-cloud disaster recovery architectures? (Choose THREE)

Accepted Answer

Configuring database replication (such as Oracle Data Guard) between OCI Autonomous Database and a database running in AWS.. Multicloud DR strategies include active-passive database replication (e.g., Oracle Data Guard between OCI and custom cloud deployments), DNS-based global traffic management (like OCI Traffic Management Steering), and cloud-to-cloud VPN/interconnect backup links.

Answer

Physically merging AWS VPC physical switches into OCI Meet-Me-Rooms.

Answer

Replicating OCI IAM identity domains natively inside AWS IAM without federation.

Question 17

You are migrating an Oracle Database to an Exadata Database Service on Dedicated Infrastructure. You need to ensure that database backups are stored securely with zero public internet exposure. What is the recommended networking architecture for backup transmission?

Accepted Answer

Configure a Service Gateway in your VCN to access OCI Object Storage privately. OCI services like Database backups communicate via Service Gateways or Private Endpoints to prevent traversing the public internet.

Answer

Deploy an internet gateway with IPSec VPN tunnels terminating at the backup bucket

Answer

Expose a NAT Gateway with strict IP whitelisting

Answer

Attach a secondary public IP address to the database VM guest nodes

Question 18

An enterprise requires a dedicated, private connection between their on-premises data center and Oracle Cloud Infrastructure (OCI). The connection must bypass the public internet and offer high bandwidth, predictable performance. Which OCI networking service should be deployed?

Accepted Answer

OCI FastConnect. OCI FastConnect provides a dedicated, private connection with higher bandwidth options and more reliable network performance compared to internet-based VPNs, making it the ideal choice for connecting on-premises data centers to OCI.

Answer

OCI Site-to-Site VPN

Answer

OCI Internet Gateway

Answer

Oracle Database Gateway

Question 19

Your company operates a hybrid application where frontend servers in Azure need to communicate with backend databases in OCI using private IP addresses via the OCI-Azure Interconnect. Which routing configuration is required on the OCI Dynamic Routing Gateway (DRG) attached to your VCN?

Accepted Answer

Add a route in the DRG route table pointing the Azure VNet CIDR to the FastConnect virtual circuit attachment.. The DRG must have an import route distribution or static/dynamic route entries pointing the Azure VNet CIDR blocks toward the virtual circuit attachment associated with the Azure ExpressRoute.

Answer

Configure a local peering route to the Azure ExpressRoute circuit.

Answer

Add a route pointing the Azure VNet CIDR to the Internet Gateway.

Answer

Attach an Azure VNet directly as a subnet inside the OCI VCN.

Question 20

You are designing a cross-region disaster recovery strategy for an Oracle Exadata Database Service on Dedicated Infrastructure deployment. Which TWO steps or configurations are required to establish an Active Data Guard standby database in a remote OCI region?

Accepted Answer

Configure Standby Redo Logs (SRLs) on both the primary and standby databases sized identically to the online redo logs.. Establishing Active Data Guard across regions requires proper network peering (such as Remote VCN Peering or DRG) and configuring the databases with appropriate Data Guard association parameters and standby redo logs.

Answer

Mount a shared block storage volume across both OCI regions using Network File System (NFS).

Answer

Enable automatic backups on the standby database using the same retention period as the primary.

Answer

Configure Oracle GoldenGate bidirectional replication as the underlying transport mechanism.