Which data type should you use?

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?

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?

A.
varbinary(max)

B.
varbinary(max) by using the FILESTREAM attribute

C.
varchar(max)

D.
nvarchar(max)



Leave a Reply 0

Your email address will not be published. Required fields are marked *