nerdexam
Microsoft

70-433 · Question #89

70-433 Question #89: Real Exam Question with Answer & Explanation

The correct answer is C. OPTIMIZE FOR. See the full explanation below for the reasoning.

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

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice