Which three tasks by default are taken care of by the Autonomous Database?
(Choose three.)
a. Database Upgrades
b. Firmware Patching
c. Application
... [Show More] User Creation
d. Data Loading
e. Backups
a. Database Upgrades
b. Firmware Patching
e. Backups
What are two security features enabled by default by the Autonomous Database?
(Choose two.)
a. Transparent Data Encryption
b. One SYSDBA account
c. Encrypted Database Links
d. SQL Net Encryption
e. Read Only access to OS Audit logs
a. Transparent Data Encryption
d. SQL Net Encryption
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 fallback scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronized with the ADB Instance for a switch back.
Which statement about the migration using Golden Gate is correct?
a. The described scenario is correct, can be used for migration and fallback scenarios.
b. Only the migration to ADB is possible from an on-premise installation of Golden Gate.
c. Migration to ADB SHOTis not possible using Golden Gate because the apply-process cannot be installed on ADB.
d. The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on AD
e. Golden Gate on premise is n
d. The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on AD
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
a. Sessions
b. Parallelism
c. Memory
d. Concurrency e. Storage
e. Storage
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, Get, List, Stop, Restore
b. Start, Delete, Update, Query, Stop
c. Create, Query, List, Stop, Restore
d. Create, Query, Update, List, Start
a. Create, Get, List, Stop, Restore
Which two are correct actions to take in order to Download the Autonomous Database Credentials?
(Choose two.)
a. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
b. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
c. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (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 Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
c. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
d. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
What are three methods to load data into the Autonomous Database?
(Choose three)
a. Oracle Golden Gate
b. Transportable Tablespace
c. RMAN Restore
d. Oracle Data Pump e. SQL*Loader
a. Oracle Golden Gate
d. Oracle Data Pump
e. SQL*Loader
Which Java Database Connectivity (JDBC) thin client version supports the user of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?
a. 18.1 onwards
b. Any version
c. 17.4 onwards
d. 12c Release 2 onwards
a. 18.1 onwards
9. What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?
a. ADBDEV
b. ADMIN
c. DWROLE
d. ADWC
c. DWROLE
What two tasks can be executed from the service console for Autonomous Database?
(Choose two)
a. Autonomous Databases monitoring for usage and query performance
b. Creating schemas
c. Creating and scaling of Autonomous Database service
d. Wizard to download connection wallet for connection from desktop tools
a. Autonomous Databases monitoring for usage and query performance
d. Wizard to download connection wallet for connection from desktop tools
How can an Autonomous Database resource be provisioned without logging to the Oracle Cloud Infrastructure console?
a. Using Database Configuration Assistant (DBCA) on the database server
b. It cannot be done
c. Connecting to the Cloud Infrastructure Command console via SSH wallet
d. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls
d. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two)
a. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
b. 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
c. A single fault domain can be associated with multiple regions and availability domains
d. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other
a. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
b. 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
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. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
b. ADW since operational reporting is a higher priority in this scenario.
c. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
d. ATP. Using 'tpurgent' and 'high' TNS services to separate conn
d. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usernames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the Data Pump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?
a. The migration can be technically a success but the 3-rd party vendor needs to support the result.
b. The suggested Data Pump version will create an alias for non-standard tablespace names so the migration is successful.
c. The tablespace names will result in a blocking error during Data Pump import because of ADB limitations.
d. The migration can be a success, both technically and functional due to Data Pump enhancements.
c. The tablespace names will result in a blocking error during Data Pump import because of ADB limitations.
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 console. They have to be added using REST APIs only.
d. Navigate to Identity, select Users panel on the console and select "Add Public Key".
d. Navigate to Identity, select Users panel on the console and select "Add Public Key".
Which two statements are true with regards to Oracle Data Sync? (Choose two.)
a. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
b. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
c. Data Sync can load your data in parallel in order to speed up the loading process.
d. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata
a. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
d. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata
Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?
a. In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.
b. The Oracle Client Credential file is downloaded as a ZIP file.
c. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
d. You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database
a. In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database. [Show Less]