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 MySQL system being backed up can never be unavailable or locked to the client applications.
* The recovery from the backup must work on any system.
* Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

• A.Take your backup from a slave of the MySQL system.
• B.Take a logical backup of the MySQL system.
• C.Use the Clone Plugin to copy the data to another MySQL system.
• D.Take a physical backup of the MySQL system.

Comment: *

Name: *

Email: *

Verification: *

Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

• A.Cross-database constraints can cause database inconsistency.
• B.Setting slave_preserve_commit_order to on will improve data consistency.
• C.Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
• D.Increasing slave_parallel_workers will improve high availability.
• E.Setting transaction_allow_batching to on will improve data consistency.
• F.Each slave thread is responsible for updating a specific database.

Comment: *

Name: *

Email: *

Verification: *

Examine this command and output:

Which statement is true?

• A.Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.
• B.Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.
• C.Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
• D.Firewall_access_granted is the number of connections granted from whitelisted hosts.

Comment: *

Name: *

Email: *

Verification: *

Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

• A.DESCRIBE manufacturing.parts;
• B.SELECT * FROM information_schema.COLUMN_STATISTICS;
• C.EXPLAIN SELECT INDEXES FROM manufacturing.parts;
• D.SHOW INDEXES FROM manufacturing.parts;
• E.SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';

Comment: *

Name: *

Email: *

Verification: *

You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?

• A.installing and configuring the Connection Control plugin
• B.avoiding concatenation of SQL statements and user-supplied values in an application
• C.using stored procedures for any database access
• D.using PREPARED STATEMENTS

Comment: *

Name: *

Email: *

Verification: *