Saturday, May 26, 2012

Exam 70-432: Week 1 - QotD

Here's this week's Question of the Day, from SQLServerCentral.com:

Which fact about DBCC CHECKDB in SQL Server 2008 R2 is not true?
  1. DBCC CHECKDB uses an internal database snapshot for the transactional consistency needed to perform these checks
  2. DBCC CHECKDB can repair corruption if you specify the REPAIR_ALLOW_DATA_LOSS option.
  3. DBCC CHECKDB does not check binary large objects (blobs) stored in the database.
  4. DBCC CHECKDB performs parallel checking of objects
I got this right by process of elimination. The first, second and fourth answers are copied verbatim from Books Online. The third option, which is not true (so it's the correct answer), comes from here: http://msdn.microsoft.com/en-us/library/ms176064%28v=sql.105%29.aspx and says that DBCC CHECKDB "Validates link-level consistency between table metadata and file system directories and files when storing varbinary(max) data in the file system using FILESTREAM."

I'm not sure I agree that's the same as checking BLOB's actually stored in the database, but I guess that's splitting hairs.

No comments:

Post a Comment