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

Question 1

You have installed MySQL 5.6.20 on Windows 2012. This MySQL Instance is monitored without an Enterprise Monitor Agent. You cannot see any MySQL queries. How can you enable this feature?

A. Use UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name =
'statements_digest'; B. MySQL query analyzing is available only in MySQL Version 5.7 and later. You need a later version of MySQL C. For query analyzing, it is mandatory to use a MySQL Enterprise Monitor agent on Windows 2012 Server. D. Use UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name='statements_digest';

Discussion 0

Correct Answer: D Vote an answer

Question 2

Identify two features of MySQL Enterprise Firewall.

A. You can automatically delete a user if the user breaks your firewall. B. You can modify a request with a SQL statement substitution. C. You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands. D. You set the firewall per database. E. You can block out potential threats by setting up a preapproved whitelist.

Discussion 0

Correct Answer: C,E Vote an answer

Question 3

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 5.6 or a later instance. Which three features are available?

A. Starting and Stopping the MySQL Instance B. Monitoring the availability of the MySQL instance C. Tracing import and export with mysqldump D. Analyzing executed MySQL queries E. Creating E-Mail Alerts and SNMP Traps for MySQL Warnings F. Deploying MySQL Agent on supported target operating system

Discussion 0

Correct Answer: C,E,F Vote an answer

Question 4

A MySQL 5.7 is monitored via 3306 without a MySQL agent (agentless installation).
Which two options are not available in such a setup in the MEM GUI?

A. Network-related information and network characteristics B. Security-related advisors warning (for example, password warnings and firewall warnings) C. MySQL Replication monitoring D. MySQL Query Analysis data. E. Disk usage and disk characteristics including disk advisors warnings

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

You want to prevent any unauthorized users from gaining access to the personal information of your employees, which is stored in the EMPLOYEE table in a MySQL database. How would you use the MySQL Enterprise Edition Firewall to prevent the following SQL injection attack from exposing the salaries of all your employees?
SELECT fl_name, salary FROM EMPLOYEE WHERE fl_name= 'JHacker' OR 1=1;

A. Create a FIREWALL STORED PROCEDURE to block any external user from executing this SQL statement. B. Create a whitelist of approved SQL commands by using the RECORDING mode, and enable protection by changing it to PROTECTION mode. C. Create a blacklist of the SQL commands, which would restrict access to the EMPLOYEE table by using the DETECTING mode. D. Create a list of approved SQL users by using the INTERROGATION mode.

Discussion 0

Correct Answer: B Vote an answer

Question 6

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. SET mysql.sp_set_firewall_mode= 'RECORDING'; B. CALL mysql.sp_reload_firewall_rules ('fwuser@localhost'); C. CALL mysql.sp_set_firewall_mode ('fwuser@localhost', 'CLEAR'); D. DELETE TABLE INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST;

Discussion 0

Correct Answer: C Vote an answer

Question 7

The MySQL database for backup with used data is configured only with the InnoDB storage engine. System data including SP, VIEWs, and users in the system database are all static. For any changes with system data, the database backup will be done separately.
You are requested to optimize backup performance to reduce backup time by using MySQL Enterprise Backup for the daily backup operation with user data (configured with the InnoDB storage engine).
Which three options would you choose to optimize the backup performance?

A. Shutting down the MySQL database and using MySQL Enterprise Backup to restart the MySQL Database to remove any potential locking B. Using the - - only- innodb or - - only- innodb- with -frm option to back up only InnoDB tables C. Running multiple MySQL Enterprise Backups at the same time to back up the same database to allow parallel database backups on MySQL D. Running the backup with the backup policy, full backup and incremental backup, supported by MySQL Enterprise Backup to reduce the daily backup time E. Using the - - no-locking option to backup non_InnoDB files

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 8

Which two ports need to be opened on a network firewall to allow an outside client (on the other side of the firewall) to be able to access a MySQL instance inside the firewall?

A. Port 18443/tcp [MySQL], when connecting from MySQL Workbench to a Windows MySQL server B. Port 22/tcp [SSH], when using TCP/IP over SSH C. Port 3306/tcp [MySQL], when tunneling is not used from within MySQL Workbench D. Port 13306/tcp [MySQL], when using TCP/IP via a command-line client

Discussion 0

Correct Answer: B,C Vote an answer

Question 9

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 10

The user 'OS-user'@'localhost' was created to monitor connections and shut down the server, and was granted the following privileges:
GRANT PROCESS, SHUTDOWN ON *.* to 'OS-user'@'localhost';
Identify three commands that the OS-user can execute.

A. KILL PROCESS; B. SHOW STATUS; C. SHUTDOWN; D. SHOW PROCESSLIST; E. SHOW BINLOG EVENTS;

Discussion 0

Correct Answer: A,B,C Vote an answer