1Z0-997-26 Practice Test 9 — 10 Questions

Question 1

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?

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

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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