NEW QUESTION 1
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 2
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 3
What REST verb is used to create an Autonomous Database service using REST APIs?

• A. A "POST" REST call
• B. A "GET" REST call
• C. An "INSERT" REST call
• D. A "PUT" REST call

Answer: D

NEW QUESTION 4
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 5
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 6
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

• A. TPPERFORMANT
• B. TPURGENT
• C. LOW
• D. MEDIUM
• E. HIGH

Answer: A

Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8

NEW QUESTION 7
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 8
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 9
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 10
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 11
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?

• A. Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
• B. Data Sync can not transform your data while loading it into the destination table.
• C. Data Sync can load a combination of data source, such as xsv, .xlsx and Oracle relational files.
• D. Data Sync can only load data from one source into one destination table.

Answer: C

NEW QUESTION 12
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 13
Which two statements are true with regards to Oracle Data Sync?

• A. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
• B. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
• C. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
• D. Data Sync can load your data in parallel in order to speed up the loading process.

Answer: D

NEW QUESTION 14
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 15
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 16
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

• A. OCPUs and storage can be scaled independently.
• B. OCPUs and storage must remain in sync.
• C. Increasing OCPUs will automatically increase storage.
• D. Storage in TB cannot be larger than the number of OCPUs.

Answer: C

NEW QUESTION 17
As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

• A. MEDIUM
• B. TP
• C. HIGH
• D. TPURGENT

Answer: C

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 can be Scaled independently of the number of CPUs in an Autonomous Database?

• A. Concurency
• B. Memory
• C. Parallelism
• D. Storage
• E. Sessions

Answer: B

NEW QUESTION 20
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 21
......