1Z0-888 試験問題を無料オンラインアクセス

Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?

• A.mysqlpasswd
• B.mysql_config_editor
• C.mysqladmin
• D.mysqld_safe

Which statement best describes the purpose of the InnoDB buffer pool?

• A.It is a pool of memory for SQL query sort operations from within the InnoDB engine.
• B.It caches only the indexes for InnoDB tables.
• C.It holds changes made during a transaction before they are written to the log.
• D.It is amount of buffers available during a transaction.
• E.It caches data and indexes for InnoDB tables.

Which two general properties relate to the mysqlimport client program? (Choose two.)

• A.It can load files both on the client host and the server host.
• B.It bypasses the server and writes directly to the data files.
• C.It can be used to easily import full binary backups.
• D.It can load files only on the server host.
• E.It provides a command-line interface to the LOAD DATA INFILE.

A MySQL replication slave is set up as follows:
Uses all InnoDB tables
Receives ROW-based binary logs
Has the read-only option
The replication slave has been found in an error state. You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur?

• A.The applications have the SUPER privilege, which allows them to update rows.
• B.For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
• C.The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases > /data/data.sql
• D.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
• E.The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

You have a scheduled task on Linux that executes mysqldumpagainst the localhost server periodically.
When checking the logs of this event to ensure that things are working and that backups will restore, you notice an output that is concerning.
The command the scheduled task is executing as follows:
$ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --protocol=TCP
> /backups/latest.sql
Warning: Using a password on the command-line interface can be insecure.
Which two methods are available to avoid the warning? (Choose two.)

• A.Connect through the --socket rather than the default --protocol=TCP for local connection.
  $ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --socket=/tmp/mysql.sock > /backups/ latest.sql
• B.Use mysql_config_editor, which allows you to store encrypted login credentials in your home directory.
• C.Store your password in an option file eg: ~/.my.cnf and use --defaults-file so that it is read and used.
  [client]
  password=t100043va
• D.Use the password validation plugin available to improve user name and password strength.