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

The correct answer is E. COLLATE IN.MEMORY F. CONTAINS MEMORY OPTIMIZED DATA. Scenario: To help with performance, the database needs to be modified so that it can support in-memorydata, specifically for the Product table, which the CIO has indicated should be a memory-optimized table. Collations and Code Pages…

Design and implement database solutions

Question

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

Exhibits

Options

ACONTAINS FILESTREAM
BChange recovery model to FULL
CCONTAINMENT = PARTIAL
DChange recovery model to BULK_LOGGED
ECOLLATE IN.MEMORY
FCONTAINS MEMORY OPTIMIZED DATA

How the community answered

(44 responses)

A
16% (7)
B
7% (3)
C
5% (2)
D
2% (1)
E
70% (31)

Explanation

Scenario: To help with performance, the database needs to be modified so that it can support in-memorydata, 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)

Topics

#In-Memory OLTP#memory-optimized filegroup#database configuration#CONTAINS MEMORY OPTIMIZED DATA

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice