Which are three facts about backups with mysqldump? (Choose three.)

• A.will lock all storage engines for duration of backup
• B.are able to back up specific items within a database
• C.create automatically compressed backups
• D.can back up a remote database server
• E.allow a consistent backup to be taken
• F.are always faster to restore than binary backups

Comment: *

Name: *

Email: *

Verification: *

Given these table definitions and the explain plan:

Which ALTER TABLE statement will improve the performance of the query?

• A.ALTER TABLE `CountryLanguage` ADD INDEX `idx_Lang` (`Language`);
• B.ALTER TABLE `Country` ADD INDEX `idx_Code` (`Code`);
• C.ALTER TABLE `CountryLanguage` ADD INDEX `idx_OffLang` (`IsOfficial`, `Language`);
• D.ALTER TABLE `Country` ADD INDEX `idx_NameCont` (`Name`, `CountryCode`);

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the creating of new MySQL physical and logical backups?

• A.Physical backups are usually slower than text backups.
• B.Physical backups can be used to recover from data corruption.
• C.Logical backups are human-readable whereas physical backups are not.
• D.Physical backups are usually faster than text backups.
• E.Logical backups are always larger than physical backups.

Comment: *

Name: *

Email: *

Verification: *

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

• A.using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications
• B.using SSL when transporting data over remote networks
• C.setting --skip-networking when remote connections are not required
• D.setting specific grant privileges to limit remote authentication
• E.setting --mysql_secure_configuration to enable paranoid mode

Comment: *

Name: *

Email: *

Verification: *

You attempt to connect to a MySQL Server by using the mysqlclient program. However, you receive this notice:

What would you run to fix the issue?

• A.the mysql_upgradescript
• B.the mysqlclient with the --ignore-password-hashingoption
• C.the mysql_secure_installationscript to update server security settings
• D.the mysqlclient with the --enable-cleartext-pluginoption
• E.the install plugincommand for the mysql_cleartext_passwordplugin

Comment: *

Name: *

Email: *

Verification: *