A MySQL database uses all InnoDB tables and is configured as follows;

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? (Choose two.)

• A.--create-apply-log
• B.--single-transaction
• C.--master-data
• D.--skip-opt
• E.--lock-all-tables

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? (Choose two.)

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

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? (Choose two.)

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

Comment: *

Name: *

Email: *

Verification: *

These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

• A.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY 'employee'@'localhost';
• B.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
• C.mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
• D.mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK;mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@'';

Comment: *

Name: *

Email: *

Verification: *

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 in your query
• C.if there are any indexes that may be used to solve this query
• D.whether there are any indexes on the tables that you are querying

Comment: *

Name: *

Email: *

Verification: *