Home » Microsoft » 70-765 » What should you do?
A company runs Microsoft SQL Server 2017 in an on-premises environment. The databases are memory-optimized.
An integrity check of a database has failed.
You need to ensure that the data is healthy and passes an integrity check.
What should you do?
A. Run the CHECKTABLE Transact-SQL statement.
B. Clear the buffer of the database.
C. Restore from a verified backup.
D. Run the CLEANTABLE Transact-SQL statement.
Correct Answer: C
Explanation/Reference:
Explanation:
To verify the integrity of the on-disk checkpoint files, perform a backup of the MEMORY_OPTIMIZED_DATA filegroup.
Incorrect Answers:
A: DBCC CHECKTABLE will fail for memory-optimized tables.
D: DBCC CLEANTABLE reclaims space after a variable-length column is dropped.
References: https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/transact-sql-constructs-not-supported-by-in-memory-oltp?view=sql-server-2017