Question 1

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 loss, the cluster is initialized and a restore is attempted resulting in this error:

ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running

Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

Options :

A : Stop all instances except the primary read/write master instance and run the restore.

B : Remove the @@GLOBAL.gtid_purged statement from the dump file.

C : Create the backup by using the --set-gtid-purged=OFF option.

D : Remove the group replication plugin from each instance before restoring.

E : Remove the @@GLOBAL.gtid_executed statement from the dump file.

F : Restore using the --set-gtid-purged=OFF option.

Answer: B,C

Question 2

On examination, your MySQL installation datadir has become recursively world read/write/executable.

What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

Options :

A : Users could overwrite configuration files.

B : Data files could be deleted.

C : SQL injections could be used to insert bad data into the database.

D : MySQL binaries could be damaged, deleted, or altered.

E : Extra startup time would be required for the MySQL server to reset the privileges.

Answer: A,B

Question 3

Examine this MySQL client command to connect to a remote database:

mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=

Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

Options :

A : REQUIRED

B : VERIFY_CA

C : VERIFY_IDENTITY

D : PREFERRED

E : DISABLED

Answer: A

Question 4

You execute this command:

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

Which statement is true?

Options :

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.

Answer: B

Question 5

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

Options :

A : The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

B : It is possible to retrieve a normalized statement, but never the exact statement that was executed.

C : It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

D : It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

E : It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Answer: C,D

Confidently Practice Online with Free 1Z0-908 Exam Cram

Buying Options: