Online Access Free 1z1-908 Exam Questions

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

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

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.Add default_authentication_plugin=mysql_native_password in the configuration file.
• B.Set validate-user-plugins=caching_sha2_password in the configuration file.
• C.Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.
• D.Add default_authentication_plugin=sha256_password in the configuration file.

Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

• A.It restores files from the data directory to their original MySQL server locations.
• B.It restores files from the backup directory to their original MySQL server locations.
• C.The copy-back process is used to overwrite a new backup over an existing backup.
• D.The copy-back process makes inconsistent backups.

Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?

• A.mysqlbinlog --stop-position=500324 binlog.000036 | mysql
• B.mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql
• C.mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql
• D.mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host
192.0.2.1:3306. You wish to connect directly to the world database.
Which four options need to be specified to complete this task with a single command? (Choose four.)

• A.--host=192.0.2.1
• B.--database=world
• C.--protocol=pipe
• D.--user=admin
• E.--socket=/tmp/mysql.sock
• F.--port=3306
• G.--shared-memory-base-name=world
• H.--password
• I.--protocol=UDP