A financial services firm has deployed a new VM DB System using the Base Database Service for a critical application. The security team reports that although the database is functional, it is accessible from an unauthorized subnet within the VCN. The system was provisioned with the intention of being isolated. Which configuration is the most likely cause of this unintended network exposure?
Answer and explanation
Correct answer: B
Security Lists control traffic at the subnet level. An ingress rule with a source CIDR that is too broad (e.g., the entire VCN CIDR block 10.0.0.0/16 instead of a specific application tier subnet) is the most common reason for unintended access from other subnets within the same VCN. This directly addresses the problem of intra-VCN exposure.
Question 2
A data analytics company uses a BaseDB VM DB System for long-term data archival and infrequent analysis. The database is 10 TB, and full backups are configured to run weekly to OCI Object Storage. The company is under pressure to reduce operational costs without violating a 7-year data retention policy. Which strategy provides the most significant cost savings for storing these backups?
Answer and explanation
Correct answer: C
This is the most effective cost-saving strategy. Recent backups, which are more likely to be needed for operational recovery, remain in the instantly accessible Standard tier. Older backups are automatically moved to the much cheaper Archive tier for long-term retention. This perfectly balances accessibility for recent data with cost efficiency for archival data, directly addressing the company's requirements.
Question 3
Multiple answers
A systems integrator is designing a cross-region disaster recovery (DR) solution for a customer's critical OLTP application running on a BaseDB VM DB System. The requirements are a Recovery Point Objective (RPO) near zero and a Recovery Time Objective (RTO) of less than 15 minutes. Which TWO components are essential to build this solution? (Select TWO)
Answer and explanation
Correct answers: B, D
Maximum Availability mode uses synchronous redo transport, ensuring zero data loss if the primary database fails, thus meeting the near-zero RPO requirement. It prioritizes data protection without halting the primary if the standby becomes unavailable.
Data Guard requires a standby database to which redo data is shipped. For cross-region DR, this standby database must be provisioned on a DB System in the designated DR region, ready to take over in a failover event.
Question 4
A global investment bank is migrating its on-premises Oracle Database to OCI. They require a solution that offers maximum control over the database software and underlying operating system for applying custom security hardening scripts, while also leveraging Oracle Real Application Clusters (RAC) for high availability. The solution must comply with strict data sovereignty regulations, requiring all data and management to reside within a specific country.
The IT team has evaluated OCI database offerings and is focusing on the Base Database Service. They must ensure that patching for the OS, Grid Infrastructure, and Database is managed by their internal DBA team to align with their quarterly change management cycles. Performance is critical, requiring low-latency storage.
Which Base Database Service configuration should the architect recommend to meet all these requirements?
Answer and explanation
Correct answer: B
This configuration perfectly aligns with all requirements. A 2-node VM DB System supports RAC for high availability. The Enterprise Edition - Extreme Performance includes all database features, including RAC. VM DB Systems provide root access to the OS, allowing the bank's DBA team to apply custom hardening scripts and manage their own patching schedule. Using Block Volumes for shared storage is the standard and supported method for RAC on VM DB Systems. Data sovereignty is met by deploying the system in the required OCI region.
Question 5
A startup is launching its first application on OCI and needs to provision a cost-effective Oracle Database. They have already purchased Oracle Database Enterprise Edition licenses through a perpetual license agreement and want to leverage this existing investment. Which licensing model should they select when provisioning their Base Database Service VM DB System?
Answer and explanation
Correct answer: B
The Bring Your Own License (BYOL) model is specifically designed for customers who already own Oracle Database software licenses. By choosing BYOL, they only pay for the OCI infrastructure compute, storage, and network resources they consume, allowing them to leverage their existing license investment and significantly reduce costs.
Question 6
True or False: When using a Base Database Service VM DB System, the customer is responsible for patching the guest operating system, the Grid Infrastructure, and the Oracle Database software.
Answer and explanation
Correct answer: A
This statement is true. Base Database Service (for both VM and Bare Metal) is a user-managed service. While Oracle manages the underlying hardware and virtualization (in the case of VMs), the customer has root access to the guest OS and is fully responsible for all patching and maintenance of the software stack, including the OS, Grid Infrastructure, and Oracle Database.
Question 7
A development team needs a full copy of a 2 TB production database running on a BaseDB VM DB System for performance testing a new application feature. The goal is to create the copy as quickly as possible with minimal impact on the source production database. Which method should be used?
Answer and explanation
Correct answer: B
The native 'Create Clone' feature in the OCI Console is the most efficient and recommended method. It leverages underlying storage snapshot capabilities and the latest backup to create a new, fully functional DB System with a copy of the database. This process is highly optimized for speed and minimizes performance impact on the source system.
Question 8
An architect is designing a BaseDB VM DB System for a write-intensive OLTP application that requires the highest possible IOPS and lowest latency. Cost is a secondary concern to performance. Which storage configuration should be selected during provisioning?
Answer and explanation
Correct answer: B
This is the optimal configuration. ASM is the recommended storage manager for Oracle databases, providing better performance and manageability than LVM. The 'Higher Performance' setting for Block Volumes provides the highest IOPS (75 IOPS/GB, up to 300,000 IOPS per volume) and lowest latency available for network-attached block storage in OCI. This combination directly meets the requirement for maximum performance for a write-intensive workload.
Question 9
A DBA is tasked with configuring a custom backup retention policy for a BaseDB VM DB System. The requirement is to retain daily incremental backups for 14 days and the first full backup of each month for one year. How can this be achieved using the OCI Console?
Answer and explanation
Correct answer: B
The OCI Console's automatic backup configuration allows for a 'Custom Policy'. This policy lets you define different retention periods for daily, weekly, monthly, and yearly backups. The DBA can set the daily retention to 14 days and the monthly retention to 12 months (one year) to meet the specified requirements directly through the console.
Question 10
An e-commerce platform running on Exadata Cloud Service experiences significant performance degradation during peak holiday sales. A DBA observes high 'cell physical IO bytes saved by smart scan' but also a high 'cell physical IO interconnect bytes returned by smart scan' metric. The application team confirms that queries are running slower than expected.
What is the most likely cause of this performance issue?
graph TD
App[Application] --> |SQL Query| DB[Database Node]
DB --> |Predicate Info| Cells[Storage Cells]
subgraph Storage Cells
A[Cell 1: Smart Scan] -->|Filtered Data| B(Interconnect)
C[Cell 2: Smart Scan] -->|Filtered Data| B
D[Cell 3: Smart Scan] -->|Filtered Data| B
end
B --> |Large Result Set| DB
DB --> |Slow Response| App
Answer and explanation
Correct answer: B
This is the correct diagnosis. A high 'bytes saved' indicates Smart Scan is working, but a high 'bytes returned' indicates that even after filtering, the remaining data being sent from the storage cells to the database nodes is very large. This suggests the queries are not selective enough (e.g., SELECT * FROM sales WHERE year=2024), causing a bottleneck on the interconnect network and overwhelming the DB nodes, which aligns with the observed slowdown.
