nerdexam
Microsoft

70-451 · Question #24

You are a database developer. You plan to create a database by using SQL Server 2008. A database contains a table named Sales. The Sales table contains customer order summary information. You create…

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

Question

You are a database developer. You plan to create a database by using SQL Server 2008. A database contains a table named Sales. The Sales table contains customer order summary information. You create a stored procedure that uses a SELECT statement. At the moment of execution, the procedure must return a precise summation of the total sales for the current day. You need to use a query hint to prevent any data modification in the Sales table when the stored procedure is being executed. Which query hint should you recommend?

Options

  • AREADPAST
  • BHOLDLOCK
  • CTABLOCKX
  • DREADCOMMITTED

How the community answered

(40 responses)
  • A
    3% (1)
  • B
    13% (5)
  • C
    78% (31)
  • D
    8% (3)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice