Online Access Free 1z1-320 Exam Questions

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 MySQL Enterprise Backup with the - -size=compress to compress the backup file.
• B.Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
• C.Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
• D.Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
• E.Use mysqldump with the - -changesonly option.

You create two database tables as shown by the following CREATE TABLE statements:
CREATE TABLE parent (
parent_id INT,
name_first VARCHAR(30),
name_last VARCHAR(30),
PRIMARY KEY (parent_id)
);
CREATE TABLE child (
child_id INT,
parent_id INT,
name_first VARCHAR(30),
name_last VARCHAR(30),
PRIMARY KEY (child_id)
);
After populating both tables with data, which statement would produce an output of only the parents' first and last names and the first and last names of the related children?

• A.SELECT name_first, name_last FROM parent, child LEFT JOIN parent_id WHERE parent_id = child_id;
• B.SELECT * FROM parent, child LEFT JOIN (child) ON (child.parent_id=parent.parent_id);
• C.SELECT * .name_first, *.name_last FROM BOTH parent, child WHERE parent_id IS EQUAL;
• D.SELECT p1.name_first, p1.name_last, c1.name_first, c1.name_last FROM parent p1 LEFT JOIN child c1 ON (c1.parent_id=p1.parent_id);

The slave connects to the master and asks for updated records. What command was issued for this to happen?

• A.SLAVE RUN
• B.START RUN SLAVE
• C.START SLAVE
• D.RUN SLAVE
• E.SLAVE START

Identify three features of MySQL Enterprise Backup.

• A.You can run the output file produced by a MySQL Enterprise Backup through a MySQL session because the output file consists of SQL statements.
• B.You can back up data that has changed since the last backup with incremental backup.
• C.You can validate the results of a MySQL Enterprise Backup to ensure that your backup has integrity.
• D.You can back up individual tables or individual tablespaces with MySQL Enterprise Backup while your server instance is online.
• E.You can edit the output file produced by a MySQL Enterprise Backup.

You have a backup image file that is backed up using MySQL Enterprise Backup with the - - compress option:
/home/mysql/backup/full/mybackup/myimage.img
mysqlbackup.cnf is shown as follows:
[mysqlbackup]
backup-dir=/home/mysql/backup/full/mybackup
backup-image=/home/mysql/backup/full/mybackup/myimage.img
You are required to perform a database restore to a new machine to provision the database.
Which command can provision the new database in the datadir as /home/mysql/data/MEB?

• A.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB restore-and-apply-log
• B.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB image-to-dir-and-apply-log
• C.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB apply-log-and-copy-back
• D.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB copy-back-and-apply-log
• E.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB image-to-dir