Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
Correct Answer: B,C,E
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.
1Z0-931-21 Exam Question 2
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
Correct Answer: D
Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store. As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.
1Z0-931-21 Exam Question 3
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
Correct Answer: D,E
In the Restore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup. https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkup-recover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C
1Z0-931-21 Exam Question 4
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst. When restoring/cloning the ADB, you must select a backup which is atleast___ hours/minutes old.
