Exam 70-464 topic 1 question 31 discussion

Actual exam question from Microsoft's 70-464

Question #: 31
Topic #: 1

You plan to create a new column in a disk-based table. The column must meet the following requirements:
✑ Be able to store images that are larger than 1 MB each.
✑ Be able to access the images from Microsoft .NET Framework applications.
✑ Be able to simulate a file system.
You need to recommend which data type must be used in the column.
Which data type should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

A. FileTable
B. varbinary
C. image
D. FileStream

Show Suggested Answer

Suggested Answer: D 🗳️
FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. Applications can leverage the rich streaming APIs and performance of the file system and at the same time maintain transactional consistency between the unstructured data and corresponding structured data.
If the following conditions are true, you should consider using FILESTREAM:
✑ Objects that are being stored are, on average, larger than 1 MB.
✑ Fast read access is important.
✑ You are developing applications that use a middle tier for application logic.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server

by Kepty at Nov. 17, 2020, 10:27 p.m.

Comments

Submit Cancel

Kepty

4 years, 6 months ago

FILESTREAM is ok. FileTable is a special table that use FILESTREAM field to store data. But the question is about FIELD, not a table.

upvoted 1 times

...