A.Implement a failover strategy to another geographic location.

B.Have a second data centre in a different region or country.

C.Use on-site network-attached storage to separate service from data.

D.Keep software updated to the latest version.

E.Create a master-master pair for each service.

F.Use RAID 10 storage for data.

A.The User field is too long for most names.

B.No indexes are defined.

C.The engine type is not appropriate to the application use.

D.Using default values for DATETIMEcauses table scans.

E.Dateshould be a TIMESTAMPfield for better performance.

A.It caches index blocks for MyISAM tables only.

B.It caches index blocks for all storage engine tables.

C.It is a global buffer.

D.It is set on a per-connection basis.

E.It caches index blocks for InnoDB tables only.

A.All max_connections were in use at 2018-03-22 14:54:06

B.There are more connections being idle than executing queries.

C.There are 140 Performance Schema threads at the time of the output.

D.The thread cache has been configured with thread_cache_size set to at least 6.

E.There are 510 connections to MySQL at the time of the output.

A.using SSL when transporting data over remote networks

B.using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications

C.setting -skip-networking when remote connections are not required

D.setting -mysql_secure_configuration to enable paranoid mode

E.setting specific grant privileges to limit remote authentication