nerdexam
Microsoft

70-433 · Question #89

You notice that for a particular set of parameter values the following query sometimes executes quickly and other times executes slowly. You also notice that 90 percent of the rows in the Address…

Sign in or unlock 70-433 to reveal the answer and full explanation for question #89. The question stem and answer options stay visible for context.

Question

You notice that for a particular set of parameter values the following query sometimes executes quickly and other times executes slowly. You also notice that 90 percent of the rows in the Address table contain the same value for the city. SELECT AddressId, AddressLine1, City, PostalCode FROM Person.Address WHERE City = @city_name AND PostalCode = @postal_code You need to use a query hint that, for the particular set of parameter values, will result in a more consistent query execution time. Which query hint should you use?

Options

  • AFAST
  • BMAXDOP
  • COPTIMIZE FOR
  • DPARAMETERIZATION FORCED

Unlock 70-433 to see the answer

You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-433 Practice