Online Access Free 1Z0-920 Exam Questions

You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

• A.CREATE USER 'jenny'@'%' IDENTIFIED WITH sha256_password BY 'SecretPass123!';
• B.CREATE USER 'jenny'@'localhost' IDENTIFIED BY ('SecretPass123!','256', Expired)
• C.CREATE USER ,jenny,0,%t IDENTIFIED BY 'SecretPass123!' PASSWORD EXPIRE;
• D.CREATE USER 'jenny *@'localhost' IDENTIFIED WITH HASH PASSWORD('SecretPass123!')
• E.CREATE USER 'jenny'@'%' WITH HASHED(password,'SecretPass123!'), PASSWORD EXPIRE

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

• A.Implementing a three-node, single-primary InnoDB Cluster.
• 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.Altering the storage engine for all tables to memory to increase performance.
• D.Edit the configuration file and increase the value for parallel_read_workers and reboot the server
• E.Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

• A.Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.
• B.Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
• C.Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
• D.Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.

The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server.
Which statement is correct?

• A.Monitoring metrics need super and root privileges because they are not available for a less-privileged user.
• B.MySQL Enterprise Monitor creates the required users automatically.
• C.The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.
• D.The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

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

• A.Any new lines can only be inserted at the end of the document.
• B.The path specified must be an array position past the end of an array using the JSON_POSITION statement.
• 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.