Previous

Next

Knowledge check

Completed

Choose the best response for each of the questions below. Then select Check your answers.

Check your knowledge

1.

Your production application has a normally heavy workload with a requirement for high concurrency. Which implementation of Azure Database for MySQL should you select?

General purpose (2 - 1. vCores)

Memory optimized (2 - 1. vCores)

Burstable (1 - 2. vCores)

2.

MySQL supports a pluggable storage engine architecture. You're porting your database to Azure Database for MySQL. Which storage engine should you select?

MyISAM

CSV

InnoDb

3.

How does the query optimizer ensure that queries run efficiently?

The query optimizer estimates the cost of different execution plans, using statistics provided by the MySQL daemon.

The query optimizer estimates the cost of different execution plans, using statistics provided by the storage engine.

The query optimizer estimates the cost of different execution plans, using statistics provided by the EXPLAIN utility statement.

You must answer all questions before checking your work.

Continue