70-465 | You need to change the ProdDB database…

Following is 70-465 | You need to change the ProdDB database… from latest Microsoft practice test.

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.