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

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

• A.MySQL Enterprise Backup will back up from Slave automatically.
• B.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.
• C.MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
• D.It allows backup to be done on the slave without impacting the master.
• E.It provides multi-master access where the application can write and read data across the database servers.

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

• A.--uncompress
• B.--apply-log-and-copy-back
• C.--uncompress-and-apply-log
• D.--decompress
• E.--copy-back-and-apply-log

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

• A.Use mysqldump with the - -changesonly option.
• B.Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
• C.Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
• D.Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
• E.Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.

You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

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

Which three prerequisites are needed for creating an Oracle Linux VM instance in the Oracle Cloud Infrastructure?

• A.Object Storage
• B.bare metal Oracle Linux shape
• C.Custom Image
• D.subnet configured on a Virtual Cloud Network (VCN)
• E.existing VCN
• F.ssh key pair