Which command is used to rename an existing MySQL user?

• A.RENAME USER 'old_user'@'host' TO 'new_user'@'host';
• B.ALTER USER 'old_user'@'host' TO 'new_user'@'host';
• C.UPDATE USER SET NAME = 'new_user';
• D.CHANGE USER 'old_user' TO 'new_user';

Comment: *

Name: *

Email: *

Verification: *

What does the --incremental option in mysqlbackup do?

• A.Backs up only the binary logs
• B.Backs up only the database structure
• C.Backs up only the changes since the last backup
• D.Restores the database from a previous backup

Comment: *

Name: *

Email: *

Verification: *

Which option allows MySQL Enterprise Backup to encrypt backup data for security purposes?

• A.--encrypt
• B.--backup-encryption
• C.--apply-log
• D.--backup-secure

Comment: *

Name: *

Email: *

Verification: *

How does HeatWave improve the performance of MySQL Database Service for analytical queries?

• A.By compressing data before processing
• B.By parallelizing query execution across multiple nodes
• C.By reducing the replication overhead
• D.By caching queries on disk

Comment: *

Name: *

Email: *

Verification: *

Which replication configuration would you use for disaster recovery by keeping a real-time copy of the primary server at a remote location?

• A.Multi-source replication
• B.Primary-replica replication
• C.Circular replication
• D.Multi-primary replication

Comment: *

Name: *

Email: *

Verification: *