Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

• A.ALTER TABLE world.city ADD INDEX (Population);
• B.ALTER TABLE world.city ADD INDEX (Name);
• C.ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
• D.ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
• E.ALTER TABLE world.city ADD SPATIAL INDEX (Population);
• F.ALTER TABLE world.city ADD SPATIAL INDEX (Name);

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about using backups of the binary log? (Choose two.)

• A.Binary logs can always be used to unapply unwanted schema changes.
• B.Multiple binary logs can be applied in parallel for faster data restoration.
• C.They allow for point-in-time recovery of the data.
• D.Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
• E.Multiple binary logs can be used to restore data.

Comment: *

Name: *

Email: *

Verification: *

Which command enables rule-based MySQL Auditing capabilities?

• A.mysql> INSTALL PLUGIN audit_log;
• B.mysql> INSTALL COMPONENT audit_log;
• C.shell> mysqld --initialize --log-raw=audit.log
• D.shell> mysql < audit_log_filter_linux_install.sql

Comment: *

Name: *

Email: *

Verification: *

Which two are characteristics of snapshot-based backups? (Choose two.)

• A.There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
• B.The frozen file system can be cloned to another virtual machine immediately into active service.
• C.A separate physical copy must be made before releasing the snapshot backup.
• D.Snapshot backups can be used only in virtual machines.
• E.Snapshot-based backups greatly reduce time during which the database and applications are unavailable.

Comment: *

Name: *

Email: *

Verification: *

You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

• A.audit log
• B.binary log
• C.slow query log
• D.general query log
• E.error log

Comment: *

Name: *

Email: *

Verification: *