Question 1

You are setting up a new server and you want to reserve 50GB of RAM for InnoDB use. What option would you set

Options :

A : innodb_ram_size=50GB

B : innodb_buffer_pool_size=50GB

C : innodb_buffer_pool=50G

Answer: B

Question 2

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

Options :

A : The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

B : It is possible to retrieve a normalized statement, but never the exact statement that was executed.

C : It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

D : It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

E : It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Answer: C,D

Question 3

User bob@% has the following roles granted: app_read and app_write.

How would you show the privileges for bob@% when it uses app_write? (Choose one).

Options :

A : SHOW GRANTS FOR bob@'%';

B : SHOW GRANTS FOR bob@'%' USING 'app_write';

Answer: B

Question 4

When using MySQL Group Replication you can use the following storage engines:

Options :

A : InnoDB and MyISAM

B : InnoDB

C : MyISAM

D : All the engines included with MySQL

Answer: B

Question 5

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

Options :

A : The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

B : It is possible to retrieve a normalized statement, but never the exact statement that was executed.

C : It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

D : It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

E : It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Answer: C,D

Free 1Z0-908 Mock Exam – Practice Online Confidently