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

You want to prevent any unauthorized users from gaining access to the personal information of your employees, which is stored in the EMPLOYEE table in a MySQL database. How would you use the MySQL Enterprise Edition Firewall to prevent the following SQL injection attack from exposing the salaries of all your employees?
SELECT fl_name, salary FROM EMPLOYEE WHERE fl_name= 'JHacker' OR 1=1;

• A.Create a FIREWALL STORED PROCEDURE to block any external user from executing this SQL statement.
• B.Create a blacklist of the SQL commands, which would restrict access to the EMPLOYEE table by using the DETECTING mode.
• C.Create a list of approved SQL users by using the INTERROGATION mode.
• D.Create a whitelist of approved SQL commands by using the RECORDING mode, and enable protection by changing it to PROTECTION mode.

The MySQL Cloud Service (CS) is a database offering from Oracle. Which three statements are correct?

• A.MySQL CS configuration can be changed in /etc/my.cnf.
• B.MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard).
• C.MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.
• D.MySQL CS is based on the MySQL Enterprise Product Suite.
• E.Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II).
• F.MySQL CS is installed based on the Oracle Flexible Architecture Standard.

After installing MySQL 5.7, you initialize the data directory with the - -initialize command. Identify two places in which you would find the root password.

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

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.
Identify two reasons for this problem.

• A.The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
• B.All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
• C.The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• D.The MASTER and SLAVE are grouped as one instance for monitoring.
• E.The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

You have a backup image file that is backed up using MySQL Enterprise Backup with the - - compress option:
/home/mysql/backup/full/mybackup/myimage.img
mysqlbackup.cnf is shown as follows:
[mysqlbackup]
backup-dir=/home/mysql/backup/full/mybackup
backup-image=/home/mysql/backup/full/mybackup/myimage.img
You are required to perform a database restore to a new machine to provision the database.
Which command can provision the new database in the datadir as /home/mysql/data/MEB?

• A.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB restore-and-apply-log
• B.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB image-to-dir
• C.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB copy-back-and-apply-log
• D.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB image-to-dir-and-apply-log
• E.#mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\- - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\-
  -datadir=/home/mysql/data/MEB apply-log-and-copy-back