Oracle 1Z0-921 問題集

質問 1：
What is true about MySQL Enterprise Transparent Data Encryption (TDE)?
A. Tablespace keys are managed manually behind the scenes.
B. Enables data-at-rest encryption by encrypting the physical files of the database.
C. Data is encrypted automatically, in real time, after it is written to storage.
D. Encryption key is stored in a centralized key memory location
正解：B

質問 2：
How would you restrict a user Joe from accessing all MySQL database objects?
A. CREATE USER ,joe'@,0.0.0.0, SET Password=PASSWORD(,% ! %,)
B. UPDATE mysql.user SET Password=PASSWORD(,Invalid,) WHERE User=,joe';
C. CREATE USER , joe,@1' %' DENY ALL PRIVILEGES
D. Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.
E. REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,;
正解：D

質問 3：
Which three are levels in which MySQL Enterprise Monitor provides access control?
A. Asset visibility: the rights to access data collected from hosts or MySQL instances
B. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
C. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent
D. Specific data access: the rights to view specific types of potentially sensitive data
E. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services
正解：A,B,D

質問 4：
Which three are requirements for MySQL Group Replication (GR)?
A. Data to be replicated must be stored in the InnoDB transactional storage engine.
B. The minimum number of required nodes for achieving a consensus is two.
C. Primary keys are required on every replicated table.
D. The use of global transaction identifiers is required.
E. GR only works with MySQL versions 8.0.12 or higher.
F. The binary log format must be set to mixed.
正解：A,C,F

質問 5：
What is Kubernetes in the context of MySQL?
Response:
A. A database engine for MySQL.
B. A cloud service provided by Oracle for MySQL databases.
C. A database management tool for MySQL.
D. An open-source container orchestration platform.
正解：D

質問 6：
Which two are advantages of using Document Store in MySQL?
A. MySQL can store XML as a schema-less database
B. MySQL provides a native data type to store JSON data as a document
C. MySQL provides a native data type to index PDF documents
D. MySQL provides a NoSQL API to access the document store
E. MySQL is a document database allowing PDF and Word documents
正解：A,D

質問 7：
You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?
A. audit-log=FORCE_PLUS_PERMANENT
B. LOAD PLUGIN=AUDIT_LOG
C. plugin-load=audit_log.so
D. plugin-audit=ON, ALWAYS
E. audit_log_permanent=ON
正解：A,E

質問 8：
What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?
A. Email
B. Browser pop-ups
C. Application-to-application messaging
D. Direct support call from an Oracle representative
E. SMS-notification tab on the dashboard
正解：A,E