1z0-888 Free Practice Test

Which are three facts about backups with mysqldump?

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

Correct Answer: BCD

What two statements are true regarding FLUSH TABLES FOR EXPORT?

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

Correct Answer: AB

Consider the join_buffer_size parameter in MySQL Server. Which two statements are true about the join buffer?

1. A. The value should be increased if the client performs several SELECT operations.
2. B. The join buffer is set per connection.
3. C. The join buffer is used to process sorts when complex joins are being performed.
4. D. The value should be increased from the default if the query joins large rows without using an index.
5. E. The join buffer is global and can be changed only by restarting the serve

Correct Answer: CD

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

1. A. Ye
2. B. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.
3. C. Ye
4. D. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.
5. E. N
6. F. The UNDO tablespaces must remain on the same file system as the system tablespaces.
7. G. N
8. H. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block device

Correct Answer: C

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?

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

Correct Answer: EF