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:
Reference:
http://msdn.microsoft.com/en-us/library/gg471497.aspx
Reference:
http://msdn.microsoft.com/en-us/library/ff929144.aspx
Why is this not D?
https://msdn.microsoft.com/en-us/library/cc645583.aspx
0
0
Disregard, looks like the link is for a feature in SQL Server 2016.
0
0
The correct answer is D
https://msdn.microsoft.com/en-US/library/cc645583(v=sql.110).aspx
0
0
I Think the correct answer is A.
https://msdn.microsoft.com/en-us/library/ff929144%28v=sql.110%29.aspx
0
0
Because the questions says taht the documents must only be accessible via Transact-SQL queries, the rigth answer id A and not D.
0
0
You right
0
0
I have an account that contains these questions and it is showing A as answer.
0
0
By the way, part of new 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0