Online Access Free 1Z0-921 Exam Questions

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

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

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 not created because there is an explicit ROLLBACK.
• B.Both the tables, t1 and t2, are created.
• C.Only the t1 table is created.
• D.Only the t2 table is created.

The slave connects to the master and asks for updated records. What command was issued for this to happen?

• A.START RUN SLAVE
• B.SLAVE START
• C.SLAVE RUN
• D.START SLAVE
• E.RUN SLAVE

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

How does MySQL HeatWave improve query performance?
Response:

• A.By automatically creating indexes on frequently used columns.
• B.By replicating data across multiple servers.
• C.By caching the entire database in memory.
• D.By offloading analytics queries to an in-memory, highly parallel processing engine.