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-462





Question ID 18863

You are a database developer for an application hosted on a Microsoft SQL Server 2012
server. The database contains two tables that have the following definitions:

Global customers place orders from several countries. You need to view the country from
which each customer has placed the most orders.
Which Transact-SQL query do you use?

Option A

 SELECT c.CustomerID, c.CustomerName, o.ShippingCountry FROM Customer c INNER JOIN (SELECT CustomerID, ShippingCountry, RANK() OVER (PARTITION BY CustomerID ORDER BY COUNT(OrderAmount) DESC) AS Rnk FROM Orders GROUP BY CustomerID, ShippingCountry) AS o ON c.CustomerID = o.CustomerID WHERE o.Rnk = 1

Option B

SELECT c.CustomerID, c.CustomerName, o.ShippingCountry FROM (SELECT c.CustomerID, c.CustomerName, o.ShippingCountry, RANK() OVER (PARTITION BY CustomerID ORDER BY COUNT(o.OrderAmount) ASC) AS Rnk FROM Customer c INNER JOIN Orders o ON c.CustomerID = o.CustomerID GROUP BY c.CustomerID, c.CustomerName, o.ShippingCountry) cs WHERE Rnk = 1

Option C

SELECT c.CustomerID, c.CustomerName, o.ShippingCountry FROM Customer c INNER JOIN (SELECT CustomerID, ShippingCountry, RANK() OVER (PARTITION BY CustomerID ORDER BY OrderAmount DESC) AS Rnk FROM Orders GROUP BY CustomerID, ShippingCountry) AS o ON c.CustomerID = o.CustomerID WHERE o.Rnk = 1

Option D

SELECT c.CustomerID, c.CustomerName, o.ShippingCountry FROM Customer c INNER JOIN (SELECT CustomerID, ShippingCountry, COUNT(OrderAmount) DESC) AS OrderAmount FROM Orders GROUP BY CustomerID, ShippingCountry) AS o ON c.CustomerID = o.CustomerID ORDER BY OrderAmount DESC

Correct Answer A
Explanation


Question ID 18864

You administer a Microsoft SQL Server 2012 database named Contoso on a server named
Server01.
You need to be notified immediately when fatal errors occur on Server01.
What should you create?

Option A

an Alert

Option B

a Server Audit Specification

Option C

an Extended Event session

Option D

a Resource Pool

Option E

a Policy

Option F

a SQL Profiler Trace

Correct Answer A
Explanation Explanation: http://www.sqlskills.com/blogs/glenn/creating-sql-server-agent-alerts-for- critical-errors/

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