READ Free Dumps For Microsoft- 70-462
Question ID 18901 | You administer a Microsoft SQL Server 2012 server along with a Windows Azure SQL
Database database.
For both servers, you need to grant users the ability to create logins and create databases.
You need to determine which permission to grant users in each instance.
Which permission or permissions should you choose? (To answer, drag the appropriate
permission or permissions to their corresponding instance type or types in the answer area.
Answer choices may be used once, more than once, or not at all. Answer targets may be
used once or not at all. Additionally, you may need to drag the split bar between panes or
scroll to view content.)
|
Option A | Answer :
|
Correct Answer | A |
Explanation
Question ID 18902 | Your database contains a table named Purchases. The table includes a DATETIME
column named PurchaseTime that stores the date and time each purchase is made. There
is a non-clustered index on the PurchaseTime column. The business team wants a report
that displays the total number of purchases made on the current day. You need to write a
query that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?
|
Option A | SELECT COUNT(*) FROM Purchases WHERE PurchaseTime = CONVERT(DATE, GETDATE())
|
Option B | SELECT COUNT(*) FROM Purchases WHERE PurchaseTime = GETDATE()
|
Option C | SELECT COUNT(*) FROM Purchases WHERE CONVERT(VARCHAR, PurchaseTime, 112) = CONVERT(VARCHAR, GETDATE(), 112)
|
Option D | SELECT COUNT(*) FROM Purchases WHERE PurchaseTime >= CONVERT(DATE, GETDATE()) AND PurchaseTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))
|
Correct Answer | D |
Explanation Explanation: Explanation/Reference: http://technet.microsoft.com/en-us/library/ms181034.aspx