MySQL Cloud Service 2018 Implementation Essentials (1z0-320) Free Practice Test

Question 1

The user 'fwuser'@'localhost' was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database.
You executed commands:

You want to clear the account whitelist for the 'fwuser'@'localhost' user. Which statement would you run to accomplish this?

A. CALL mysql.sp_set_firewall_mode ('fwuser@localhost', 'CLEAR');

B. SET mysql.sp_set_firewall_mode= 'RECORDING';

C. CALL mysql.sp_reload_firewall_rules ('fwuser@localhost');

D. DELETE TABLE INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST;

Correct Answer: A

Question 2

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

A. TDE supports at-rest encryption for InnoDB tables stored in file-per-table tablespaces.

B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the KEY VAULT file.

C. Both MyISAM and InnoDB table can be encrypted by setting the keyring_engine =ALL variable in the MySQL configuration file.

D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

Correct Answer: A

Question 3

Your customer runs several Oracle products and would like to reuse them. Identify four options that are certified to work with the MySQL Enterprise Edition features.

A. MySQL Enterprise Firewall uses Oracle Database Firewall to block intrusive users and queries.

B. MySQL Server can be monitored by Oracle Enterprise Manager both for performance and alerting.

C. MySQL Enterprise Backup can send its backups directly to Oracle Secure Backup.

D. MySQL Server's configuration can be saved by Oracle Enterprise Manager so that configuration changes can be tracked.

E. MySQL Enterprise Encryption uses Cloud Key Vault's access to OpenSSL to create encrypted keys.

F. MySQL Server can be hosted using Oracle VM for hard-partitioned virtualization installations.

Correct Answer: A,C,D,E

Question 4

What command should be used to execute a stored procedure named run_daily_report with the parameter
2016/12/31?

A. UPDATE PROCEDURE run_daily_report WHERE VARIABLE = ("2016/12/31');

B. CALL run_daily_report ('2016/12/31');

C. EXECUTE PROC run_daily_report INCLUDE PARAMETER ('2016/12/31');

D. SELECT SP run_daily_report ('2016/12/31') from mysql.procedures;

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

After the installation of the MySQL Server, you cannot find MySQL Utilities.
How would you correct the problem?

A. MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution.

B. MySQL Utilities comes with MySQL Enterprise Backup. Download MySQL Enterprise Monitor to install.

C. MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install.

D. MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. Download the MySQL Utilities separately from www.mysql.com.

E. MySQL Utilities is a package from MySQL Connector. Download the MySQL/Connector and install.

Correct Answer: D

Question 6

A keyfile has been generated as follows:
# openssl rand 32 -hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?

A. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile -
-backup-dir=/var/tmp/backup backup-to-image

B. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile -
-backup-dir=/var/tmp/backup backup-to-image

C. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup - timestamp backup

D. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup

E. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - - backup-dir=/var/tmp/backup backup-to-image

Correct Answer: A

Question 7

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup.
You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

A. --uncompress-and-apply-log

B. --copy-back-and-apply-log

C. --uncompress

D. --apply-log-and-copy-back

E. --decompress

Correct Answer: B,C

Question 8

Identify three levels in which MySQL Enterprise Monitor provides access control.

A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services

B. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration

C. Asset visibility: the rights to access data collected from hosts or MySQL instances

D. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent

E. Specific data access: the rights to view specific types of potentially sensitive data

Correct Answer: B,C,E

Question 9

Which two statements are true about MySQL Enterprise Firewall?

A. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

B. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

C. 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.

D. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.

E. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

F. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.

Correct Answer: B,F

Question 10

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

A. MySQL CS is based on the MySQL Enterprise Product Suite.

B. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.

C. Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II).

D. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard).

E. MySQL CS is installed based on the Oracle Flexible Architecture Standard.

F. MySQL CS configuration can be changed in /etc/my.cnf.

Correct Answer: A,C,F

Welcome to TestSimulate

Oracle MySQL Cloud Service 2018 Implementation Essentials (1z0-320) Free Practice Test