Online Access Free 1Z0-921 Practice Test

Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

• A.MySQL Enterprise Data Masking and De-identification
• B.MySQL Enterprise Audit
• C.MySQL Enterprise Scalability
• D.MySQL Enterprise Transparent Data Encryption (TDE)
• E.MySQL Enterprise No-Login Authentication

You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

• A.CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)
• B.CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;
• C.CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)
• D.CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;
• E.CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE

Which of the following statements is true regarding MySQL user account privileges?
Response:

• A.A user with the SUPER privilege can only read data from the database.
• B.The USAGE privilege allows a user to connect to the MySQL server but grants no other privileges.
• C.The RELOAD privilege allows a user to delete data from a table.
• D.The GRANT option allows a user to revoke privileges from other users.

You need to change the password level for a test system.
Which two allow to change this level before you create new test user/passwords?

• A.Add validate_password_policy=,new level, in the [mysqld] section of the MySQL configuration file.
• B.Add validate_password=,new level, in the [security] section of the MySQL configuration file.
• C.SET GLOBAL validate_password_policy=,new level,;
• D.SET GLOBAL force_password_complex_policy=0;

You just installed MySQL by Using a Package Manager on Linux.
Where are the default InnoDB redo log files stored?

• A./var/lib/mysql/innodb
• B./var/lib/mysql
• C./usr/bin/logs
• D./usr/mysql
• E./usr/redo
• F./etc/my.cnf