Oracle Cloud Data Management 2022 Foundations Associate

Question 1

Which two statements are true regarding MySQL Database Service HeatWave? (Choose all correct answers)

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

B. HeatWave uses machine learning to automate operations, increasing DBA productivity and reducing costs.

C. HeatWave uses periodic long-running ETL batch jobs to refresh the data.

D. HeatWave data which is needed for analytic processing is stored in disk files.

Correct Answer: A,B

Question 2

Oracle Data Lakehouse streamlines the integration, storage, and processing of data. Which two services are used for persistence of the data in Lakehouse? (Choose all correct answers)

A. Autonomous Database

B. OCI Data Catalog

C. OCI Object Storage

D. OCI GoldenGate

Correct Answer: B,C

Question 3

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

Correct Answer: D

Question 4

Which statement is true about MySQL Database Service?

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

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

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

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

Correct Answer: C

Question 5

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

A. SODA (Simple Oracle Document Access)

B. OASD (Oracle Application Storage Definition)

C. DOSA (Document Open Solution Access)

D. OSDA (Oracle Simple Document Access)

Correct Answer: A

Question 6

Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures?

A. OCI File Storage

B. OCI Object Storage

C. OCI Block Volumes

D. OCI Data Safe

Correct Answer: C

Oracle Cloud Data Management 2022 Foundations Associate - 1z0-1105-22 Exam Practice Test

Latest Update

Useful Links

Contact Us