Which are the three prerequisites to configure a private endpoint with autonomous databases Adbs )?

All Autonomous Database tools are supported in databases configured with private endpoints, but additional configuration is required: to connect from your data center, to resolve the Autonomous Database private endpoint, you need a Fully Qualified Domain Name (FQDN), mapping the private endpoint IP to the FQDN. For that you either need to add an entry into your client's hosts files (e.g. /etc/hosts on Linux) or you can use hybrid DNS in the Oracle Cloud Infrastructure.

In addition to the name resolution, your dynamic routing gateway must allow the traffic to and from the Autonomous Database.

For what it's worth, if you want to learn more about the private endpoint setup, check the official doc and specifically the connection example

20.Which two are correct actions to take in order to download Autonomous database credentials?
A) Click the compute section of the menu, then choose instance configurations, then downloads wallet.
B) Click on the object storage and find your Autonomous Bucket and download the wallet credentials.
C) Click on the Autonomous Data Warehouse Section, pick a database, then choose Actions, then Download the wallet.
D) Find the Service Console for your Autonomous Database, then pick Administration, then Download the client Credentials (Wallet)
E) Click on the Autonomous Data warehouse in the menu, click a database name, then choose DB connection button, then download the wallet.

34. The Oracle Autonomous database dedicated Exadata infrastructure feature is based upon which oracle cloud resources?
A) Virtual Cloud network, Compartments, Policies, Autonomous Exadata infrastructure
B) Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, fleet Administrator, database Administrator
C) Fleet Administrator, Database Administrator, Database User, Autonomous Exadata infrastructure.
D) Autonomous Exadata infrastructure, Autonomous backups, Autonomous Container Database, Autonomous Database

Other sets by this creator

Which FOUR levels of access can be defined in policies? (Choose all correct answers)

Options are :

• Use (Correct)
• Create
• Inspect (Correct)
• Write
• Manage (Correct)
• Read (Correct)

Answer :
*Use (Correct)
*Inspect (Correct)
*Manage (Correct)
*Read (Correct)

Which statement is true about Autonomous Data Guard?

Options are :

• After a failover, a new standby for the primary database is automatically provisioned. (Correct)
• Autonomous Data Guard is free.
• The standby database and the primary database are always on different regions.
• After a failover to the local region�s standby database you need to update the URLs for all your tools with the new primary database details.

Answer :
*After a failover, a new standby for the primary database is automatically provisioned. (Correct)

Which TWO statements are TRUE about Oracle Spatial with Autonomous Database? (Choose all correct answers)

Options are :

• Spatial supports the use of JSON and GeoJSON objects. (Correct)
• Open Geospatial Consortium Web Services is available in Autonomous Database.
• Oracle Spatial with Autonomous Database comes with integrated Network Model and Data Model.
• Spatial consists of a schema (MDSYS) that prescribes the storage, syntax, and semantics of supported geometric data types. (Correct)

Answer :
*Spatial supports the use of JSON and GeoJSON objects. (Correct)
*Spatial consists of a schema (MDSYS) that prescribes the storage, syntax, and semantics of supported geometric data types. (Correct)

1Z0-1072-21 & 1Z0-997-21 | Exam Practice Tests - Bundle Set 4

When you are increasing the number of OCPUs in your Autonomous Database, what does its status show?

Options are :

• SCALING IN PROGRESS (Correct)
• UPSCALE IN PROGRESS
• UPLIFT IN PROGRESS
• RESIZING IN PROGRESS

Answer :
*SCALING IN PROGRESS (Correct)

Which Oracle Package is used to load data to an ADB from object storage?

Options are :

• DBMS_LOAD
• DBMS_CLOUD (Correct)
• DBMS_MIGRATE
• DBMS_RPC

Answer :
*DBMS_CLOUD (Correct)

Which are the TWO prerequisites to migrate a physical database to an autonomous database? (Choose all correct answers)

Options are :

• Database must be a PDB. (Correct)
• All uses of CDB admin privileges must be removed. (Correct)
• Database must not be encrypted.
• All indexes must be dropped.

Answer :
*Database must be a PDB. (Correct)
*All uses of CDB admin privileges must be removed. (Correct)

1Z0-1072-21 & 1Z0-997-21 | Exam Practice Tests - Bundle Set 10

In which format is data stored in an Oracle Autonomous Data Warehouse database?

Options are :

• Row Format
• Columnar Format (Correct)
• Fast Changing Dimension Format
• Slow Changing Dimension Format

Answer :
*Columnar Format (Correct)

