1z0-888: MySQL 5.7 Database Administrator MYSQL Practice Questions

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

• AA. It relies on the shared disk architecture being visible to both servers.
• BB. It is provided by means of IP-level disk replication.
• CC. It implements High Availability by using the NET Connector's load balancing capabilities.
• DD. It is a shared-nothing architectur

MySQL is installed on a Linux server and has this configuration: [mysqld] user=mysql datadir=/data/mysql/ As the ‘root’ user, you change the datadir location by executing: shell> cp –R /var/lib/mysql /data/mysql/ shell> chown –R mysql /data/mysql What is the purpose of changing ownership of datadir to the ‘mysql’ user?

• AA. MySQL needs to be run as the root user, but files cannot be owned by it.
• BB. The mysqld process requires all permissions within datadir to be the same.
• CC. MySQL cannot be run as the root user.
• DD. MySQL requires correct file ownership while remaining secur

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?

• AA. the mysql_upgrade script
• BB. the mysql client with the --ignore-password-hashing option
• CC. the mysql_secure_installation script to update server security settings
• DD. the mysql client with the --enable-cleartext-plugin option
• EE. the install plugin command for the mysql_cleartext_password plugin

Which two options describe how MySQL Server allocates memory?

Select 2 answers.

• AA. Each connection may have its own per-thread memory allocations.
• BB. Thread memory is pre-allocated up to thread_cache_size for performance.
• CC. Each thread allocates memory from a global pool.
• DD. Global memory resources are allocated at server startu