Oracle Autonomous Database Cloud 2019 Certified Specialist Exam
Questions with Correct Answers
Question 1:
Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)
Database Upgrades
Firmware Patching Application User Creation Data Loading
Backups
Answer:
Database Upgrades
Question 2:
Firmware Patching e. Backups What are two security features enabled by default by the
Autonomous Database? (Choose two.) Transparent Data Encryption
One SYSDBA account Encrypted Database Links SQL Net Encryption
Read Only access to OS Audit logs
Answer:
a. Transparent Data Encryption
Question 3:
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?
The described scenario is correct, can be used for migration and fallback scenarios. Only the
migration to ADB is possible from an on-premise installation of Golden Gate.
Migration to ADB SHOTis not possible using Golden Gate because the apply-process cannot be
installed on ADB.
The fallback scenario is not possible using Golden Gate because the capture-process cannot be
installed on AD
Golden Gate on premise is n
Answer:
d. The fallback scenario is not possible using Golden Gate because the capture-process cannot
be installed on AD
,Question 4:
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
SessionsParallelism MemoryConcurrency e. Storage
Answer:
e. Storage
Question 5:
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
Sessions
Parallelism Memory
Concurrency e. Storage
Answer:
e. Storage
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?
Create, Get, List, Stop, Restore Start, Delete, Update, Query, Stop Create, Query, List, Stop,
Restore Create, Query, Update, List, Start
Answer:
a. Create, Get, List, Stop, Restore
Question 7:
Which two are correct actions to take in order to Download the Autonomous Database
Credentials? (Choose two.)
Click on the Object Storage and find your Autonomous Bucket and Download the Wallet
Credentials. Click the Compute section of the menu, then choose Instance Configurations, then
Download Wallet. Find the Service Console for your Autonomous Database, then pick
Administration, then Download the Client Credentials (Wallet).
Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB
Connection button, then Download the Wallet.
Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then
Download the Wallet.
Answer:
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.
, Question 8:
What are three methods to load data into the Autonomous Database? (Choose three) Oracle
Golden Gate
Transportable Tablespace RMAN Restore
Answer:
a. Oracle Golden Gate
Question 9:
D. Oracle Data Pump
E. SQL*Loader Oracle Data Pump
Answer:
a. 18.1 onwards
Question 10:
What is the predefined role that exists in Autonomous Database that includes common
privileges that are used by a Data Warehouse developer?ADBDEV ADMIN DWROLE ADWC
Answer:
c. DWROLE
Question 11:
What two tasks can be executed from the service console for Autonomous Database? (Choose
two) Autonomous Databases monitoring for usage and query performanceCreating
schemasCreating and scaling of Autonomous Database serviceWizard to download connection
wallet for connection from desktop tools
Answer:
a.Autonomous Databases monitoring for usage and query performanced. Wizard to download
connection wallet for connection from desktop tools
Question 12:
What two tasks can be executed from the service console for Autonomous Database? (Choose
two) Autonomous Databases monitoring for usage and query performanceCreating
schemasCreating and scaling of Autonomous Database serviceWizard to download connection
wallet for connection from desktop tools
Answer:
a.Autonomous Databases monitoring for usage and query performanced. Wizard to download
connection wallet for connection from desktop tools
Questions with Correct Answers
Question 1:
Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)
Database Upgrades
Firmware Patching Application User Creation Data Loading
Backups
Answer:
Database Upgrades
Question 2:
Firmware Patching e. Backups What are two security features enabled by default by the
Autonomous Database? (Choose two.) Transparent Data Encryption
One SYSDBA account Encrypted Database Links SQL Net Encryption
Read Only access to OS Audit logs
Answer:
a. Transparent Data Encryption
Question 3:
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?
The described scenario is correct, can be used for migration and fallback scenarios. Only the
migration to ADB is possible from an on-premise installation of Golden Gate.
Migration to ADB SHOTis not possible using Golden Gate because the apply-process cannot be
installed on ADB.
The fallback scenario is not possible using Golden Gate because the capture-process cannot be
installed on AD
Golden Gate on premise is n
Answer:
d. The fallback scenario is not possible using Golden Gate because the capture-process cannot
be installed on AD
,Question 4:
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
SessionsParallelism MemoryConcurrency e. Storage
Answer:
e. Storage
Question 5:
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
Sessions
Parallelism Memory
Concurrency e. Storage
Answer:
e. Storage
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?
Create, Get, List, Stop, Restore Start, Delete, Update, Query, Stop Create, Query, List, Stop,
Restore Create, Query, Update, List, Start
Answer:
a. Create, Get, List, Stop, Restore
Question 7:
Which two are correct actions to take in order to Download the Autonomous Database
Credentials? (Choose two.)
Click on the Object Storage and find your Autonomous Bucket and Download the Wallet
Credentials. Click the Compute section of the menu, then choose Instance Configurations, then
Download Wallet. Find the Service Console for your Autonomous Database, then pick
Administration, then Download the Client Credentials (Wallet).
Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB
Connection button, then Download the Wallet.
Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then
Download the Wallet.
Answer:
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.
, Question 8:
What are three methods to load data into the Autonomous Database? (Choose three) Oracle
Golden Gate
Transportable Tablespace RMAN Restore
Answer:
a. Oracle Golden Gate
Question 9:
D. Oracle Data Pump
E. SQL*Loader Oracle Data Pump
Answer:
a. 18.1 onwards
Question 10:
What is the predefined role that exists in Autonomous Database that includes common
privileges that are used by a Data Warehouse developer?ADBDEV ADMIN DWROLE ADWC
Answer:
c. DWROLE
Question 11:
What two tasks can be executed from the service console for Autonomous Database? (Choose
two) Autonomous Databases monitoring for usage and query performanceCreating
schemasCreating and scaling of Autonomous Database serviceWizard to download connection
wallet for connection from desktop tools
Answer:
a.Autonomous Databases monitoring for usage and query performanced. Wizard to download
connection wallet for connection from desktop tools
Question 12:
What two tasks can be executed from the service console for Autonomous Database? (Choose
two) Autonomous Databases monitoring for usage and query performanceCreating
schemasCreating and scaling of Autonomous Database serviceWizard to download connection
wallet for connection from desktop tools
Answer:
a.Autonomous Databases monitoring for usage and query performanced. Wizard to download
connection wallet for connection from desktop tools
