최신Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z1-320무료샘플문제
문제1
A keyfile has been generated as follows:
# openssl rand 32 -hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?
A keyfile has been generated as follows:
# openssl rand 32 -hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?
정답: C
문제2
Which three options describe the setup of MySQL High Availability solutions?
Which three options describe the setup of MySQL High Availability solutions?
정답: A,C,E
문제3
The MySQL database for backup with used data is configured only with the InnoDB storage engine. System data including SP, VIEWs, and users in the system database are all static. For any changes with system data, the database backup will be done separately.
You are requested to optimize backup performance to reduce backup time by using MySQL Enterprise Backup for the daily backup operation with user data (configured with the InnoDB storage engine).
Which three options would you choose to optimize the backup performance?
The MySQL database for backup with used data is configured only with the InnoDB storage engine. System data including SP, VIEWs, and users in the system database are all static. For any changes with system data, the database backup will be done separately.
You are requested to optimize backup performance to reduce backup time by using MySQL Enterprise Backup for the daily backup operation with user data (configured with the InnoDB storage engine).
Which three options would you choose to optimize the backup performance?
정답: A,B,E
문제4
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.
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.
정답: C,E
문제5
You have configured MySQL Enterprise Transparent Data Encryption (TDE). What command would you use to encrypt a table?
You have configured MySQL Enterprise Transparent Data Encryption (TDE). What command would you use to encrypt a table?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
The user 'fwuser'@'localhost' was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database.
You executed commands:
You want to clear the account whitelist for the 'fwuser'@'localhost' user. Which statement would you run to accomplish this?
The user 'fwuser'@'localhost' was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database.
You executed commands:
You want to clear the account whitelist for the 'fwuser'@'localhost' user. Which statement would you run to accomplish this?
정답: D
문제7
Which three statements describe MySQL Cloud Service Backup?
Which three statements describe MySQL Cloud Service Backup?
정답: A,B,E
문제8
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;
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;
정답: B
문제9
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?
Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?
정답: A,B,D
문제10
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?
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?
정답: B