You are a professional level SQL Sever 2008 Database Administrator. A new database named Engineering is deployed. Large documents are managed by the Engineering database, and the documents will be…

Question

Options

• ATo achieve the goal, row-level compression should be utilized on the document table.
• BTo achieve the goal, NTFS file system compression should be utilized on the volume.
• CTo achieve the goal, varbinary(MAX) data type should be utilized with FILESTREAM
• DTo achieve the goal, row-level compression should be enabled on all columns that the

• A
  5% (2)
• B
  83% (35)
• D
  12% (5)

Explanation

Much of the data that is created every day is unstructured data, such as text documents, images, and videos, This unstructured data is often stored outside the database, separate from its structured data. This separation can cause data management complexities. Or, if the data is associated with structured storage, the file streaming capabilities and performance can be limited. FILESTREAM integrates the SOL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. Transact-SOL statements can insert, update, query, search, and back up FILESTREAIVI data. Win32 tile system interfaces provide streaming access to the data. FILESTFiEAlv1 uses the NT system cache for caching file data. This helps reduce any effect that FILESTREAM data might have on Database Engine performance. The SQL Server butter pool is not used; therefore, this memory is available for query processing. Note: FILESTREAM data is not encrypted even when transparent data encryption is enabled. 2. NTFS compression NTFS compression should be used to compress the files on the NTFS file system

No community discussion yet for this question.