← Back to exam page

Free 1z0-908 – MySQL 8.0 Database Administrator Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–3 of 10 questions

Question 1

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.)

Select all that apply, then click Submit answer.

  • ○

    The cluster will shut down to preserve data consistency.
  • ○

    The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
  • ○

    The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
  • ○

    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.
  • ○

    A manual intervention to force group members to be only the working two instances is required.
Question 2

Examine this command, which executes successfully:

shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb

Which two statements are true? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    It executes flush tables with read lock.
  • ○

    It enforces consistent backups for all storage engines.
  • ○

    The backup created is a consistent data dump.
  • ○

    This option uses the READ COMMITTED transaction isolation mode.
  • ○

    It is a cold backup.
Question 3

Your MySQL server is running on the Microsoft Windows platform.

Which three local connection protocols are available to you? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    named pipes
  • ○

    shared memory
  • ○

    SOCKET
  • ○

    X Protocol
  • ○

    UDP
  • ○

    TCP/IP