Which Transact-SQL statement should you run?

You use a Microsoft SQL Server database.

You want to create a table to store files.

You need to ensure that the following requirements are met:

– The files must include information about the directory structure.

– The files must be accessible in SQL Server.

– The files must be in a folder that is accessible directly by using Windows Explorer.

Which Transact-SQL statement should you run?

A)

B)

C)

D)

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: D

Explanation:

References: https://docs.microsoft.com/en-us/sql/relational-databases/blob/create-alter-and-drop­filetables?view=sql-server-2017