You are a database developer of a Microsoft SQL 2012 Server database.

You are designing a table that will store Customer data from different sources. The table will include a column that contains the CustomerID from the source system and a column that contains the SourceID.

A sample of this data is as shown in the following table.

You need to ensure that the table has no duplicate CustomerID within a SourceID. You also need to ensure that the data in the table is in the order of SourceID and then CustomerID.

Which Transact- SQL statement should you use?

A. CREATE TABLE Customer (

SourceID int NOT NULL IDENTITY,

CustomerID int NOT NULL IDENTITY,

CustomerName varchar(255) NOT NULL);

B.

CREATE TABLE Customer (

SourceID int NOT NULL,

CustomerID int NOT NULL PRIMARY KEY CLUSTERED,

CustomerName varchar(255) NOT NULL);

C.

CREATE TABLE Customer (

SourceID int NOT NULL PRIMARY KEY CLUSTERED,

CustomerID int NOT NULL UNIQUE,

CustomerName va

rchar(255) NOT NULL);

D.

CREATE TABLE Customer (

SourceID int NOT NULL,

CustomerID int NOT NULL,

CustomerName varchar(255) NOT NULL,

CONSTRAINT PK_Customer PRIMARY KEY CLUSTERED

(SourceID, CustomerID));

Explanation: