Online Access Free 1Z1-921 Exam Questions

What is true about MySQL Enterprise Transparent Data Encryption (TDE)?

• A.Encryption key is stored in a centralized key memory location
• B.Data is encrypted automatically, in real time, after it is written to storage.
• C.Enables data-at-rest encryption by encrypting the physical files of the database.
• D.Tablespace keys are managed manually behind the scenes.

Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

• A.The OCI instance is still in the "creation" process.
• B.Only root is allowed to access from non-localhost.
• C.The opc user can be used to access MySQL only with the created SSH-Key.
• D.You forgot to enable port 3306.
• E.You forgot to create the correct SSL/TLC certificate during the setup process.

Which three are characteristics of the JSON data type?

• A.Key or array references enable quick read-access to look up document elements directly.
• B.Comparisons of JSON values are not case-sensitive.
• C.It supports indexing directly against the JSON-defined column.
• D.A set of SQL functions substantially support the SQL utilization of the data type.
• E.It validates the JSON syntax on insert or merge.
• F.It is based on the TEXT data type.

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH) For accessing a new MySQL Enterprise Edition on an Oracle Cloud Infrastructure (OCI) Instance you " Add SSH key " information during the OCI instance setup. You want to use Putty from your Windows Client to install MySQL.
What are the correct steps to accomplish this?

• A.Open Port 22 on your OCI Instance and configure Putty with the ssh private key.
• B.Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.
• C.Convert the private key to ppk format first and use the new private key for authentication.
• D.Use the provided private key for authentication.

Which three statements are true about MySQL Enterprise Backup?

• A.It performs logical backups.
• B.It provides the ability to create incremental backups.
• C.It cannot back up encrypted tablespaces.
• D.It performs hot or warm backups.
• E.It enables you to take non-locking backups.