1z0-908 Exam Dumps - MySQL 8.0 Database Administrator

The instance deployed on host2 is elected as the new primary instance.

The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')

The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.

Failure of the instance deployed on host1 provokes an outage.

The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.

The primary instance can be specified by using the command cluster.setPrimaryInstance(:).

The country table is accessed as the first table, and then joined to the city table.

It takes more than 8 milliseconds to sort the rows.

The optimizer estimates that 51 rows in the country table have Continent = ‘Asia’.

35 rows from the city table are included in the result.

The query returns exactly 125 rows.

The instances use different user accounts unique to each instance.

The instances listen on different IP addresses.

The instances use different socket names.

The instances have appropriate net masks set.

The cluster will shut down to preserve data consistency.

The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

A manual intervention to force group members to be only the working two instances is required.

You can scale writes by creating a replicated mesh.

It guarantees near real-time replication between a master and a slave.

You can scale reads by adding multiple slaves.

MySQL Enterprise Backup will automatically back up from an available slave.

It allows backup to be done on the slave without impacting the master.

ALTER USER baduser@hostname PASSWORD DISABLED;

ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

ALTER USER baduser@hostname ACCOUNT LOCK;

ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

ALTER USER baduser@hostname DEFAULT ROLE NONE;

PREFERRED

VERIFY_CA

REQUIRED

VERIFY_IDENTITY

installing and configuring the Connection Control plugin

avoiding concatenation of SQL statements and user-supplied values in an application

using stored procedures for any database access

using PREPARED STATEMENTS