Online Access Free 1z0-320 Practice Test

You want to prevent your users from using a specific list of passwords. How would you implement this on your system?

• A.Specify the nonusable passwords via MySQL Enterprise Audit
• B.You cannot save a list of nonusable passwords in MySQL
• C.Store values in a plain-text file set by using the validate_password_dictionary_file command
• D.Store values in the mysql.user_invalid_passwords table
• E.Set validate_password_dictionary_file=pass_dict.txt and store the nonusable passwords in the pass_dict.txt file in your data directory
• F.Manually store the values in a file and use SHA-256 to check against the mysql.user table

Identify the MySQL plug-in that is provided only with MySQL Enterprise Edition and servers to increase performance and high availability.

• A.the MySQL PAM Authentication plug-in
• B.the MySQL memcached plug-in
• C.the MySQL Firewall plug-in
• D.the MySQL No-Login Authentication plug-in
• E.the MySQL Semisynchronous replication plug-in
• F.the MySQL Thread Pool plug-in

The user 'fwuser'@'localhost' was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database.
You executed commands:

You want to clear the account whitelist for the 'fwuser'@'localhost' user. Which statement would you run to accomplish this?

• A.SET mysql.sp_set_firewall_mode= 'RECORDING';
• B.CALL mysql.sp_reload_firewall_rules ('fwuser@localhost');
• C.DELETE TABLE INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST;
• D.CALL mysql.sp_set_firewall_mode ('fwuser@localhost', 'CLEAR');

Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances.

• A.Direct support call from an Oracle representative
• B.Notification tab on the dashboard
• C.Browser pop-ups
• D.Email
• E.SMS

Which three options describe the setup of MySQL High Availability solutions?

• A.creating an NFS volume with multiple running MySQL Server Instances attaching the same NFS Volume with the same datadir
• B.providing the Active/Passive setup of MySQL Server running on two machines with Shared Storage together with OS clustering to provide storage and Virtual IP failover
• C.setting up Master and Slave with MySQL Semi-Sync Replication Plugin
• D.Setting up three machines configured as follows:Machine A with 2 x Data NodesMachine B with 2 x mysqld nodeMachine C with 2 x ndb_mgmd node
• E.setting up three machines configured as follows:Machine 1: Data Node and mysqld nodeMachine 2:
  Data Node and mysqld nodeMachine 3: ndb_mgmd