Instantly download 1Z0-888 training test engine

A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

• A. --single-transaction
• B. --skip-opt
• C. --create-apply-log
• D. --master-data
• E. --lock-all-tables

Which statement describes how the relay log works?

• A. It stores changes on the master, and relays them to the slave.
• B. It maintains a record of available master binary logs and the current executed log position.
• C. when a slave receives a change from the master, it is processed first, and then recorded in the relay log.
• D. When a slave receives a change from the master, it is recorded in the relay log first and processed later.

Which statement is true about tablespaces?

• A. The system tablespace can be configured to span multiple files.
• B. All tablespace files must be in the directory specified by the -datadir option.
• C. General tablespaces can be configured to span multiple files.
• D. All tables must be in either the system tablespace or a general tablespace.

To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

• A. Install the X509 plug-in on the server.
• B. Set the X509 option in the [client] section of the MySQL server's configuration file.
• C. Provide users access to the server's private key.
• D. Distribute client digital certificates to the client computers being used to log in by the user accounts.
• E. Restart the server with the --require-x509 option.

The MySQL user `adam' currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the -single-option.
transaction
Which extra GRANT permissions are required for adam to take mysqldump backups?

• A. The `adam' user must also have SELECT on the football database for backups to work.
• B. The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.
• C. The `adam' user must have the SUPER privilege in order to take data backups.
• D. The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.