This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the questions below.
Which storage engines does Azure Database for MySQL support?
Blackhole and InnoDB
MyISAM and InnoDB
Memory and InnoDB
If you don't specify a storage engine when creating a table, what happens?
The table will not be created.
The data will never be written to disk.
The default storage engine will be used.
Which statement should you use when specifying the storage engine for a table?
CREATE TABLE
CREATE ENGINE
CREATE TABLESPACE
What is best practice when creating tables in InnoDB?
All tables are created in the system tablespace.
All tables are created in the file per table tablespace.
All tables are created in a custom general tablespace.
What is the purpose of the write-ahead log (WAL)?
To improve performance.
To recover data in the event of a crash.
To group changes together and write them to disk in one batch.
You must answer all questions before checking your work.
Was this page helpful?