1z0-908 Practice Test

1z0-908 Practice Test practice questions, page 2 of 9, with answer review and explanations.

Question 6

Which two are features of MySQL Enterprise Firewall? (Choose two.)

  1. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
  2. blocking of potential threats by configuring pre-approved whitelists
  3. modifying SQL statement dynamically with substitutions
  4. automatic locking of user accounts who break your firewall
  5. provides stateless firewall access to TCP/3306

Question 7

Examine the modified output: Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)

  1. The master is most probably too busy to transmit data and the slave needs to wait for more data.
  2. One or more large tables do not have primary keys.
  3. This value shows only I/O latency and is not indicative of the size of the transaction queue.
  4. The master is producing a large volume of events in parallel but the slave is processing them serially.
  5. The parallel slave threads are experiencing lock contention.

Question 8

You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server. Which value of --ssl-mode will do this?

  1. PREFERRED
  2. VERIFY_CA
  3. REQUIRED
  4. VERIFY_IDENTITY

Question 9

Consider this shell output and executed commands: [root@oel7 ~]# ps aux | grep mysqld mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid [root@oel7 ~]# kill -15 2076 Which statement is true about MySQL server shutdown?

  1. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
  2. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
  3. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
  4. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

Question 10

You wish to protect your MySQL database against SQL injection attacks. Which method would fail to do this?

  1. installing and configuring the Connection Control plugin
  2. avoiding concatenation of SQL statements and user-supplied values in an application
  3. using stored procedures for any database access
  4. using PREPARED STATEMENTS