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

Which three are features of MySQL AutoPilot? (Choose three.)

A.

Auto backup

B.

Auto thread pooling

C.

Auto encoding

D.

Auto provisioning

E.

AutoML

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.

A query is not offloaded to the HeatWave cluster for execution. Which three are possible reasons? (Choose three.)

A.

The use_secondary_engine session variable is OFF.

B.

The client is connected to the DB system instead of the HeatWave cluster.

C.

The query estimated cost is less than the query cost threshold.

D.

The user does not have privileges to access the HeatWave cluster.

E.

A required column is excluded from the RAPID secondary engine.

What must you do to minimize a DB system down time caused by automatic maintenance operations?

A.

Create read replicas.

B.

Add HeatWave cluster.

C.

Enable crash recovery.

D.

Enable high availability.

Which is true about exporting data to Object Storage with MySQL Shell util.dumpInstance?

A.

You must have a valid OCI CLI configuration.

B.

You must specify ociParManifest: true.

C.

You must specify ocimds: true.

D.

You must provide an OCI username and password to gain write access to Object Storage.

There are more than 10 concurrent users running queries on the DB system. The airport_geo table has been loaded successfully into a HeatWave cluster.

You want to run this query:

SELECT DISTINCT country FROM airport_geo ORDER BY country;

How do you determine whether the query is offloaded to the HeatWave cluster for execution?

A.

View the Query Execution Plan of the query by running EXPLAIN.

B.

Check the value of the rapid_query_offload_count global status variable.

C.

Query the rpd_tables table in performance_schema.

D.

Check the value of the hw_data_scanned global status variable.

Which two are true about creating a Bastion service to connect to a MySQL DB system? (Choose two.)

A.

The Bastion service must have a public IP address.

B.

The Bastion service must be in the same VCN as the DB system.

C.

The Bastion CIDR block allowlist must include the IP address of all valid client machines.

D.

The Bastion CIDR block allowlist must include the IP address of the DB system.

E.

TheBastion subnet must have an ingress rule to allow stateful connections on the MvSQL DB system port number.

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 want to import data into a DB system with MySQL Shell util.loadDump().

Which option can speed up the load?

A.

updateGtidSet: off

B.

showMetadata: false

C.

skipBinlog: true

D.

deferTableIndexes: all

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.