Online Access Free 1Z0-931 Exam Questions

When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are exported?

• A.Reports
• B.Tablespaces
• C.Data
• D.Schemas

Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

• A.Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.
• B.Adding, removing, or modifying tablespaces is allowed.
• C.Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.
• D.In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

• A.through SQLPIus
• B.through the Oracle Cloud Infrastructure service console
• C.through SQL/Developer s
• D.using DBMS_CLOUD_ADMIN package

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.sqlnet.ora
• B.cwallet.sso
• C.tnsnames.ora
• D.ojdbc.properties
• E.keystore.jks

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