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

Question 1

Which THREE features are unique or heavily enhanced capabilities of Oracle Exadata Database Service on Dedicated Infrastructure compared to standard OCI Base Database systems? (Choose three.)

Accepted Answer

Exadata Storage Server Resource Management (IORM) for fine-grained I/O prioritization. Exadata Database Service offers unique architectural features such as Smart Scan, persistent memory flash cache, and IORM.

Answer

Native support for attaching external Microsoft Azure Blob Storage containers as ASM disk groups

Answer

Automatic index creation managed entirely by the local Linux kernel swap daemon

Question 2

What is the primary benefit of using OCI Autonomous Database Serverless compared to Provisioned (Dedicated) infrastructure regarding database administration?

Accepted Answer

Oracle fully automates all patching, tuning, scaling, and provisioning with zero infrastructure management required. Autonomous Database Serverless fully automates infrastructure provisioning, tuning, patching, and scaling without requiring manual management of VMs or Exadata hardware.

Answer

Customers must manually configure Exadata cell software versions

Answer

Serverless databases do not support automated backups

Answer

Customers are required to manually apply quarterly database security patches

Question 3

An organization is designing a disaster recovery strategy using Exadata Database Service on Dedicated Infrastructure. They require an Recovery Time Objective (RTO) of less than 30 seconds and a Recovery Point Objective (RPO) of zero for an enterprise database handling mission-critical workloads. Which Data Guard configuration should be implemented?

Accepted Answer

Oracle Active Data Guard configured in Maximum Protection mode with synchronous transport. To achieve an RPO of zero and ultra-low RTO for mission-critical Exadata workloads, Oracle Data Guard should be configured in Maximum Protection mode with synchronousredo transport across Availability Domains or regions.

Answer

Manual RMAN backup replication via OCI Object Storage every 15 minutes

Answer

Oracle Data Guard configured in Maximum Performance mode with asynchronous transport

Answer

Oracle GoldenGate real-time replication with asynchronous extract configurations

Question 4

You are planning to migrate a large, mission-critical Oracle Database (12.1.0.2) on-premises to Exadata Database Service on Dedicated Infrastructure in OCI. The migration requires minimal downtime and must handle cross-endian platform conversion since the source is IBM AIX. Which migration tool and strategy combination is most appropriate?

Accepted Answer

Oracle Data Pump transportable tablespaces with RMAN cross-platform incremental backup.. For cross-endian migrations of large databases with minimal downtime, Oracle Data Pump transportable tablespaces combined with Cross-Platform Incremental Backup using RMAN is the recommended and most efficient approach.

Answer

Oracle Zero Downtime Migration (ZDM) with physical online migration workflow.

Answer

Oracle GoldenGate for real-time replication with initial load via datapump.

Answer

Standard RMAN backup and restore directly from an on-premises NFS mount to OCI Object Storage.

Question 5

An enterprise application running on Exadata Database Service on Dedicated Infrastructure experiences severe I/O contention due to a noisy neighbor batch reporting job. Which Exadata storage feature should you configure to isolate and guarantee I/O resources for critical online transaction processing (OLTP) workloads?

Accepted Answer

Exadata I/O Resource Management (IORM) with database-level resource plans. Exadata Storage Server Resource Management (IORM) allows administrators to allocate I/O resource shares and limit bandwidth consumption for specific database workloads or consumer groups.

Answer

OCI Block Volume performance tiers (Higher VPU settings)

Answer

Autonomous Database concurrency limits in the OCI console

Answer

OCI Compute Auto-scaling configurations on the domU guest VMs

Question 6

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 7

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 8

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 9

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 10

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