1Z0-908 Online Practice Questions and Answers

Examine this command and output:

Which two statements are true? (Choose two.)

A. The lock is at the metadata object level.

B. The lock is a shared lock.

C. The lock is an intentional lock.

D. The lock is at the table object level.

E. The lock is a row-level lock.

F. The lock is an exclusive lock.

Examine this command, which executes successfully: cluster.addInstance(`@:', {recoveryMethod: `clone'}) Which three statements are true? (Choose three.)

A. The account used to perform this recovery needs the BACKUP_ADMIN privilege.

B. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

C. InnoDB tablespaces outside the datadir are able to be cloned.

D. It is always slower than {recoveryMethod: `incremental'}.

E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

F. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.

Which two statements are true? (Choose two.)

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

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

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

D. Failure of the instance deployed on host1 provokes an outage.

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

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

Which two statements are true about the binary log encryption feature? (Choose two.)

A. It encrypts any connecting slaves connection thread.

B. It can be set at run time.

C. It requires a keyring plugin.

D. When enabled it encrypts existing binary logs.

E. It can be activated per session.

Your MySQL environment has asynchronous position based-replication with one master and one slave.

The slave instance had a disk I/O problem, so it was stopped.

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

You restart MySQL Server.

How can replication be restored?

A. The slave relay logs should be deleted; then execute START SLAVE;

B. The relay logs from the master should be used to replace the corrupted relay logs.

C. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D. The slave needs to be restored from backup.

Which three statements are true about MySQL replication? (Choose three.)

A. Replication can use only TCP/IP connections.

B. Any instance can have multiple slaves, but it can have only one master.

C. Each instance in a replication topology must have a unique server ID.

D. Binary logs contain only transactions originating from a single MySQL instance.

E. Each slave must have its own MySQL user for replication.

F. Binary logging must be enabled on the master in order to replicate to other instances.

G. A replication user must have the SELECT privilege for all tables that need to be replicated.

Examine this command, which executes successfully:

$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path

Which activity is performed?

A. MySQL Router is configured based on the information in files in directory_path.

B. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.

C. MySQL Router is restarted.

D. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)

A. SHOW ENGINE INNODB STATUS;

B. INFORMATION_SCHEMA.INNODB_METRICS

C. SHOW TABLE STATUS;

D. INFORMATION_SCHEMA.STATISTICS

E. INFORMATION_SCHEMA.INNODB_TABLESTATS

F. SHOW STATUS;

You execute this command:

shell> mysqlpump --exclude-databases=% --users

Which statement is true?

A. It creates a logical backup of all MySQL user accounts.

B. It creates a logical backup of all metadata, but contains no table data.

C. It returns an error because the mysqldump command should have been used.

D. It creates a logical backup of only the users database.

User account baduser@hostname on your MySQL instance has been compromised.

Which two commands stop any new connections using the compromised account? (Choose two.)

A. ALTER USER baduser@hostname PASSWORD DISABLED;

B. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

C. ALTER USER baduser@hostname ACCOUNT LOCK;

D. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

E. ALTER USER baduser@hostname DEFAULT ROLE NONE;