1Z0-908 Online Practice Questions and Answers

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

An existing asynchronous replication setup is running MySQL 8.

Which two steps are a part of implementing GTID replication? (Choose two.)

A. Enable GTID by executing this on the master and the slave: SET GLOBAL GTID_ENABLED=on;

B. Execute this on the slave to enable GTID: START SLAVE IO_THREAD WITH GTID;

C. Restart MySQL (master and slave) with these options enabled: --gtid_mode=ON --log-bin --log-slave-updates --enforce-gtid-consistency

D. Execute this on the slave to enable GTID: RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

E. On the slave, alter the MySQL master connection setting with: ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

F. On the slave, alter the MySQL master connection setting with: CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

Examine this command, which executes successfully:

Which statement is true?

A. Only files for MySQL or Its built-in storage engines are backed

B. Only non-encrypted files are backed up.

C. The backup includes only data files and their metadata.

D. Only InnoDB data and log files are backed up.

E. Only tables stored in their own tablespaces are backed up.

You have semi-synchronous replication configured and working with one slave. rpl_semi_sync_master_timeout has never been reached.

You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable. Which two statements are true? (Choose two.)

A. No committed transactions are lost.

B. The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.

C. As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.

D. Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.

E. Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.

F. A small amount of committed transactions may be lost in case they were committed just before the disk failure.

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?

A. The slave relay logs should be deleted; then execute START SLAVE;

B. The relay logs from the master should be used to replace the corrupted relay logs.

C. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D. The slave needs to be restored from backup.

Examine this statement: mysql> DROP ROLE r_role1, r_role2; Which two are true? (Choose two.)

A. It fails if any of the roles is specified in the mandatory_roles variable.

B. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

C. Existing connections can continue to use the roles' privileges until they reconnect.

D. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.

E. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.

F. It fails if at least one of the roles does not exist.

Examine this list of MySQL data directory binary logs:

binlog.000001 binlog.000002

.....

binlog.000289

binlog.000300

binlog.000301

binlog.index

Now examine this command, which executes successfully:

mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql

Which two are true? (Choose two.)

A. All databases are backed up to the output file.

B. All non-active binary logs are removed from the master.

C. All binary logs are deleted from the master.

D. All binary logs are backed up and then deleted.

E. All databases, excluding master metadata, are backed up to the output file.

F. All details regarding deleted logs and master metadata are captured in the output file.

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

A. Run MySQL Server docker containers.

B. Use systemd with different settings for each instance.

C. Use system tools to lock each instance to its own CPU.

D. Start mysqld or mysqld_safe using different option files for each instance.

E. Run mysqld with --datadir defined for each instance.

F. Use resource groups to lock different instances on separate CPUs.

There are five MySQL instances configured with a working group replication. Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

A. The cluster will shut down to preserve data consistency.

B. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

C. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

D. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

E. A manual intervention to force group members to be only the working two instances is required.

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

A. Increase the number of buffer pool instances to 16.

B. Increase the number of buffer pool instances to 32.

C. Decrease the number of buffer pool instances to 1.

D. Increase the number of buffer pool instances to 12.

E. Decrease the number of buffer pool instances to 4.