Which statement is true about tablespaces?

• A.All tablespace files must be in the directory specified by the --datadir option.
• B.General tablespaces can be configured to span multiple files.
• C.The system tablespace can be configured to span multiple files.
• D.All tables must be in either the system tablespace or a general tablespace.

Comment: *

Name: *

Email: *

Verification: *

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

• A.The sync_relay_log=1000 setting on the slave is too small.
• B.binlog_format=STATEMENT and a non-deterministic query was executed.
• C.sync_binlog=0 and the master server crashed.
• D.binlog_cache_size=1024 is too small and transactions are lost.
• E.enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

Comment: *

Name: *

Email: *

Verification: *

Which three allocate memory per thread in MySQL?

• A.query cache
• B.thread cache
• C.read buffer
• D.internal temporary table
• E.sort buffer
• F.InnoDB buffer pool instance

Comment: *

Name: *

Email: *

Verification: *

You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
* It must be possible to rebuild the instance using the backup.
* It must be verified.
* It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)

• A.Include the MySQL PID file in the backup.
• B.Include the relay logs in the backup.
• C.Restore the backup to a clean MySQL instance.
• D.Include the MySQL socket file in the backup.
• E.Copy the backup to a remote host.
• F.Include the operating system disk encryption key in the backup.
• G.Include the binary logs in the backup.
• H.Include the keyring data and/or configuration in the backup.
• I.Include the ibtmp1 file in the backup.

Comment: *

Name: *

Email: *

Verification: *

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

• A.Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directoryvalue in your my.cnf.
• B.Yes. Shut down the mysqldprocess, enable the transportable_tablespaceoption, and move the UNDO directory to the SSD.
• C.No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.
• D.No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

Comment: *

Name: *

Email: *

Verification: *