Oracle ADB Certification
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
DBAManager 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? - ATP.
Using 'tpurgent' and 'high' TNS services to separate connection types.
A clone database source can be from a point-in-time backup that is less than 2 hours old. T/F -
False
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? - ATP. Using
'tpurgent' and 'high' TNS services to separate connection types.
A customer would like to use Golden Gate as a fall-back scenario for the first 6 months after their
migration from on-prem to ADB. What issue will they run into? - The fallback scenario is not
possible using Golden Gate because the capture-process cannot be installed on ADB.
A Network Security Group is required within your Virtual Cloud Network before you can provision a
shared Autonomous Database to use Private Endpoints T/F - True
A new Python developer has joined your team and needs to access the Autonomous Database (ADB)
data. How does the developer connect to and interact with ADB from Python? - The Oracle Client
and the cx_Oracle interface for Python
,ADB auto scaling is enabled by default T/F - True
ADB Shared resources can be moved from one compartment to another T/F - True
AJD cannot store heterogenous collections JSON and non JSON documents T/F - True
All schemas can use auto indexes by default T/F - True
A clone database source can be a running database instance. T/F - True
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a
database user id with other users when accessing ADB. - Rotate the instance wallet and share the
new wallet with the remaining users.
Apex is auto enabled T/F - True- you get access through the service console. Username is admin
and password is the initial admin password
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? -
TPURGENT
Automatic Failover Overview in Autonomous Data Guard: - It is Auto triggered. Only Allowed to
occur when no data loss will occur. RTO is 2 minutes and RPO is 0 minutes.
Automatic Indexing is enabled by default in ADW? - False
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. In Autonomous Data Warehouse direct access to the database node and the local file system is
allowed.
B. 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.
C. Adding, removing, or modifying tablespaces is allowed.
D. 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
Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent
resources that move with them. Associated (non-dependent) resources remain in their current
compartments. T/F - True
Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching
of the Exadata grid infrastructure code and operating systems updates), and include database patching.
T/F - False
Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is
mandatory. T/F - True
Backups, Firmware Patches, Database Upgrades are managed Automatically by ADB T/F - True
Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression
for all tables by default. T/F - True
CPU billing is halted based on full-cycles of usage when Oracle ADB is stopped T/F? - True
Data Analysis Medley (4 parts) - Data Load: ODI
Data Prep: ODEQ
Semantic Modeling
Data Analysis
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
DBAManager 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? - ATP.
Using 'tpurgent' and 'high' TNS services to separate connection types.
A clone database source can be from a point-in-time backup that is less than 2 hours old. T/F -
False
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? - ATP. Using
'tpurgent' and 'high' TNS services to separate connection types.
A customer would like to use Golden Gate as a fall-back scenario for the first 6 months after their
migration from on-prem to ADB. What issue will they run into? - The fallback scenario is not
possible using Golden Gate because the capture-process cannot be installed on ADB.
A Network Security Group is required within your Virtual Cloud Network before you can provision a
shared Autonomous Database to use Private Endpoints T/F - True
A new Python developer has joined your team and needs to access the Autonomous Database (ADB)
data. How does the developer connect to and interact with ADB from Python? - The Oracle Client
and the cx_Oracle interface for Python
,ADB auto scaling is enabled by default T/F - True
ADB Shared resources can be moved from one compartment to another T/F - True
AJD cannot store heterogenous collections JSON and non JSON documents T/F - True
All schemas can use auto indexes by default T/F - True
A clone database source can be a running database instance. T/F - True
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a
database user id with other users when accessing ADB. - Rotate the instance wallet and share the
new wallet with the remaining users.
Apex is auto enabled T/F - True- you get access through the service console. Username is admin
and password is the initial admin password
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? -
TPURGENT
Automatic Failover Overview in Autonomous Data Guard: - It is Auto triggered. Only Allowed to
occur when no data loss will occur. RTO is 2 minutes and RPO is 0 minutes.
Automatic Indexing is enabled by default in ADW? - False
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. In Autonomous Data Warehouse direct access to the database node and the local file system is
allowed.
B. 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.
C. Adding, removing, or modifying tablespaces is allowed.
D. 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
Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent
resources that move with them. Associated (non-dependent) resources remain in their current
compartments. T/F - True
Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching
of the Exadata grid infrastructure code and operating systems updates), and include database patching.
T/F - False
Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is
mandatory. T/F - True
Backups, Firmware Patches, Database Upgrades are managed Automatically by ADB T/F - True
Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression
for all tables by default. T/F - True
CPU billing is halted based on full-cycles of usage when Oracle ADB is stopped T/F? - True
Data Analysis Medley (4 parts) - Data Load: ODI
Data Prep: ODEQ
Semantic Modeling
Data Analysis
