1Z0-908 Online Practice Questions and Answers

Examine this command, which executes successfully:

mysqlpump --user=root --password > full_backup.sql

Which two databases will be excluded from this dump? (Choose two.)

A. information_schema

B. world

C. employee

D. sys

E. mysql

You are upgrading a MySQL instance to the latest 8.0 version. Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

A. It defines all innodb tablespace options relative to a starting parent directory.

B. It is not necessary because innodb_data_home_dir is already defined.

C. It allows scanning of other locations to discover more innodb tablespaces.

D. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

E. It adds more temporary workspace in addition to the innodb_tmpdir location.

Examine this statement and output:

You must try to reduce query execution time.

Which two queries should you focus on? (Choose two.)

A. QN = 3

B. QN = 5

C. QN = 1

D. QN = 4

E. QN = 2

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation. Examine the output:

What statement is true about the start attempt?

A. MySQL server was not started due to a problem while executing process 2732.

B. MySQL server continued to start up even though another process existed.

C. systemd found the mysqld service disabled and failed to start it.

D. systemd waited for 30 seconds before timing out and start up failed.

E. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Examine this SQL statement:

mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;

Which two are true? (Choose two.)

A. Mark can grant the privileges assigned to the r_read@localhost role to another user.

B. ADMIN OPTION causes the role to be activated by default.

C. Mark can grant the r_read@localhost role to another user.

D. Mark can revoke the r_read@localhost role from another role.

E. ADMIN OPTION allows Mark to drop the role.

F. Mark must connect from localhost to activate the r_read@localhost role.

Examine this command, which executes successfully:

shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb

Which two statements are true? (Choose two.)

A. It executes flush tables with read lock.

B. It enforces consistent backups for all storage engines.

C. The backup created is a consistent data dump.

D. This option uses the READ COMMITTED transaction isolation mode.

E. It is a cold backup.

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.

You issue this command:

SHOW SLAVE STATUS In the output, there is a value for Seconds_behind_master.

How is this time calculated?

A. It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.

B. It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.

C. It is the time between the I/O thread receiving details of the master's last transaction and the time it was written to the relay log on the slave.

D. It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

A. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

B. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.

C. Logical upgrades are much faster because they do not require restarting the mysqld process.

D. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.

E. Physical upgrades are much faster because they do not require restarting the mysqld process.

F. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server. Which value of --ssl-mode will do this?

A. PREFERRED

B. VERIFY_CA

C. REQUIRED

D. VERIFY_IDENTITY

You must run multiple instances of MySQL Server on a single host. Which three methods are supported? (Choose three.)

A. Run MySQL Server docker containers.

B. Use systemd with different settings for each instance.

C. Use system tools to lock each instance to its own CPU.

D. Start mysqld or mysqld_safe using different option files for each instance.

E. Run mysqld with --datadir defined for each instance.

F. Use resource groups to lock different instances on separate CPUs.

The data in this instance is transient; no backup or replication will be required. It is currently under performing.

The database size is static and including indexes is 19G.

Total system memory is 32G.

After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.

Which three changes will provide the most benefit to the instance? (Choose three.)

A. innodb_flush_log_at_trx_commit=1

B. buffer_pool_size=24G

C. innodb_log_file_size=1G

D. sync_binlog=0

E. innodb_doublewrite=0

F. max_connections=10000

G. innodb_undo_directory=/dev/shm

Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

A. Remove group read/write privileges from the private_key.pem file.

B. Remove world read privileges from the server-cert.pem certificate file.

C. Change the group ownership of the mysql directory to the mysql user group.

D. Remove world read privileges from the public_key.pem file.

E. Change the parent directory owner and group to mysql.

F. Remove the world read/execute privilege from the accounting directory.

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;

Which condition is true about the use of the hash join algorithm?

A. No index can be used for the join.

B. The query must access no more than two tables.

C. The smallest of the tables in the join must fit in memory as set by join_buffer_size.

D. At least one of the tables in the join must have a hash index.