最新的 Oracle MySQL 1Z1-921 免費考試真題:

1. You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

A) Use mysqldump with the - -changesonly option.
B) Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
C) Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
D) Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
E) Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.

2. What three are ways to export and import data in MySQL Workbench?

A) Binary Data Export and Import Wizard
B) Table Data Export and Import Wizard
C) Data Modeling Import Export Wizard
D) SQL Data Export and Import Wizard
E) Backup Data Export and Import Wizard
F) Result Data Export and Import

3. Which two statements are true about MySQL Enterprise Authentication?

A) MySQL Enterprise Authentication supports Windows Active Directory.
B) MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
C) MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
D) MySQL Enterprise Authentication determines what operation the user can perform.
E) MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..

4. The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server.
Which statement is correct?

A) 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.
B) The super privilege is required when starting, stopping, or restarting monitored MySQL databases.
C) MySQL Enterprise Monitor creates the required users automatically.
D) Monitoring metrics need super and root privileges because they are not available for a less-privileged user.

5. You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

A) Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
B) Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
C) Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.
D) Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.

問題與答案：