Online Access Free 1z0-320 Exam Questions

What are security rules in Compute Cloud Service?

• A.Security are essentially firewall rules that can help to control traffic between Cloud Service instances, as well as between instances and external hosts.
• B.These are rules established by HIPAA for securing end-user data.
• C.They allow administrators access to applications in the cloud.
• D.Security rules are data encryption levels that control who can see the data.
• E.They are user-role designation that assign rights to certain users.

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 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 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.
• 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 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.
• 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 all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4.
  Validate the backup 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 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.

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 * FROM parent, child LEFT JOIN (child) ON (child.parent_id=parent.parent_id);
• B.SELECT * .name_first, *.name_last FROM BOTH parent, child WHERE parent_id IS EQUAL;
• C.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);
• D.SELECT name_first, name_last FROM parent, child LEFT JOIN parent_id WHERE parent_id = child_id;

Select three privileges that are necessary to successfully back up a server instance with the mysqlbackup command after the initial installation.

• A.INDEX
• B.RELOAD
• C.GRAND OPTION
• D.CREATE TEMPORARY TABLES
• E.REPLICATION CLIENT

The MySQL server looks for option files in standard locations. The server might read multiple files from different locations. For a Linux installation, which two methods would you use to view the options file lookup locations, the order in which they are read, and groups?

• A.SHOW GLOBAL VARIABLES;
• B.$ mysql - - print-defaults
• C.$ mysqld --help
• D.$ mysqld - -help - -verbose | grep-A1 "Default options"