1Z0-997-26 Practice Exam 4 — 20 Questions

Question 1

You are optimizing the cost and performance of an Exadata Database Service on Dedicated Infrastructure environment hosting multiple large databases. Which THREE practices should you implement to achieve optimal resource utilization and cost efficiency?

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

Accepted Answer

Consolidate multiple non-CDB databases into a single Multitenant Container Database (CDB) with multiple PDBs.. To optimize Exadata Dedicated environments, you can leverage OCPUs scaling, database consolidation into multitenant container databases, and storage server flash cache optimizations.

Answer

Migrate all table data to standard Block Volume storage to bypass Exadata storage servers.

Answer

Disable automatic backups entirely to save OCI Object Storage costs.

Question 2

An OCI architect is setting up a disaster recovery environment where compute instances in the DR region need identical network configurations (private IPs, VNICs, security lists) to the primary region. Which OCI capability assists in deploying reproducible network topologies across regions?

Accepted Answer

OCI Resource Manager with Terraform configurations. OCI Resource Manager uses Terraform to provision infrastructure as code, allowing architects to replicate identical VCN, subnet, and security configurations across regions.

Answer

OCI File Storage Network File System (NFS) exports

Answer

OCI IAM Domain Federation wizard

Answer

OCI Streaming service partition replication

Question 3

You are configuring transparent data encryption (TDE) for an Oracle Database on Exadata Database Service using OCI Vault for master encryption key management. What happens if the database loses connectivity to the OCI Vault key management service?

Accepted Answer

The database continues to run using keys cached in memory for a period, but cannot be restarted until connectivity to OCI Vault is restored. If TDE master keys are stored in OCI Vault (external key management), the database can continue operating temporarily using cached keys in memory, but cannot restart or decrypt new sessions if key access remains blocked indefinitely.

Answer

The database instantly crashes and forces an immediate failover to the standby database

Answer

The database automatically falls back to self-managed wallet storage without alerting administrators

Answer

All encrypted data files are automatically wiped to prevent security breaches

Question 4

Your development team wants to connect securely to an Autonomous Database (Serverless) instance using mutual TLS (mTLS) authentication. Where must the client application obtain the required credentials to establish this secure connection?

Accepted Answer

Download the database connection wallet zip file from the OCI Console or CLI and extract it on the client host. Clients connecting via mTLS to an Autonomous Database must download the wallet file (credentials zip) generated from the OCI Console or CLI.

Answer

Generate a Kerberos ticket granting service token via the IAM security console

Answer

Retrieve the master encryption key directly from OCI Vault using an API key

Answer

Configure a public SSL certificate issued by Let's Encrypt in the database parameter settings

Question 5

An architect is designing an Oracle Exadata Database Service on Dedicated Infrastructure deployment with multiple VM clusters on a single Exadata rack. Which architectural feature allows secure isolation of CPU, memory, and database workloads between these distinct VM clusters?

Accepted Answer

Hard partitioning using Oracle VM (dom0/domU) hypervisor virtualization on the database servers. Exadata VM clusters utilize Oracle Virtual Machine (dom0/domU) virtualization architecture to completely isolate resources between different clusters on the same physical rack.

Answer

OCI Block Volume volume group replicas synchronized via block replication

Answer

Software-defined VLAN tagging enforced by the OCI Virtual Cloud Network (VCN) hypervisor only

Answer

Autonomous Database container database resource pools sharing a single OS kernel

Question 6

You are designing an automated backup strategy for an Exadata Database Service on Dedicated Infrastructure. You want to ensure that incremental backups are taken daily and full backups weekly, with long-term retention stored in OCI Object Storage. Where are these backup schedules configured?

Accepted Answer

In the OCI Console under the database system backup configuration settings or via API/CLI. Backup policies and schedules for Exadata Database Service are configured directly through the OCI Console, CLI, or API under the database system backup settings.

Answer

By modifying the crontab configuration file as root on the dom0 hypervisor node

Answer

By editing the initialization parameter file (spfile) using SQL*Plus

Answer

Via Oracle Enterprise Manager Cloud Control deployed exclusively on-premises

Question 7

An enterprise requires deploying an Oracle Autonomous Database on Dedicated Infrastructure to meet stringent data isolation and security mandates. Which foundational resource must be provisioned first before creating the Autonomous Container Database?

Accepted Answer

An Autonomous Exadata Infrastructure resource. Before you can provision an Autonomous Container Database (ACD) on Dedicated Infrastructure, you must provision an Autonomous Exadata Infrastructure resource which allocates the underlying physical Exadata compute and storage resources.

Answer

An Autonomous Database on Shared Infrastructure instance

Answer

A standard Oracle Base Database system

Answer

A Virtual Cloud Network with a default database subnet only

Question 8

You are configuring scaling parameters for an Autonomous Database on Dedicated Infrastructure. You need to enable automatic scaling of CPU cores to handle unpredictable traffic bursts while maintaining strict cost controls. What is the maximum CPU core auto-scaling limit for an Autonomous Container Database on Dedicated Infrastructure?

Accepted Answer

Up to the total number of unallocated CPU cores available in the underlying Exadata Infrastructure instance. On Dedicated Infrastructure, auto-scaling for Autonomous Databases can scale up to the total number of unallocated CPU cores available in the underlying Exadata Autonomous Exadata Infrastructure instance.

Answer

Exactly three times the base OCPU count provisioned for the database instance

Answer

An unlimited amount limited only by OCI regional capacity limits

Answer

Fixed at a maximum of 128 OCPUs regardless of hardware size

Question 9

You are managing an Oracle Base Database Service instance configured with Data Guard in OCI. Due to a severe networking anomaly, the standby database falls significantly behind in applying redo. You decide to rebuild the standby database from an incremental backup taken on the primary. Which Recovery Manager (RMAN) command or process is used to synchronize the standby with the new incremental backup?

Accepted Answer

Apply an incremental backup from SCN on the primary database to the standby database using RMAN.. RMAN incremental backup from SCN allows you to apply an incremental backup taken from the primary database directly to the standby database to catch it up without having to recreate the entire standby from scratch.

Answer

Execute a complete cold restore of all datafiles using FTP over port 21.

Answer

Reboot the OCI compute host using the OCI console 'Reset' button.

Answer

Run 'ALTER DATABASE CONVERT TO SNAPSHOT STANDBY' and drop all tablespaces.

Question 10

When designing high availability for stateless web servers in OCI, which combination of services provides automatic scaling and load distribution across multiple Availability Domains?

Accepted Answer

OCI Instance Pools, Autoscaling Configurations, and a regional OCI Load Balancer. Combining OCI Instance Pools, Autoscaling Configurations, and an OCI Load Balancer provides automated scaling and multi-AD high availability.

Answer

OCI Streaming and OCI Notifications service

Answer

OCI Database Backup Policies and Local Peering Gateways

Answer

OCI Vaults and OCI Key Management service

Question 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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