NEW QUESTION 1
What are three methods to load data into the Autonomous Database?

• A. Transportable Tablespace
• B. Oracle Data Pump
• C. RMAN Restore
• D. Oracle GoldenGate
• E. SQL*Loader

Answer: BDE

NEW QUESTION 2
Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

• A. RMAN backup & restore
• B. Physical migration method like database cloning
• C. Data Pump
• D. Original Import/Export tools

Answer: C

NEW QUESTION 3
Which three statements are true about procedures in the DBMS_CLOUD package?

• A. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
• B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
• C. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
• D. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE 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.
• E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the clou
• F. You can run queries on external data from the Autonomous Data Warehouse.

Answer: ACD

NEW QUESTION 4
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

• A. On the Autonomous Database Console.
• B. SSH keys are not required In Oracle Cloud Infrastructure.
• C. SSH keys cannot be added from consol
• D. They have to be added using REST APIs only.
• E. Navigate to Identity, select Users panel on the console and select "Add Public Key".

Answer: C

NEW QUESTION 5
Which is NOT required to connect to Autonomous Database from SQL developer?

• A. Service name
• B. Wallet file
• C. Database name
• D. Username and password

Answer: C

NEW QUESTION 6
Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?

• A. Create, Query, Update, List, Start
• B. Create, Query, List, Stop, Restore
• C. Create, Get, List, Stop, Restore
• D. Start, Delete, Update, Query, Stop

Answer: B

NEW QUESTION 7
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

• A. Scaling cannot happen while there are active transactions in the database.
• B. Active transactions are terminated and rolled back.
• C. Active transactions are paused.
• D. Active transactions continue running unaffected.

Answer: A

NEW QUESTION 8
The default eight day retention period for Autonomous Database performance data can be modifiedusing whichDBMS_WORKLOAD_REPOSITORY subprogram procedure?

• A. MODIFY_SNAPSHOT_SETTINGS
• B. UPDATE_OBJECT_INFO
• C. CREATE_BASELINE_TEMPLATE
• D. UPDATE_OBJECT_INFO

Answer: A

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#

NEW QUESTION 9
Which statement is true in regards to database links?

• A. Connect from Autonomous Database to remote database using a database link.
• B. Connect to Autonomous Database from remote database using a database link.
• C. You can call PL/SQL procedures and functions using a database link.
• D. Create a database link from one Autonomous Database to another Autonomous Database instance.

Answer: A

NEW QUESTION 10
Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low.
Which statement about these consumer groups is correct?

• A. High provides highest concurrency and lowest resources, and DoP is i.
• B. Medium provides intermediate resource and concurrency, and queries run in a serial.
• C. High provides highest resources, lowest concurrency, and DoP is 1.
• D. Low provides highest concurrency, lowest resources, and DoP =1.

Answer: D

NEW QUESTION 11
What is the default retention period for both Automatic and Manual Autonomous Database Backups?

• A. One Year
• B. 90 days
• C. 7 days
• D. 30 days
• E. 60 days

Answer: D

NEW QUESTION 12
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

• A. Fiv
• B. They are called tpurgent, tp, high, medium and low.
• C. Thre
• D. They are called high, medium and low.
• E. Non
• F. There are no pre-defined service names in tnsnames.ora.
• G. Tw
• H. They are called ATP and ADW.

Answer: A

NEW QUESTION 13
What are two security features enabled by default by the Autonomous Database?

• A. Encrypted Database Links
• B. SQL Net Encryption
• C. One SYSDBA account
• D. Read Only access to OS Audit logs
• E. Transparent Data Encryption

Answer: AE

NEW QUESTION 14
Which of these database features is NOT part of the Autonomous Database?

• A. Flashback Database
• B. Java in the Database
• C. Real Application Clusters (RAC)
• D. Online Indexing

Answer: C

NEW QUESTION 15
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database?

• A. Data Pump creates the tablespaces used by your Autonomous Database.
• B. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
• C. Data Pump is faster to migrate database than using RMAN.
• D. Data Pump is platform independent - it can migrate Oracle Databases running on any platform.

Answer: AD

NEW QUESTION 16
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

• A. Import Table
• B. Create a Data Set
• C. Replicate the table using Golden Gate
• D. Load data using Data Pump

Answer: D

NEW QUESTION 17
When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

• A. OJDBC.PROPERTIES
• B. CWALLET.SSO
• C. SQLNET.ORA
• D. TNSNAMES.ORA

Answer: B

NEW QUESTION 18
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

• A. Autonomous Data Warehouse
• B. Neither service ignores hints by default
• C. Autonomous Transaction Processing
• D. Both services ignore hints by default

Answer: C

NEW QUESTION 19
Which three tasks by default are taken care of by the Autonomous Database?

• A. Database Upgrades
• B. Application User Creation
• C. Backups
• D. Firmware Patching
• E. Data Loading

Answer: ADE

NEW QUESTION 20
What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database?

• A. CSV files copied to Autonomous Database block storage
• B. Data Pump
• C. Golden Gate
• D. Recovery Manager (RMAN)

Answer: D

NEW QUESTION 21
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

• A. Autonomous Data Warehouse
• B. Neither service ignores hints by default
• C. Autonomous Transaction Processing
• D. Both services ignore hints by default

Answer: C

NEW QUESTION 22
Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning?

• A. Run SQL Scripts
• B. Create Notebooks
• C. Create workspaces
• D. Create projects
• E. Create Oracle Machine Learning User

Answer: AD

NEW QUESTION 23
......