1Z0-908Preview

Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?

Examine this query and its output:

Which two statements are true? (Choose two.)

Your my.cnf file contains these settings:

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

You recently upgraded your MySQL installation to MySQL 8.0.
Examine this client error:

Which option will allow this client to connect to MySQL Server?

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

Examine this partial output for InnoDB Cluster status:

Which statement explains the state of the instance deployed on host2?

Which three sets of item information are visible in the mysql system database? (Choose three.)

Examine this statement, which executes successfully:

Now examine this query:

You must add an index that can reduce the number of rows processed by the query.
Which two statements can do this? (Choose two.)

You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?

Which statement is true about InnoDB persistent index statistics?

Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

Which two statements are true about MySQL server multi-source replication? (Choose two.)

Which command enables rule-based MySQL Auditing capabilities?

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running
Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?

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

You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

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

You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)