Question 1

When the backup is taken, there are no errors.Why are triggers missing from the backup?

Options :

A : The FILE privilege is required to back up the TRG files stored in the database directory.

B : The PROCESS privilege will allow the user access to process items such as triggers and functions.

C : The ALL privilege is required to back up triggers because triggers have a wide variety of abilities.

D : The TRIGGER privilege Is required to create, execute, and show triggers in a database.

Answer: D

Question 2

A MySQL replication master is set up by using global reansaction identifiers(GTIDs). You execute this statement:mysql> CREATE TABLE datatarget SELECT * FROM datasource;ERROR 1786 (HY000): CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.Why is this statment forbiden?

Options :

A : GTIDs have detected thar a slave is inconsistent and therefore, disallow upadtes until the problem is resolved.

B : The datasource table is using an older InnoDB tablespace format, which is not compatible with GTIDs.

C : The datasource table is using the MyISAM engine, which is not compatible with GTIDs.

D : The statement cannot be logged in a transactionally safe manner.

Answer: D

Question 3

You are considering using file-system snapshots to back up MySQL.Which three statements are true? (Choose three.)

Options :

A : They take roughly twice as long as logical backups.

B : They allow direct copying of table rows with operating system copy commands.

C : They work best for transaction storage engines that can perform their own recovery when restored.

D : The backup window is almost zero from the perspective of the application.

E : They do not back up views, stored procedures, or configuration files.

F : There is a slight performance cost while the snapshot is active.

G : They do not use additional disk space.

Answer: A,C

Question 4

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

Options :

A : recording the order in which queries are issued

B : audit of all queries

C : point-in-time recovery

D : replication

E : logging the duration and locks for all queries

Answer: A,C

Question 5

Which statement is true about FLUSH LOGS command?

Options :

A : It requires the RELOAD, FILE, and DROP privileges.

B : It closes and reopens all log files.

C : It closes and sends binary log files to slave servers.

D : It flushes dirty pages in the buffer pool to the REDO logs.

Answer: B

Smartly Prepare Exam with Free Online 1Z0-908 Practice Test

Buying Options: