1Z1-888 무료 덤프문제 온라인 액세스

You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

• A.--single-transaction
• B.--quick
• C.--tab
• D.--skip-buffer

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

• A.export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
• B.SET GLOBAL mysql_cleartext_passwords=1;
• C.mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com
• D.mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
• E.INSTALL PLUGIN mysql_cleartext_password SONAME `mysql_cleartext_password.so';

You have been tasked with creating a QA MySQL instance on a DB host, which already has one large instance in /var/lib/mysql/running as the mysqluser. The MySQL configuration file for the existing instance includes:

The default instance was installed using the OS package manager. The latest binaries for both client and server are already in ENV PATH.
The new instance will run as a different user from the existing instance for security purposes.
You create the new data directory successfully and move on to initialize the new DATADIR.
You verify the output to confirm the operation's success:
[mysqlQA@linux /var/lib/]$ mysqld --initialize --datadir=/var/lib/mysql_QA 2>&1 | tail -n3
2018-05-03T12:16:10.928809Z 0 [ERROR] Could not open file '/var/log/mysqld.log' for error logging:
Permission denied
2018-05-03T12:16:10.928841Z 0 [ERROR] Aborting
[mysqlQA@linux /var/lib/]$
The initialization of the instance has failed.
What would you do to enable the initialization to succeed?

• A.Change permissions on /var/log/mysqld.log to allow writes.
• B.Use mysql_install_db.
• C.Pass --log-error=/var/lib/mysql_QA/mysqld.log.
• D.Use --no-defaults to ignore the existing config file in the default PATH.

What two statements are true regarding FLUSH TABLES FOR EXPORT?

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

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 MySQL PID file in the backup.
• B.Include the keyring data and/or configuration in the backup.
• C.Include the binary logs in the backup.
• D.Copy the backup to a remote host.
• E.Include the operating system disk encryption key in the backup.
• F.Include the MySQL socket file in the backup.
• G.Restore the backup to a clean MySQL instance.
• H.Include the relay logs in the backup.
• I.Include the ibtmp1 file in the backup.