Which are the THREE pre-requisites to configure a private endpoint with Autonomous Databases (ADBs)? (Choose all correct answers)

Options are :

• There must be a Web Application Firewall (WAF) configured within the region.
• There must be at least one Network Security Group (NSG) within your VCN. (*) (Correct)
• There must be a private subnet with DHCP option. (Correct)
• There must be a VCN within the region of the ADB. (Correct)
• There must be a Vault Key configured for the ADB.

Answer :
*There must be at least one Network Security Group (NSG) within your VCN. (*) (Correct)
*There must be a private subnet with DHCP option. (Correct)
*There must be a VCN within the region of the ADB. (Correct)

Your company has deployed an Autonomous Database on a dedicated infrastructure. Which THREE resources will be managed by your company? (Choose all correct answers)

Options are :

• Schemas (Correct)
• DB User (Correct)
• Storage Servers
• Hypervisors
• DB servers
• Encryption Keys (Correct)

Answer :
*Schemas (Correct)
*DB User (Correct)
*Encryption Keys (Correct)

Oracle Cloud Infrastructure 2020 Architect Associate Set 3

Which feature is available in Autonomous Database Shared but not in Autonomous Database Dedicated?

Options are :

• Data Guard � Active Standby
• Oracle Machine Learning (OML) Notebooks * (Correct)
• Java in Database
• Transparent Application Continuity

Answer :
*Oracle Machine Learning (OML) Notebooks * (Correct)

What is the pre-requisite for taking a manual backup of an Oracle Autonomous Database?

Options are :

• Your database must be deployed on Oracle Exadata [email protected] X8M.
• You must have an Object Storage bucket and your database must be configured to connect to it. (Correct)
• Your database must be stopped.
• You cannot take manual backups of an Oracle Autonomous Database.

Answer :
*You must have an Object Storage bucket and your database must be configured to connect to it. (Correct)

Who manages the compartment quotas for an Autonomous Database in a dedicated infrastructure?

Options are :

• System Administrator
• Fleet Administrator (Correct)
• Database Administrator
• Service Administrator

Answer :
*Fleet Administrator (Correct)

1Z0-931-21 || Oracle Autonomous Database Cloud Set 5

Which TWO infrastructure support deployment of Oracle Autonomous Database? (Choose all correct answers)

Options are :

• Dedicated Exadata Infrastructure (Correct)
• Virtual Machines on Oracle Cloud Infrastructure
• Shared Exadata Infrastructure (Correct)
• Oracle Bare Metal Servers

Answer :
*Dedicated Exadata Infrastructure (Correct)
*Shared Exadata Infrastructure (Correct)

Which command can you use to create an Autonomous Database?

Options are :

• POST /20160918/createautonomousDatabases
• POST /20160918/autonomousDatabases (*) (Correct)
• POST /20160918/createDatabases
• POST /20160918/createADB

Answer :
*POST /20160918/autonomousDatabases (*) (Correct)

Which chart shows the average number of running SQL statements historically?

Options are :

• SQL statements executed per second
• Running SQL Statements (Correct)
• Response Time Queued Statements
• Average SQL Statements

Answer :
*Running SQL Statements (Correct)

Oracle 1Z0-1067-21 | OCI Cloud Operations Associate Set 5

Which TWO statements are true about API Signing Key? (Choose all correct answers)

Options are :

• It must be generated with a passphrase.
• An RSA key pair in PEM format must have a minimum of 1024 bits.
• It is an RSA key pair in PEM format. (Correct)
• It is required when using OCI API in conjunction with SDK/CLI. (Correct)

Answer :
*It is an RSA key pair in PEM format. (Correct)
*It is required when using OCI API in conjunction with SDK/CLI. (Correct)

Which THREE statements are TRUE when provisioning an Autonomous Database? (Choose all correct answers)

Options are :

• The provisioned database is fully encrypted. (Correct)
• It is deployed on a private software-defined network. (Correct)
• The provisioned database automatically masks user data.
• The provisioned database has a scalable RAC cluster running on Exadata. (Correct)

Answer :
*The provisioned database is fully encrypted. (Correct)
*It is deployed on a private software-defined network. (Correct)
*The provisioned database has a scalable RAC cluster running on Exadata. (Correct)

You have moved an Autonomous Database from compartment C01 to C02. Which TWO are TRUE? (Choose all correct answers)

Options are :

• You need to shut down the database in C01 before you can move it to C02.
• An Autonomous Data Guard for the database is created in C01 post successful migration to C02.
• The Automatic Backups are moved to C02, as well. (Correct)
• Any policy defined on C02 will be immediately applied to the database. (Correct)

