Online 1Z0-908 Practice Test

Question 1

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

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

Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.

Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

Options :

A : Implement a failover strategy to another geographic location.

B : Create a master-master pair for each service.

C : Have a second data centre in a different region or country.

D : Keep software updated to the latest version.

E : Use RAID 10 storage for data.

F : Use on-site network-attached storage to separate service from data.

Answer: A,C

Question 4

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.

Which method would use mysqlbinlog for greater consistency?

Options :

A : shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

B : shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

C : shell> mysqlbinlog – restore bin.00010 bin.00011 bin.00012

D : shell> mysqlbinlog – include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql

Answer: B

Question 5

You enable binary logging on MySQL Server with the configuration: binlog-format=STATEMENT log-bin

Which database updates are logged on the master server to the binary log by default?

Options :

A : all updates except to the TEMPDB database

B : all updates except to the PERFORMANCE_SCHEMA database

C : all updates not involving temporary tables

D : all updates to the default database, except temporary tables

E : all updates to all databases

Answer: A

EXPERTY DESIGNED 1Z0-908 PRACTICE TEST