NEW QUESTION 1
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 2
You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements: USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

• A. You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
• B. The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
• C. The statement would fail because you cannot update more than one row at a time when using –binlogformat = ROW.
• D. Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.
• E. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

Answer: DE

NEW QUESTION 3
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 4
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server: Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

• A. The log_bin variable is set to OFF on the slave.
• B. server_id is not unique.
• C. The max_connections variable on the slave needs to be increased.
• D. The shared_memory_base_name variable must match the master.
• E. The version of the slave is newer that the version of the maste

Answer: A

NEW QUESTION 5
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 6
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

• A. Execute the PURGE BINARY LOGS NOT USED command.
• B. Edit the .index file to remove the files you want to delete.
• C. Ensure that none of the attached slaves are using any of the binary logs you want to delete.
• D. Remove all of the binary log files that have a modification date earlier than today.
• E. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

Answer: CE

Explanation: A: To safely purge binary log files, follow this procedure:
1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file. Syntax:
PURGE { BINARY | MASTER } LOGS
{ TO ‘log_name’ | BEFORE datetime_expr }

NEW QUESTION 7
Which statement best describes the purpose of the InnoDB buffer pool?

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

Answer: C

NEW QUESTION 8
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 9
Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?

• A. The server will crash.
• B. The server suspends that INSERT operation until space becomes available.
• C. An error message will be returned to the client .Server Error: ER_IO
• D. The server suspends operations for all storage engines until space becomes availabl

Answer: B

NEW QUESTION 10
You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?

• A. The access does not take effect until the user logs out and back in.
• B. The access does not take effect until the next time the server is started.
• C. The access is available immediately.
• D. The access does not take effect until you issue the FLUSH PRIVILEGES statemen

Answer: C

NEW QUESTION 11
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 12
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.sql
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?

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

Answer: A

NEW QUESTION 13
Consider:

Which statement best describes the meaning of the value for the key_len column?

• A. It shows how many bytes will be used from each index row.
• B. It shows the number of characters indexed in the key.
• C. It shows the total size of the index row.
• D. It shows how many columns in the index are examine

Answer: A

NEW QUESTION 14
Which two statements are true regarding the creating of new MySQL physical and logical backups?

• A. Physical backups can be used to recover from data corruption.
• B. Logical backups are human-readable whereas physical backups are not.
• C. Logical backups are always larger than physical backups.
• D. Physical backups are usually slower than text backups.
• E. Physical backups are usually faster than text backup

Answer: AE

NEW QUESTION 15
Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

• A. It relies on the shared disk architecture being visible to both servers.
• B. It is provided by means of IP-level disk replication.
• C. It implements High Availability by using the NET Connector's load balancing capabilities.
• D. It is a shared-nothing architectur

Answer: A

NEW QUESTION 16
MySQL is installed on a Linux server and has this configuration:
[mysqld] user=mysql
datadir=/data/mysql/
As the ‘root’ user, you change the datadir location by executing:
shell> cp –R /var/lib/mysql /data/mysql/ shell> chown –R mysql /data/mysql
What is the purpose of changing ownership of datadir to the ‘mysql’ user?

• A. MySQL needs to be run as the root user, but files cannot be owned by it.
• B. The mysqld process requires all permissions within datadir to be the same.
• C. MySQL cannot be run as the root user.
• D. MySQL requires correct file ownership while remaining secur

Answer: A

NEW QUESTION 17
Which three are key advantages of standard MySQL replication?

• A. supports native automatic failover
• B. enables automatic resync of databases when discrepancies are detected
• C. provides arbitrary geographic redundancy with minimal overhead to master
• D. synchronously guarantees identical slave copy
• E. is easy to configure and has low performance overhead
• F. can easily add slaves for read scaling

Answer: BEF

NEW QUESTION 18
Which three statements correctly describe MySQL InnoDBCluster?

• 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.
• F. Each query will be executed in parallel across the node

Answer: BDF