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

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

Which statement is true?

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

You have semi-synchronous replication configured and working with one slave.
rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)

• A.Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.
• B.The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.
• C.As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.
• D.No committed transactions are lost.
• E.Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.
• F.A small amount of committed transactions may be lost in case they were committed just before the disk failure.

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

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

The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

• A.innodb_undo_directory=/dev/shm
• B.innodb_flush_log_at_trx_commit=1
• C.innodb_doublewrite=0
• D.innodb_log_file_size=1G
• E.buffer_pool_size=24G
• F.max_connections=10000
• G.sync_binlog=0

Which three requirements must be enabled for group replication? (Choose three.)

• A.binary log ROW format
• B.slave updates logging
• C.replication filters
• D.binary log checksum
• E.primary key or primary key equivalent on every table
• F.semi-sync replication plugin
• G.binary log MIXED format