Examine this query and output:

Which two statements are true? (Choose two.)

• A.The country table is accessed as the first table, and then joined to the city table.
• B.The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
• C.35 rows from the city table are included in the result.
• D.It takes more than 8 milliseconds to sort the rows.
• E.The query returns exactly 125 rows.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

• A.It is possible to retrieve a normalized statement, but never the exact statement that was executed.
• B.It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
• C.The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
• D.It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
• E.It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the binary log encryption feature? (Choose two.)

• A.It encrypts any connecting slaves connection thread.
• B.It requires a keyring plugin.
• C.When enabled it encrypts existing binary logs.
• D.It can be activated per session.
• E.It can be set at run time.

Comment: *

Name: *

Email: *

Verification: *

You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

• A.It creates a logical backup of all MySQL user accounts.
• B.It creates a logical backup of all metadata, but contains no table data.
• C.It returns an error because the mysqldump command should have been used.
• D.It creates a logical backup of only the users database.

Comment: *

Name: *

Email: *

Verification: *

Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

• A.Remove world read privileges from the public_key.pem file.
• B.Remove the world read/execute privilege from the accounting directory.
• C.Change the parent directory owner and group to mysql.
• D.Change the group ownership of the mysql directory to the mysql user group.
• E.Remove world read privileges from the server-cert.pem certificate file.
• F.Remove group read/write privileges from the private_key.pem file.

Comment: *

Name: *

Email: *

Verification: *