Online Access Free 1z0-320 Practice Test

How do you restrict a user named joe from being able to connect from any IP address to a MySQL database?

• A.You cannot deny access to a user based on his or her username.
• B.Insert Joe's name into the mysql.user_restriction table, and issue the FLUSH PRIVILEGES command.
• C.UPDATE mysql.user SET Password=PASSWORD ('Invalid') WHERE User= 'joe';
• D.CREATE USER 'joe'@'0.0.0.0'SET Password=PASSWORD ('%!%')
• E.CREATE USER 'joe'@%' DENY ALL PRIVILEGES

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

• A.You can create a slave server for reporting applications, which get only read access to the slave servers.
  It off-loads the master server. Additional servers allow different database server configuration.
• B.It provides multi-master access where the application can write and read data across the database servers.
• C.MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
• D.MySQL Enterprise Backup will back up from Slave automatically.
• E.It allows backup to be done on the slave without impacting the master.

Which two architecture options can provide Active/Active Master configuration for the MySQL Database?

• A.Deploy MySQL Cluster on the following machines:Machine 1: MySQL Node+ MySQL Management NodeMachine 2: MySQL Node+ MySQL Management NodeMachine 3: Data NodeMachine 4: Data NodeApplication can access MySQL Node on Machine 1 or Machine 2 for Active/Active Configuration.
• B.2x MySQL Server Instances should be deployed on two machines with shared NFS volume. Datadir points to the shared folder. Applications can access either one of the MySQL Servers for the same set of data.
• C.Execute the following on the 2x MySQL Server Instancesmysql> ALTER REPLICATION set mode= active;
• D.Configure MySQL Replication for two MySQL Database instances with circular Replication Topology, where two different applications with each using different database schemas connecting to a specified MySQL Database Instance.MySQL Database Instance1 < -----Replication---> MySQL Database Instance 2Application A connecting to MySQL Database Instance 1 for schema db1Application B connecting to MySQL Database Instance 2 for schema db2
• E.Configure MySQL Replication between two MySQL Database instances and setting Replication mode = active.

You use MySQL Enterprise Monitor for a group of MySQL servers. In recent weeks, the MySQL Enterprise Monitor has slowed down significantly.
Which two preventative actions should you take if your number of monitored MySQL instances has changed?

• A.Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).
• B.Increase the necessary operating system swap space (Linux): mkswap /dev/sdx; swapon/dev/sdx,
  /etc/fstab.
• C.Increase the disk space with at least 10% of the database size.
• D.Increase the amount of RAM available to the JVM installed with Tomcat. The JVM memory settings are defined by the JAVA_OPTS line of the setenv file, which sets the environment variables for Tomcat (--JvmMs/-Xms and -JvmMx/-Xmx).

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