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

You have an inbound replication channel that replicates data from one DB system to another DB system. Both DB systems are created with the default configuration.

You encountered the following error on the target DB system:

What is the possible cause?

A.

The missingGTID set has been archived to object storage and is no longer available.

B.

The target DB system relay log file destination is full.

C.

The channel has been disabled for more than 2 hours.

D.

The administrator has deleted the binary log files from the source DB system.

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

A.

High availability

B.

Lakehouse

C.

Standalone server

D.

Read replica

E.

HeatWave cluster

You want to determine which version of MySQL is running on your DB system.

Which two SQL statements show the MySQL version? (Choose two.)

A.

SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME=’version’;

B.

select @@version;

C.

SHOW VARIABLES LIKE ‘version’;

D.

SHOW STATUS LIKE ‘version’;

E.

SELECT @version;

Which is true about dynamic variables in MySQL HeatWave configurations?

A.

Initialization variables are not dynamic.

B.

Changes in dynamic variables require a server restart.

C.

Dynamic variables in a custom configuration can be changed without copying the configuration to a new configuration.

D.

All user variables are dynamic.

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

A.

Generate a load command to activate Auto Parallel Load.

B.

Estimate the number of OCPUs required to process selected user tables.

C.

Estimate the memory required for each user table.

D.

Generate a set of alter statements to load selected tables into the HeatWave cluster.

E.

Estimate the disk storage required for each user table.

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?

A.

MySQL DB system allows only SSL-encrypted connections.

B.

MySQL DB system endpoint does not have a public IP address.

C.

MySQL DB system allows only connections through a proxy server.

D.

MySQL DB system cannot use the standard MySQL client libraries.

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

A.

Change the storage size.

B.

Create a manual backup.

C.

Restore the DB system from an existing manual backup.

D.

View the metrics.

E.

View the API call logs on the Audit page.

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

A.

Create an OCI password.

B.

Create an encryption key.

C.

Create an OCI vault.

D.

Create an OCI secret.

E.

Import an X.509 certificate into the OCI vault.

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

A.

Faster import with minimal logging

B.

Smaller storage size with better compression

C.

Faster backup with a first full backup

D.

Consistent data with no user connection