Which two database options should you change to meet the requirements?

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 I
F . MEMORY
G . CONTAINS MEMORY OPTIMIZED DATA

Answer: E, F

Explanation:

* 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.

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments