1z0-908 Practice Test

1z0-908 Practice Test practice questions, page 6 of 9, with answer review and explanations.

Question 26

You are backing up raw InnoDB files by using mysqlbackup. Which two groups of files will be backed up during a full backup? (Choose two.)

  1. ibbackup files
  2. *.CSM files
  3. *.sdi files
  4. *.ibd files
  5. ib_logfile* files

Question 27

You made some table definition changes to a schema in your MySQL Server. Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

  1. MySQL writes SDI to the binary log for distributed backups.
  2. MySQL keeps InnoDB metadata changes in .sdi files in datadir.
  3. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
  4. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
  5. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

Question 28

Which two are characteristics of snapshot-based backups? (Choose two.)

  1. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
  2. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
  3. The frozen file system can be cloned to another virtual machine immediately into active service.
  4. A separate physical copy must be made before releasing the snapshot backup.
  5. Snapshot backups can be used only in virtual machines.

Question 29

You must run multiple instances of MySQL Server on a single host. Which three methods are supported? (Choose three.)

  1. Run MySQL Server docker containers.
  2. Use systemd with different settings for each instance.
  3. Use system tools to lock each instance to its own CPU.
  4. Start mysqld or mysqld_safe using different option files for each instance.
  5. Run mysqld with --datadir defined for each instance.
  6. Use resource groups to lock different instances on separate CPUs.

Question 30

There are five MySQL instances configured with a working group replication. Examine the output of the group members: Which two statements are true about network partitioning in the cluster? (Choose two.)

  1. The cluster will shut down to preserve data consistency.
  2. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
  3. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
  4. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
  5. A manual intervention to force group members to be only the working two instances is required.