新しい質問 47
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

新しい質問 48
Which three sets of item information are visible in the mysql system database? (Choose three.)

新しい質問 49
You have configured MySQL Enterprise Monitor to monitor your MySQL server.
Which four features are available? (Choose four.)

新しい質問50
Examine this command and output:

正しい記述はどれか？(2つ選びなさい)

新しい質問 51
You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

新しい質問 52
Which two statements are true about MySQL server multi-source replication? (Choose two.)

新しい質問 53
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

新しい質問 54
Examine this query and output:

正しい記述はどれか？(2つ選びなさい)

新しい質問 55
Which condition is true about the use of the hash join algorithm?

新しい質問56
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377’’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?

新しい質問 57
Examine the modified output:

Seconds_Behind_ Mastervalue is steadily growing.
What are two possible causes? (Choose two.)

新しい質問 58
Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

新しい質問 59
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:

どちらが正しいか？

新しい質問 60
Examine this command and output:

どちらが正しいか？

新しい質問 61
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

新しい質問 62
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

新しい質問 63
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

どちらが正しいか？

新しい質問 64
You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?

新しい質問65
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

新しい質問 66
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY ‘P@ssw0rd’;
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?