Online Access Free 1z1-320 Exam Questions

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

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

After the installation of the MySQL Server, you cannot find MySQL Utilities.
How would you correct the problem?

• A.MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution.
• B.MySQL Utilities comes with MySQL Enterprise Backup. Download MySQL Enterprise Monitor to install.
• C.MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. Download the MySQL Utilities separately from www.mysql.com.
• D.MySQL Utilities is a package from MySQL Connector. Download the MySQL/Connector and install.
• E.MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install.

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing.
The binlog size keeps growing. Identify two methods to fix the issue.

• A.Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
• B.On the Master server, disable binlog by removing the - - log -bin option.
• C.To safely purge binary log files, perform the following steps:1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up-to-date, this is the last log file on the list.4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)5. Purge all log files up to but not including the target file by using the PURGE BINARY LOGS statement.
• D.Delete all binlog files manually on the file system to release storage spaces.
• E.Execute the PURGE BINARY LOGS statement without argument.

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

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

You are requested to export data from a set of the following tables in the database 'world_x'.
Tables (country, countryinfo, location)
Which two options would allow you to export data as files?

• A.using mysqldump to dump multiple tables in a database in one command line:# mysqldump -u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql
• B.using mysqlexport to export multiple tables in a database in one command line:# mysqlexport -u<user>- h<host> -P<port> -p world_x country countryinfo location> mydump.sql
• C.using MySQL Client and the - -dump option to dump the tables to files:# mysql -u<user> -p -h<host>
  -P<port> -- dump world_x.country world_x.countryinfo world_x.location
• D.using MySQL Client and EXPORT <table> TO <file> to export data one by one:mysql>EXPORT world_x.country TO '/output/country.txt';mysql>EXPORT world_x.countryinfo TO
  '/output/countryinfo.txt';mysql>EXPORT world_x.location TO '/output/location.txt';
• E.using MySQL Client and SELECT ...INTO OUTFILE '<filename>' from <TABLE> to export data one by one:mysql>select * into outfile '/output/country.txt' from world_x.country;mysql>select * into outfile '/output/countryinfo.txt' from world_x.countryinfo;mysql>select * into outfile
  '/output/location.txt' from world_x.location;