1z0-1105-23 Oracle Cloud Data Management 2023 Foundations Associate Free Practice Exam Questions (2025 Updated)

 Exadata Cloud Service and Autonomous Database are two target database environments that provide both high availability (HA) and disaster recovery (DR) options in the cloud. Exadata Cloud Service is a fully managed Oracle Database service that runs on Exadata infrastructure in the cloud. It offers high performance, scalability, availability, security, and reliability for all types of database workloads. It also supports various HA and DR options, such as Oracle Real Application Clusters (RAC), Oracle Data Guard, Oracle Active Data Guard, Oracle GoldenGate, and Oracle Zero Data Loss Recovery Appliance Cloud Service. Autonomous Database is a self-driving, self-securing, and self-repairing cloud database service that automates provisioning, configuring, securing, tuning, scaling, patching, backing up, and repairing of databases without human intervention. It also provides built-in HA and DR features based on Oracle Maximum Availability Architecture (MAA), such as transparent application continuity, automatic failover to standby databases or regions, automatic backups to object storage, point-in-time recovery using restore points or backups.

Oracle Native Network Encryption and TDE are security measures that are implemented out-of-the-box, and are included if you are not using BYOL licensing with Exadata Cloud@Customer. According to the Oracle documentation5, “Oracle Native Network Encryption encrypts all data sent over the network between database clients and servers using industry-standard encryption algorithms.” Additionally, according to the Oracle documentation6, “Transparent Data Encryption (TDE) enables you to encrypt sensitive data, such as credit card numbers, stored in tables and tablespaces.”

Focuses on creation of indexes and optimized for response time are two characteristics of Autonomous Transaction Processing (ATP). According to the Oracle documentation,“Autonomous Transaction Processing is a database service that is optimized for transaction processing or mixed workloads. It delivers the best experience for mission-critical applications that require high performance, high concurrency, and low latency. Autonomous Transaction Processing automatically creates indexes, materialized views, and partitions based on the workload.” Additionally, according to the Oracle documentation, “Autonomous Transaction Processing is optimized for response time. It uses a combination of caching, in-memory columnar format, and result set caching to deliver fast response times.”

These are two benefits that the partnership and interconnect between Oracle Cloud and Microsoft Azure provide. According to the Oracle website1, the partnership enables the following benefits:

A secure intercloud connection that bypasses the public internet

High availability and reliability through redundant 10-Gbps physical connections

Predictable cross-cloud network performance

One time setup without the need for any intermediate network provider

Unified identity and access management platform that leads to cost savings

The unified identity and access management platform allows customers to use a single identity provider to access resources in both clouds, simplifying the authentication and authorization process. The low latency is achieved by the direct interconnection between the two clouds, which provides less than two seconds of latency for superior multicloud network performance2.

NoSQL Service does not provide data processing on OCI Lakehouse. According to the Oracle website5, “Oracle Lakehouse provides extensive data processing capabilities, to accommodate the migration of existing architectures or the creation of new, agile ones. You can use Autonomous Database for SQL processing; Big Data Service for Hadoop/Spark processing; OCI Data Flow for serverless Spark processing; and OCI Data Integration for data movement.” NoSQL Service is a fully managed database service that provides fast and predictable performance for simple queries on flexible schemas.

OCI Block Volumes is the service used by default by the MySQL Database Service to store user data to make it more resistant to failures. OCI Block Volumes provides high-performance block storage volumes that can be attached to MySQL DB systems running on OCI Compute instances. Block volumes are always encrypted at rest using AES-256 encryption keys. Block volumes also support backup and restore operations using snapshots or clones that can be used for disaster recovery or testing purposes.

This statement is true about how the Converged Database helps to access data using an API. According to the Oracle documentation5, “Oracle REST Data Services (ORDS) makes it easy to develop modern REST interfaces for relational data in the Oracle Database and the Oracle Database 18c JSON Document Store. A mid-tier Java application, ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database transactions and returns any results formatted using JSON.” ORDS can automatically generate RESTful services for tables and views in the database or expose custom REST APIs using SQL or PL/SQL.

Groups is an Oracle Cloud Infrastructure (OCI) Identity and Access Management (IAM) capability that helps you to organize multiple users into teams. According to the Oracle documentation4, “Groups are collections of users who need the same type of access to a particular set of resources. You can use groups to organize users and apply policies to them as a group.”

Exadata DB Systems is an OCI service that is NOT available as part of Oracle Cloud Free Tier. According to the Oracle website5, “Oracle Cloud Free Tier includes a free time-limited promotional trial that allows you to explore a wide range of Oracle Cloud Infrastructure products, and a set of Always Free offers that never expire.” The list of eligible services for the Free Tier does not include Exadata DB Systems, which is a high-performance database platform that runs on OCI6.

The goal of scale out high availability can be achieved by provisioning nodes with Real Application Clusters (RAC). According to the Oracle documentation6, “Oracle Real Application Clusters (RAC) enables you to scale out your database by adding nodes as needed without changing your application code. RAC also provides high availability by automatically recovering from node failures.” RAC allows multiple instances of Oracle Database to run on different servers while accessing a shared set of data files.

Changing COMPATIBLE after upgrades is one of the scenarios when you should change COMPATIBLE. According to the Oracle blog post7, “COMPATIBLE needs to be adjusted only once after you completed your last database upgrade.” The blog post also explains that changing COMPATIBLE requires a restart of the database and that it should not be changed before upgrades or patching or after downgrades.

An Autonomous Database with the workload type Data Warehouse, Transaction Processing, JSON or APEX is a prerequisite of running APEX on an Autonomous Database. According to the Oracle documentation, “Oracle Application Express (APEX) is a low-code development platformthat enables you to build scalable, secure apps with world-class features that can be deployed anywhere. APEX is preconfigured and fully managed in Oracle Autonomous Database (ADB). You can use APEX on any Autonomous Database workload type: Data Warehouse (ADW), Transaction Processing (ATP), JSON (AJD), or APEX (APEX).”