1Z1-921 試験問題を無料オンラインアクセス

Which MySQL command is used to grant specific privileges to a user on a database?
Response:

• A.GRANT PERMISSIONS
• B.GIVE ACCESS
• C.GRANT
• D.SET PRIVILEGES

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.random data substitution
• C.dictionary substitution
• D.strict or relaxed masking
• E.misspelling

After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?

• A.The root password displayed on the screen via a [warning] message.
• B.The root_pw variable stored in the mysq1.install table.
• C.As root, execute the show password command by using the SHA-256 password encryption plug-in.
• D.The root password inserted in the error log set by the --log-error=[file_name] variable
• E.The root password is not given and is blank. You must manually set the root password.

Which two are advantages of using Document Store in MySQL?

• A.MySQL provides a native data type to index PDF documents
• B.MySQL provides a NoSQL API to access the document store
• C.MySQL is a document database allowing PDF and Word documents
• D.MySQL provides a native data type to store JSON data as a document
• E.MySQL can store XML as a schema-less database

When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?

• A.Both Cloud storage and local storage
• B.Cloud tape library
• C.Flash-archive recovery area
• D.Cloud storage only