Actual 1z0-888 Class 2021

NEW QUESTION 1
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

• A. They are not affected by this configuration change.
• B. They all connect via the secure sha256_password algorithm without any configuration change.
• C. They will have their passwords updated on start-up to sha256_password format.
• D. They will have to change their password the next time they login to the serve

Answer: A

NEW QUESTION 2
What is the order of tables shown in an EXPLAIN output?

• A. It lists tables from the smallest to the largest.
• B. It lists tables in the order in which their data will be read.
• C. It lists tables from the most optimized to the least optimized.
• D. It lists tables in the order in which they are specified in the statement that is being explaine

Answer: D

NEW QUESTION 3
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. --skip-opt
• B. --lock-all-tables
• C. --create-apply-log
• D. --single-transaction
• E. --master-data

Answer: AB

NEW QUESTION 4
Consider these global status variables:

Which two conclusions can be made from the output?

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

Answer: BD

NEW QUESTION 5
Which two options describe how MySQL Server allocates memory?

• A. Each connection may have its own per-thread memory allocations.
• B. Thread memory is pre-allocated up to thread_cache_size for performance.
• C. Each thread allocates memory from a global pool.
• D. Global memory resources are allocated at server startu

Answer: AD

NEW QUESTION 6
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

• A. the mysql_upgrade script
• B. the mysql client with the --ignore-password-hashing option
• C. the mysql_secure_installation script to update server security settings
• D. the mysql client with the --enable-cleartext-plugin option
• E. the install plugin command for the mysql_cleartext_password plugin

Answer: C

NEW QUESTION 7
You have just executed a manual backup by using this command:
mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backup The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?

• A. Backup State = Compressed Backup Operation = copy-back
• B. Backup State = Raw Backup Operation = apply-log
• C. Backup State = Prepared Backup Operation = validate
• D. Backup State = Prepared Backup Operation = apply-log
• E. Backup State = Raw Backup Operation = backupdir-to-image

Answer: E

NEW QUESTION 8
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. binlog_cache_size=1024 is too small and transactions are lost.
• B. binlog_format=STATEMENT and a non-deterministic query was executed.
• C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
• D. The sync_relay_log=1000 setting on the slave is too small.
• E. sync_binlog=0 and the master server crashe

Answer: AC

NEW QUESTION 9
Which are three facts about backups with mysqldump?

• A. will lock all storage engines for duration of backup
• B. can back up a remote database server
• C. allow a consistent backup to be taken
• D. are able to back up specific items within a database
• E. create automatically compressed backups
• F. are always faster to restore than binary backups

Answer: BCD

NEW QUESTION 10
The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.
Which two are true about the login path feature?

• A. mysql_config_editor is the only MySQL-provided utility that can print the values stored in.mylogin.cnf.
• B. A .mylogin.cnf file can store at most one login path.
• C. It provides a FIPS-compliant keyring for storing MySQL login details.
• D. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
• E. It is an alternative to storing the MySQL login details in a my.cnf file.
• F. It provides means to help avoid accidentally exposing the MySQL login detail

Answer: EF

NEW QUESTION 11
A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?

• A. a backup created with mysqldump --all-databases
• B. a backup created using FLUSH TABLES … FOR EXPORT
• C. an up-to-date replication slave
• D. a file system-level snapshot
• E. a file system copy created while MySQL was shut dow

Answer: AD

NEW QUESTION 12
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. mysql --protocol=PLAIN –uroot –p –h dbhost.example.com
• B. INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;
• C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’
• D. SET GLOBAL mysql_cleartext_passwords=1;
• E. mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com

Answer: DE

NEW QUESTION 13
Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

• A. Set isolation level to be SERIALIZABLE.
• B. Use the binary log row format.
• C. Set isolation level to be READ COMMITTED.
• D. Configure IPv6 network for hosts.
• E. Guarantee a secondary index on every table.
• F. Guarantee a primary key on every table.
• G. Set multiple slave parallel worker thread

Answer: ABF

NEW QUESTION 14
A particular government’s security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

• A. using GRANT … REQUIRE X509 AND REQUIRE ISSUER ‘/C=…..’ AND REQUIRE SUBJECT ‘/C=…..’
• B. using GRANT USAGE, X509, …….ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’
• C. using GRANT … REQUIRE SSL for a secure connection
• D. using GRANT USAGE, SSL, …..ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’

Answer: A

NEW QUESTION 15
You created a backup of the world database with this command: shell> mysqldump --opt world > dump.sql Which two will import the data from dump.sql?

• A. shell> mysqladmin recover test dump.sql
• B. shell> mysql test < dump.sql
• C. shell> mysqlimport test dump.sql
• D. mysql> USE test; mysql> LOAD DATA INFILE ‘dump.sql’;
• E. mysql>USE test; mysql>SOURCE dump.sql;

Answer: CD

NEW QUESTION 16
What two statements are true regarding FLUSH TABLES FOR EXPORT?

• A. It can be used to export TEMPORARY tables.
• 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 is the safest way to extract tables from the shared tablespace.
• E. Partitioned tables are not supporte

Answer: AB

NEW QUESTION 17
After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output?

• A. Date should be a TIMESTAMP field for better performance.
• B. The User field is too long for most names.
• C. The engine type is not appropriate to the application use.
• D. Using default values for DATETIME causes table scans.
• E. No indexes are define

Answer: CE

NEW QUESTION 18
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?

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

Answer: BF

NEW QUESTION 19
Exhibit:

What does the possible_keys column in this output denote?

• A. if it is possible for you to include any indexes in your query
• B. whether there are any indexes on the tables that you are querying
• C. if there are any indexes that may be used to solve this query
• D. whether there are any indexes in your query

Answer: A

NEW QUESTION 20
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO ‘webadmin’@’%’; GRANT ALTER ON PROCEDURE sales.myproc TO ‘webadmin’@’%’;
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports; What is the result of executing the statement?

• A. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.
• B. The user will get an error because he or she did not put the database name in front of the stored procedure name.
• C. The stored procedure named get_reports will be dropped.
• D. The user will get an error because he or she does not have the permission to drop stored procedure

Answer: C

NEW QUESTION 21
old_alter_table is disabled as shown. mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table: mysql> ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing this statement?

• A. All data in p1 and p3 partitions is removed and the table definition is changed.
• B. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
• C. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
• D. It results in a syntax error because you cannot specify more than one partition in the same statemen

Answer: B

NEW QUESTION 22
......