AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Microsoft- 70-461





Question ID 15104

You are a database developer of a Microsoft SQL Server 2012 database.
The database contains a table named Customers that has the following definition:

You need to ensure that the CustomerId column in the Orders table contains only values
that exist in the CustomerId column of the Customer table.
Which Transact-SQL statement should you use?

 

Option A

ALTER TABLE Orders ADD CONSTRAINT FX_Orders_CustomerID FOREIGN KEY (CustomerId) REFERENCES Customer (CustomerId)

Option B

ALTER TABLE Customer ADD CONSTRAINT FK_Customer_CustomerID FOREIGN KEY {CustomerID) REFERENCES Orders (CustomerId)

Option C

ALTER TABLE Orders ADD CONSTRAINT CK_Orders_CustomerID CHECK (CustomerId IN (SELECT CustomerId FROM Customer))

Option D

ALTER TABLE Customer ADD OrderId INT NOT NULL; ALTER TABLE Customer ADD CONSTRAINT FK_Customer_OrderID FOREIGN KEY (OrderID) REFERENCES Orders (OrderID);

Option E

ALTER TABLE Orders ADD CONSTRAINT PK Orders CustomerId PRIMARY KEY (CustomerID)

Correct Answer A
Explanation Reference: http://msdn.microsoft.com/en-us/library/ms189049.aspx


Question ID 15105

You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an
application. You need to evaluate existing and potential clustered and non-clustered
indexes that will improve performance.
What should you do?

Option A

Query the sys.dm_db_index_usage_stats DMV.

Option B

 Query the sys.dm_db_missing_index_details DMV.

Option C

Use the Database Engine Tuning Advisor.

Option D

Query the sys.dm_db_missing_index_columns DMV.

Correct Answer C
Explanation

Send email to admin@getfreedumps for new dumps request!!!