Oracle 1z0-908 - MySQL 8.0 Database Administrator
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?
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)
Which two statements are true about MySQL Enterprise Backup? (Choose two.)
Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full
copy-back
Which statement is true about the copy-back process?
Examine this command and output:
Which two statements are true? (Choose two.)
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user’s mysql credentials to satisfy this requirement? (Choose three.)
Examine this query:
What information does this query provide?
How can mysql_multi be configured to allow MySQL instances to use the same port number?
You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?
You want to dump all databases with names that start with "db".
Which command will achieve this?