nerdexam
Microsoft

98-361 · Question #96

You are developing a database that other programmers will query to display race results. You need to provide the ability to query race results without allowing access to other information in the…

The correct answer is A. Disable implicit transactions. See the full explanation below for the reasoning.

Question

You are developing a database that other programmers will query to display race results. You need to provide the ability to query race results without allowing access to other information in the database. What should you do?

Options

  • ADisable implicit transactions.
  • Bplace the query jnt0 a stored procedure.
  • CCreate an index on the result table.
  • DAdd an AFTER UPDATE trigger on the result table to reject updates.

How the community answered

(54 responses)
  • A
    74% (40)
  • B
    7% (4)
  • C
    15% (8)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 98-361 Practice