70-465 Question 19

You need to change the ProdDB database. Which two database options should you change to meet the requirements? Each correct answer presents part of the solution. Choose two.

A. CONTAINS FILESTREAM
B. Change recovery model to FULL
C. CONTAINMENT = PARTIAL
D. Change recovery model to BULK_LOGGED
E. COLLATE IN.MEMORY
F. CONTAINS MEMORY OPTIMIZED DATA

Answer: E, F

Explanation/Reference:

* Scenario: To help with performance, the database needs to be modified so that it can support in-memory data, specifically for the Product table, which the CIO has indicated should be a memory-optimized table.



Category: 70-465 Questions Answers

you are at 70-465 Question 19

For more questions you can browse 70-465 Questions Answers.