nerdexam
Microsoft

70-433 · Question #65

You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB01 that hosts the Retail database. The Retail database has a table named Customers that has a…

The correct answer is C. By specifying the geography data type. See the full explanation below for the reasoning.

Question

You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB01 that hosts the Retail database. The Retail database has a table named Customers that has a column named Address. You need to alter the Address column to enable users to query the column based on geographic location. How would you alter the column?

Options

  • ABy specifying the datetimeoffset data type.
  • BBy specifying the text data type.
  • CBy specifying the geography data type.
  • DBy specifying the user-defined type data type.

How the community answered

(30 responses)
  • A
    7% (2)
  • B
    17% (5)
  • C
    70% (21)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice