Home » Microsoft » 70-469 » 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 IN.MEMORY
F. CONTAINS MEMORY OPTIMIZED DATA
Correct Answer: EF
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.
Collations and Code Pages
FileGroupDefinition.ContainsMemoryOptimizedData Property (Microsoft.SqlServer.TransactSql.ScriptDom)
