Online Access Free 1Z1-920 Practice Test

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 force_password_complex_policy=0;
• D.SET GLOBAL validate_password_policy='new level';

Which is true about inserting an additional line in a single document stored in MySQL document store?

• A.You specify the new element's position in the JSON_ARRAY_INSERT statement.
• B.You cannot insert a single line, you have to replace the entire document with a new document.
• C.The path specified must be an array position past the end of an array using the JSON_POSITION statement.
• D.Any new lines can only be inserted at the end of the document.

Which two methods help prevent MySQL security risks?

• A.Use the secure installation script "mysql_alays_secure_installation".
• B.Transmit plain (unencrypted) data over networks.
• C.Allow unauthorized clients to connect to the server.
• D.Ensure that MySQL accounts have short and easy passwords.
• E.Use a firewall to control access to MySQL ports.
• F.Grant only permissions that a user requires.

The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';
Which three are commands that the os-user can execute?

• A.SHOW BINLOG EVENTS;
• B.SHOW STATUS;
• C.GRANT PROXY
• D.SHOW PROCESSLIST;
• E.SHUTDOWN
• F.KILL PROCESS;

Which three statements describe MySQL Enterprise Backup?

• A.MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
• B.MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
• C.MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
• D.MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
• E.MySQL Enterprise Backup provides the point-in-time recovery functionality.