Question 1

Examine this command and output:Which statement is true?

Options :

A : Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

B : Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C : Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

D : Firewall_access_granted is the number of connections granted from whitelisted hosts.

Answer: C

Question 2

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 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

In a test database, you issue the SELECT … INTO OUTFLLE statement to create a file with your t1 table data.You then TRUNCATE this table to empty it.mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;mysql> TRUNCATE t1;Which two methods will restore data to the t1 table? (Choose two.)

Options :

A : mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;

B : $ mysqladmin -u root -p -h locathost test –restore /tmp/t1.sql

C : $ mysql -u root -p -h localhost test < /tmp/t1.sql

D : $ mysqlimport -u root -p -h localhost test /tmp/t1.sgl

E : mysql> INSERT INTO t1 VALUES FRON ‘tmp/t1.sql’;

Answer: A,D

Question 5

You have forgotten the root user account password. You decide to reset the password and execute: 2020-03-14-14-37-11-4ec4153145d3e66368ed58ed6f5922f5 Which additional argument makes this operation safer?

Options :

A : --old-passwords, to start MySQL to use the old password format while running without the grant tables.

B : --reset-grant-tables, to start the server with only the mysql database accessible.

C : --read-only, to set all data to read-only except for super users

D : --skip-networking, to prohibit access from remote locations

Answer: D