Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Oracle 1z0-1105-23 Oracle Cloud Data Management 2023 Foundations Associate Exam Practice Test

Demo: 23 questions
Total 79 questions

Oracle Cloud Data Management 2023 Foundations Associate Questions and Answers

Question 1

Which two target database environments provide both high availability (HA) and disaster re-covery (DR) options in the cloud? (Choose all correct answers)

Options:

A.

Streaming Service

B.

Compute VM

C.

Exadata Cloud Service

D.

Autonomous Database

Question 2

What are two important reasons to upgrade and patch? (Choose all correct answers)

Options:

A.

Restructure the database

B.

Security

C.

Validation of application

D.

Support Compliance

Question 3

Which is NOT a resource type for NoSQL Database Cloud Service?

Options:

A.

Nosql-keys

B.

Nosql-indexes

C.

Nosql-rows

D.

Nosql-tables

Question 4

Which Oracle Cloud Infrastructure (OCI) service is NOT available for provisioning in your tenancy as an Always Free resource?

Options:

A.

Connect (1Gbps public peering)

B.

Block Volume (up to 100 GB total storage)

C.

Load Balancing (one load balancer)

D.

Autonomous Database (up to two database instances)

Question 5

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

Options:

A.

Private and public cloud network

B.

Oracle FastConnect

C.

Dedicated cloud region

D.

Cloud databases

Question 6

What does ORDS stand for?

Options:

A.

Oracle Resilient Data Security

B.

Oracle REAP Diagnosis Systems

C.

Oracle Rapid Data Systems

D.

Oracle REST Data Services

Question 7

Which two are objectives of Oracle's Data Management strategy? (Choose all correct answers)

Options:

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 for the fastest, most scalable converged SQL database.

D.

Provide the best platform for warehouse workloads only.

Question 8

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

Options:

A.

Exadata Cloud@Customer is hosted in 4 customer data center so the Exadata infrastructure is not registered in an region.

B.

Consider any business polices or regulations that preclude the use of a particular report The Exadata Cloud@Customer region can be changed after the infrastructure is created.

C.

Consider which availability domain (within the region) to create the Exadata Cloud#Customer infrastructure

D.

Consider the physical proximity of the region you register the infrastructure m to your data center.

Question 9

Which statement is true about MySQL Database Service?

Options:

A.

Its users are responsible for database and operating system patching tasks.

B.

It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine.

C.

It is a public cloud service built on MySQL Community Edition.

D.

It is a fully managed Oracle Cloud Infrastructure (OCI) native service.

Question 10

Which three are prerequisites for using the MySQL Database Service? (Choose all correct answers)

Options:

A.

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

B.

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

C.

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

D.

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

You must create a compartment to store your resources

Question 11

What are two characteristics of Oracle SQLcl (SQL Developer Command Line)? (Choose all correct answers)

Options:

A.

Tracks database schema changes

B.

Creates isolated development environments

C.

Available in the OCI Cloud Shell by default

D.

Ability to execute SQL batch files

Question 12

New hardware innovations of the Exadata X8M allow customers to take advantage of Remote Direct Memory Access (RDMA). What resource does RDMA access?

Options:

A.

Storage Disks

B.

Database Servers

C.

Persistent Memory

D.

Compute Instances

Question 13

The Demand Side is data that is active and does something. What two data services are typi-cally part of the demand side? (Choose all correct answers)

Options:

A.

Inert algorithms

B.

Authorization

C.

Payloads

D.

Data Models

Question 14

The Supply Side is data that is passive and means something. What two models and libraries are included in the supply side?

Options:

A.

Reports

B.

Technical definitions of business terms

C.

Business rules

D.

Domain objects

Question 15

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

Options:

A.

The database provides only one universal RES interface which makes integration of applications extremely agile.

B.

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

C.

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

D.

Developer can point their application to the location of ADB Wallet which integration all REST API calls.

Question 16

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

Options:

A.

in the Oracle Cloud and customer site

B.

only at the customer site

C.

only in a hybrid cloud

D.

only in public cloud environments

Question 17

Which two are key features of MySQL Database Service?

Options:

A.

Integration with Oracle Technologies: Uses a diem s existing Oracle investments and easily integrates MySQL Database Service with Oracle technologies

B.

inter active Documents: Uses a built-in web-based notebook tool for designing and sharing SQL-based data-driven scripts

C.

in Memory Lookups: Avoids unnecessary I/O operations by replacing storage indexes with a few m memory lookups

D.

Regulatory Compliance: Uses advanced security to help clients meet industry and regulatory compliance requirements. including GDPR, PCI, and HIPPA

Question 18

Which component is NOT included as part of an Oracle NoSQL table Oracle Cloud Identifier (OCID)?

Options:

A.

Compartment ID

B.

Resource type

C.

Region

D.

Unique ID

Question 19

Multicloud strategy eliminates the reliance of a single cloud provider but also provides which two advantages? (Choose all correct answers)

Options:

A.

Ability to have private clouds and maintain customer data centers

B.

Compliance for use of specific geographies for data sovereignty laws

C.

Duplication of data and applications

D.

Workload utilization of specific services

Question 20

Which three data file formats can be loaded using Oracle Database Actions? (Choose all cor-rect answers)

Options:

A.

JSON

B.

AVRO

C.

CSV

D.

VSAM

E.

Continue

F.

Retake test

Question 21

Which tool is provided to support Continuous Integration/Continuous Deliver (CI/CD) work-flows?

Options:

A.

Database Actions (including real time SQL monitor)

B.

ADB console (including Performance Hub)

C.

SQLcl (including Liquibase)

D.

SQL Developer (including ADB wallet)

Question 22

A customer is looking to migrate their old database backups from their on-premises data center to Oracle Cloud Infrastructure (OCI).

Which OCI service is the most cost-effective?

Options:

A.

Block Volume

B.

Archive Storage

C.

File Storage

D.

Object Storage (standard)

Question 23

Oracle & Automated Machine Learning (AutoML) has options for using in-database and opensource algorithms. Which is an example of an in-database option?

Options:

A.

Tuning of hyperparameter

B.

Oracle Machine Learning for Python (OML4Py) APIs

C.

REST Interface

D.

Cognitive text

Demo: 23 questions
Total 79 questions