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

QUESTION 18
Which two methods can you use to import data into a MySQL DB system by using MySQL Shell? (Choose two.)

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

QUESTION 20
Which feature do you use to copy transactions from an on-premises MySQL instance to a DB system?

QUESTION 21
Which two are true about read replica load balancer? (Choose two.)

QUESTION 22
You can perform a node estimate when adding a HeatWave cluster to a DB system in OCI Console. Which two tasks are performed by the node estimate process? (Choose two.)

QUESTION 23
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?

QUESTION 24
The following statements are executed successfully:

Which two are true? (Choose two.)

QUESTION 25
Which type of configuration variables CANNOT be modified in MySQL custom configurations?

QUESTION 26
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.)

QUESTION 27
You want to restore a stand-alone DB system to a high-availability DB system with a point-in-time recovery.
Which three are required? (Choose three.)

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

QUESTION 29
You create a new MySQL DB system. It fails because you use mysql.sys as the administrator username.
What is the reason?

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

QUESTION 31
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?

QUESTION 32
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?

QUESTION 33
Which table option defines a Lakehouse external table based on a CSV file?

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

QUESTION 35
Which two are true about data loaded into a MySQL HeatWave cluster? (Choose two.)

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

QUESTION 37
Which is true about automatic DB system version upgrades?

QUESTION 38
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.)

QUESTION 39
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?

QUESTION 40
Which three must be provided when creating a channel? (Choose three.)

QUESTION 41
Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.)