1z0-888 Free Practice Test

You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size. You start to restore your backup with this command;
shell> mysql –u root –p < backup>After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?

1. A. The MySQL server has stopped inserting data to check index consistency.
2. B. InnoDB is doing CRC32 checks over the tablespace data as it grows.
3. C. The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.
4. D. InnoDB has filled the redo log and now must flush the pages.
5. E. Secondary indexes no longer fit into the buffer poo

Correct Answer: A

The /myfolder/my.cnf file has option set: [mysqld] skip-log-bin
/myfolder2/my.cnf has this option set: [mysqld] log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?

1. A. MySQL starts and Binary Logging is enabled.
2. B. MySQL fails to start due to the conflicting options in the configuration files.
3. C. MySQL fails to start due to conflicting options on the command line.
4. D. MySQL starts but Binary Logging is disable

Correct Answer: C

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

1. A. it contains the binary log.
2. B. it contains a general tablespace.
3. C. it is the default location for all new tables that you create.
4. D. it contains the system tablespace.
5. E. it contains the redo log.
6. F. it contains the undo lo

Correct Answer: CD

An admin attempts to enforce stronger security by using these commands:
<>

1. A. validate_password_policy cannot be set without restarting the MySQL instance.
2. B. The name of the dictionary file is too obvious.
3. C. The dictionary file word list is too short.
4. D. validate_password_dictionary_file cannot be set without restarting the MySQL instance.
5. E. The validate_password plug-in has not been loaded.
6. F. The dictionary file is an insecure locatio

Correct Answer: BF

You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

1. A. binlog_format=STATEMENT
2. B. log-bin
3. C. apply-log
4. D. bonlog_format=ROW
5. E. gtid_enable

Correct Answer: B