새 질문 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:

다음 중 어느 것이 사실입니까? (두 개를 선택하세요.)

새 질문 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:

다음 중 어느 것이 사실입니까? (두 개를 선택하세요.)

새 질문 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:

Which statement is true?

새 질문 60
Examine this command and output:

Which statement is true?

새 질문 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:

Which statement is true?

새 질문 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?