Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index?

• A.Add FORCE INDEX (Birthday) to the query.
• B.Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
• C.Add a functional index for YEAR(Birthday).
• D.Add a generated column calculating YEAR(Birthday) and index that column.
• E.Execute ANALYZE TABLE to update the index statistics.

Comment: *

Name: *

Email: *

Verification: *

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 shared_memory_base_name variable must match the master.
• B.The log_bin variable is set to OFF on the slave.
• C.server_id is not unique.
• D.The version of the slave is newer that the version of the master.
• E.The max_connections variable on the slave needs to be increased.

Comment: *

Name: *

Email: *

Verification: *

To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

• A.Set the X509 option in the [client] section of the MySQL server's configuration file.
• B.Restart the server with the --require-x509option.
• C.Install the X509plug-in on the server.
• D.Distribute client digital certificates to the client computers being used to log in by the user accounts.
• E.Provide users access to the server's private key.

Comment: *

Name: *

Email: *

Verification: *

A MySQL replication slave is set up as follows:
Uses all InnoDB tables
Receives ROW-based binary logs
Has the read-only option
The replication slave has been found in an error state. You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur?

• A.The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.
• B.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
• C.The applications have the SUPER privilege, which allows them to update rows.
• D.The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases > /data/data.sql
• E.For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.

Comment: *

Name: *

Email: *

Verification: *

You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.
Why is it important to remove snapshots after completing a raw backup in this way?

• A.The system keeps a copy of changes in memory and can cause an out-of-memory event.
• B.The snapshots take a significant amount of disk space because they are a duplicate copy of the data.
• C.The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.
• D.The snapshot size will continue to grow as changes to the volume are made.

Comment: *

Name: *

Email: *

Verification: *