1Z0-920 Online Practice Questions and Answers

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

A. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

B. Use mysqldump with the - -changesonly option.

C. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.

D. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.

E. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - compress-level to select the level of compression.

Which statement would you use to remove the population column from the city table?

A. ALTER TABLE city DROP population;

B. DELETE population FROM city;

C. ALTER TABLE city DELETE population;

D. ALTER TABLE city LESS population;

E. DROP population FROM city;

You have three machines with MySQL Databases running on Linux platform. Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.

2.

Install MySQL Enterprise Backup on machine which is used to start the backup.

3.

Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving-- hosts=machine1:port1, machine2:port2, machine3:port3.

4.

Validate the backups using the mysqlbackup program to ensure that the backups created are valid.

B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.

2.

Install MySQL Enterprise Backup on all three machines.

3.

Start mysqlbackup on all machines to back up the database to the mounted volume using - -backupdir.

4.

Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.

2.

Install MySQL Enterprise Backup on the machine that is used to start the backup.

3.

Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.

4.

Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.

D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.

2.

Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.

3.

Startup MySQL backup from MySQL Workbench to back up the three databases.

4.

Validate the backup by using MySQL Workbench to ensure that the backup created is valid.

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log. Which two options should you add to the mysqlbackup to achieve the restoration of the database?

A. --uncompress-and-apply-log

B. --apply-log-and-copy-back

C. --copy-back-and-apply-log

D. --uncompress

E. --decompress

How would you restrict a user Joe from accessing all MySQL database objects?

A. CREATE USER 'joe'@'0.0.0.0' SET Password=PASSWORD('% ! %')

B. REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';

C. UPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';

D. Insert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

E. CREATE USER ' joe'@1' %' DENY ALL PRIVILEGES

Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

A. MySQL Enterprise Audit

B. MySQL Enterprise Scalability

C. MySQL Enterprise No-Login Authentication

D. MySQL Enterprise Transparent Data Encryption (TDE)

E. MySQL Enterprise Data Masking and De-identification

Which two statements are true about MySQL Enterprise Authentication?

A. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.

B. MySQL Enterprise Authentication determines what operation the user can perform.

C. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).

D. MySQL Enterprise Authentication supports Windows Active Directory.

E. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..

Which two methods help prevent MySQL security risks?

A. Use a firewall to control access to MySQL ports.

B. Transmit plain (unencrypted) data over networks.

C. Ensure that MySQL accounts have short and easy passwords.

D. Allow unauthorized clients to connect to the server.

E. Use the secure installation script "mysql_alays_secure_installation".

F. Grant only permissions that a user requires.