최신Oracle MySQL 2021 Implementation Essentials - 1Z1-921무료샘플문제

A. MySQL Enterprise Monitor creates the required users automatically.

B. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

C. The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.

D. Monitoring metrics need super and root privileges because they are not available for a less-privileged user.

A. MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.

B. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).

C. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.

D. MySQL Enterprise Backup comes with all MySQL editions including community edition.

E. MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.

A. MySQL provides a native data type to store JSON data as a document

B. MySQL is a document database allowing PDF and Word documents

C. MySQL provides a native data type to index PDF documents

D. MySQL provides a NoSQL API to access the document store

E. MySQL can store XML as a schema-less database

A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.

B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving--hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.

C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.

D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

A. SET GLOBAL force_password_complex_policy=0;

B. Add validate_password=,new level, in the [security] section of the MySQL configuration file.

C. Add validate_password_policy=,new level, in the [mysqld] section of the MySQL configuration file.

D. SET GLOBAL validate_password_policy=,new level,;

A. The minimum number of required nodes for achieving a consensus is two.

B. Primary keys are required on every replicated table.

C. The binary log format must be set to mixed.

D. The use of global transaction identifiers is required.

E. GR only works with MySQL versions 8.0.12 or higher.

F. Data to be replicated must be stored in the InnoDB transactional storage engine.

A. maintaining a history of row insertions or updates

B. increasing performance when using select statements

C. preventing duplicate keys

D. to make it easier to change the PRIMARY KEY value

E. automatic storage of data in a sorted order

F. exporting data faster with mysqldump

A. Cloud tape library

B. Flash-archive recovery area

C. Cloud storage only

D. Both Cloud storage and local storage