NO.10 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.)

NO.11 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?

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

NO.13 What is the benefit of creating a new DB system with data import?

NO.14 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?

NO.15 Which two are true about read replica load balancer? (Choose two.)

NO.16 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.)

NO.17 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?

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

NO.19 A MySQL DB system has an endpoint in an OCI VCN subnet. The VCN is not configured with VCN peering, VPN access, and FastConnect. You want to connect to the MySQL DB system directly from an OCI Cloud Shell session.
Which two are true? (Choose two.)

NO.20 You want to create a second user called admin2 with the same privileges as the administrator specified when creating the DB system.
Which statement helps you achieve this?

NO.21 Which three must be provided when creating a channel? (Choose three.)

NO.22 You create a MySQL DB system with default port numbers, and attach it to a subnet.
Which configuration is required on the subnet to enable client applications to connect to the DB system?

NO.23 You want to enable high availability of a stand-alone DB system. Which two conditions are required? (Choose two.)

NO.24 You want to restore the backup of a stand-alone DB system to a new DB system.
Which two changes are allowed? (Choose two.)

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

NO.26 You want to determine which version of MySQL is running on your DB system.
Which two SQL statements show the MySQL version? (Choose two.)

NO.27 A DB system has been deleted successfully. Which two operations are allowed on the deleted DB system?
(Choose two.)

NO.28 How can you determine the uptime of a DB system?

NO.29 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.)

NO.30 Which is true about automatic DB system version upgrades?

NO.31 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?

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

NO.33 The following statements are executed successfully:

Which two are true? (Choose two.)

NO.34 You run this command to connect successfully to a DB system:
mysqlsh [email protected] –auth-method=authentication_oci_client
Why does the command NOT require a password?