Question #1

A MySQL database uses all InnoDB tables and is configured as follows:
shell>cat/ etc/ my.cnf
[mysqld]
log-bin
server-id=1
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: DE

Question #2

Consider the key buffer in a MySQL server.
Which two statements are true about this feature?

• A. It caches index blocks for MyISAM tables only.
• B. It caches index blocks for all storage engine tables.
• C. It is a global buffer.
• D. It is set on a per-connection basis.
• E. It caches index blocks for InnoDB tables only.

Answer: AC

Question #3

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.
mysql> SHOW SLAVE STATUS G
...
Slave_IO_Running: Yes
Slave_SQL_Running: No
What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?

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

Answer: BC

Question #4

Which three statements correctly describe MySQL InnoDB Cluster?

• A. The cluster can be operated in multimaster mode with conflict detection for DML statements.
• B. All MySQL client programs and connectors can be used for executing queries.
• C. It provides fully synchronous replication between the nodes.
• D. There is support for automatic failover when one node fails.
• E. The data is automatically shared between the nodes.

Answer: ABD

Question #5

How does the InnoDB storage engine handle deadlocks when they are detected?

• A. Both the affected transactions will be rolled back.
• B. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.
• C. One of the affected transactions will be rolled back, the other is allowed to proceed.
• D. The transaction isolation level determines which transaction is rolled back.

Answer: C

Question #6

Which three allocate memory per thread in MySQL?

• A. query cache
• B. thread cache
• C. read buffer
• D. internal temporary table
• E. sort buffer

Answer: CDE

Question #7 ... 179

MySQL 5.7 Database Administrator

Note: The 1Z0-888 DEMO includes only a small portion of the actual product content. To access the complete material, please consider purchasing the product. Upon purchase, you'll receive a PDF file containing the entire content.

Additionally, our 1Z0-888 brain dumps has been curated to exclude outdated, invalid, and erroneous information, ensuring a more effective learning experience for you.