Online Access Free 1Z1-921 Practice Test

Which three are requirements for MySQL Group Replication (GR)?

• A.The use of global transaction identifiers is required.
• B.GR only works with MySQL versions 8.0.12 or higher.
• C.The minimum number of required nodes for achieving a consensus is two.
• D.The binary log format must be set to mixed.
• E.Primary keys are required on every replicated table.
• F.Data to be replicated must be stored in the InnoDB transactional storage engine.

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.Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
• 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.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.
• D.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.

An Oracle Cloud Infrastructure customer already has many database instances configured and running in the cloud; however, they are reporting that they are unable to create any more instances.
What could be the problem?

• A.The customer reached the database instance limit of 32.
• B.The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to-date.
• C.The customer does not have proper user rights.
• D.The customer account might have reached resource quota/limits.

MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. Which three are MySQL Enterprise Masking and De-identification functions?

• A.whitelisting and substitution
• B.strict or relaxed masking
• C.dictionary substitution
• D.misspelling
• E.random data substitution

What SQL keyword must be specified when creating a foreign key constraint?

• A.unique PRIMARY key values for both child and parent tables
• B.an index on the foreign key
• C.a TRIGGER on the child table for cascading delete statements
• D.a REFERENCES in the child table to the parent table
• E.the SET_FOREGIN variable in the my .cnf file