You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTERcommand are correct.
Examine the GTID information from both master and slave:

Which statement is true?

• A.Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
• B.Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
• C.Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
• D.Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
• E.Replication will work.

Comment: *

Name: *

Email: *

Verification: *

Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

• A.Cross-database constraints can cause database inconsistency.
• B.Setting slave_preserve_commit_order to on will improve data consistency.
• C.Each slave thread is responsible for updating a specific database.
• D.Setting transaction_allow_batching to on will improve data consistency.
• E.Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
• F.Increasing slave_parallel_workers will improve high availability.

Comment: *

Name: *

Email: *

Verification: *

You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

• A.The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
• B.The mysqlcheck --optimize --all-databases command reclaims free space from table files.
• C.The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
• D.The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
• E.The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

Comment: *

Name: *

Email: *

Verification: *

How can mysql_multi be configured to allow MySQL instances to use the same port number?

• A.The instances have appropriate net masks set.
• B.The instances use different socket names.
• C.The instances listen on different IP addresses.
• D.The instances use different user accounts unique to each instance.

Comment: *

Name: *

Email: *

Verification: *

You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

• A.on slave: --replicate-wild-ignore=example.%
• B.on slave: --binlog-ignore-db=example
• C.on slave: --replicate-ignore-db=example
• D.on master: --binlog-ignore-db=example
• E.on master: --replicate-ignore-db=example

Comment: *

Name: *

Email: *

Verification: *