1z0-908 Practice Test

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

Question 21

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

  1. performance metrics
  2. table definitions
  3. access control lists
  4. view definitions
  5. server runtime configuration
  6. server configuration rollback
  7. stored procedure definitions
  8. InnoDB buffer pool LRU management data

Question 22

You have an InnoDB Cluster configured with three servers. Examine this command, which executes successfully: mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql Due to data loss, the cluster is initialized and a restore is attempted resulting in this error: ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

  1. Stop all instances except the primary read/write master instance and run the restore.
  2. Remove the @@GLOBAL.gtid_purged statement from the dump file.
  3. Create the backup by using the --set-gtid-purged=OFF option.
  4. Remove the group replication plugin from each instance before restoring.
  5. Remove the @@GLOBAL.gtid_executed statement from the dump file.
  6. Restore using the --set-gtid-purged=OFF option.

Question 23

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

  1. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
  2. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
  3. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
  4. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Question 24

You are upgrading a MySQL instance to the latest 8.0 version. Examine this output: You plan to add this parameter to the configuration: innodb_directories=’/innodb_extras’ Which statement is true?

  1. It defines all innodb tablespace options relative to a starting parent directory.
  2. It is not necessary because innodb_data_home_dir is already defined.
  3. It allows scanning of other locations to discover more innodb tablespaces.
  4. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
  5. It adds more temporary workspace in addition to the innodb_tmpdir location.

Question 25

You wish to store the username and password for a client connection to MySQL server in a file on a local file system. Which is the best way to encrypt the file?

  1. Use the AES_ENCRYPT() MySQL function on the option file.
  2. Use mysql_secure_installation to encrypt stored login credentials.
  3. Use a text editor to create a new defaults file and encrypt it from Linux prompt.
  4. Use mysql_config_editor to create an encrypted file.