1Z0-908 Online Practice Questions and Answers

You have configured GTID-based asynchronous replication with one master and one slave.

A user accidentally updated some data on the slave.

To fix this, you stopped replication and successfully reverted the accidental changes.

Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

A. RESET MASTER; SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1- 2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

C. RESET SLAVE; SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa--aaaaaaaaaaaa:1-10300;

D. RESET MASTER; SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

E. RESET SLAVE; SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Which three are requirements for a secure MySQL Server environment? (Choose three.)

A. Restrict the number of OS users that have access at the OS level.

B. Ensure appropriate file system privileges for OS users and groups.

C. Minimize the number of non-MySQL Server-related processes running on the server host.

D. Encrypt the file system to avoid needing exact file-system permissions.

E. Keep the entire software stack on one OS host.

F. Run MySQL server as the root user to prevent incorrect sudo settings.

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.

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.

Examine the modified output:

Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)

A. The master is most probably too busy to transmit data and the slave needs to wait for more data.

B. One or more large tables do not have primary keys.

C. This value shows only I/O latency and is not indicative of the size of the transaction queue.

D. The master is producing a large volume of events in parallel but the slave is processing them serially.

E. The parallel slave threads are experiencing lock contention.

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

B. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

C. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

MySQL programs look for option files in standard locations.

Which method will show the option files and the order in which they are read?

A. shell> mysqladmin --debug

B. shell> mysql --print-defaults

C. shell> mysqld --help --verbose

D. mysql> SHOW GLOBAL VARIABLES;

Which statement is true about InnoDB persistent index statistics?

A. Updating index statistics is an I/O expensive operation.

B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

Which three requirements must be enabled for group replication? (Choose three.)

A. slave updates logging

B. semi-sync replication plugin

C. primary key or primary key equivalent on every table

D. binary log checksum

E. binary log ROW format

F. binary log MIXED format

G. replication filters

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.