Free 1Z0-888 Exam Dumps Preview

You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)

You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k

To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:

mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;

This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.

Which three best describe this scenario?

What does the possible_keys column in this output denote?

Which two statements describe how InnoDB recovery works? (Choose two.)

You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST.

Which three statements are true? (Choose three.)

Consider these global status variables:

Which two conclusions can be made from the output? (Choose two.)

The account [email protected] has been created with privileges, as shown in the output:

The account [email protected] exists.
The account [email protected] does not exist.

Which three statements will succeed when executed by [email protected]? (Choose three.)

You have created a backup of the `sales' database with the command:

Which two procedures can be used to restore the `orders' table from the backup?

You have issued this statement:

GRANT PROXY ON 'a' FOR 'b';

When user account 'b' issues a query, the query returns an access denied error.

What could have caused that error?

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.

Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.

Which two are true about the login path feature? (Choose two.)

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output? (Choose two.)

You want to create the first configuration file for a new installation of MySQL.

1. You will start mysqld manually (not automate it to start when the host machine starts or execute as a service).
2. You will stop mysqld using mysqladmin.
3. You will interact with mysqld by using only the command-line client mysql.

Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?

What is the best method for monitoring Group Replication conflict resolution?

Which two capabilities are granted with the SUPER privilege?

Multiversion Concurrency Control (MVCC) enables what type of backup?

Which two statements can be used to adjust the sort_buffer_size variable on a running MySQL server? (Choose two.)

What three are correct statements about MySQL backups? (Choose three.)

Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

Which three options are most likely to be changed for production form their default values? (Choose three.)

Which command-line utility creates encrypted files that can be used by client programs and contain obfuscated usernames and passwords?

You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value) for your operating system.

Which step should you perform before defining your own databases and database tables?

A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department.

Which method could be used to restrict access as required?