Oracle Cloud Data Management 2023 Foundations Associate (1z0-1105-23) Free Practice Test

Question 1

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

A. Compute Instances

B. Database Servers

C. Storage Disks

D. Persistent Memory

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

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

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

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

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

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

Correct Answer: B,C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

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

A. Domain objects

B. Technical definitions of business terms

C. Reports

D. Business rules

Correct Answer: A,D

Question 4

Which Lakehouse service should you use for serverless Spark processing?

A. Oracle Analytics Cloud

B. OCI Data Flow

C. OCI Object Storage

D. OCI Data Catalog

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

What are two typical reasons why customers CANNOT move their database into the public cloud? (Choose all correct answers)

A. Public cloud does not provide storage for more than 10TB

B. Regulations that prevent moving data into the public cloud

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

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

Correct Answer: B,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

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

A. Load data using Data Pump

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

C. Load data using FTP

D. Load data from a remote database

E. Load data from cloud storage (Oracle, S3, Azure, Google)

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

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

A. Exadata Cloud Service

B. Autonomous Database

C. Compute VM

D. Streaming Service

Correct Answer: A,B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

Which statement is true about moving virtual machine (VM) database (DB) systems fro one compartment to another?

A. You can move VM DB systems from one compartment to another by only using Oracle Cloud Infrastructure REST APIs.

B. You do not need access permissions to the compartment that the resource is being moved to when moving VM DB systems to a different compartment.

C. You have to move dependent resources like Database Homes and databases to the des-tination compartment before moving the VM DB system.

D. You can move DB systems to a different compartment if you have sufficient access permissions to the compartment that the resource is being moved to, as well as the cur-rent compartment.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Cloud Data Management 2023 Foundations Associate (1z0-1105-23) Free Practice Test