You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Which two are possible reasons for this problem?

• A.The MASTER and SLAVE are grouped as one instance for monitoring.
• B.The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
• C.All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
• D.The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• E.The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

Comment: *

Name: *

Email: *

Verification: *

The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server.
Which statement is correct?

• A.MySQL Enterprise Monitor creates the required users automatically.
• B.Monitoring metrics need super and root privileges because they are not available for a less-privileged user.
• C.The super privilege is required when starting, stopping, or restarting monitored MySQL databases.
• D.The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.

Comment: *

Name: *

Email: *

Verification: *

Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

• A.Networks must be in separate regions.
• B.Groups must be in even numbers; 2, 4, 6, 8.
• C.isolated machine resources
• D.use SSD's for data and replication logs
• E.The number of machines per group must be 3, 5, 7 or 9.
• F.smaller VM's work best - with a maximum of eight vCPU's and 16GB of RAM
• G.Use Network-attached storage (NAS) for the data files.

Comment: *

Name: *

Email: *

Verification: *

The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?
A)

B)

C)

D)

• A.Option C
• B.Option A
• C.Option B
• D.Option D

Comment: *

Name: *

Email: *

Verification: *

You are testing a new application and want to use data masking but the database is empty. What option will generate dummy data for you to use for testing?

• A.Execute the sakila-data. sqi script to populate the database
• B.Use mysqldump to import data from the sakila_dummy database sample data set.
• C.Use MySQL Enterprise High Availability to access one of the available data tables
• D.Alter the table with the statement: ALTER TABLE IMPORT DATA WITH data_masking plugin;

Comment: *

Name: *

Email: *

Verification: *