nerdexam
Microsoft

70-451 · Question #9

You are a database solutions architect. Your company plans to develop a solution by using a SQL Server 2008 instance. You design a new database that contains a table to store Microsoft Office…

The correct answer is C. varbinary(max). See the full explanation below for the reasoning.

Question

You are a database solutions architect. Your company plans to develop a solution by using a SQL Server 2008 instance. You design a new database that contains a table to store Microsoft Office documents. You have the following business requirements:

  • The documents are part of the database backup.
  • The snapshots of the database are used.

You need to use an appropriate data type to store the documents. Which data type should you use?

Options

  • Avarchar(max)
  • Bnvarchar(max)
  • Cvarbinary(max)
  • Dvarbinary(max) by using the FILESTREAM attribute

How the community answered

(53 responses)
  • A
    2% (1)
  • B
    9% (5)
  • C
    83% (44)
  • D
    6% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-451 Practice