Oracle 1z0-915-1 - MySQL HeatWave Implementation Associate Rel 1
You want to create a new DB system with data import. How do you prepare the data?
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?
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?
You have successfully enabled high availability of a stand-alone DB system. Which is true?
The following statements execute successfully:
CALL sys.ML_TRAIN(‘ml_data.iris’, ‘class’, NULL, @model);
SELECT @model;
Which three are true? (Choose three.)
Automatic backup retention of a DB system is disabled. Which operation deletes all automatic backups of the DB system?
Which MySQL HeatWave AutoML routine evaluates a model?
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?
Why would you select "Source cannot use GTID auto-positioning" when creating a channel?
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?