MySQL Cloud Service 2018 Implementation Essentials

Question 1

Which three statements are true about MySQL Enterprise Backup?

A. It enables you to take non-locking backups.

B. It provides the ability to create incremental backups.

C. It performs logical backups.

D. It performs hot or warm backups.

E. It cannot backup encrypted tablespaces.

Correct Answer: A,B,C

Question 2

Identify three characteristics of the JSON data type.

A. Comparisons of JSON values are not case-sensitive.

B. A set of SQL functions substantially support the SQL utilization of the data type.

C. it supports indexing directly against the JSON-defined column.

D. It validates the JSON syntax on insert or merge.

E. Key or array references enable quick read-access to look up document elements directly.

F. It is based on the TEXT data type.

Correct Answer: C,D,E

Question 3

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. EXECUTE PROC run_daily_report INCLUDE PARAMETER ('2016/12/31');

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

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

Correct Answer: D

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

Question 4

The replication setup for Master and Slave MySQL 5.6 instances is configured and running correctly without using Global Transaction ID (GTID).
You are required to perform a replication change to implement GTID for the MASTER and SLAVE configuration.
Which two steps would you perform?

A. Enable GTID by executing the following on MASTER and SLAVE:>set global GTID_ENALBED=on;

B. On the SLAVE, alter the mysql master connection setting with:> CHANGE MASTER TO>MASTER_HOST = host,>MASTER_PORT = port,>MASTER_USER = user,>MASTER_PASSWORD= password,>MASTER_AUTO_POSITION=1

C. Execute the following on SLAVE to enable GTID:>start slave io_thread - -gtid-mode=on;

D. On the SLAVE, alter the mysql master connection setting with:> ALTER system CHANGE MASTER TO>MASTER_HOST = host,>MASTER_PORT = port,>MASTER_USER = user,>MASTER_PASSWORD= password,>MASTER_AUTO_POSITION=1

E. Restart MySQL (MASTER and SLAVE) with the following options enabled:- - gtid_mode=ON- - log-bin- -log-slave-updates- - enforce-gtid-consistency

Correct Answer: B,E

Question 5

Which three are part of the core MySQL architecture? (Choose three.)

A. Storage engines

B. Optimizer

C. Parser

D. Disk parity/RAID

E. mysqldump

Correct Answer: A,B,E

Question 6

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. Using the - - only- innodb or - - only- innodb- with -frm option to back up only InnoDB tables

B. Using the - - no-locking option to backup non_InnoDB files

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. Shutting down the MySQL database and using MySQL Enterprise Backup to restart the MySQL Database to remove any potential locking

Correct Answer: B,C,D

Question 7

MySQL is installed on a Linux server and has the following configuration:
[mysqld]
User=mysql
Datadir=/data/mysql
Which two methods should you use to change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

A. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

B. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';

C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

D. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';

Correct Answer: A,D

Question 8

You have the following mysqlbackup-inc.cnf config file:

Which two commands allow MySQL Enterprise Backup to perform incremental backup based on the last full backup?

A. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password incremental

B. # mysqlbackup -defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password backup-to-incremental

C. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password backup-incremental

D. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password --with-timestamp backup

E. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password --incremental backup-to-image

Correct Answer: E

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

Question 9

You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted.
What steps would you perform to create a new audit file?

A. Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME
'audit_log.so'; Delete the corrupted file. Restart the MySQL server.

B. Stop the MySQL server. Move or rename the existing audit.log file. Restart the MySQL server.

C. As the root user, execute the FLUSH AUDIT LOGS command. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH.

D. As the root user, execute the SET GLOBAL audit_log_flush=ON command.

Correct Answer: A

Question 10

Your customer wants you to install and configure MySQL on the customer's Oracle Linux 6 server with tarball binaries in the /app/mysql1/directory, where the bin directory is found at /app/mysql/bin and a data directory at /app/data.
What are two correct and required server configurations, excluding redundant configuration entries, to build a MySQL instance supporting your customer's requirement?

A. The configuration log-bin=/app/data is needed.

B. The configuration datadir=/app/mysql/data is needed.

C. The configuration innodb_log_group_home_dir=/datadir is needed.

D. The configuration basedir=/app/mysql is needed.

E. The configuration basedir=/app/mysql/bin is needed.

F. The configuration datadir=/app/data is needed.

Correct Answer: E,F

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

Latest Update

Useful Links

Contact Us