nerdexam
Microsoft

70-465 · Question #116

Drag and Drop Question You are designing a database for a university. The database will contain two tables named Classes and StudentGrades that have the following specifications: - Classes will…

The correct answer is FileTable; Filegroup. FileTable is correct for the Classes table because it extends FileStream to support storing files in a hierarchical folder structure that is accessible via Windows UNC paths, and natively supports XPS (and other file formats) as Windows files. Filegroup is correct for the…

Submitted by kevin_r· Mar 5, 2026Design and implement database objects - specifically selecting appropriate SQL Server storage technologies (FileTable, FileStream, Filegroups) based on requirements for file accessibility, folder hierarchy, UNC paths, and granular backup scheduling.

Question

Drag and Drop Question You are designing a database for a university. The database will contain two tables named Classes and StudentGrades 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. - StudentGrades must be backed up on a separate schedule than the rest of the database. 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

70-465 question #116 exhibit

Answer Area

Drag items

FileStreamFileTableFilegroupPartitioned views

Correct arrangement

  • FileTable
  • Filegroup

Explanation

FileTable is correct for the Classes table because it extends FileStream to support storing files in a hierarchical folder structure that is accessible via Windows UNC paths, and natively supports XPS (and other file formats) as Windows files. Filegroup is correct for the StudentGrades table because placing a table in a separate filegroup allows it to be backed up independently on its own schedule using filegroup-level backups, which is a standard SQL Server backup strategy for differential scheduling.

Topics

#FileTable#Filegroup Backup#SQL Server Storage#Database Design

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice