1Z0-920 Online Practice Questions and Answers

Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

A. MySQL Servers with Group Replication to replicate data to all members of the cluster.

B. MySQL Online Hot Backup to keep data consistent and always ready to be used.

C. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.

D. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.

E. MySQL Router to ensure client requests are load balanced and routed to the correct servers.

You need to change the password level for a test system. Which two allow to change this level before you create new test user/passwords?

A. Add validate_password='new level' in the [security] section of the MySQL configuration file.

B. SET GLOBAL validate_password_policy='new level';

C. SET GLOBAL force_password_complex_policy=0;

D. Add validate_password_policy='new level' in the [mysqld] section of the MySQL configuration file.

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. --apply-log-and-copy-back

C. --copy-back-and-apply-log

D. --uncompress

E. --decompress

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

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

A. On the Master server, disable binlog by removing the --log-bin option.

B. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.

C. To safely purge binary log files, perform these steps:

1.

On each slave server, use show slave status to check which log file it is reading.

2.

Obtain a listing of the binary log files on the master server with show binary logs.

3.

Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up- to-date, this is the last log file on the list.

4.

Make a backup of all the log files you are about to delete. (This step is optional, but always

advisable.)

5.

Purge all log files up to but not including the target file by using the purge binary logs statement

D. Execute the purge binary logs statement without argument.

E. Delete all binlog files manually on the file system to release storage spaces.

Which three are characteristics of the JSON data type?

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

B. It supports indexing directly against the JSON-defined column.

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

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

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

F. It is based on the TEXT data type.

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

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

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

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

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

Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT =

1:

What is the result after issuing the rollback command?

A. Both the tables, t1 and t2, are created.

B. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

C. Only the t2 table is created.

D. Only the t1 table is created.

Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

A. The number of machines per group must be 3, 5, 7 or 9.

B. use SSD's for data and replication logs

C. Groups must be in even numbers; 2, 4, 6, 8.

D. isolated machine resources

E. Use Network-attached storage (NAS) for the data files.

F. smaller VM's work best - with a maximum of eight vCPU's and 16GB of RAM

G. Networks must be in separate regions.

How would you restrict a user Joe from accessing all MySQL database objects?

A. CREATE USER 'joe'@'0.0.0.0' SET Password=PASSWORD('% ! %')

B. REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';

C. UPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';

D. Insert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

E. CREATE USER ' joe'@1' %' DENY ALL PRIVILEGES

Which Oracle product is certified to work with MySQL Enterprise Edition?

A. Oracle Enterprise Backup

B. Oracle Data Pump

C. Oracle Enterprise Manager

D. Oracle Application Express

Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

A. You can connect directly to the VCN without a define subnet.

B. Your instance does not have a public IP address, so you cannot connect with a public subnet.

C. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.

D. You can connect directly to an instance over the internet, without a public IP address.

E. You must have an IPSec VPN to connect to an Oracle Linux instance.

Which two are advantages of using Document Store in MySQL?

A. MySQL provides a NoSQL API to access the document store

B. MySQL can store XML as a schema-less database

C. MySQL is a document database allowing PDF and Word documents

D. MySQL provides a native data type to index PDF documents

E. MySQL provides a native data type to store JSON data as a document

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 is not given and is blank. You must manually set the root password.

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

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

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

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

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

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

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

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

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

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