Home » Microsoft » 70-461 v.2 » Which storage type or types should you use?
DRAG DROP
You are developing a Microsoft SQL Server database:
You have the following requirements:
• Data should use the least storage space.
• Data should not lose precision.
Which storage type or types should you use? To answer, drag the appropriate storage types to the correct uses. Each type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: FILESTREAM
FILESTREAM integrates the SQL Server Database Engine with an NTFS or ReFS file systems by storing varbinary(max) binary large object (BLOB) data as files on the file system.
Box 2: NUMERIC
Numeric data types that have fixed precision and scale.
Box 3: BIGINT
Need bigint for 3 billion unique values.
Box 4: BIT
The SQL Server Database Engine optimizes storage of bit columns. If there are 8 or fewer bit columns in a table, the columns are stored as 1 byte. If there are from 9 up to 16 bit columns, the columns are stored as 2 bytes, and so on.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server
https://docs.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql
https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql
https://docs.microsoft.com/en-us/sql/t-sql/data-types/bit-transact-sql