Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
1z0-908
Free trial
Verified
Question 26
Which two statements are true about the binary log encryption feature? (Choose two.)
- A: It encrypts any connecting slaves connection thread.
- B: It can be set at run time.
- C: It requires a keyring plugin.
- D: When enabled it encrypts existing binary logs.
- E: It can be activated per session.
Question 27
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
- A: ibtmp1
- B: undo_001
- C: ib_buffer_pool
- D: ibdata1
- E: mysql.ibd
- F: ib_logfile0
Question 28
Which two statements are true about the mysqld-auto.cnf file? (Choose two.)
- A: This file is for storing MySQL Server configuration options in ISON format.
- B: This file is for logging purposes only and is never processed.
- C: It is read and processed at the beginning of startup configuration.
- D: It is read and processed at the end of startup configuration.
- E: It is always updated with changes to system variables.
- F: This file is for storing MySQL server_uuid values only.
Question 29
MySQL is installed on a Linux server with this configuration:
Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?
- A: Set validate-user-plugins=caching_sha2_password in the configuration file.
- B: Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.
- C: Add default_authentication_plugin=mysql_native_password in the configuration file.
- D: Add default_authentication_plugin=sha256_password in the configuration file.
That’s the end of your free questions
You’ve reached the preview limit for 1z0-908Consider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!