Exam Dumps VCE

QUESTION 19
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 20
Which two are true about MySQL HeatWave configuration resources? (Choose two.)

QUESTION 21
You want to change the configuration of an active stand-alone DB system. The DB system is configured as the target of a channel, and the channel is currently active.
Which sequence of steps must you perform?

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

QUESTION 23
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 24
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 25
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 26
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 27
Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.)

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

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

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

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

QUESTION 32
Which operation is necessary before enabling a MySQL HeatWave cluster?

QUESTION 33
Which two are true about creating a new DB system with data import? (Choose two.)

QUESTION 34
How can you determine the uptime of a DB system?

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

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

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

QUESTION 38
You want to replicate data from an on-premises MySQL server to a MySQL DB system. The on-premises MySQL server runs in your corporate network. The MySQL server accepts incoming connections from the Internet on a public IP endpoint.
The DB system runs in Oracle Cloud Infrastructure. The DB system endpoint is connected to a privatesubnet of a VCN.
Which network configuration is required?

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

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

QUESTION 41
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 42
Which sequence of steps must you perform to change the configuration of a high-availability DB system?

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