nerdexam
Microsoft

98-361 · Question #236

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. Add an AFTER UPDATE trigger on the result table to reject updates. 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

  • AAdd an AFTER UPDATE trigger on the result table to reject updates.
  • BCreate an index on the result table.
  • CPlace the query into a stored procedure.
  • DDisable implicit transactions.

How the community answered

(56 responses)
  • A
    79% (44)
  • B
    5% (3)
  • C
    13% (7)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 98-361 Practice