Drag and Drop Question 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 bro

Submitted by viktor_hu· Mar 5, 2026Design and implement database objects - specifically selecting appropriate SQL Server technologies for unstructured file storage and query performance optimization

Question

Drag and Drop Question 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:

Exhibit

Explanation

FileTable is the correct technology for the Classes table because it extends FILESTREAM to support Windows file namespace compatibility, allowing files like XPS brochures to be stored in a structured folder hierarchy and accessed via UNC paths - exactly as specified. Partitioned tables are correct for the Enrollment table because table partitioning improves query performance by allowing SQL Server to scan only relevant partitions (e.g., current enrollments) rather than the entire table, which is a classic use case for enhancing performance on large, range-queryable datasets.

Topics

#FileTable#Table Partitioning#FILESTREAM#SQL Server Storage

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice