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?

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?

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:



Leave a Reply 1

Your email address will not be published. Required fields are marked *