1Z0-908 Exam Questions

Which two statements are true about MySQL server multi-source replication? (Choose two.)

Which command enables rule-based MySQL Auditing capabilities?

Examine this SQL statement: mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION; Which two are true? (Choose two.)

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

You have an InnoDB Cluster configured with three servers. Examine this command, which executes successfully: mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql Due to data l...

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

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 st...

You wish to store the username and password for a client connection to MySQL server in a file on a local file system. Which is the best way to encrypt the file?

You are backing up raw InnoDB files by using mysqlbackup. Which two groups of files will be backed up during a full backup? (Choose two.)

You made some table definition changes to a schema in your MySQL Server. Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

Which two are characteristics of snapshot-based backups? (Choose two.)

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

There are five MySQL instances configured with a working group replication. Examine the output of the group members: Which two statements are true about network partitioning in the...

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

A user wants to connect without entering his or her username and password on the Linux command prompt. Which three locations can be used to store the user's mysql credentials to sa...

It is a non-empty InnoDB table. Examine these statements, which are executed in one session: BEGIN; SELECT * FROM t FOR UPDATE; Which is true?

Which two MySQL Server accounts are locked by default? (Choose two.)

Examine this SQL statement: Which set of privileges will allow Tom to execute this SQL statement?

Examine these commands and output: Which connection ID is holding the metadata lock?

Which two are true about binary logs used in asynchronous replication? (Choose two.)

Which two queries are examples of successful SQL injection attacks? (Choose two.)

You execute this command: shell> mysqlpump --exclude-databases=% --users Which statement is true?

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

Examine this statement: mysql> DROP ROLE r_role1, r_role2; Which two are true? (Choose two.)

Examine these statements and output: Which statement is true?

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

You plan to install MySQL Server by using the RPM download. Which two statements are true? (Choose two.)

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases. Which command will back up the databases in parallel?

A valid raw backup of the shop.customers MyISAM table was taken. You must restore the table. You begin with these steps: 1. Confirm that secure_file_priv='/var/tmp' 2. mysql> DROP...

You want to check the values of the sort_buffer_size session variables of all existing connections. Which performance_schema table can you query?

Examine these statements, which execute successfully: TRUNCATE test; BEGIN; INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK; SELECT id FROM test; Which three storage engine...

Examine this command, which executes successful mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back...

Which three actions are effective in capacity planning? (Choose three.)

An attempt to recover an InnoDB Cluster fails. Examine this set of messages and responses: host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default clust...

Your MySQL server was upgraded from an earlier major version. The sales database contains three tables, one of which is the transactions table, which has 4 million rows. You are ru...

You reconfigure and start a slave that was not replicating for several days. The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both ma...

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

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

A colleague complains about slow response time on your website. Examine this query and output: What is the most likely cause for the high number of lock waits?

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...

Which statement is true about InnoDB persistent index statistics?

Which two are features of MySQL Enterprise Firewall? (Choose two.)

Examine the modified output: Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)

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...

Examine this command and output: Which two options will improve the security of the MySQL instance? (Choose two.)

You are using mysqlcheck for server maintenance. Which two statements are true? (Choose two.)

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation. Which three features are available with this installation method? (Choose three.)

You have a MySQL system with 500 GB of data that needs frequent backups. You use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement: - The My...

Examine these entries from the general query log: All UPDATE statements reference existing rows. Which describes the outcome of the sequence of statements?