NEW QUESTION 1
Which two options are available to restore an Autonomous Data Warehouse?

• A. Select the snapshot of the backup.
• B. Specify the point in time (timestamp) to restore
• C. Select the archived redo logs.
• D. Backup and recovery must be done using Recovery Manager(RMAN).
• E. Select the backup from which restore needs to be done.

Answer: AD

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 is correct about security features that are available in Oracle Autonomous Database?

• A. Neither Data Redaction nor TDE are supported .
• B. Data Redaction but not TDE
• C. TDE but not Data Redaction
• D. Data Redaction and TDE are both supported

Answer: A

NEW QUESTION 4
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 5
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: AC

NEW QUESTION 6
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their
end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB instance for a switch back.
Which statement about the migration using Golden Gate is correct?

• A. The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.
• B. Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
• C. Golden Gate on premise Is not certified with ADB because Golden Gate Cloud Service exists for this.
• D. Only the migration to ADB is possible from an on-premise installation of Golden Gate.
• E. The described scenario is correct, can be used for migration and fallback scenarios.

Answer: D

NEW QUESTION 7
Which two statements are true about the The Oracle Cloud Infrastructure (OCI)?

• A. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
• B. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
• C. A single fault domain can be associated with multiple regions and availability domains.
• D. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.

Answer: AC

NEW QUESTION 8
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

• A. Connecting to the Cloud Infrastructure Command console via SSH wallet.
• B. It cannot be done.
• C. Using Database Configuration Assistant (DBCA) on the database server.
• D. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Answer: A

NEW QUESTION 9
Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.
Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading?

• A. SQL Developer can only export/move/import files using datapump from databases running on Linux systems.
• B. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.
• C. SQL Developer can be used to export/move/import of a database to ADB in l set of wizard steps.
• D. SQL Developer can be started from the ADB Cloud console but only for data loading scenarios.
• E. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.

Answer: ABD

NEW QUESTION 10
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 11
What two tasks can be executed from the service console for Autonomous Databases?

• A. Autonomous Databases monitoring for usage and query performance.
• B. Wizard to download connection wallet for connection from desktop tools.
• C. Creating and scaling of Autonomous Database service.
• D. Creating schemas.

Answer: CD

NEW QUESTION 12
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?

• A. Unplug into a pdb archive which can be uploaded to object storage.B Create a database link from source database to the ADB environment and clone the PDB.
• B. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
• C. Unplug to an xml file so database files and xml file can be uploaded to object storage.

Answer: B

NEW QUESTION 13
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 14
Which two are correct actions to take in order to Download the Autonomous Database Credentials?

• A. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
• B. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
• C. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
• D. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
• E. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.

Answer: CD

NEW QUESTION 15
Which two system privileges does a user need to create analytic views?

• A. CREATE ATTRIBUTE DIMENSION
• B. CREATE ANALYTIC VIEW
• C. CREATE ANALYTIC MEASURE
• D. CREATE ANALYTIC LEVEL
• E. CREATE ANALYTIC HIERARCHY

Answer: BD

NEW QUESTION 16
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?

• A. DBNAME_MEDIUM
• B. DBNAME_HIGH
• C. DBNAME_CONCURRENT
• D. DBNAME_LOW

Answer: B

NEW QUESTION 17
Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?

• A. 17.4 onwards
• B. Any version
• C. 12c Release 2 onwards
• D. 18.1 onwards

Answer: D

NEW QUESTION 18
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 19
If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

• A. cwallet.sso
• B. keystore.jks
• C. ojdbc.properties
• D. sqlnet.ora
• E. tnsnames.ora

Answer: E

NEW QUESTION 20
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 21
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 22
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 23
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?

• A. AT
• B. Using 'tpurgenf and 'high' TNS services to separate connection types
• C. ADW since operational reporting is a higher priority in this scenario.
• D. Since the application needs to be highly available, It should to be deployed on a Kubernetes Cluster.
• E. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

Answer: D

NEW QUESTION 24
Which statement about the Export Wizard used to export database objects and data is NOT correct?

• A. If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported.
• B. Export DDL includes features such as "Show schema," "Storage," and "Terminator."
• C. If "Grants" Is checked as a DDL Option, GRANT statements are Included for any grant objects on the exported objects, including those owned by the SYS schema.
• D. If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format.

Answer: C

NEW QUESTION 25
......