You use a Microsoft SQL Server 2012 database. You want to create a table to store Microsoft Word
documents. You need to ensure that the documents must only be accessible via Transact-SQL queries. Which
Transact-SQL statement should you use?
A.
CREATE TABLE DocumentStore
(
[Id] INT NOT NULL PRIMARY KEY,
[Document] VARBINARY(MAX) NULL
)
GO
B.
CREATE TABLE DocumentStore
(
[Id] hierarchyid,
[Document] NVARCHAR NOT NULL
)
GO
C.
CREATE TABLE DocumentStore AS FileTable
D.
CREATE TABLE DocumentStore
(
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,
[Document] VARBINARY(MAX) FILESTREAM NULL
)
GO
Explanation:
Verified answer as correct.
Reference: http://msdn.microsoft.com/en-us/library/gg471497.aspx
Reference: http://msdn.microsoft.com/en-us/library/ff929144.aspx
Exam B
Answers: A
CREATE TABLE DocumentStore
(
[Id] INT NOT NULL PRIMARY KEY,
[Document] VARBINARY(MAX) NULL
)
GO
FILESTREAM column should have a UNIQUEIDENTIFIER column with ROWGUIDCOL and UNIQUE attributes.
It should be D not A.
https://www.red-gate.com/simple-talk/sql/learn-sql-server/an-introduction-to-sql-server-filestream/