Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z0-320 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Identify the MySQL plug-in that is provided only with MySQL Enterprise Edition and servers to increase performance and high availability.

A. the MySQL PAM Authentication plug-in B. the MySQL Firewall plug-in C. the MySQL Semisynchronous replication plug-in D. the MySQL No-Login Authentication plug-in E. the MySQL Thread Pool plug-in F. the MySQL memcached plug-in

Discussion 0

Correct Answer: A Vote an answer

Question 2

You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

A. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard. B. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances. C. Go to the configuration section (MEM) and configure the default login credentials. D. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.

Discussion 0

Correct Answer: B Vote an answer

Question 3

You want to use Workbench to connect your local MySQL instance by using a local socket. Where would you find the location of the socket file?

A. You always use port 3307 for connecting by using the local socket. B. The file location is set by using the socket parameter located in the global or local option file. C. You can find the file by querying the GLOBAL VARIABLE SOCKET_LOCATION parameter. D. You have to set up your session to be able to accept LOCAL SOCKET, and then connect via port 22. E. The socket file is located in the MySQL data directory.

Discussion 0

Correct Answer: B Vote an answer

Question 4

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 Enterprise Backup will back up from Slave automatically. D. It allows backup to be done on the slave without impacting the master. E. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 5

You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables.
Which syntax accomplishes this?

A. CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON *.* TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO 'mysqlbackup'@'localhost';GRANT REPLICATION CLIENT ON *.* TO 'mysqlbackup'@'localhost'; B. CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON *.* to 'mysqlbackup'@localhost';GRANT CREATE, INSERT, DROP, UPDATE ON, mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ONmysql.backup_history TO 'mysqlbackup'@'localhost';GRANT REPLICATION CLIENT ON *.* to 'mysqlbackup'@'localhost';GRANT SUPER ON *.* TO
'mysqlbackup'@'localhost';GRANT PROCESS ON *.* TO 'mysqlbackup'@'localhost';GRANT LOCK TABLES, SELECT, CREATE, ALTER ON *.* TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO 'mysqlbackup'@'localhost'; C. CREATE USER 'mysqlbackup'@localhost'IDENTIFIED BY 'new-password'; D. CREATE USER 'mysqlbackup'@localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON
*.* TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON
mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO 'mysqlbackup'@'localhost';GRANT REPLICATION CLIENT ON *.* TO 'mysqlbackup'@'localhost';GRANT SUPER ON *.* TO 'mysqlbackup'@' localhost;GRANT PROCESS ON *.* 'mysqlbackup'@'localhost'; E. CREATE USER 'mysqlbackup'@'localhost' IDENTIFIED BY 'new-password';GRANT RELOAD ON *.* TO ''mysqlbackup'@'localhost';GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO 'mysqlbackup'@'localhost';GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO 'mysqlbackup'@localhost';

Discussion 0

Correct Answer: C Vote an answer

Question 6

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. $ mysql - - print-defaults B. $ mysqld --help C. $ mysqld - -help - -verbose | grep-A1 "Default options" D. SHOW GLOBAL VARIABLES;

Discussion 0

Correct Answer: B,C Vote an answer

Question 7

You have a user on your MySQL instance who is flooding the server with complex queries and large INSERTS, which prevents another user with a higher priority from running queries. Which two choices will limit the number of SELECTS to 10 per hour and the number of INSERTS to 4 per hour for user 'employee1' from MySQL Workbench by first selecting Server> Users and Privileges> employee1?

A. Set Max. Queries to 10 for 'employee1'. B. Set Max. Queries to 14 for 'employee1'. C. Set Max. Connections to 14 for 'employee1'. D. Set Max Updates to 4 for 'employee1'. E. Set Concurrent Connections to 14 for 'employee1'.

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

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 Encryption uses Cloud Key Vault's access to OpenSSL to create encrypted keys. B. MySQL Server can be monitored by Oracle Enterprise Manager both for performance and alerting. C. MySQL Server can be hosted using Oracle VM for hard-partitioned virtualization installations. D. MySQL Server's configuration can be saved by Oracle Enterprise Manager so that configuration changes can be tracked. E. MySQL Enterprise Backup can send its backups directly to Oracle Secure Backup. F. MySQL Enterprise Firewall uses Oracle Database Firewall to block intrusive users and queries.

Discussion 0

Correct Answer: A,D,E,F Vote an answer

Question 9

You have the MySQL 5.7 database running. MySQL Enterprise Backup 3.12 is installed and it is used to back up the MySQL 5.7 database. The backup has failed. Identify the reason.

A. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack. B. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the - -upgrade on MySQL 5.7 database to allow the mysql.backup_progress and mysql.backup_history tables to be patched. C. MySQL Workbench must be installed with MySQL Enterprise Backup to enable the backup to run successfully. D. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x providing that the MySQL 5.7 is pre-registered in the MySQL Enterprise Backup configuration file. E. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7.

Discussion 0

Correct Answer: A Vote an answer

Question 10

Which command in MySQL Utility can perform and start replication among a slave and multiple masters?

A. mysqlreplicate B. mysqlrpladmin C. mysqlrplms D. mysqlrplcheck E. mysqlreplicatems

Discussion 0

Correct Answer: C Vote an answer