Which three are key advantages of standard MySQL replication?

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements correctly describe MySQL InnoDB Cluster?

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

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO 'webadmin'@'%';
A user successfully connects to the database as webadminand created a stored procedure named get_reports.The next day, the user logs in again as webadminand wants to delete the stored procedure named get_reports,and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?

• A.The stored procedure named get_reportswill be dropped.
• B.The user will get an error because he or she did not put the database name in front of the stored procedure name.
• C.The user will get an error because he or she did not use the ALTERstatement to drop the stored procedure.
• D.The user will get an error because he or she does not have the permission to drop stored procedures.

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

Comment: *

Name: *

Email: *

Verification: *