nerdexam
Microsoft

70-433 · Question #148

You are reviewing a trigger in the database which was deployed with the folowing script: EXECUTE AS USER = 'BuildUser' GO CREATE TRIGGER Inventory.TR_Stock ON Inventory.Stock FOR INSERT, UPDATE…

The correct answer is D. BuildUser. See the full explanation below for the reasoning.

Question

You are reviewing a trigger in the database which was deployed with the folowing script:

EXECUTE AS USER = 'BuildUser' GO CREATE TRIGGER Inventory.TR_Stock ON Inventory.Stock FOR INSERT, UPDATE, DELETE EXECUTE AS SELF AS ... A user 'WebUser' insert rows into Inventory.Stock table. You need to identify under which security context the trigger will execute.

Options

  • ADBO
  • BInventory
  • CWebUser
  • DBuildUser

How the community answered

(13 responses)
  • A
    15% (2)
  • B
    8% (1)
  • D
    77% (10)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice