Which Three options describe benefits of using the InnoDB memcached API?
A.
Provides a simple, well supported method for accessing and updating data.
B.
Provides a total in –memory storage system that eliminates disk1/0 overhead.
C.
Bypasses the SQL layer thus avoiding extra processing.
D.
Implements a fast caching mechanism to replace the query cache.
E.
Provides protection via InnoDB buffers and crash recovery.
C,E, and maybe A or D.
But A looks a lot better than D though!
https://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-benefits.html
C: Data that is written using the memcached protocol is transparently written to an InnoDB table, without going through the MySQL SQL layer
E: You can stop and start the memcached server without losing updates made to the cached data. To guard against unexpected outages, you can take advantage of InnoDB crash recovery, replication, and backup procedures.
A: Because you can access the underlying data through SQL, you can produce reports, search or update across multiple keys, and call functions such as AVG() and MAX() on the memcached data.
D: (It has nothing about query cache)
I agree with A, C, E too.
A,C,E
A,C,E