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.error log
• B.binary log
• C.audit log
• D.slow query log
• E.general query log

Comment: *

Name: *

Email: *

Verification: *

You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

• A.*.CSM files
• B.ibbackup files
• C.ib_logfile* files
• D.*.sdi files
• E.*.ibd files

Comment: *

Name: *

Email: *

Verification: *

Which two MySQL Server accounts are locked by default? (Choose two.)

• A.any user created without a password
• B.any internal system accounts
• C.any user created with a username, but missing the host name
• D.any new ROLE accounts
• E.any user set as DEFINER for stored programs

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about InnoDB persistent index statistics?

• A.Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
• B.Updating index statistics is an I/O expensive operation.
• C.Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
• D.Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
• E.Tables are scanned and index statistics recalculated when an instance is restarted.
• F.Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Comment: *

Name: *

Email: *

Verification: *

Examine this command, which executes successfully:
mysqlpump -–user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)

• A.information_schema
• B.world
• C.employee
• D.sys
• E.mysql

Comment: *

Name: *

Email: *

Verification: *