Consider the Mysql Enterprise Audit plugin.
The following event detail is found in the audit log:
<AUDIT_RECORD
TIMESTAMP="2013-04-09t01:54:17"
NAME="Connect"
CONNECTION_ID="3"
STATUS="1045"
USER="kate"
PROXY_USER=""
HOST="localhost"
IP=""
DB=""/>
Which two points can be concluded from the given event?

• A. A connection as the user kate was successful.
• B. A connection was attempted via socket rather than TCP.
• C. A connection was blocked by a firewall or a similar security mechanism.
• D. A connection failed due to authentication being unsuccessful.
• E. A connection failed because the proxy user privileges did not match the login user.

You are using the performance Schema to investigate replication on a slave:
Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime
FROM performance_schema.events_waits_summary_by_thread_by_event_name
INNER JOIN performance_schema_threads USING (THREAD_ID)
WHERE threads .NAME LIKE 'thread/sql/slave\-%'
GROUP BY THREAD_ID, threads.NAME;

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?

• A. At most two schemas are being updated concurrently.
• B. The slave cannot process the relay log fast enough to use all threads.
• C. The server needs more cores to use all slave threads.
• D. The slave is configured with slave_parallel_workers = 4.

You have been notified that the 'apps' . 'reports' table has been accidentally truncated.
You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the 'apps' . 'reports' table must be restored without affecting the other remaining databases and tables.
Which restore option is suitable in this scenario?

• A. Extract the 'apps' . 'reports' table from the backup using the SOURCE command.
• B. Execute mysqldump on the backup,sql file and apply - filter arguments to obtain only the 'apps' . 'reportys' table.
• C. Execute LOAD DATA INFILE 'backup.sql' SCHEMA='apps' TABLE= 'reports'
• D. Restore the backup to another databases instance and obtain a copy of the reports table individually.

User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?

• A. INSERT INTO pets...
• B. SELECT....FROM pets
• C. UPDATE pets...
• D. ALTER TABLE pets...

Consider the Mysql Enterprise Audit plugin.
A CSV file called data.csv has 100 rows of data.
The stored procedure prepare_db ( ) has 10 auditable statements.
You run the following statements in the mydb database: Mysql> CALL prepare_db ( );
Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable;
Mysql> SHOW TABLES;
How many events are added to the audit log as a result of the preceding statements?

• A. 12; only top-level statements and stored procedure events are logged.
• B. 3; only the top-level statements are logged.
• C. 102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.
• D. 111; top-level statements and all lower-level statements are logged.