PrepAway - Latest Free Exam Questions & Answers

How would you store these files?

You work as a SQL Server 2012 database developer at ABC.com.
You are developing a database that will be used by a Web application. The database will store
small multimedia files in several tables. The largest multimedia file is 975 kB. These multimedia
files will be retrieved quite often.
How would you store these files?

PrepAway - Latest Free Exam Questions & Answers

A.
You should make use of a cursor.

B.
You should make use of a row-level compression.

C.
You should make use of the FileStream data type.

D.
You should make use of the VARBINARY data type.

Explanation:

One Comment on “How would you store these files?


Leave a Reply