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 15054

You develop a Microsoft SQL Server 2012 database that contains tables named
Customers and Orders. The tables are related by a column named CustomerId.
You need to create a query that meets the following requirements:
✑ Returns the CustomerName for all customers and the OrderDate for any orders
that they have placed.
✑ Results must not include customers who have not placed any orders.
Which Transact-SQL query should you use?

Option A

SELECT CustomerName, OrderDate FROM Customers LEFT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerId

Option B

SELECT CustomerName, OrderDate FROM Customers RIGHT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerId

Option C

SELECT CustomerName, OrderDate FROM Customers CROSS JOIN Orders ON Customers.CustomerId = Orders.CustomerId

Option D

SELECT CustomerName, OrderDate FROM Customers JOIN Orders ON Customers.CustomerId = Orders.CustomerId

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


Question ID 15055

You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that
has the following definition:

You need to create a non-clustered index on the SalesOrderID column in the OrderDetail
table to include only rows that contain a value in the SpecialOfferID column. Which four
Transact-SQL statements should you use?
(To answer, move the appropriate statements from the list of statements to the answer
area and arrange them in the correct order.)

Option A

Correct Answer A
Explanation

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