70-465 · Question #9
Drag and Drop Question You have a SQL Azure database named Database1. You need to design the schema for a table named table1. Table1 will have less than one million rows. Table1 will contain the…
The correct answer is int; varchar; char; date. The correct data types minimize storage: 'int' (4 bytes) is sufficient for an ID column with less than 1 million rows (max ~2.1 billion), making 'bigint' (8 bytes) wasteful. 'varchar' stores variable-length non-Unicode strings efficiently by only using space for actual…
Question
Exhibits
Answer Area
Drag items
Correct arrangement
- int
- varchar
- char
- date
Explanation
The correct data types minimize storage: 'int' (4 bytes) is sufficient for an ID column with less than 1 million rows (max ~2.1 billion), making 'bigint' (8 bytes) wasteful. 'varchar' stores variable-length non-Unicode strings efficiently by only using space for actual characters, while 'nvarchar' doubles storage with 2 bytes per character for Unicode. 'char' is appropriate for fixed-length fields (like a country code or status code) where all values are the same length, and 'date' (3 bytes) stores only date information without time, making 'smalldatetime' (4 bytes) unnecessary if time precision is not required.
Topics
Community Discussion
No community discussion yet for this question.