PrepAway - Latest Free Exam Questions & Answers

You use a Microsoft SQL Server 2012 database.

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,

[Docum

ent] 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


Leave a Reply