nerdexam
Microsoft

70-459 · Question #121

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

(19 responses)
  • A
    5% (1)
  • B
    74% (14)
  • C
    5% (1)
  • E
    16% (3)

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice