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. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.
• 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. 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.
• 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 - - only-innodb option to back up only InnoDB tables, to avoid blocking.

Your system is being swamped by business users running multiple ad hoc queries. What is a valid way to limit the resources for a particular user?

• A. CONNECTIONS_PER_HOUR
• B. MAX_QUERY_SIZE
• C. MAX_UPDATES_PER_DAY
• D. MAX_CONNECTIONS
• E. MAX_QUERIES_PER_HOUR

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. 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.
• B. You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.
• C. Use the provided private key for authentication.
• D. Convert the private key to ppk format first, and use the new private key for authentication.

A Cloud customer already has many database instances configured and running in the cloud, however, they are reporting that they are unable to create any more instances.
What could be the problem?

• A. The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to date.
• B. The customer does not have proper user rights.
• C. The customer account might have reached its compute quota.
• D. The customer reached the database instance limit of 32.

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. Running multiple MySQL Enterprise Backups at the same time to back up the same database to allow parallel database backups on MySQL
• B. Using the - - only- innodb or - - only- innodb- with -frm option to back up only InnoDB tables
• C. Using the - - no-locking option to backup non_InnoDB files
• D. Running the backup with the backup policy, full backup and incremental backup, supported by MySQL Enterprise Backup to reduce the daily backup time
• E. Shutting down the MySQL database and using MySQL Enterprise Backup to restart the MySQL Database to remove any potential locking