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

Which three statements describe MySQL Cloud Service Backup?

• A.MySQL Cloud Service Backup provides the point-in-time recovery functionality.
• B.MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
• C.MySQL Cloud Service offers backup based on Oracle RMAN with optimized row locking.
• D.MySQL Enterprise Backup can be used to send backups to Oracle Cloud Storage Service.
• E.MySQL Cloud Service Backup is an optimized backup based on mysqldump with optimized row locking.

Identify three levels in which MySQL Enterprise Monitor provides access control.

• A.MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services
• B.MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent
• C.Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
• D.Specific data access: the rights to view specific types of potentially sensitive data
• E.Asset visibility: the rights to access data collected from hosts or MySQL instances

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 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.
• 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 - - only-innodb option to back up only InnoDB tables, to avoid blocking.
• E.There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.

You get a Maintenance notification about your Oracle MySQL Cloud Service. What are the implications?

• A.You need to agree to the maintenance windows. If not, you are not affected by the outage.
• B.There are no maintenance operations planned. You need to do them manually.
• C.You can expect an outage of your MySQL Cloud Service during the planned time.
• D.Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

Which three options describe the setup of MySQL High Availability solutions?

• A.Setting up three machines configured as follows:Machine A with 2 x Data NodesMachine B with 2 x mysqld nodeMachine C with 2 x ndb_mgmd node
• B.setting up three machines configured as follows:Machine 1: Data Node and mysqld nodeMachine 2:
  Data Node and mysqld nodeMachine 3: ndb_mgmd
• C.creating an NFS volume with multiple running MySQL Server Instances attaching the same NFS Volume with the same datadir
• D.setting up Master and Slave with MySQL Semi-Sync Replication Plugin
• E.providing the Active/Passive setup of MySQL Server running on two machines with Shared Storage together with OS clustering to provide storage and Virtual IP failover