70-461 Exam Dumps | You are a database developer of a Microsoft SQL Server database. You are designing a table that will

Valid 70-461 Dumps shared by ExamDiscuss.com for Helping Passing 70-461 Exam! ExamDiscuss.com now offer the newest 70-461 exam dumps, the ExamDiscuss.com 70-461 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-461 dumps with Test Engine here:

Access 70-461 Dumps Premium Version
(252 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 53/126

You are a database developer of a Microsoft SQL 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,
CustomerID int NOT NULL,
CustomerName varchar(255) NOT NULL
CONSTRAINT UQ_Customer UNIQUE
(SourceID, CustomerID));

B. CREATE TABLE Customer
(SourceID int NOT NULL UNIQUE,
CustomerID int NOT NULL UNIQUE,
CustomerName varchar(255) NOT NULL);

C. CREATE TABLE Customer
(SourceID int NOT NULL PRIMARY KEY CLUSTERED,
CustomerID int NOT NULL UNIQUE,
CustomerName varchar(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));

Question 53/126

LEAVE A REPLY

Download PDF File