1Z0-1093-25 Oracle Cloud Database Services 2025 Professional Practice Questions
Prepare for 1Z0-1093-25 with more than an answer.
- Exam fee
- $245 USD
- Level
- Professional
- Valid for
- Subject to Cloud Recertification policy
Domains covered on the exam 5
- Base Database Service - VM (BaseDB)20%
- Exadata Database Service (ExaDB)20%
- MySQL HeatWave Technical Overview20%
- NoSQL Database Service Technical Overview20%
- Oracle Cloud Infrastructure Database Management Service20%
- 1
A company has an Exadata Cloud Service VM Cluster that is currently configured with 10 OCPUs enabled per node. To handle month-end processing, they need to increase the processing power temporarily. A DBA uses the OCI Console to scale the OCPU count to 16 per node. What is the immediate impact of this action on licensing and billing?
Show answer details
Correct answer: A
This is correct. OCPU scaling on Exadata is an elastic, online operation. The change takes effect without requiring downtime. For 'License Included' models, billing is metered hourly, so the increased cost for the additional OCPUs starts as soon as they are provisioned. For BYOL, the customer must ensure they have sufficient licenses to cover the new, higher OCPU count.
- 2
True or False: On an Exadata Cloud Service instance, a customer can elastically add more Exadata Storage Servers to an existing Quarter Rack configuration to increase storage capacity.
Show answer details
Correct answer: B
This statement is correct. Exadata Cloud Service shapes are fixed hardware configurations. While you can elastically scale OCPUs within the provisioned hardware, you cannot elastically add more physical DB servers or storage servers to the configuration. Increasing the physical hardware requires provisioning a new, larger shape and migrating the databases.
- 3
A cloud architect is hosting multiple PDBs for different business units within a single CDB on an Exadata Cloud Service system. The 'Gold' business unit's PDB requires a guaranteed minimum of 40% of the CPU resources, while the 'Silver' and 'Bronze' PDBs can share the remaining resources. Which Oracle Database feature should be used to enforce this CPU allocation?
Show answer details
Correct answer: D
Database Resource Manager is the correct feature for this requirement. Within a multitenant environment, you can create a CDB resource plan that allocates CPU shares or utilization limits to different PDBs. The architect can create a plan that gives the 'Gold' PDB a higher share, ensuring it gets its required resources, especially during periods of contention.
- 4
A media streaming company wants to analyze user activity logs stored as Parquet files in OCI Object Storage. Their goal is to run complex analytical queries on this data and join it with user subscription data stored in their primary MySQL OLTP database. They need a single platform that can perform these queries with high performance without moving the log data into the database.
Which MySQL HeatWave feature is specifically designed to meet this requirement?
graph TD subgraph OCI subgraph VCN HW[MySQL HeatWave Cluster] MySQL[MySQL DB System] end OS[OCI Object Storage] Logs([Parquet Log Files]) --> OS end BI[BI Tool] --> |SQL Query| HW HW --> |Reads| MySQL HW --> |Reads| OSShow answer details
Correct answer: B
HeatWave Lakehouse is the exact feature designed for this scenario. It allows the HeatWave query engine to directly query data in various formats (like Parquet and CSV) residing in OCI Object Storage at massive scale. This enables users to analyze data in their data lake and join it with transactional data in the MySQL database within a single query, without requiring any ETL process.
- 5
A data analyst reports that a complex aggregation query against a 500 GB table is running much slower than expected on a MySQL HeatWave instance. The DBA suspects the query is not being offloaded to the HeatWave cluster. How can the DBA verify if a specific query was accelerated by HeatWave?
Show answer details
Correct answer: A
Using the
EXPLAINcommand is the standard way to see the query execution plan. When a query is successfully offloaded to HeatWave (codenamed RAPID), theExtracolumn of theEXPLAINoutput will contain the note 'Using secondary engine RAPID'. If this note is absent, the query was executed by the standard MySQL engine (InnoDB), which explains the poor performance for an analytical query. - 6
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?
Show answer details
Correct answer: A
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.
- 7
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?
Show answer details
Correct answer: D
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.
- 8
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)
Show answer details
Correct answer: C, E
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.
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.
- 9
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?
Show answer details
Correct answer: C
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.
- 10
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?
Show answer details
Correct answer: C
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.
