Knowledge check - Use the SQL Server Query Tuning Assistant (QTA)

Completed

Check your knowledge

1.

Which versions of SQL Server support the Query Store?

Any version after SQL Server 2005.

SQL Server 2016 and later.

Only SQL Server 2022.

2.

Which feature predicts how many rows a query is likely to return?

The cardinality estimator.

The Query Tuning Assistant (QTA).

The Query Store.

3.

Which of the following statements about automatic plan correction is true?

It's set at the server level.

It can change the execution plan of an individual query to use an earlier cardinality estimator.

It always uses the cardinality estimator that's mapped to the target compatibility level.

4.

What does the Query Tuning Assistant (QTA) do?

Collects data to monitor queries or measure the effects of a single change.

Predicts how many rows a query is likely to return.

Finds queries that are beginning to regress and experiments to find solutions.

5.

How long should the Query Store run to gather sufficient workload information on a database?

Long enough for the Query Store to capture a typical cycle of business activity.

One week.

It depends on the Query Store version.

6.

What's the correct order of steps for using the QTA to evaluate query regressions caused by upgrading a database from SQL Server 2012 to SQL Server 2022?

Migrate the database to SQL Server 2022 and upgrade the compatibility level. Enable the Query Store and collect statistics on the database after the upgrade, and use the QTA to investigate regressing queries.

Enable the Query Store and collect baseline query statistics. Migrate the database to SQL Server 2022 and upgrade the compatibility level. Collect Query Store statistics after the upgrade, and use the QTA to investigate regressing queries.

Migrate the database to SQL Server 2022. Enable the Query Store on the database and collect baseline statistics. Upgrade the compatibility level, continue to collect Query Store statistics, and use the QTA to investigate regressing queries.

7.

Which of the following choices isn't a valid setting for Query Store in SQL Server 2022?

Off

Active

Read only

Read write

You must answer all questions before checking your work.