nerdexam
Microsoft

70-457 · Question #149

You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.

The correct answer is B. Enable FILESTREAM on the Server Instance. D. Create a non-empty FILESTREAM file group. F. Set the FILESTREAM directory name on the Database. See the full explanation below for the reasoning.

Question

You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.

Options

  • ADisable FILESTREAM on the Database.
  • BEnable FILESTREAM on the Server Instance.
  • CConfigure the Database for Partial Containment.
  • DCreate a non-empty FILESTREAM file group.
  • EEnable Contained Databases on the Server Instance.
  • FSet the FILESTREAM directory name on the Database.

How the community answered

(35 responses)
  • A
    9% (3)
  • B
    83% (29)
  • C
    3% (1)
  • E
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice