Oracle Cloud Infrastructure 2024 Data Foundations Associate

Exam Number: 1Z0-1195-24

Question - 01

What are two typical reasons why customers CANNOT move their database into the

public cloud?

A. Putting data in the cloud would break data residency rules

B. Regulations that prevent moving data into the public cloud
C. Total Cost of Ownership in public cloud is higher than on-premises
D. Public cloud does not provide storage for more than 10TB

Ans: A and B (Confirmed)

Question - 02

What are the two main features of APEX’S low code platform?

A. Limited productivity
B. Build scalable web apps for MongoDB
C. Simplified core-based licensing
D. Use graphical user interfaces and configuration
E. Use traditional computer programming paradigms
F. Focus on business requirements

Ans: D and F (Confirmed)

Question - 03

The Supply Side is data that is passive and means something. What two models and

libraries are included in the supply side?

A. Business rules
B. Domain objects
C. Technical definitions of business terms
D. Reports

Ans: A and C (Confirmed)

Question - 04

After you have provisioned a virtual machine (VM) database (DB) system, what action can

you take to meet changes in block storage requirements?

A. If a VM DB system requires more block storage, increase the storage at any time
without impacting the system.
B. Only bare metal DB systems can increase block storage at any time without impacting
the system.
C. If a VM DB system has different requirements for block storage, increase or decrease
the storage at any time without impacting the system.
D. After you have provisioned a VM DB system, you cannot increase or decrease block
 storage.

Ans: A

Question - 05

How does the Converged Database help to access data using an API?

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

data.

B. A REST API is automatically generated on top of SQL or stored procedures.

C. The database provides only one universal REST interfaces with makes integration of

applications extremely agile.

D. Developers can point their application to the location of ADB Wallet which integrates

all REST API calls.

Ans: B (Confirmed)

Question - 06

Which three are a part of the five key Lakehouse elements?

A. Data analysis
B. Managed open-source services
C. Data Catalog
D. Data load
E. Data Integration

Ans: A, B and C

Question - 07

What does ORDS stand for?

A. Oracle REST Data Services

B. Oracle Resilient Data Security
C. Oracle Rapid Data Systems
D. Oracle REAP Diagnosis Systems

Ans: A

Question - 08

Which two are objectives of Oracle's Data Management strategy?

A. Offer multiple integration points for 3rd party databases that work better for mixed
and analytic workloads.
B. Automate everything for developers, data analysts, DBAs and data scientists.
C. Provide the best platform for warehouse workloads only.
D. Provide for the fastest, most scalable converged SQL database.

Ans: A and D
Question - 09

What three typical data types/models are covered by Oracle’s Converged Database?

A. Events
B. Spatial
C. Terraform
D. Notifications
E. Graph
F. Relational

Ans: B, E and F (Confirmed)

Question - 10

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

A. UPDATE quarter_reference set Q1=012022"

B. SELECT * from EMPLOYEES;
C. CREATE index emp_id_idx on EMPLOYEES(emp_id);
D. SELECT SYSDATE from DUAL;

Ans: B (Confirmed)

Question - 11

What security control area determines if there is sensitive data in a system?

A. Users
B. Detect
C. Assess
D. Protect

Ans: B (Confirmed)

Question - 12

Which three can be selected when using the console to create an autonomous database on

an Autonomous Exadata Cloud@Customer?

A. workload type
B. amount of database storage required
C. amount of database OCPUs required
D. size of the shared global arca (SGA) to use
E. client network

Ans: A, B and C

Question - 13

The DBA has determined that number of OCPU assigned to an Autonomous Database does

not provide sufficient performance. Which option does the DBA have in this case?

A. Plan for a one-hour downtime and increase the number of OCPU while database is
offline.
 B. Call Oracle Cloud Support and raise a request to increase number of OCPU. Expect a

downtime of approximately one hour.

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

required.

D. 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.

Ans: C (Confirmed)

Question - 14

Which are two characteristics of Autonomous Transaction Processing (ATP)?

A. Optimized for response time

B. Focuses on creation of indexes
C. Stores data in columnar format
D. Creates autonomous data summaries
E. Statistics are gathered as part of bulk load operations

Ans:

Question - 15

Which Lakehouse service should you use for serverless Spark processing?

A. Oracle Analytics Cloud

B. OCI Object Storage
C. OCI Data Flow
D. OCI Data Catalog

Ans: C (Confirmed)

Question - 16

Multicloud strategy eliminates the reliance of a single cloud provider but also provides

which two advantages?

A. Duplication of data and applications

B. Ability to have private clouds and maintain customer data centers
C. Workload utilization of specific services
D. Compliance for use of specific geographies for data sovereignty laws

Ans: C and D

Question - 18

Which of the following helps avoid manual or exhaustive search techniques?

A. Auto Feature Selection

B. Auto Algorithm Selection
C. Auto Model Tuning
D. Adaptive Sampling
 E. Feature Prediction Impact

Ans: C

Question - 19

Oracle Data Lakehouse streamlines the integration, storage, and processing of data.

Which two services are used for persistence of the data in Lakehouse?

A. OCI Data Catalog

B. Autonomous Database
C. OCI GoldenGate
D. OCI Object Storage

Ans: B and D

Question - 20

How can the goal of scale out high availability be achieved?

A. By implementing Flashback
B. By provisioning nodes with Real Application Clusters
C. By implementing Active Data Guard
D. By using the Zero Data Loss Recovery Appliance

Ans: B

Question - 21

What is the FINAL release supporting the non-CDB architecture?

A. Oracle Database 21c

B. Oracle Database 19c
C. Oracle Database 23c
D. Oracle Database 18c

Ans: B (Confirmed)

Question - 22

When should you change COMPATIBLE?

A. When the database is stopped

B. After upgrades
C. After patching
D. After database downgrades

Ans: B (Confirmed)

Question - 23

Oracle Lakehouse provides extensive data processing capabilities, to accommodate the

migration of existing architectures or the creation of new, agile ones. Which service does

NOT provide data processing on Oracle Cloud Infrastructure (OCI) Lakehouse?

 A. Autonomous Database
B. NoSQL Service
C. Big Data Service
D. OCI Data Flow

Ans: B (Confirmed)

Question - 24

Which are two characteristics of Autonomous Data Warehouse (ADW)?

A. Focuses on creation of indexes

B. Creates data summaries
C. Statistics are gathered as part of DML operations
D. Stores data in row format
E. Optimized for complex SQL

Ans: C and E

Question - 25

What is the Oracle recommended way to upgrade databases?

A. Database Upgrade Assistant (DBUA)

B. Data Pump Export/Import
C. Command Line Upgrade
D. AutoUpgrade

Ans: D (Confirmed)

Question - 26

Which two statements about ORDS are true?

A. ORDS creates servlets for the Data Dictionary.

B. ORDS stores, manages and indexes JSON documents
C. ORDS is a low code development platform to build responsive applications.
D. ORDS makes REST APIs in the Oracle Database available

Ans: B and D

Question - 27

What set of NoSQL-style APIs can be used in Autonomous JSON Databases?

A. OASD (Oracle Application Storage Definition)

B. SODA (Simple Oracle Document Access)
C. DOSA (Document Open Solution Access)
D. OSDA (Oracle Simple Document Access)

Ans: B (Confirmed)

Question - 28

What are two characteristics of CI/CD?

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

 B. Development changes are automatically tested on push/commits and merges.
C. It requires Liquibase
D. It prevents developers from merging their code changes back to the shared branch
for security.

Ans: A and B (Confirmed)

Question - 29

Oracle Automated Machine Learning (AutoML) has options for using in-database and

opensource algorithms. Which is an example of an in-database option?

A. REST Interface
B. Cognitive text
C. Oracle machine Learning for Python (OML4PY) APIs
D. Tuning of hyperparameter

Ans: C (Confirmed)

Question - 30

Which is not a resource type for NoSQL Database cloud service?

A. NoSQL-indexes
B. NoSQL-rows
C. NoSQL-keys
D. NoSQL-tables

Ans: C

Question - 31

The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse

solution. What level of data detail does Data Catalog provide when integrated with

Autonomous Databases and Object storage?

A. Analytic environments
B. Data Warehouse
C. Source of managed services
D. View of data for discovery

Ans: D (Confirmed)

Question - 32

Which Oracle Cloud Infrastructure (OCI) service is NOT available as part of Oracle Cloud

Free Tier?

A. Autonomous Data Warehouse

B. Exadata DB Systems
C. Compute
D. Monitoring
Ans: B (Confirmed)

Question - 33

What is NOT a feature of the Oracle autonomous database to protect data from external

and internal threats?

A. Data is encrypted
B. Protects data from admin snooping using database vault
C. Security updates are applied online
D. Admin passwords are disabled after provisioning

Ans: D (Confirmed)

Question - 34

What are two characteristics of Oracle SQLcl (SQL Developer Command Line)?

A. Creates isolated development environments

B. Tracks database schema changes
C. Ability to execute SQL batch files
D. Available in the OCI Cloud Shell by default

Ans: C and D (Confirmed)

Question - 35

What are two important reasons to upgrade and patch?

A. Support Compliance
B. Validation of application
C. Security
D. Restructure the database

Ans: A and C (Confirmed)

Question - 36

Lakehouse on Oracle Cloud Infrastructure (OCI) is the platform for analyzing any data

for any insights. Which is NOT a component of this solution?

A. Oracle Autonomous Data Warehouse

B. OCI Data Flow
C. OCI Data Catalog
D. Oracle E-Business Suite
E. OCI Big Data Service

Ans: D (Confirmed)

Question - 37

What is NOT a workload that can be selected when provisioning an Autonomous

Database?

A. MySQL
 B. JSON
C. Data Warehouse
D. APEX

Ans: A (Confirmed)

Question - 38

Which two are true about the Data Catalog?

A. Management is required
B. Harvest object storage to derive schemas
C. Discover data using powerful search
D. Data Catalog does not integrate with Autonomous Database

Ans: Band C

Question - 39

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?

A. Allow only the Oracle Staff to perform control access

B. Operator Access Control can terminate Oracle operator connections
C. Allow network connections in the Oracle public cloud
D. Secure access configured to the customer network

Ans: B and D (Confirmed)

Question - 40

Which Oracle Cloud Infrastructure storage platform is used by MySQL Database

Service for all data storage?

A. Archive Storage
B. Object Storage
C. Block Volume Storage
D. Flash Local Storage
E. File Storage

Ans: C

Question - 41

Which statement is not the responsibility of the customer in a simple cloud management

model?

A. Manage database servers and VM hosts

B. Subscribe to database servers
C. Everything inside of the database
D. Control access to customer VMs
Ans: A

Question - 42

The Demand Side is data that is active and does something. What two data services are

typically, part of the demand side?

A. Data Models
B. Payloads
C. Inert algorithms
D. Authorization

Ans: A and B (Confirmed)

Question - 43

Which component is NOT included as part of an Oracle NoSQL table Oracle Cloud

Identifier (OCID)?

A. Resource type
B. Compartment ID
C. Region
D. Unique ID

Ans: C

Question - 44

Which command for the MySQL Data Service will resume OCPU billing?

A. Start
B. Stop
C. Restart
D. Backup

Ans: C

Question - 45

NoSQL Database Cloud Service supports all three types of big data. Which is NOT

considered big data?

A. Semi-structured data
B. Free-Structured data
C. Unstructured data
D. Structured data

Ans: B (Confirmed)

Question - 46

New hardware innovations of the Exadata X8M allow customers to take advantage of

Remote Direct Memory Access (RDMA).

 A. Compute Instances
B. Persistent Memory
C. Storage Disks
D. Database Servers

Ans: B (Confirmed)

Question - 47

Which statement is true about Autonomous Transaction Processing?

A. This used for OLTP and mixed workloads.

B. Data is stored in columnar format.
C. It is used for analytic workloads.
D. Tt is used with data marts and machine learning.

Ans: A

Question - 48

Which three are prerequisites for using the MySQL Database Service?

A. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure
B. You must create a tenancy and be able to sign in to it.
C. You must download the latest MySQL version from
A. https://edelivery.oracle.com
D. You must create a compartment to store your resources
E. You or Your group must be granted the policies described in Mandatory Policies

Ans: B, D and E (Confirmed)

Question - 49

Exadata is the integration of the software and hardware and is available to customers on

which deployments?

A. Only in a hybrid cloud

B. Only in public cloud environments
C. Only at the customer site
D. In the Oracle Cloud and customer site

Ans: D

Question - 50

Which statements are included in default configuration for automatic database backups?

A. Backups occur weekly

B. Archive redo log files are backed up every 30 minutes
C. Retention period is set at 14 days
D. Backups are executed on primary site

Ans: D

Question - 51
Which is NOT a prerequisite for patching Grid Infrastructure or database homes when

using the console?

A. Oracle Clusterware is down on the VM cluster.

B. All database compute nodes of the VM cluster are up and running.
C. The /u01 directory on the database host file system has at least 15 GB of free space for
the execution of patching processes.
D. The required patch is available on the Control Plane server.

Ans: A

Question - 52

Which two are key characteristics of Oracle Autonomous Database?

A. Lower cost
B. Oracle Manages everything
C. Higher cost
D. Less automated
E. Customer manages everything

Ans: A and B (Confirmed)

Question - 53

What is the primary goal of Oracle Maximum Availability Architecture of customer

systems?

A. Continuous Availability, network security and failover

B. Active Replication, Data Protection and continuous availability
C. Data Protection, access and reporting
D. Scale out, application availability and protection

Ans: B (Confirmed)

Question - 54

Which of the following has expanded flexibility with shared or dedicated Exadata

infrastructure?

A. Oracle Database Cloud Service

B. Oracle Exadata Cloud Service
C. Oracle Autonomous Database
D. Oracle Exalogic Cloud Service

Ans: C

Question - 55

Which service is used by default by the MySQL Database Service to store user data to

make it more resistant to failures?

A. OCI Block Volumes

 B. OCI File Storage
C. OCI Object Storage
D. OCI Data Safe

Ans: A (Confirmed)

Question - 56

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

A. Provide for the fastest, most scalable converged SQL database.

B. Automate everything for developers, data analysts, DBAs and data scientists.
C. Offer multiple integration points for 3" party databases that work better for mixed
and analytic workloads.
D. Provide the best platform for warehouse workloads only.

Ans: A and C

Question - 57

Which are the capabilities of Oracle Autonomous Database that can accelerate innovation?

(Choose 3)

A. Scaling of CPUs with very little downtime

B. Built-in AT and ML helps find patterns that could identify undiscovered anomalies
C. Instant scaling of storage
D. Provisions a data warehouse in seconds

Ans: A, B and C

Question - 58

Which Oracle Cloud Infrastructure (OCI) service is NOT available for provisioning in your

tenancy as an Always Free resource?

A. Load Balancing (one load balancer)

B. Autonomous Database (up to two database instances)
C. FastConnect (1 Gbps public peering)
D. Block Volume (up to 100 GB total storage)

Ans: C (Confirmed)

Question - 59

Which security measure is implemented out-of-the-hox, and is included if you are not

using BYOL licensing with Exadata Cloud@Customer?

A. Oracle Key Vault

B. Audit Vault and Database Firewall
C. Database Vault and Data Masking Pack
D. Oracle Native Network Encryption and TDE (Transparent Data Encryption)

Ans: D (Confirmed)
Question - 61

Where should your store unstructured, high volume data sets of unknown values for

best price/performance?

A. OCI Data Flow

B. OCI Data Catalog
C. OCI GoldenGate
D. OCI Object Storage

Ans: D (Confirmed)

Question - 62

Which is NOT an option in Database Actions to load data into Autonomous Database?

A. Load data from a local file such as text or Excel

B. Load data using FTP
C. Load data from a remote database
D. Load data using Data Pump
E. Load data from cloud storage (Oracle, S3, Azure, Google)

Ans: B

Question - 63

Which two statements are true when deciding which Oracle Cloud Infrastructure (OCI)

region to register an Exadata Cloud@Customer infrastructure in?

A. Consider any business policies or regulations that preclude the use of a particular
region.
B. Exadata Cloud@Customer is hosted in a customer data canter so the Exadata

infrastructure is not registered in an OCI region.

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

created.
D. Consider the Physical proximity of the region you register the infrastructure into your

data canter.

E. Consider which availability domain (within the region) to create the Exadata

Cloud@Customer infrastructure in

Ans: A and D (Confirmed)

Question - 64

Which two actions can be performed from the OCI Console for an Oracle Autonomous

Database?

A. Scale up/down CPU

B. Increase Network bandwidth
C. Scale up/down Memory
 D. Increase Storage allocated for Database

Ans: A and D

Question - 65

What are the two characteristics of CI/CD?

A. It prevents developers from merging their code changes back to the shared branch for
security
B. Development changes are automatically tested on push/commits and merges
C. It requires Liquibase
D. It introduces automation into all stages of app/database development.

Ans: B and D (Confirmed)

Question - 66

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

A. A DBA must enable ORDS first.

B. An Autonomous Database with the workload type Data Warehouse, Transaction
Processing, JSON or APEX.
C. APEX can only be used when selecting APEX as a workload when provisioning an
Autonomous Database.
D. DBA must create APEX admin and APEX users first before starting APEX from Oracle
Cloud Infrastructure Console.
E. APEX can simply be installed by downloading the executable from OTN.

Ans: B (Confirmed)

Question - 67

Which statements are true about built-in SQL Worksheet and Notebook? (Choose

two)

A. Based on Apache Tomcat

B. Need to install client query tool for the PL/SQL
C. No need to install a client query tool
D. Quickly start running queries with built-in web-based notebooks

Ans: C and D

Question - 68

Which two locations can be used to store your DB system database backups?

A. You can store your DB system database backups in on-premises local storage.
B. You can store your DB system database backups on locally attached block storage
volumes.
C. You can store your DB system database backups in Oracle Cloud Infrastructure
Object Storage.
D. You can store your DB system database backups locally in the Fast Recovery Arca
of the DB system.
Ans: A and C

Question - 69

What information is required to connect to the NoSQL Database Cloud Service?

A. User ID, tenancy ID, component ID

B. API Signing key, admin ID, user ID
C. Signing key fingerprint, API signing key, tenancy OCID
D. Tenancy ID, passphrase, handshake key

Ans: C (Confirmed)

Question - 70

Which Oracle Cloud Infrastructure (OCT) Identify and Access Management (IAM)

capability helps you to organize multiple users into teams?

A. Groups
B. Policies
C. Users
D. Roles

Ans: A (Confirmed)

Question - 71

Which migration types uses Datapump and GoldenGate tools?

A. Physical Migration
B. Logical Migration
C. Direct Connection
D. Indirect Connection

Ans: B

Question - 72

When customers are using the Exadata Cloud Service, what are they responsible for

managing?

A. Databases and Customer VM

B. Hypervisor and Internal Fabric
C. Internal Fabric and Customer VMs
D. Host VM and Storage

Ans: A (Confirmed)

Question - 73

A customer wants to use Oracle Cloud Infrastructure (OCI) for storing application backups

which can be stored for months but retrieved immediately based on business needs.

Which OCT storage service can be used to meet this requirement?

 A. Object Storage (Standard)
B. Archive Storage
C. File Storage
D. Block Volume

Ans: A (Confirmed)

Question - 74

Which two are true about the Autonomous JSON database?

A. Accessed via document APIs

B. Applications cannot be built without SQL
C. ADBA is required
D. Instant auto-scaling

Ans: A and D

Question - 75

Which two are key features of MySQL Database Service?

A. Regulatory Compliance: Uses advanced security to help clients meet industry and
regulatory compliance requirements, including GDPR, PCI, and HIPPA
B. In-Memory Lookups: Avoids unnecessary I/O operations by replacing storage indexes
with a few in-memory lookups
C. Integration with Oracle Technologies: Uses a client's existing Oracle investments and
easily integrates MySQL Database Service with Oracle technologies
D. Interactive Documents: Uses a built-in web-based notebook tool for designing and
sharing SQL-based data-driven scripts

Ans: A and C

Question - 76

Which workload CANNOT be run on Oracle Database 19¢?

A. Machine Learning
B. Translytical
C. Gaming
D. Hadoop Clusters

Ans: D (Confirmed)

Question - 77

What component is not included in a MySQL Database Service DB System?

A. Compute Instance
B. Virtual Network Interface
C. FastConnect
D. Block Storage

Ans: C

Question - 78
Which three data file formats can be loaded using Oracle Database Actions? (Choose all

correct answers)

A. JSON
B. AVRO
C. Csv
D. VSAM

Ans: A, B and C

Question - 79

A customer is looking to migrate their old database backups from their on-premises data

canter to Oracle Cloud Infrastructure (OCI). Which OCI service is the most cost-effective?

A. Object Storage (standard)

B. Block Volume
C. File Storage
D. Archive Storage

Ans: D (Confirmed)

Question - 80

Which ADB tool can you use to discover anomalies, outliers, and hidden patterns in your

Data?

A. Data Load
B. Data Insights
C. Data Transforms
D. Catalog

Ans: B

Question - 81

Which two target database environments provide both high availability (HA) and disaster

recovery (DR) options in the cloud?

A. Streaming Service
B. Compute VM
C. Exadata Cloud Service
D. Autonomous Database

Ans: C and D

Question - 82

In order to support multicloud strategies, what is offered as an industry first by Oracle?

A. Private and public cloud network

B. Cloud databases
C. Oracle FastConnect
 D. Dedicated cloud region

Ans: D (Confirmed)

Question - 83

What interconnect solutions are available to connect Oracle Cloud to other cloud

provider?

A. Virtual Cloud Network

B. Virtual Private Cloud
C. Cloud Router
D. FastConnect

Ans: D

Question - 84

What is a main feature of APEX's low code platform?

A. Use graphical interfaces and configuration for building web applications

B. Use traditional computer programming paradigms
C. Limited productivity
D. Build scalable web apps for MongoDB
E. Simplified core-based licensing

Ans: A

Question - 85

What connections to multiple public clouds are provided through 3 party connectivity?

A. Layer 3 and FastConnect

B. Virtual Cloud Networks (VCNs) and Amazon Virtual Private Cloud (VPC)
C. Megaport Cloud Router (MCR) and Virtual Cross Connect (VXC)
D. FastConnect and Direct Connect (SCC)

Ans: C (Confirmed)

Question - 86

Which self-service tools are available with the Autonomous Database?

A. Business Objects
B. Oracle Machine Learning
C. Low-Code App Dev, APEX
D. Encryption only in Object Storage

Ans: B and C

Question - 87

Which ability is NOT provided out of the box with the Autonomous Database Tools set?

