1. What is a prerequisite of running APEX on an Autonomous Database?

A DBA must create APEX admin and APEX users first before starting APEX from Oracle Cloud
Infrastructure Console.

APEX can only be used when selecting APEX as a workload when provisioning an Autonomous
Database.

APEX can simply be installed by downloading the executable from OTN.

A DBA must enable ORDS first.

An Autonomous Database with the workload type Data Warehouse, Transaction Processing, JSON
or APEX.

2. Which two are objectives of Oracle’s Data Management strategy?

Offer multiple integration points for 3rd party databases that work better for mixed and analytic
workloads.

Automate everything for developers, data analysts, DBAs and data scientists.

Provide the best platform for warehouse workloads only.

Provide for the fastest, most scalable converged SQL database.

3. Which two are key characteristics of Oracle Autonomous Database?

Oracle manages everything

Customer manages everything

Less automated

Lower cost

Higher cost

4. What security control areas determines il there is sensitive data in a system?

Detect

Assess

Protect

User
5. Which statement can be detected by monitoring of access to sensitive data?

SELECT * from EMPLOYEES;

CREATE index emp_id_idx on EMPLOYEES(emp_id);

SELECT SYSDATE from DUAL;

UPDATE quarter_reference set Q1='012022'

6. Oracle ExaC@C brings the Oracle Cloud to the customer data center.

The Oracle Cloud Infrastructure is the same, but responsibilities are adjusted so that customer can
perform which two tasks?

Allow only the Oracle Staff to perform control access.

Operator Access Control can terminate Oracle operator connections.

Allow network connections in the Oracle public cloud.

Secure access configured to the customer network.

7. Exadata is the integration of the software and hardware and is available to customer on which
deployments?

only al the customer site

only in public cloud environments

only in a hybrid cloud

in the Oracle cloud and customer site

8. What are two characteristics of CI/CD?

Development changes are automatically tested on push/commits and merges.

It prevents developers from merging their code changes back to the shared branch for security.

It introduces automation into all stages of app/database development.

It requires Liquibase.
9. What set of NoSQL-style APIs can be used in Autonomous JSON Database?

SODA (Simple Oracle Document Access)

OASD (Oracle Application Storage Definition)

OSDA (Oracle Simple Document Access)

DOSA (Document Open Solution Access)

10. Oracle cloud infrastructure OCI?

Archive storage

11. Organize multiple users in to teams?

Groups

12. But retrieved immediately based on business needs?

Object storage (standard)

13. Always Free resource?

Fast connect (1 Gbps Public peering)

14. Oci Data Flow

15. oci object storage

16. Oracle E-Business Suite

17. Meta Data source of truth

18. Fast connect and direct connect, virtual cloud networks and amazon virtual private cloud

19. one more correct, low latency, upgrade compliance, connection to other multi cloud
environments

20. pay loads, data models

22. Developers can point their application to the location of ADB Wallet which integrates all REST
API calls.

Each database comes with a REST-enabled compute instance to provide access to data.

23. relational, spatial, Events,Notifications,Terraform

24. Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) workflows?

SQL Developer (including ADB wallet)

ADB console (including Performance Hub)

Database Actions (including real time SQL monitor)

SQLd (including Liquibase)

25. Which three are prerequisites for using the MySQL Database Service?

You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.

You must create a compartment to store your resources.

You or your group must be granted the policies described in Mandatory Policies.

You must create a tenancy and be able to sign in to it.

You must download the latest.MySQL version from https://edelivery.oracle.com/.

26. Oracle Automated Machine Learning (AutoML) has options for using in-database and opensource
algorithms.

Which is an example of an in-database option?

Oracle Machine Learning for Python (OML4Py) APIs

Tuning of hyperparameter

REST Interface

Cognitive text
27. When should you change COMPATIBLE?

After upgrades

After database downgrades

When the database is stopped

After patching

28. What are two important reasons to upgrade and patch?

Validation of application

Support Compliance

Restructure the database

Security

29. What is the Oracle recommended way to upgrade databases?

Data Pump Export/Import

Command Line Upgrade

Database Upgrade Assistant (DBUA)

AutoUpgrade

30. Which deployment option provides the highest degree of security and governance while
providing a completely self-service database experience?

Oracle Database Cloud Service

Oracle MySQL Database Service

Oracle Autonomous Database

Exadata Cloud Service

Which option does the DBA have in this case?

No downtime is required as number of OCPU can be increased from OCI console, but users have to
be informed that they must not use any application for at least one hour.

Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a downtime of
approximately one hour.

Open the database in OCI Console and increase the number of OCPU. No downtime required.

Plan for a one-hour downtime and increase the number of OCPU while database is offline.

32. What are two typical reasons why customers CANNOT move their database into the public
cloud?

Regulations that prevent moving data into the public cloud

Public cloud does not provide storage for more than 10TB

Total Cost of Ownership in public cloud is higher than on-premises

Putting data in the cloud would break data residency rules

33. Which security measure is implemented out-of-the-box, and is included if you are not using BYOL
licensing with Exadata Cloud@Customer?

Database Vault and Data Masking Pack

Oracle Native Network Encryption and TDE (Transparent Data Encryption)

Audit Vault and Database Firewall

Oracle Key Vault

34. Which two statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to
register an Exadata Cloud@Customer infrastructure in?

Consider any business policies or regulations that preclude the use of a particular region.

The Exadata Cloud@Customer region can be changed after the infrastructure is created.

Exadata Cloud@Customer is hosted in a customer data center so the Ixadata infrastructure is not
registered in an OCI region

Consider which availability domain (within the region) to create the Exadata Cloud@Customer
infrastructurear

Consider the physical proximity of the region you register the infrastructure in to youl data center
35. What is NOT a workload that can be selected when provisioning an Autonomous Database?

Data Warehouse

JSON

APEX

MySQL

36. What is the primary goal of Oracle Maximum Availability Architecture for customer systems?

Data Protection, access and reporting

Continuous Availability, network security and failover

Active Replication, Data Protection and continuous availability

Scale out, application availability and protection

37. Which two methods can you use to create or modify Oracle Cloud Infrastructure (OCI) resources?

OCI REST APIs

Secure Shell (SSH)

Remote Desktop Protocol (RDP)

OCI Command-line Interface (CLI)

Serial console connection (SCC)

38. Which feature allows you to logically group and isolate your Oracle Cloud Infrastructure
resources?

Compartments

Identity and Access Management Groups

Availability Domain

Tenancy
39. Which workload CANNOT be run on Oracle Database 19c?

Machine Learning

Hadoop Clusters

Gaming

Translytical

40. What are the two main features of APEX's low code platform?

Build scalable web apps for MongoDB

Use traditional computer programming paradigms

Limited productivity

Focus on business requirements

Simplified core-based licensing

Use graphical user interfaces and configuration