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? (Choose two.)
A. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
B. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
C. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
D. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
E. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?
A. Run the create_system_tables.sql file
B. Run the mysql_unpack.sql file
C. Invoke mysqld with the --initialize option.
D. Invoke mysql with the --initialize option.
Host slave1 has ip address 192.0.2.10. Host slave2 has ip address 203.0.113.50
Examine these commands:
Why did this error occur?
A. The host on the command line is not defined in the login path.
B. The mysqld instance has not been restarted after creating the login path.
C. There is no password defined in the login path.
D. The DNS is not configured correctly for slave1 host.
E. The .mylogin.cnf file is not readable.
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUS indicates these values: RELAY_LOG_FILE=hostname-relay-bin.00004 RELAY_LOG_POS=1383
Which command set would make the slave current?
A. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = `hostname-relaybin.00004', RELAY_LOG_POS = 1383;
You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a
replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data
Encryption (TDE). Other than the configuration required to make the instance a replication master and
enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
It must be possible to rebuild the instance using the backup.
It must be verified.
It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)
A. Include the keyring data and/or configuration in the backup.
B. Restore the backup to a clean MySQL instance.
C. Copy the backup to a remote host.
D. Include the MySQL socket file in the backup.
E. Include the ibtmp1 file in the backup.
F. Include the relay logs in the backup.
G. Include the operating system disk encryption key in the backup.
H. Include the MySQL PID file in the backup.
I. Include the binary logs in the backup.
You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?
A. include-log-file
B. master-binlog
C. include-master-info
D. master-data
You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-dddeee:3 on a slave.
Which procedure would you execute from a MySQL prompt?
A. Option A
B. Option B
C. Option C
D. Option D
You are looking at these details:
Why does the message "Waiting for an event from Coordinator" show up on the slave_worker threads?
A. The Event Schedular is not enabled on the slave host.
B. The slave is waiting for an event to come into the relay log.
C. The slave thread is waiting for another event to finish in another slave thread.
D. The binary log on the master is not being updated.
Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?
A. mysqld -e 'shutdown'
B. service mysqld stop
C. mysqladmin shutdown
D. mysql -e 'shutdown'
You have issued this statement:
GRANT PROXY ON 'a' FOR 'b';
When user account 'b' issues a query, the query returns an access denied error.
What could have caused that error?
A. When connecting, user account 'b' is not entering the correct password for user account 'a'.
B. You have not set the proxy_user variable in the configuration file.
C. User account 'b' has not been granted permission to access the data being queried.
D. User account 'a' has not been granted permission to access the data being queried.
