[2022年更新]合格できる1Z0-888試験にはリアルな問題解答 [Q68-Q86]

[2022年更新]合格できる1Z0-888試験にはリアルな問題解答

1Z0-888試験問題ゲット最新[2022]と正解回答

質問 68
Which statement best describes the purpose of the InnoDB buffer pool?

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

正解: D

解説:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html

質問 69
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? (Choose two.)

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

正解: C,E

質問 70
You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?

A. You receive a syntax error that indicates that you cannot set a password and expire it at the same time.
B. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
C. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.
D. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.

正解: D

解説:
mysql> CREATE USER 'erika'@'localhost' IDENTIFIED BY 'first#1Pass' PASSWORD EXPIRE; mysql -u erika -pfirst#1Pass -hlocalhost mysql> use db1; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> show variables;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

質問 71
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)

A. THREAD_ID 21 has stopped running.
B. The slave is configured with slave_parallel_workers = 4
C. The salve has two intermediate relay slaves connected to it.
D. At most, two schemas are being updates concurrently.
E. The server needs more cores to use all slave threads.
F. The slave cannot process the relay log fast enough to use all threads.

正解: B,F

質問 72
An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid explanation for why one of the users is unable to connect to the database?

A. All users are blocked because max_user_connections is accumulated over the host account information.
B. Kay is already connected elsewhere and attempting to log in again.
C. Joe has exceeded the max_user_connections global limit.
D. Bob has max_user_connections set to zero, which blocks all his connections.
E. connect_timeout is too small to allow a connection to occur.

正解: C

質問 73
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

A. to allow the remaining events to be processed on the slave while not receiving new events from the master
B. to allow for point-in-time recovery on the slave
C. to prevent any transaction experiencing a deadlock
D. to allow a backup to be created under reduced load
E. to prevent schema changes from propagating to the slave before they are validated

正解: B,D

質問 74
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)

A. THREAD_ID 21 has stopped running.
B. The slave is configured with slave_parallel_workers = 4
C. At most, two schemas are being updates concurrently.
D. The server needs more cores to use all slave threads.
E. The slave cannot process the relay log fast enough to use all threads.
F. The slave has two intermediate relay slaves connected to it.

正解: B,E

質問 75
An administrator installs MySQL to run under a mysqlOS account. The administrator decides to disable logins to the mysqlaccount by using /nologinor /bin/falseas the user's shell setting.
Which statement is true?

A. This prevents mysqldfrom starting when standard startup scripts are used.
B. The OS needs to allow logging in as mysqlso that administrative tasks can be performed.
C. This prevents creation of a command shell with the mysqlaccount, while allowing mysqldto run.
D. The mysqluser needs a login and its home directory must be the base directory of the installation.

正解: D

解説:
Explanation/Reference:

質問 76
A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

A. The sync_relay_log=1000 setting on the slave is too small.
B. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
C. binlog_format=STATEMENT and a non-deterministic query was executed.
D. sync_binlog=0 and the master server crashed.
E. binlog_cache_size=1024 is too small and transactions are lost.

正解: B,E

質問 77
Consider:

Which statement best describes the meaning of the values in the ref columns?

A. No indexed columns are used to select rows from the Countrytable. The world.City.CountryCode column is used to select rows in the City table.
B. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.
C. world.City.CountryCode is used to sort the rows in the Citytable.
D. world.City.CountryCodeis used as the primary key for the Country table.

正解: B

質問 78
Which three tasks are handled by the optimizer? (Choose three.)

A. Rewrite the WHEREclause.
B. Verify that the user is allowed to execute the query.
C. Change the order in which the tables are joined.
D. Execute the query.
E. Parse the query.
F. Decide which indexes to use.
G. Validate the query.

正解: A,D,E

質問 79
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)

A. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';
B. CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
'imbatman';
C. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
D. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY 'imbatman';
E. CREATE USER WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS 'webdesign' USING 'imbatman';
F. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
'imbatman';

正解: A,C

質問 80
You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-ddd-eee:3 on a slave.
Which procedure would you execute from a MySQL prompt?

A. Option D
B. Option C
C. Option A
D. Option B

正解: D

質問 81
Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

A. Change the WHEREclause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
B. Add FORCE INDEX (Birthday)to the query.
C. Add a generated column calculating YEAR(Birthday)and index that column.
D. Execute ANALYZE TABLEto update the index statistics.
E. Add a functional index for YEAR(Birthday).

正解: A,B

質問 82
Where does MySQL Linux RPM install the mysqld binary?

A. /usr/bin/
B. /usr/sbin/
C. /usr/local/mysql/bin/
D. /opt/mysql/server/bin/
E. /usr/libexec/

正解: B

解説:
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html

質問 83
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. Use mysql_config_editor, which allows you to store encrypted login credentials in your home directory.
B. 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
C. Use the password validation plugin available to improve user name and password strength.
D. Store your password in an option file eg: ~/.my.cnf and use --defaults-file so that it is read and used.
[client]
password=t100043va

正解: A,C

解説:
https://dev.mysql.com/doc/mysql-security-excerpt/8.0/en/password-security-user.html
https://dev.mysql.com/doc/refman/5.6/en/validate-password.html

質問 84
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. Provide users access to the server's private key.
B. Distribute client digital certificates to the client computers being used to log in by the user accounts.
C. Set the X509 option in the [client] section of the MySQL server's configuration file.
D. Install the X509plug-in on the server.
E. Restart the server with the --require-x509option.

正解: C

質問 85
Consider these global status variables:

Which two conclusions can be made from the output? (Choose two.)

A. There are more connections being idle than executing queries.
B. There are 510 connections to MySQL at the time of the output.
C. There are 140 Performance Schema threads at the time of the output.
D. The thread cache has been configured with thread_cache_size set to at least 6.
E. All max_connections were in use at 2018-03-22 14:54:06

正解: A,B

質問 86
......

練習できる1Z0-888問題で認証試験問題集ガイド解答は練習専門Fast2test：https://jp.fast2test.com/1Z0-888-premium-file.html