Oracle 1z1-320 Exam : MySQL Cloud Service 2018 Implementation Essentials

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

• A. Configure MySQL Replication between two MySQL Database instances and setting Replication mode = active.
• B. 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.
• C. 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.
• D. Execute the following on the 2x MySQL Server Instancesmysql> ALTER REPLICATION set mode= active;
• E. 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

You have configured MySQL Enterprise Transparent Data Encryption (TDE). What command would you use to encrypt a table?

• A. UPDATE TABLE SET ENCRYPTION = 'ON';
• B. ALTER INSTANCE ROTATE INNODB MASTER KEY;
• C. ALTER TABLE <table> ENCRYPTION = 'Y';
• D. ALTER mysql.encryption SET tde_status = 'YES';

Which two statements are true about MySQL Enterprise Firewall?

• A. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.
• B. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• C. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
• D. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
• E. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• F. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

The MySQL Cloud Service (CS) is a database offering from Oracle. Which three statements are correct?

• A. MySQL CS configuration can be changed in /etc/my.cnf.
• B. MySQL CS is installed based on the Oracle Flexible Architecture Standard.
• C. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard).
• D. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.
• E. MySQL CS is based on the MySQL Enterprise Product Suite.
• F. Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II).

After installing MySQL 5.7, you initialize the data directory with the - -initialize command. Identify two places in which you would find the root password.

• A. As root, execute the SHOW PASSWORD command by using the SHA-256 password encryption plug-in.
• B. The root password is not given and is blank. You must manually set the root password.
• C. The root password will be inserted in the error log set by the - -log error= [file_name] variable.
• D. You will find it as a root_pw variable stored in the mysql.install table.
• E. The root password will be displayed on the screen via a [Warning] message.