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.
Select and Place:
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.
References:
FileTables (SQL Server)
Partitioned Tables and Indexes