Oracle 1z0-320 問題集

質問 1：
When there are long-running queries, mysqbackup hangs there to wait for the completion of the queries. You know that the system has only user data on InnoDB and there is no DDL execution during the backup period.
There is no update/alternation to tables with non-InnoDB storage engines.
Which two ways allow the MySQL Enterprise Backup to be executed without being blocked or without locking?
A. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.
B. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - - only-innodb option to back up only InnoDB tables, to avoid blocking.
C. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use - -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking.
D. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.
E. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - -no-locking option to backup up the non-InnoDB files. Note that MyISAM, .frm, and other files copied under the --no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.
正解：C,E

質問 2：
Which two methods can change password expiration for a database user account? (Choose two.)
A. Use an ALTER USER command to change the password expiration
B. Use the SET GLOBAL command to update the default password expiration time
C. Update the my.cnf configuration to include default_password_lifetime=100 and restart the server
D. Create a new database user account with an explicit password expiration time
正解：A

質問 3：
By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.
A. You can create a slave server for reporting applications, which get only read access to the slave servers.
It off-loads the master server. Additional servers allow different database server configuration.
B. MySQL Enterprise Backup will back up from Slave automatically.
C. It allows backup to be done on the slave without impacting the master.
D. It provides multi-master access where the application can write and read data across the database servers.
E. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
正解：A,B,C

質問 4：
An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysqldump and mysql client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What are two benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?
A. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.
B. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.
C. MySQL Enterprise Backup does not back up system data so that it is much faster.
D. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.
E. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.
正解：B,D

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