Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

• A.Executing ALTER TABLE transactions will enable you to free up disk space.
• B.Truncating the transactions table will free up the most disk space.
• C.The transactions table was created with innodb_file_per_table=OFF.
• D.Truncating the sales and leads table will free up disk space.
• E.Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.

Comment: *

Name: *

Email: *

Verification: *

Which three actions are effective in capacity planning? (Choose three.)

• A.consulting the application team about any future projects and use
• B.buying more CPU
• C.buying more RAM
• D.basing expected growth on an average of the last 3 years
• E.buying more disk
• F.adding circular replication nodes for increased DML capability
• G.upgrading to the latest application version
• H.monitoring OS resources for patterns

Comment: *

Name: *

Email: *

Verification: *

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 metadat a. Please use the most up to date instance: 'host1:3377'. (RuntimeError) Which statement is true?

• A.The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').
• B.The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').
• C.The cluster is running and there is at least one ONLINE instance.
• D.It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
• E.The instance deployed on host3 must be rebuilt with a backup from the primary instance.

Comment: *

Name: *

Email: *

Verification: *

Examine this command and output:

Which two statements are true? (Choose two.)

• A.The lock is a shared lock.
• B.The lock is an intentional lock.
• C.The lock is at the metadata object level.
• D.The lock is an exclusive lock.
• E.The lock is at the table object level.
• F.The lock is a row-level lock.

Comment: *

Name: *

Email: *

Verification: *

Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

• A.ALTER TABLE world.city ADD SPATIAL INDEX (Population);
• B.ALTER TABLE world.city ADD INDEX (Name);
• C.ALTER TABLE world.city ADD INDEX (Population);
• D.ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
• E.ALTER TABLE world.city ADD SPATIAL INDEX (Name);
• F.ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Comment: *

Name: *

Email: *

Verification: *