Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-915-1 - MySQL HeatWave Implementation Associate Rel 1

Page: 1 / 2
Total 65 questions

You want to create a new DB system with data import. How do you prepare the data?

A.

Export the data into the file system with a MySQL Shell dump utility

B.

Export the data into anObject Storage bucket with a MySQL Shell dump utility.

C.

Back up the database into an Object Storage bucket with MySQL Enterprise Backup.

D.

Export the data into the file system with the mysqldump client utility.

You want to migrate an on-premises MySQL database to MySQL HeatWave by exporting the MySQL database with MySQL Shell util.dumpInstance.

What is the purpose of the ocimds: true option?

A.

It launches a new DB system and imports the data concurrently with the export operation.

B.

It enables all MySQL HeatWave compatibility options.

C.

It returns an error if the database has any incompatibilities with MySQL HeatWave.

D.

It stores the exported files in OCI Object Storage.

You run this command to connect successfully to a DB system:

mysqlsh john@10.0.1.122 --auth-method=authentication_oci_client

Why does the command NOT require a password?

A.

The credential is stored in an OCI vault secret.

B.

The operating system user credential is used to authenticate with the DB system.

C.

The correct API key-pair is specified in the -/. oci. config file.

D.

The correct password is saved in the local MySQL Shell secret store.

You have successfully enabled high availability of a stand-alone DB system. Which is true?

A.

The DB system performs load balancing by distributing client connections to all instances.

B.

The DB system provides new port numbers on the same endpoint to connect to the secondary instances for read-only connections.

C.

The DB system provides new endpoints to connect to the secondary instances for read-only connections.

D.

The DB system has three instances running in different availability or fault domains.

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 validate the data set but do not create a model.

B.

The generated model handle is shown in the output.

C.

The statements create a classification model.

D.

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

E.

The target column is class.

Automatic backup retention of a DB system is disabled. Which operation deletes all automatic backups of the DB system?

A.

Enabling point-in-time recovery

B.

Disabling delete protection

C.

Deleting the DB system

D.

Disabling point-in-time recovery

Which MySQL HeatWave AutoML routine evaluates a model?

A.

ML_EXPLAIN

B.

ML_EXPLAIN_TABLE

C.

ML_TRAIN

D.

ML_SCORE

E.

ML_PREDICT_TABLE

You have successfully provisioned a MySQL DB system on Oracle Cloud Infrastructure by using OCI Console. You have installed the standard MySQL client libraries and MySQL Shell on your workstation that is not connected to any VPN, FastConnect, or SSH tunnel.

You CANNOT connect directly to the DB system endpoint from your workstation connected to the Internet.

What is the reason?

A.

MySQL DB system allows only SSL-encrypted connections.

B.

MySQL DB system endpoint does not have a public IP address.

C.

MySQL DB system allows only connections through a proxy server.

D.

MySQL DB system cannot use the standard MySQL client libraries.

Why would you select "Source cannot use GTID auto-positioning" when creating a channel?

A.

The target DB system is a high-availability DB system.

B.

Some tables have no primary key

C.

The binary log offset is unknown.

D.

The source gtid mode is OFF.

You have a MySQL DB system with five active read replicas. The workload consists of 5% writes and 95% reads.

Which connection method provides the fastest query response time?

A.

Connect to the source DB system to perform read-only operations.

B.

Connect to a specific read replica to perform read-only operations.

C.

Connect to the read replica load balancer to perform read-only operations.

D.

Connect to the read replica load balancer to perform read/write operations.