Question 1

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 2

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld]Loq-binBinrylog_format=ROWYou do not notice the spelling error in binrylog_format and restart your production server.How does the MySQL server behave with incorrectly spelled options?

Options :

A : Mysqld uses internal configuration versioning and reverts to the previous configuration.

B : When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

C : The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

D : Mysqld prints to the error log about an unknown variable, and then exits.

Answer: D

Question 3

Examine this command and output:

Which statement is true?

Options :

A : Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

B : Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C : Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

D : Firewall_access_granted is the number of connections granted from whitelisted hosts.

Answer: C

Question 4

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 theSSL/TLS connection to MySQL?

Options :

A : REQUIRED

B : VERIFY_CA

C : VERIFY_IDENTITY

D : PREFERRED

E : DISABLED

Answer: A

Question 5

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

Free 1Z0-908 Mock Exam – Practice Online Confidently

Buying Options: