Which command is used to start MySQL replication on a replica server?

• A.START SLAVE;
• B.START REPLICA;
• C.REPLICATE DATA;
• D.BEGIN REPLICATION;

Comment: *

Name: *

Email: *

Verification: *

Which MySQL replication mode is most vulnerable to data loss in the event of a primary server crash?

• A.Semi-synchronous replication
• B.Synchronous replication
• C.Asynchronous replication
• D.Multi-source replication

Comment: *

Name: *

Email: *

Verification: *

What is the role of the storage engine in MySQL architecture?

• A.To execute queries and return results to clients
• B.To handle data storage, retrieval, and indexing
• C.To manage user authentication and permissions
• D.To analyze query performance and provide optimization suggestions

Comment: *

Name: *

Email: *

Verification: *

Which MySQL log should be enabled to monitor failed connection attempts?

• A.Slow Query Log
• B.General Query Log
• C.Error Log
• D.Relay Log

Comment: *

Name: *

Email: *

Verification: *

Which option is used to specify the compression level in MySQL Enterprise Backup?

• A.--compress-level
• B.--compress
• C.--apply-log
• D.--incremental

Comment: *

Name: *

Email: *

Verification: *