Answer :
*The Automatic Backups are moved to C02, as well. (Correct)
*Any policy defined on C02 will be immediately applied to the database. (Correct)

1Z0-1085-21 || Oracle Cloud Infrastructure Foundations Set 5

Which THREE predefined database service names are available in an Autonomous Data Warehouse? (Choose all correct answers)

Options are :

• medium (Correct)
• low (Correct)
• tpurgent
• tp
• high (Correct)

Answer :
*medium (Correct)
*low (Correct)
*high (Correct)

Which Autonomous Database Developer tool can be used to build web applications rapidly?

Options are :

• Web Reporting Studio
• Jupyter Notebooks
• APEX (Correct)
• SQL

Answer :
*APEX (Correct)

Which TWO are TRUE regarding cloning an Autonomous Database? (Choose all correct answers)

Options are :

• The cloned database version can be higher than the source database version. (Correct)
• A new autonomous database can be cloned from a live running database instance. (Correct)
• A refreshable (read-only) clone of the source database can be from its backup.
• A refreshable (read-only) clone of the source database can be from its backup.
• You cannot change the licensing type during cloning.

Answer :
*The cloned database version can be higher than the source database version. (Correct)
*A new autonomous database can be cloned from a live running database instance. (Correct)

Oracle Cloud Infrastructure 2020 Architect Associate Set 3

DBSRV1 is an Autonomous Database with the display name PRODDB. You plan to take manual backup of this database periodically. What must be the name of the bucket that will be used to store manual backups?

Options are :

• BACKUP_DBSRV1
• BACKUP_PRODDB
• backup_proddb
• backup_dbsrv1 (Correct)

Answer :
*backup_dbsrv1 (Correct)

Which statement is TRUE about auto indexing in an Autonomous Database?

Options are :

• It analyzes the application workload, and accordingly creates new indexes and drops the existing underperforming indexes to improve database performance. (Correct)
• Auto indexing is enabled by default.
• It provides PL/SQL APIs for configuring automatic indexing in a database and generating reports related to automatic indexing operations.
• It cannot rebuild indexes that are marked as unusable due to table partitioning maintenance operations.

Answer :
*It analyzes the application workload, and accordingly creates new indexes and drops the existing underperforming indexes to improve database performance. (Correct)

Which THREE can be used in ADB for authentication to object storage? Which THREE are used by IAM service to authenticate a principal ?

Options are :

• API signing key (Correct)
• Wallet Credentials
• Resource Principal (Correct)
• SSH
• Username and Password (Correct)

Answer :
*API signing key (Correct)
*Resource Principal (Correct)
*Username and Password (Correct)

1Z0-1072-21 & 1Z0-997-21 | Exam Practice Tests - Bundle Set 3

Which is the recommended data loading tool to migrate data from third-party databases?

Options are :

• SQL Developer Data Import Wizard
• SQL Loader
• Oracle Data Pump
• SQL Developer Migration Workbench (Correct)

Answer :
*SQL Developer Migration Workbench (Correct)

Which TWO statements are TRUE about patching an Autonomous Database? (Choose all correct answers)

Options are :

• Oracle patches the database during a scheduled maintenance window. (Correct)
• Oracle patching generally does not take more than two hours. (Correct)
• Users can change the patching schedule.
• The database is not accessible to the user during patching.

Answer :
*Oracle patches the database during a scheduled maintenance window. (Correct)
*Oracle patching generally does not take more than two hours. (Correct)

Which ROLE is automatically granted to any user created in Autonomous Database?

Options are :

• DTPROLE
• DBROLE
• DUSERROLE
• DWROLE (Correct)

Answer :
*DWROLE (Correct)

1Z0-1072-21 & 1Z0-997-21 | Exam Practice Tests - Bundle Set 4

For which resource consumption will you be charged when your Autonomous Database is stopped temporarily?

Options are :

• data security
• allocated number of OCPUs
• allocated storage (Correct)
• network consumption

Answer :
*allocated storage (Correct)

Which TWO tasks are performed by a Fleet Administrator? (Choose all correct answers)

Options are :

• Manage Autonomous Databases.
• Provision Autonomous Database instances.
• Provision Autonomous Exadata Infrastructure. (Correct)
• Create IAM users.
• Provision Autonomous Container Databases. (Correct)

Answer :
*Provision Autonomous Exadata Infrastructure. (Correct)
*Provision Autonomous Container Databases. (Correct)

Which TWO Data Guard Replication Modes are available in Autonomous Database Dedicated? (Choose all correct answers)

Options are :

• Max Protection
• Max Synchronization
• Max Availability (Correct)
• Max Performance (Correct)

Answer :
*Max Availability (Correct)
*Max Performance (Correct)

Oracle 1Z0-1055-20 | Oracle Financials Cloud Payables Set 2

You want to migrate a schema from an on-premises database to an ATP dedicated instance using Data Pump export. You specified the ENCRYPTION parameter as DATA_ONLY and Oracle Encryption Wallet is open. Which type of encryption mode will be used in this scenario?

Options are :

• Password
• Dual
• None
• Transparent (Correct)

Answer :
*Transparent (Correct)

In which TWO situations can Data Pump be used to migrate to an Autonomous Database? (Choose all correct answers)

Options are :

• when moving a relatively small amount of data
• cross endian platforms (Correct)
• source Database 10g and later (Correct)
• when source is a flat file

Answer :
*cross endian platforms (Correct)
*source Database 10g and later (Correct)

Which TWO statements are TRUE about Access Control Lists (ACLs) configured for Autonomous Databases?

Options are :

• A database restore overwrites the existing ACLs.
• ACLs can be configured for individual IP addresses, CIDR block ranges, and VCNs. (Correct)
• All services that are subsets of an ADB, such as SQL Developer Web, APEX, and OML notebooks, are also blocked by ACLs. (Correct)
• Access Control Lists can be configured for autonomous databases only at the time of provisioning.

Answer :
*ACLs can be configured for individual IP addresses, CIDR block ranges, and VCNs. (Correct)
*All services that are subsets of an ADB, such as SQL Developer Web, APEX, and OML notebooks, are also blocked by ACLs. (Correct)

1Z0-1085-21 || Oracle Cloud Infrastructure Foundations Set 2

Which TWO statements are true about OCI Command Line Interface? (Choose all correct answers)

Options are :

• does not use REST APIs
• calls OCI REST APIs (Correct)
• is easy to use and lightweight to install (Correct)
• runs only on Linux operating systems
• is easy to use but involves complex installation and configuration

Answer :
*calls OCI REST APIs (Correct)
*is easy to use and lightweight to install (Correct)

Which THREE statements are true about Oracle Data Pump? (Choose all correct answers)

Options are :

• It allows you to specify the level of compression of the export dump file.
• It can export specified views as tables. (Correct)
• It can overwrite an existing dump file during an export operation. (Correct)
• It can perform remapping operations on schemas and data files. (Correct)

Answer :
*It can export specified views as tables. (Correct)
*It can overwrite an existing dump file during an export operation. (Correct)
*It can perform remapping operations on schemas and data files. (Correct)

Which TWO statements are TRUE about an Oracle Autonomous Transaction Processing database? (Choose all correct answers)

Options are :

• It is best suited for Analytics Workload.
• It stores data in Row Format. (Correct)
• Memory configuration, data formats, indexes, and access structures are automatically optimized to optimize response time. (Correct)
• Use data summaries such as storage indexes on the Exadata storage cells to quickly answer the data that is needed in the query.

Answer :
*It stores data in Row Format. (Correct)
*Memory configuration, data formats, indexes, and access structures are automatically optimized to optimize response time. (Correct)

1Z0-931-21 || Oracle Autonomous Database Cloud Set 1

Which can be used to ensure that your Autonomous Database is accessible only from a given set of IPs?

Options are :

• Access Control List (Correct)
• IP Vault
• Security List
• IPSec List

Answer :
*Access Control List (Correct)

Which TWO Oracle Cloud Infrastructure console tools can be used to monitor the performance of an autonomous database service instance? (Choose all correct answers)

Options are :

• SQL Developer
• Performance Hub (Correct)
• APEX
• OCI Metrics (Correct)

Answer :
*Performance Hub (Correct)
*OCI Metrics (Correct)

Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS?

Options are :

• Event
• Topic (Correct)
• Notification
• Subject

Answer :
*Topic (Correct)

1Z0-1085-21 || Oracle Cloud Infrastructure Foundations Set 16

You want to enable automatic indexing in a database, but any new auto indexes should be created as invisible indexes, so that they cannot be used in SQL statements. Which command will you use?

Options are :

• EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','INVISIBLE');
• EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','IMPLEMENT');
• EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','OFF');
• EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY'); (Correct)

Answer :
*EXEC DBMS_AUTO_INDEX.CONFIGURE('AUTO_INDEX_MODE','REPORT ONLY'); (Correct)

