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

Which two ports need to be opened on a network firewall to allow an outside client (on the other side of the firewall) to be able to access a MySQL instance inside the firewall?

• A.Port 13306/tcp [MySQL], when using TCP/IP via a command-line client
• B.Port 3306/tcp [MySQL], when tunneling is not used from within MySQL Workbench
• C.Port 18443/tcp [MySQL], when connecting from MySQL Workbench to a Windows MySQL server
• D.Port 22/tcp [SSH], when using TCP/IP over SSH

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

You want to use Workbench to connect your local MySQL instance by using a local socket. Where would you find the location of the socket file?

• A.The socket file is located in the MySQL data directory.
• B.You have to set up your session to be able to accept LOCAL SOCKET, and then connect via port 22.
• C.You can find the file by querying the GLOBAL VARIABLE SOCKET_LOCATION parameter.
• D.The file location is set by using the socket parameter located in the global or local option file.
• E.You always use port 3307 for connecting by using the local socket.

You have configured MySQL Enterprise Transparent Data Encryption (TDE). What command would you use to encrypt a table?

• A.ALTER mysql.encryption SET tde_status = 'YES';
• B.ALTER INSTANCE ROTATE INNODB MASTER KEY;
• C.UPDATE TABLE SET ENCRYPTION = 'ON';
• D.ALTER TABLE <table> ENCRYPTION = 'Y';

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

• A.A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
• B.A browser-based wizard to remotely deploy the MySQL Monitor Agent
• C.A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
• D.A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
• E.A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database