DRAG DROP
You are designing a database for a university.
The database will contain two tables named Classes and Enrollment that have the following
specifications:
• Classes will store brochures in the XPS format. The brochures must be structured in
folders and must be accessible by using UNC paths.
• Enrollment will store information about students and their classes. Performance must
be enhanced for queries of the current enrollments.
You need to identify which SQL Server technology meets the specifications of each table.
Which technologies should you identify?
To answer, drag the appropriate technology to the correct table in the answer area.

Answer:

Explanation:

Note:
* The FileTable feature brings support for the Windows file namespace and compatibility with
Windows applications to the file data stored in SQL Server. FileTable lets an application
integrate its storage and data management components, and provides integrated SQL
Server services – including full-text search and semantic search – over unstructured data and metadata.

In other words, you can store files and documents in special tables in SQL Server called
FileTables, but access them from Windows applications as if they were stored in the file
system, without making any changes to your client applications.