You work as a Database Administrator (DBA) for a company named ABC.com. The company has
a Windows Azure subscription. The company uses a cloud-based SQL Server environment
hosted on SQL Azure.
You are configuring a database for a components list for your company. A table named
Components will list information about every component the company manufactures.
You need to design the schema for the Components table so that the storage space used for each
row is minimized.
The table will have three columns.
The first column will be an ID number to identify each row. The data type for the ID column will be
Int.
The second column will be a part number that consists of six alphanumeric characters. Every
component will have a unique part number.
The third column will be a name for each component. The name will be a string in English of
between five and twenty characters.
What data types should you configure for the Part Number and Name columns? (Choose two).
A.
The Part Number column should use the Char data type.
B.
The Name column should use the Char data type.
C.
The Part Number column should use the Varchar data type.
D.
The Name column should use the Varchar data type.
E.
The Part Number column should use the Text data type.
F.
The Name column should use the Text data type.
Explanation: