1z0-931-23 Exam Dumps - Oracle Autonomous Database Cloud 2023 Specialist

Refer to https://www.oracle.com/autonomous-database/autonomous-data-warehouse/pricing/

If you run Oracle Database Enterprise Edition and the required options listed below, then your BYOL requirements are as follows:

For 1-16 OCPUs of a single Oracle Autonomous Data Warehouse instance:

For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate up to 2 OCPUs of the BYOL Cloud Service.

For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate 1 OCPU of the BYOL Cloud Service.

For 17 OCPUs or more of a single Oracle Autonomous Data Warehouse:

For each supported Processor license of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate up to 2 OCPUs of the BYOL Cloud Service.

For every 25 supported Named User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant and Real Application Clusters, you may activate 1 OCPU of the BYOL Cloud Service.

https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html "Do customers need Exadata licenses to benefit from BYOL?"

DELETE_FILE Procedure

This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.

CREATE_CREDENTIAL Procedure

This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.

PUTJDBJECT Procedure

This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).

VALIDATE EXTERNAL TABLE Procedure

This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.

CREATE_EXTERNAL_TABLE Procedure

This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.

To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.

This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're

moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.

VALIDATE_EXTERNAL_TABLE Procedure

This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Database. The overloaded form enables you to use the operation_id parameter.

PUT_OBJECT Procedure

This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB)

DELETE FILE Procedure

This procedure removes the specified file from the specified directory on Autonomous Database.

CREATE_EXTERNAL_TABLE Procedure

This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.

https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9EC F-40CB-8EFC-D1CFF664EC5A

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/ connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417

https://docs.oracle.com/en/cloud/pa as/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B

"To create users in your database, connect to the database as the ADMIN user using any SQL client tool." https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-create.html #GUID-54CA837B-CD6A-4ED2-A960-5874535818CB

https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm

Graphical user interface, text, application Description automatically generated