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: 2 / 2
Total 65 questions

A port-forwarding Bastion session has been created for a MySQL DB system listening on 10.10.1.187:3306. The SSH command provided by the Bastion session is:

An SSH tunnel is created successfully on a client machine by running this command:

Which command connects to the MySQL DB System from the client machine?

A.

mysqlsh mysql://admin@10.10.1.187:3311

B.

mysqlsh mysql://admin@127.0.0.1:3306

C.

mysqlsh mysql://admin@127.0.0.1:3311

D.

mysqlsh mysql://admin@10.10.1.187:3306

Which three operations can be performed on a MySQL HeatWave backup? (Choose three.)

A.

Delete an active manual backup when point-in-time recovery is enabled on the DB system.

B.

Change the retention period of an active manual backup.

C.

Restore an active backup to a new DB system in another region.

D.

Change the retention period of an active automatic backup.

E.

Move an active backup to another compartment.

The following statements are executed successfully:

Which two are true? (Choose two.)

A.

The data placement key of the airport table is airport_id.

B.

The airport.tbl file is in CSV format.

C.

The fields in the airport.tbl file are delimited by comma.

D.

The data of the airport table is loaded into the MySQL DB system.

E.

Every row in the airport table has a unique airport_id value.

Which is true about automatic DB system version upgrades?

A.

You must specify the next version to be used before the upgrade.

B.

The DB system is never upgraded automatically.

C.

The DB system is upgraded to the next release in sequence.

D.

The DB system is upgraded to the most recent release.

You create a new MySQL DB system. It fails because you use mysql.sys as the administrator username.

What is the reason?

A.

mysql.sys is a reserved username that cannot be used in customer-defined user accounts.

B.

The username can contain only uppercase characters.

C.

The username cannot contain non-alphanumeric characters, such as a period.

D.

The username must have at least 10 characters.

Which two are benefits of read replicas? (Choose two.)

A.

Reduce query latency.

B.

Reduce down time.

C.

Reduce network latency.

D.

Scale read queries.

E.

Speed up analytical queries.

What must be enabled for using the point-in-time recovery feature in a DB system?

A.

Delete protection

B.

Automatic backups

C.

High availability

D.

HeatWave cluster

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 encryption key.

C.

Create an OCI vault.

D.

Create an OCI secret.

E.

Import an X.509 certificate into the OCI vault.

Which operation is necessary before enabling a MySQL HeatWave cluster?

A.

Start Cloud Shell in OCI Console connected to the DB system's network.

B.

Create all the schemas and tables in the DB system but do not load the data.

C.

Offload the data to object storage to facilitate reloading into the cluster.

D.

Create a DB system with a HeatWave shape.