Which three backup scenarios can be accommodated with MySQL Enterprise Backup? (Choose three.)

• A. making a backup directly into tape device by using MySQL Enterprise Backup Media Management Software (MMS)
• B. making partial backup and optimistic backup
• C. converting a database backup from another database vendor to MySQL
• D. making a single file backup by creating backups in single-file format
• E. creating a cloud backup

Your customer wants you to install and configure MySQL on the customer's Oracle Linux 6 server with tarball binaries in the /app/mysql1/directory, where the bin directory is found at /app/mysql/bin and a data directory at /app/data.
What are two correct and required server configurations, excluding redundant configuration entries, to build a MySQL instance supporting your customer's requirement?

• A. The configuration basedir=/app/mysql/bin is needed.
• B. The configuration innodb_log_group_home_dir=/datadir is needed.
• C. The configuration datadir=/app/mysql/data is needed.
• D. The configuration basedir=/app/mysql is needed.
• E. The configuration log-bin=/app/data is needed.
• F. The configuration datadir=/app/data is needed.

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

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

설명: (Fast2test 회원만 볼 수 있음)

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. 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.
• 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 - -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. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.
• D. 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.
• E. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.

Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances.

• A. SMS
• B. Email
• C. Browser pop-ups
• D. Direct support call from an Oracle representative
• E. Notification tab on the dashboard