You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.

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

• A.The slave is configured with slave_parallel_workers = 4
• 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.THREAD_ID 21 has stopped running.
• E.The salve has two intermediate relay slaves connected to it.
• F.At most, two schemas are being updates concurrently.

Comment: *

Name: *

Email: *

Verification: *

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUSoutput:

You execute a 'SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVEcommand. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVEcommand to resolve the duplicate key error. Which statement should be used?

• A.SET GTID_NEXT="CONSISTENCY";
  BEGIN; COMMIT;
  SET GTID_NEXT="AUTOMATIC";
• B.SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
  BEGIN; COMMIT;
  SET GTID_NEXT="AUTOMATIC";
• C.SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
• D.SET GLOBAL enforce_gtid_consistency=ON
• E.SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";

Comment: *

Name: *

Email: *

Verification: *

Which two options describe how MySQL Server allocates memory?

• A.Each connection may have its own per-thread memory allocations.
• B.Global memory resources are allocated at server startup.
• C.Each thread allocates memory from a global pool.
• D.Thread memory is pre-allocated up to thread_cache_size for performance.

Comment: *

Name: *

Email: *

Verification: *

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns? (Choose two.)

• A.validate_password_dictionary_filecannot be set without restarting the MySQL instance.
• B.The validate_passwordplug-in has not been loaded.
• C.The dictionary file is an insecure location.
• D.The dictionary file word list is too short.
• E.The name of the dictionary file is too obvious.
• F.validate_password_policycannot be set without restarting the MySQL instance.

Comment: *

Name: *

Email: *

Verification: *

How does the InnoDB storage engine handle deadlocks when they are detected?

• A.The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
• B.The transaction isolation level determines which transaction is rolled back.
• C.Both the affected transactions will be rolled back.
• D.One of the affected transactions will be rolled back, the other is allowed to proceed.
• E.The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

Comment: *

Name: *

Email: *

Verification: *