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.Manually store the values in a file and use SHA-256 to check against the mysql.user table
• D.Store values in a plain-text file set by using the validate_password_dictionary_file command
• 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.Store values in the mysql.user_invalid_passwords table

Which two statements are true about MySQL Enterprise Firewall?

• A.MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
• B.On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• C.The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.
• D.Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• E.System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
• F.MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

MySQL Replication Environment (Master and Slave) is prepared. What are the two options for connecting a Java application to the MySQL Master and Slave?

• A.Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL asjdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] ...
  [/[database]] [? propertyName=propertyValue1 [&propertyName2-propertyValue2]...]
• B.Use MySQL Router with the following configuration:[DEFAULT]logging_folder=
  /var/log/mysqlrouter[logger]level=INFO[routing: failover]bind_port =
  7001mode=replicationdestinations=master:3306, slave:3306The Java application can connect to bind_port=7001
• C.The default JDBC driver is automatically configured with High Availability Option by pointing the connection URL to any one of the MySQL instances.
• D.Use MySQL Router with the following
  configuration:[DEFAULT]logging_folder=/var/log/mysqlrouter[logger]level=INFO[routing:
  failover]bind_port = 7001mode=read-writedestinations= master:3306, slave:3306The Java application can connect to bind_port=7001.

Which two MySQL features are provided exclusively with the Enterprise Edition license, in addition to the database server?

• A.MySQL Enterprise Monitor
• B.MySQL Cluster Manager
• C.MySQL Replication
• D.MySQL Enterprise Firewall

Identify an example of creating an Enterprise Encryption function.

• A.SET@function = CREATE_ASYMMETRIC_PRIV_KEY (@algo, @key_len);
• B.VALIDATE FUNCTION create_asymmetric_priv_key WITH 'openssl_udf.so';
• C.CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME 'openssl_udf.so';
• D.INSERT INTO t1 (key-col) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY('RSA', 1024));