1z0-908 Practice Test

1z0-908 Practice Test practice questions, page 4 of 9, with answer review and explanations.

Question 16

Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’. Which command will do this?

  1. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
  2. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
  3. mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
  4. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql

Question 17

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

  1. It reconfigures InnoDB Cluster if the cluster was stopped.
  2. It performs InnoDB Cluster instances rolling restart.
  3. It only starts all InnoDB Cluster instances.
  4. It is not mandatory that all instances are running and reachable before running the command.
  5. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
  6. It only stops and restarts all InnoDB Cluster instances.
  7. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Question 18

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

  1. It is not compatible with auto-positioning.
  2. It needs to be re-instanced after a crash to maintain consistency.
  3. It uses only time-based replication conflict resolution.
  4. It relies on relay_log_recovery for resilient operations.
  5. It does not attempt to detect or resolve replication conflicts.
  6. It must use GTID replication.

Question 19

Which command enables rule-based MySQL Auditing capabilities?

  1. shell> mysql < audit_log_filter_linux_install.sql
  2. shell> mysqld --initialize --log-raw=audit.log
  3. mysql> INSTALL PLUGIN audit_log;
  4. mysql> INSTALL COMPONENT audit_log;

Question 20

Examine this SQL statement: mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION; Which two are true? (Choose two.)

  1. Mark can grant the privileges assigned to the r_read@localhost role to another user.
  2. ADMIN OPTION causes the role to be activated by default.
  3. Mark can grant the r_read@localhost role to another user.
  4. Mark can revoke the r_read@localhost role from another role.
  5. ADMIN OPTION allows Mark to drop the role.
  6. Mark must connect from localhost to activate the r_read@localhost role.