Does the solution meet the goal?

After you answer a question in this section, you will NOT be able to return to it As a result, these questions will not appear in the review screen.

You support an application that stores data in a Microsoft SQL Server database. You have a query that returns data for a report that users run frequently.

The query optimizer sometimes generates a poorly-performing plan for the query when certain parameters are used. You observe that this is due to the distribution of data within a specific table that the query uses.

You need to ensure that the query optimizer always uses the query plan that you prefer.

Solution: You create a plan guide for the query by using the desired query plan and the sp_create_plan_guide stored procedure.

Does the solution meet the goal?
A . Yes
B . No

View Answer

Answer: B

Explanation:

The KEEPFIXED PLAN should be used as it forces the query optimizer not to recompile a query due to changes in statistics.

References: https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql­server-2017