Free Oracle 1z1-908 Exam Dumps Questions & Answers

Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

• A.  The copy-back process makes inconsistent backups.
• B.  It restores files from the backup directory to their original MySQL server locations.
• C.  It restores files from the data directory to their original MySQL server locations.
• D.  The copy-back process is used to overwrite a new backup over an existing backup.

Which two are true about binary logs used in asynchronous replication? (Choose two.)

• A.  They are pulled from the master to the slave.
• B.  They contain events that describe only administrative commands run on the master.
• C.  They are pushed from the master to the slave.
• D.  They contain events that describe database changes on the master.
• E.  They contain events that describe all queries run on the master.

All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)

• A.  If only some InnoDB Cluster members are enabled for SSL group communication, and
  --ssl-mode=PREFERRED, communication will fall back to unencrypted connection.
• B.  SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
• C.  SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
• D.  SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
• E.  An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
• F.  Configuring SSL group communication also configures SSL distributed recovery.

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)

• A.  network-related information and network characteristics
• B.  MySQL Query Analysis data
• C.  CPU utilization
• D.  MySQL Replication monitoring
• E.  security-related advisor warnings
• F.  operating system memory utilization
• G.  disk usage and disk characteristics including disk advisors warnings

Which two statements are true about using backups of the binary log? (Choose two.)

• A.  Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
• B.  Multiple binary logs can be applied in parallel for faster data restoration.
• C.  Multiple binary logs can be used to restore data.
• D.  Binary logs can always be used to unapply unwanted schema changes.
• E.  They allow for point-in-time recovery of the data.