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 is a correct example of creating an Enterprise Encryption function?
A. SET @function = CREATE_ASYMMETRIC_PRIV_KEY(@algo, @key_len);
B. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME 'openss1_udf.so';
C. INSERT INTO t1 (key_co1) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY('RSA', 1024));
D. VALIDATE FUNCTION create_asymmetric_priv_key WITH 'openssl_udf.so';
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 need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug- in
from being removed at run time.
Which two options should you include in the MySQL configuration file?
A. audit_log_permanent=ON
B. audit-log=FORCE_PLUS_PERMANENT
C. plugin-load=audit_log.so
D. plugin-audit=ON, ALWAYS
E. LOAD PLUGIN=AUDIT_LOG
What three are ways to export and import data in MySQL Workbench?
A. Result Data Export and Import
B. Binary Data Export and Import Wizard
C. SQL Data Export and Import Wizard
D. Backup Data Export and Import Wizard
E. Table Data Export and Import Wizard
F. Data Modeling Import Export Wizard
You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by
a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?
A. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
B. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.
C. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
D. Go to the configuration section (MEM) and configure the default login credentials.
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?
A. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
B. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
C. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
D. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
E. A browser-based wizard to remotely deploy the MySQL Monitor Agent
You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?
A. Execute the sakila-data. sqi script to populate the database
B. Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;
C. Use MySQL Enterprise High Availability to access one of the available data tables
D. Use mysqldump to import data from the sakila_dummy database sample data set.
Which three statements are true about MySQL Enterprise Backup?
A. It performs hot or warm backups.
B. It provides the ability to create incremental backups.
C. It cannot back up encrypted tablespaces.
D. It enables you to take non-locking backups.
E. It performs logical backups.
Which three are requirements for MySQL Group Replication (GR)?
A. Data to be replicated must be stored in the InnoDB transactional storage engine.
B. The use of global transaction identifiers is required.
C. Primary keys are required on every replicated table.
D. GR only works with MySQL versions 8.0.12 or higher.
E. The binary log format must be set to mixed.
F. The minimum number of required nodes for achieving a consensus is two.