A. Data Insight
B. Data Labelling
 C. Data Loading
D. Cataloging

Ans: A

Question - 88

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

resources?

A. OCI REST APIs

B. Remote Desktop Protocol (RDP)
C. OCI Command-line Interface (CLI)
D. Secure Shell (SSH)
E. Serial Console Connection (SCC)

Ans: A and C (Confirmed)

Question - 89

What are the three security zones of control?

A. Assess
B. Detect
C. Prevent
D. Solve

Ans: A, B and C

Question - 90

What are three platforms where Oracle's Autonomous Database service can be

deployed?

A. Hybrid Cloud Configurations

B. Dedicated Region Cloud at Customer
C. Oracle Cloud Infrastructure
D. AWS Cloud at Customer
E. Oracle Public Cloud at Customer

Ans: B,C and E

Question - 91

What are two main benefits of Oracle APEX?

A. Faster development time using hand coding

B. Less productivity compared to hand coding
C. Store data in PL/SQL objects
D. Develop responsive web apps
E. Rapidly develop, customize, and deliver secure applications

Ans: D and E (Confirmed)

Question - 92
Which three are required for provisioning an Oracle Autonomous Database instance?

A. Number of CPUs
B. Number of Tablespaces
C. Backup Location FRA Size
D. Workload Type

Ans: A, C and D

Question - 93

What does the Oracle Cloud Infrastructure (OCI) Data Catalog primarily provide for

data in the Lakehouse on OCI?

A. Converged Database
B. Data Integration
C. Analytic environment
D. Metadata source of truth
E. Machine Learning

Ans: D

Question - 94

Oracle Cloud and Microsoft azure have an interconnect for workloads across cloud.

Which two are also benefits this partnership and interconnect provide?

A. Upgrade compliance
B. Low Latency
C. Unified identity and access management
D. Connection to other multicloud environments

Ans: B and C (Confirmed)

Question - 95

Which feature allows you to logically group and isolate your oracle Cloud Infrastructure

resources?

A. Identity and Access Management Groups

B. Compartments
C. Tenancy
D. Availability Domain

Ans: B (Confirmed)

Question - 96

Which is NOT a key to successful database upgrades?

A. Download and install Oracle 19c

B. Download and use AutoUpgrade
C. Enable Performance Stability with SPM, STA, and RAT
D. Download and install newest RU
 E. Download and install oracle 21c

Ans: E

Question - 98

What are two characteristics of Oracle SQLcl (SQL Developer Command Line)?

A. Tracks database schema changes

B. Ability to execute SQL batch files
C. Available in the OCI Cloud Shell by default
D. Creates isolated development environments

Ans: B and C

Question - 99

Which is not true about Low Code?

A. Builds apps faster

B. Scalable
C. Accessible
D. Rich functionality with more code

Ans: D

Question - 100

Which deployment option provides the highest degree of security and governance

while providing a completely self-service database experience?

A. Exadata Cloud Service

B. Oracle Autonomous Database
C. Oracle Database Cloud Service
D. Oracle MySQL Database Service

Ans: B (Confirmed)

Question - 101

You have stopped the HeatWave cluster. Which two statements are correct?

A. Billing will stop for the HeatWave cluster.

B. The HeatWave cluster stop action will also stop DB System.
C. The HeatWave cluster data will remain loaded.
D. Billing will continue for the HeatWave cluster.
E. The data loaded in HeatWave cluster memory is lost.

Ans: A and E

Question - 102

Which two statements are true regarding MySQL Database Service HeatWave?

A. HeatWave is a in-memory, query-processing engine designed for fast execution of

analytic queries.
 B. HeatWave data which is needed for analytic processing is stored in disk files.
C. HeatWave uses periodic long-running ETL batch jobs to refresh the data.
D. HeatWave uses machine learning to automate operations, increasing DBA
productivity and reducing costs.

Ans: A and D