You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave?

1. A. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
2. B. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
3. C. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
4. D. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
5. E. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Correct Answer: BE

What two statements are true regarding FLUSH TABLES FOR EXPORT?

1. A. It can be used to export TEMPORARY tables.
2. B. Table only exports when the table has its own tablespace.
3. C. The InnoDB Storage engine must be used for the table being exported.
4. D. It is the safest way to extract tables from the shared tablespace.
5. E. Partitioned tables are not supporte

Correct Answer: AB

You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?

1. A. The access does not take effect until the user logs out and back in.
2. B. The access does not take effect until the next time the server is started.
3. C. The access is available immediately.
4. D. The access does not take effect until you issue the FLUSH PRIVILEGES statemen

Correct Answer: C

Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

1. A. Set isolation level to be SERIALIZABLE.
2. B. Use the binary log row format.
3. C. Set isolation level to be READ COMMITTED.
4. D. Configure IPv6 network for hosts.
5. E. Guarantee a secondary index on every table.
6. F. Guarantee a primary key on every table.
7. G. Set multiple slave parallel worker thread

Correct Answer: ABF

Which three statements correctly describe MySQL InnoDBCluster?

1. A. The cluster can be operated in multimaster mode with conflict detection for DML statements.
2. B. All MySQL client programs and connectors can be used for executing queries.
3. C. It provides fully synchronous replication between the nodes.
4. D. There is support for automatic failover when one node fails.
5. E. The data is automatically shared between the nodes.
6. F. Each query will be executed in parallel across the node

Correct Answer: BDF