1Z0-921試験無料問題集（78題）「Oracle MySQL 2021 Implementation Essentials 認定」

出題：1

You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Which two are possible reasons for this problem?

A. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

B. The MASTER and SLAVE are grouped as one instance for monitoring.

C. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.

D. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.

E. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

正解：B,E 解答を投票する

出題：2

An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?

A. MySQL Enterprise Backup does not back up system data so that it is much faster.

B. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.

C. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.

D. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.

E. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.

正解：D,E 解答を投票する

出題：3

Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

A. A browser-based wizard to remotely deploy the MySQL Monitor Agent

B. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

C. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

D. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database

E. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

正解：B,D,E 解答を投票する

出題：4

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 created.

B. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

C. Only the t2 table is created.

D. Only the t1 table is created.

正解：A 解答を投票する

出題：5

Which three are characteristics of the JSON data type?

A. It supports indexing directly against the JSON-defined column.

B. A set of SQL functions substantially support the SQL utilization of the data type.

C. It validates the JSON syntax on insert or merge.

D. Key or array references enable quick read-access to look up document elements directly.

E. It is based on the TEXT data type.

F. Comparisons of JSON values are not case-sensitive.

正解：A,C,D 解答を投票する

出題：6

Which two statements are correct about MySQL Enterprise Edition?

A. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.

B. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.

C. Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II).

D. MySQL configuration can be changed in /etc/lib/myi.cnf.

E. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

正解：C,D 解答を投票する

出題：7

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. Browser pop-ups

B. SMS-notification tab on the dashboard

C. Application-to-application messaging

D. Direct support call from an Oracle representative

E. Email

正解：B,E 解答を投票する

出題：8

Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

A. MySQL Audit and MySQL Workbench

B. SQL Enterprise Monitor and MySQL Enterprise Authentication

C. MySQL Enterprise Monitor and MySQL Audit

D. MySQL Workbench and MySQL Enterprise Firewall

正解：B 解答を投票する

1Z0-921試験無料問題集「Oracle MySQL 2021 Implementation Essentials 認定」