Home » Microsoft » MB6-886 » What datatype should you chose?
You have to store windows media file (WMV) that has size greater that 2GB in the database.
What datatype should you chose?
A. image
B. filestream
C. varbinary(max)
D. file
Correct Answer: B
Explanation/Reference:
The question is not correct. FILESTREAM is just an attribute. The datatype should be varbinary(max).
Example:
CREATE TABLE dbo.Records
(
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,
[SerialNumber] INTEGER,
[SerialNumber] INTEGER,
[Chart] VARBINARY(MAX) FILESTREAM NULL
)
GO
FILESTREAM storage is implemented as a varbinary(max) column in which the data is stored as BLOBs in the file system. The sizes of the BLOBs are limited only by the volume size of the file system. The standard varbinary(max) limitation of 2-GB file sizes does not apply to BLOBs that are stored in the file system.