1Z0-931-25 Sample Questions & Answers

False. Even on Dedicated Infrastructure, Oracle manages the patching and updates as part of the autonomous service. However, unlike on Shared Infrastructure, you have control over the maintenance schedule and can define a specific window for these operations to occur.

Autonomous Data Guard is Oracle's premier disaster recovery solution. It maintains a synchronized physical standby database, providing the lowest RPO (near-zero data loss) and RTO (fast failover). This is the standard for mission-critical applications requiring high availability. Backups and clones are for recovery but do not offer the same near-instantaneous failover capabilities.

When using Data Pump to export or import files directly to or from OCI Object Storage, the CREDENTIAL parameter is mandatory. This parameter specifies the name of the pre-configured database credential object (created with DBMS_CLOUD.CREATE_CREDENTIAL) that allows Data Pump to authenticate with the Object Storage service. DUMPFILE specifies the file URI, but CREDENTIAL provides the necessary access rights.

The Oracle REST Data Services (ORDS) module within Database Actions is the dedicated tool for creating and managing REST APIs based on database objects like tables, views, and PL/SQL procedures. It provides a user-friendly interface to REST-enable database assets. The SQL Worksheet is for running queries, the Data Modeler is for designing schemas, and the JSON workshop is for managing JSON collections.

Autonomous JSON Database is specifically tailored for developers building JSON-centric applications. It provides all the autonomous features but is optimized for storing, indexing, and querying JSON documents using native SODA APIs. While ATP can also handle JSON, AJD is the purpose-built and most cost-effective solution for this specific NoSQL-style workload.

The OCI CLI provides commands (e.g., oci db autonomous-database stop) that can be easily integrated into shell scripts and scheduled with tools like cron for automation.

The OCI REST APIs expose endpoints for all lifecycle operations, including start and stop. These can be called from any programming or scripting language, making them ideal for integration into broader automation workflows or CI/CD pipelines.

The Access Control List (ACL) is the specific feature used to filter traffic to the Autonomous Database's public endpoint. It allows you to define a list of IP addresses or CIDR blocks that are permitted to connect. To meet the requirement, the administrator must add both the corporate IP range and the VCN's CIDR block to this list. NSGs and Security Lists operate at the VCN level, not on the database's public endpoint itself.

While both OCI Vault and third-party KMS fall under 'Customer-Managed Keys', the specific requirement to use their own on-premises HSM points to integration with a third-party KMS. Autonomous Database on Dedicated and Cloud@Customer infrastructure supports this integration, allowing organizations to maintain full control over their encryption keys using their existing security infrastructure. OCI Vault is a cloud-based service managed by Oracle.

Elastic Resource Pools are specifically designed for database consolidation scenarios on Autonomous Database Shared. They allow you to create a pool of OCPUs that can be shared among multiple databases, providing a way to manage resources efficiently and maintain performance isolation for different workloads within the same shared infrastructure.

A refreshable clone can be kept up-to-date with its source database, but it can lag behind by a maximum of 7 days. If the clone is not refreshed within this 7-day window, the link to the source database is automatically severed, and the clone becomes a regular, standalone clone.