nerdexam
Microsoft

70-433 · Question #131

You are tasked to create a table that has a column that must store the current time accurate to ten microseconds. You need to use a system function in conjunction with the DEFAULT option in the…

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

Question

You are tasked to create a table that has a column that must store the current time accurate to ten microseconds. You need to use a system function in conjunction with the DEFAULT option in the column definition. Which system function should you use?

Options

  • ADATEADD
  • BGETUTCDATE
  • CSYSDATETIME
  • DCURRENT_TIMESTAMP

How the community answered

(16 responses)
  • A
    6% (1)
  • B
    6% (1)
  • C
    75% (12)
  • D
    13% (2)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice