1z0-908 Practice Test

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

Question 31

Examine this statement and output: You must try to reduce query execution time. Which two queries should you focus on? (Choose two.)

  1. QN = 3
  2. QN = 5
  3. QN = 1
  4. QN = 4
  5. QN = 2

Question 32

Examine this query: What information does this query provide?

  1. total memory used across all connections associated with the user on connection number 10
  2. total memory used by the first 10 connections
  3. total memory used by thread number 10
  4. total memory used across all connections associated with the user on thread number 10
  5. total memory used by connection number 10
  6. total memory used by the first 10 threads

Question 33

On examination, your MySQL installation datadir has become recursively world read/write/executable. What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

  1. Users could overwrite configuration files.
  2. Data files could be deleted.
  3. SQL injections could be used to insert bad data into the database.
  4. MySQL binaries could be damaged, deleted, or altered.
  5. Extra startup time would be required for the MySQL server to reset the privileges.

Question 34

User account baduser@hostname on your MySQL instance has been compromised. Which two commands stop any new connections using the compromised account? (Choose two.)

  1. ALTER USER baduser@hostname PASSWORD DISABLED;
  2. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
  3. ALTER USER baduser@hostname ACCOUNT LOCK;
  4. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
  5. ALTER USER baduser@hostname DEFAULT ROLE NONE;

Question 35

An existing asynchronous replication setup is running MySQL 8. Which two steps are a part of implementing GTID replication? (Choose two.)

  1. Enable GTID by executing this on the master and the slave: SET GLOBAL GTID_ENABLED=on;
  2. Execute this on the slave to enable GTID: START SLAVE IO_THREAD WITH GTID;
  3. Restart MySQL (master and slave) with these options enabled: --gtid_mode=ON --log-bin --log-slave-updates --enforce-gtid-consistency
  4. Execute this on the slave to enable GTID: RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
  5. On the slave, alter the MySQL master connection setting with: ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
  6. On the slave, alter the MySQL master connection setting with: CHANGE MASTER TO MASTER_AUTO_POSITION = 1;