Oracle Cloud Data Management 2023 Foundations Associate

Question 1

The Oracle Cloud Infrastructure (OCI) Data Catalog is an integral part of the Lakehouse so-lution. What level of data detail does Data Catalog provide when integrated with Autonomous Databases and Object storage?

A. Analytic environments

B. Data Warehouse

C. View of data for discovery

D. Source of managed services

Correct Answer: C

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

Question 2

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. Open the database in OCI Console and increase the number of OCPU. No downtime required.

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

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

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.

Correct Answer: A

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

Question 3

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)

A. Authorization

B. Inert algorithms

C. Payloads

D. Data Models

Correct Answer: C,D

Question 4

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

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

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

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

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

Correct Answer: B,D

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

Question 5

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

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

Question 6

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

A. only in public cloud environments

B. only at the customer site

C. only in a hybrid cloud

D. in the Oracle Cloud and customer site

Correct Answer: D

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. Streaming Service

B. Autonomous Database

C. Exadata Cloud Service

D. Compute VM

Correct Answer: B,C

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

Question 8

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

A. By provisioning nodes with Real Application Clusters

B. By using the Zero Data Loss Recovery Appliance

C. By implementing Flashback

D. By implementing Active Data Guard

Correct Answer: A

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

Question 9

Lakehouse on Oracle Cloud Infrastructure (OCI) is the premier platform for analyzing any data for any insights. Which is NOT a component of this solution?

A. Oracle E-Business Suite

B. OCI Data Catalog

C. OCI Big Data Service

D. OCI Data Flow

E. Oracle Autonomous Data Warehouse

Correct Answer: B

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

Latest Update

Useful Links

Contact Us