Online Access Free 1Z0-921 Exam Questions

Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

• A.Simple Authentication and Security Layer
• B.Native Windows services
• C.authentication via Pluggable Authentication Modules (PAMs)
• D.SECURID authentication and authorization identity
• E.connections through the local host via the UNIX socket file
• F.authentication using SHA-256 password hashing

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

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

Which two statements are true about MySQL Enterprise Authentication?

• A.MySQL Enterprise Authentication determines what operation the user can perform.
• B.MySQL Enterprise Authentication supports Windows Active Directory.
• C.MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
• D.MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
• E.MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.

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.Only the t1 table is created.
• C.Only the t2 table is created.
• D.Both the tables, t1 and t2, are created.

What are the two main components required to set up persistent storage for MySQL on Kubernetes?
Response:

• A.PVC (Persistent Volume Claim) and ConfigMap
• B.Pod and ReplicaSet
• C.Secret and Deployment
• D.PVC (Persistent Volume Claim) and PV (Persistent Volume)