Which database is specialized for developing NoSQL-style applications that use JavaScript Object Notation (JSON)?

Options are :

• Autonomous Transaction Processing database
• Autonomous APEX database
• Autonomous Data Warehouse database
• Autonomous JSON database (Correct)

Answer :
*Autonomous JSON database (Correct)

Which TWO statements are TRUE about Auto Scaling? (Choose all correct answers)

Options are :

• If you are provisioning an always-free database, auto scaling is not available. (Correct)
• Scaling up automatically expands CPU but not IO resources.
• Enabling auto scaling also increases the concurrency and parallelism settings for the predefined services.
• It can be enabled when provisioning an ADB instance or anytime using the Oracle Cloud Infrastructure console. (Correct)

Answer :
*If you are provisioning an always-free database, auto scaling is not available. (Correct)
*It can be enabled when provisioning an ADB instance or anytime using the Oracle Cloud Infrastructure console. (Correct)

Oracle Cloud Infrastructure 2020 Architect Associate Set 1

Which THREE statements are TRUE about private endpoints? (Choose all correct answers)

Options are :

• You can configure a private endpoint while cloning your ADB. (Correct)
• You can change the network access of an autonomous database in a shared Exadata infrastructure from private endpoint to public endpoint. (Correct)
• You can configure an existing Autonomous Database (ADB) to use a private endpoint. (Correct)
• You need to set up transit routing in your VCN and use a service gateway to connect.

Answer :
*You can configure a private endpoint while cloning your ADB. (Correct)
*You can change the network access of an autonomous database in a shared Exadata infrastructure from private endpoint to public endpoint. (Correct)
*You can configure an existing Autonomous Database (ADB) to use a private endpoint. (Correct)

Which TWO are true about Autonomous JSON Database? (Choose all correct answers)

Options are :

• You can promote an Autonomous JSON Database service to an Autonomous Data Warehouse service.
• They are schemaless. (Correct)
• In a SODA collection, you can have a collection of image documents or a collection that contains both JSON documents and image documents.
• There is no storage limit for JSON collections. (Correct)

Answer :
*They are schemaless. (Correct)
*There is no storage limit for JSON collections. (Correct)

REPORTADB is a refreshable clone of PRODADB. Which TWO statements are TRUE? (Choose all correct answers)

Options are :

• REPORTADB can be changed to READ WRITE without disconnecting it from PRODADB.
• APEX URLs will not work for REPORTADB. (*) (Correct)
• If you do not perform a refresh within seven days, then REPORTADB will be no longer refreshable. (*) (Correct)
• It is possible to create cascading refreshable clones.

Answer :
*APEX URLs will not work for REPORTADB. (*) (Correct)
*If you do not perform a refresh within seven days, then REPORTADB will be no longer refreshable. (*) (Correct)

1Z0-1094-21 || Oracle Cloud Database Migration & Integration Set 4

The Oracle Autonomous Db 1Z0-931 certification measures you on following topics:

The Oracle Autonomous Cloud 2020 refers to a cloud-based technology that is designed for automating many routine tasks essential for managing Oracle databases. Oracle 1Z0-931-20 exam validates your skills and demonstrates your knowledge in Autonomous Transaction Database (ATP) and Autonomous ?Data Warehouse (ADW). Further, this highly acclaimed exam helps you enhance your employability and promises higher career growth.

1. Autonomous Database Technical Overview
2. Migration and Data Loading into Autonomous Database
3. Monitoring Autonomous Database
4. Provisioning and Connectivity
5. Managing and Maintaining Autonomous Database
6. Tools, Reporting and Analytics using Autonomous Data Warehouse (ADW)

Prerequisite For 1Z0-931-21

There is no prerequisite for this certification, you can go for this exam directly. A combination of Oracle training and hands-on experience is recommended.

Note: This certification comes under the Cloud Recertification policy, to read more about the guidelines click here.

Exam Details (1Z0-931-21)

• Exam Title: Oracle Autonomous Database Cloud Specialist
• Exam Number: 1Z0-931-21
• Exam Price: $244
• Format: Multiple Choice
• Duration: 90 Minutes
• Number of Questions: 60
• Passing score: 65%

Which are the three pre requisites to configure a private endpoint with autonomous databases Adbs )?

Which 3 tools are bundled with autonomous database?

Which are the three types of autonomous databases you can deploy?

Which three Oracle cloud infrastructure resources do you need to configure before provisioning your autonomous database with private endpoint?