Oracle MySQL HeatWave Implementation Associate Rel 1 (1z0-915-1) Free Practice Test

Question 1

You want to deploy a high-availability MySQL DB system in a region with multiple availability domains.
Which two types of subnet provide maximum redundancy? (Choose two.)

A. A private AD-specific subnet

B. A public AD-specific subnet

C. A public regional subnet

D. A private regional subnet

Correct Answer: C,D

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

Question 2

Which placement is NOT valid for a high-availability DB system? (Note: AD refers to availability domain and FD refers to fault domain.)

A. Primary instance: AD1-FD1; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3

B. Primary instance: AD1-FD3; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3

C. Primary instance: AD1-FD3; Secondary instance 1: AD1-FD2; Secondary instance 2: AD1-FD3

D. Primary instance: AD1-FD1; Secondary instance 1: AD2-FD2; Secondary instance 2: AD3-FD3

Correct Answer: C

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

Question 3

You want to replicate data from an on-premises MySQL server to a MySQL DB system. The on-premises MySQL server runs in your corporate network. The MySQL server accepts incoming connections from the Internet on a public IP endpoint.
The DB system runs in Oracle Cloud Infrastructure. The DB system endpoint is connected to a privatesubnet of a VCN.
Which network configuration is required?

A. Create a NAT gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the NAT gateway.

B. Create an Internet gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the Internet gateway.

C. Create a service gateway in the VCN and configure the DB system subnet to route Internet-bound traffic to the service gateway.

D. Configure an OCI network load balancer to accept incoming connections on a public IP and route to the DB system private IP address.

Correct Answer: A

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

Question 4

Which sequence of steps must you perform to change the configuration of a high-availability DB system?

A. Edit and change the configuration of all secondary instances, switch over to a secondary instance, andedit and change the configuration of the former primary instance.

B. Disable high availability, edit the DB system, change the configuration, and enable high availability.

C. Stop the DB system, edit the DB system, change the configuration, and start the DB system.

D. Edit the DB system and change the configuration.

Correct Answer: C

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

Question 5

You have obtained a new tenancy on Oracle Cloud Infrastructure. You first create a VCN by using the VCN Wizard, and then create a MySQL DB system. You want to create a Connection in Database tools to use the SQL Worksheet feature.
Which three steps are required? (Choose three.)

A. Create an OCI password.

B. Create an OCI vault.

C. Import an X.509 certificate into the OCI vault.

D. Create an OCI secret.

E. Create an encryption key.

Correct Answer: A,C,D

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

Question 6

You want to train a model that predicts sales based on the available data the company holds.
This is an excerpt of thesalestable:

Which command trains the model?

A. CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'regression'), @model);

B. CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'anomaly_detection'),
@model);

C. CALL sys.mML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'forecasting'), @model);

D. CALL sys.ML_TRAIN('ml_data.sales', 'Sales', JSON_OBJECT('task', 'classification'), @model);

Correct Answer: A

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

Question 7

The following statements execute successfully:
CALL sys.ML_TRAIN('ml_data.iris', 'class', NULL, @model);
SELECT @model;
Which three are true? (Choose three.)

A. The statements create a classification model.

B. The generated model handle is shown in the output.

C. The statements validate the data set but do not create a model.

D. The training data set is obtained from the ml_data table in the iris schema.

E. The target column is class.

Correct Answer: A,B,E

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

Welcome to TestSimulate

Oracle MySQL HeatWave Implementation Associate Rel 1 (1z0-915-1) Free Practice Test