MySQL 2019 Implementation Essentials (1Z1-920) Free Practice Test

Question 1

Which two deployment architectures could you use for scaling-out database reads?

A. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.

B. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.

C. Edit the configuration file and increase the value for parallel_read_workers and reboot the server

D. Implementing a three-node, single-primary InnoDB Cluster.

E. Altering the storage engine for all tables to memory to increase performance.

Correct Answer: D,E

Question 2

You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

A.

B.

C.

D.

E.

Correct Answer: A

Question 3

Which is true about inserting an additional line in a single document stored in MySQL document store?

A. The path specified must be an array position past the end of an array using the JSON_POSITION statement.

B. Any new lines can only be inserted at the end of the document.

C. You specify the new element's position in the JSON_ARRAY_INSERT statement.

D. You cannot insert a single line, you have to replace the entire document with a new document.

Correct Answer: C

Question 4

After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?

A. The root password displayed on the screen via a [warning] message.

B. The root password inserted in the error log set by the --log-error=[file_name] variable

C. The root password is not given and is blank. You must manually set the root password.

D. As root, execute the show password command by using the SHA-256 password encryption plug-in.

E. The root_pw variable stored in the mysq1.install table.

Correct Answer: D,E

Question 5

Which query will find rows in a table that have no counterpart in another table?

A. SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;

B. SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;

C. SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;

D. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;

Correct Answer: B

Question 6

Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

A. MySQL Enterprise Monitor and MySQL Audit

B. MySQL Workbench and MySQL Enterprise Firewall

C. MySQL Audit and MySQL Workbench

D. SQL Enterprise Monitor and MySQL Enterprise Authentication

Correct Answer: D

Question 7

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?

A. plugin-load=audit_log.so

B. audit_log_permanent=ON

C. LOAD PLUGIN=AUDIT_LOG

D. audit-log=FORCE_PLUS_PERMANENT

E. plugin-audit=ON, ALWAYS

Correct Answer: B,D

Welcome to TestSimulate

Oracle MySQL 2019 Implementation Essentials (1Z1-920) Free Practice Test