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

You are setting up a MySQL Cluster on two machines, where each machine is hosting the following:
-1x ndbmtd
-1x ndb_mgmd
-1x mysqld
The cluster is started. What will happen if the network connection between the two machines is disconnected?

• A.Components from one of the machines will be chosen as victim. Only one machine will provide service.
• B.A MySQL Cluster backup process will be kick-started automatically.
• C.All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.
• D.The MySQL Cluster service will be paused. After the network is online, the MySQL Cluster service will be resumed.
• E.The entire cluster will be shut down.

Identify two features of MySQL Enterprise Firewall.

• A.You can block out potential threats by setting up a preapproved whitelist.
• B.You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands.
• C.You can modify a request with a SQL statement substitution.
• D.You can automatically delete a user if the user breaks your firewall.
• E.You set the firewall per database.

Which query will find rows in a table that have no counterpart in another table?

• A.SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;
• B.SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;
• C.SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;
• D.SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;

For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the "Create SSH Keys function" during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps.

• A.Convert the private key to ppk format first, and use the new private key for authentication.
• B.Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication.
• C.Use the provided private key for authentication.
• D.You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.

How do you restrict a user named joe from being able to connect from any IP address to a MySQL database?

• A.CREATE USER 'joe'@'0.0.0.0'SET Password=PASSWORD ('%!%')
• B.CREATE USER 'joe'@%' DENY ALL PRIVILEGES
• C.Insert Joe's name into the mysql.user_restriction table, and issue the FLUSH PRIVILEGES command.
• D.UPDATE mysql.user SET Password=PASSWORD ('Invalid') WHERE User= 'joe';
• E.You cannot deny access to a user based on his or her username.