1Z0-888 Exam Questions

Which two are considered good security practices when using passwords? (Choose two.)

You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice: `ERROR 2059 (HY000): Authentication plugin 'mysql_clear_password' cann...

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a...

You are investigating the performance of a query which selects data from an InnoDB table. Consider this Performance Schema diagnostics output for the query: mysql> SELECT event_id,...

The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a / backup partition available on NFS where backups are stored. You investigate and...

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...

This output is from a SHOW SLAVE STATUS: ``` mysql> SHOW SLAVE STATUS\G *************************** 1. row *************************** Slave_IO_state: Waiting for master to send ev...

In which order does MySQL process an incoming INSERT statement?

You want to immediately stop access to a database server for remote user 'mike'@'client.example.com'. This user is currently not connected to the server. Which two actions can you...

SQL injection is a common security threat. Which two methods would help protect against this risk? (Choose two.)

A transaction involving a single InnoDB INSERT statement commits. Which list of locations is in the sequence of disk writes for this transaction?

You have installed the validate_password plug-in and set the validate_password_policy variable. Which validation is affected by the validate_password_policy setting?

Which two statements are true regarding MySQL security? (Choose two.)

Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?

You are asked to examine user accounts and find: ``` mysql> select user,host,plugin,authentication_string from user; +------------------+-----------------------------+-------------...

You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it u...

You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP...

You are investigating the performance of the server and see this information: * events_waits_summary_global_by_event_name in the Performance Schema shows that the wait/synch/mutex/...

Where does MySQL Linux RPM install the mysqld binary?

Which two methods will provide the total number of partitions on a table? (Choose two.)

Which statement is correct about how InnoDB storage engine uses disk space?

Which statement is true about tablespaces?

Which MySQL utility copies the master instance to a slave instance on the same host?

Consider: ```sql mysql> EXPLAIN SELECT Name FROM Country WHERE Population BETWEEN 1 AND 10000\G *************************** 1. row *************************** id: 1 select_type: SI...

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

Which statement best describes the meaning of the values in the ref columns?

While attempting to set up a new replication slave on host '192.168.0.25' with the user 'replication', you encounter this error: ERROR 1218 (08S01): Error connecting to master: Hos...

You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to incl...

You are using GTIDs in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-ddd-eee:3 on a slave. Which procedure would you execute from a MySQL prompt?

The MySQL user `adam` currently has USAGE permissions to the database. The football database is transactional and has non-stop updates from application users. The `adam` user needs...

shell >/etc/init.d/mysql stop shell >/etc/init.d/mysql start --skip-grant-tables Which additional argument makes this operation safer?

Which statement describes how the relay log works?

Why should you be selective when granting the PROCESS privilege to an account?

You want to dump only data from the userdata table. Which mysqldump command argument is required to accomplish this?

An employee cannot access the company database. You check the connection variables: mysql> SHOW GLOBAL VARIABLES LIKE '%connect%'; +--------------------+-------+ | Variable_name |...

You have just created a replication slave from a backup of the master made with mysqldump: mysqldump -u backup -p --all-databases > /backups/mysql.sql You try to log in to the slav...

The account [email protected] has been created with privileges, as shown in the output: mysql> SHOW GRANTS FOR [email protected]; +-----------------------------------------------------...

To query two system variables, you execute this statement and get the results shown: mysql> SELECT @@autocommit, @@max_connections; +--------------+-------------------+ | @@autocom...

You have set innodb_stats_auto_recalc to OFF. For tables using persistent statistics, what is the outcome of this change?

Consider a replication setup where a snapshot of the replication status shows: mysql> SELECT CHANNEL_NAME, SERVICE_STATE, LAST_HEARTBEAT_TIMESTAMP, RECEIVED_TRANSACTION_SET FROM pe...

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

You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a raw bac...