New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Oracle 1z0-1105-22 Dumps Questions Answers

Page: 1 / 2
Total 55 questions

Oracle Cloud Data Management 2022 Foundations Associate Questions and Answers

Question 1

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

Options:

A.

Autonomous Data Warehouse

B.

Compute

C.

Exadata DB Systems

D.

Monitoring

Buy Now
Question 2

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

Options:

A.

Oracle MySQL Database Service

B.

Oracle Autonomous Database

C.

Oracle Database Cloud Service

D.

Exadata Cloud Service

Question 3

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?

Options:

A.

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

B.

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.

C.

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

D.

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

Question 4

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 5

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 6

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 7

Which Lakehouse service should you use for serverless Spark processing?

Options:

A.

OCI Data Flow

B.

Oracle Analytics Cloud

C.

OCI Object Storage

D.

OCI Data Catalog

Question 8

Which are two characteristics of Autonomous Transaction Processing (ATP)? (Choose all correct answers)

Options:

A.

Focuses on creation of indexes

B.

Stores data in columnar format

C.

Statistics are gathered as part of bulk load operations

D.

Optimized for response time

E.

Creates autonomous data summaries

Exam Detail
Vendor: Oracle
Exam Code: 1z0-1105-22
Last Update: Dec 22, 2024
1z0-1105-22 Question Answers
Page: 1 / 2
Total 55 questions