You create an availability group named HaContoso that has replicas named Server01/HA,
---
Server02/HA, and Server03/HA.
Currently, Server01l/HA is the primary replicA.
You need to ensure that the following requirements are met:
Backup operations occur on Server02/HA.
If Server02/HA is unavailable, backup operations occur on Server03/HA.
Backup operations do not occur on Server01/HA.
How should you configure HaContoso?

• A.set the backup preference of HaContoso to Prefer Secondary.
  Set the backup priority of Server02/HA to 20.
  Set the backup priority of Server03/HA to 10.
• B.Set the backup preference of HaContoso to Secondary only.
  Set the backup priority of Server02/HA to 20.
  Set the backup priority of Server03/HA to 10.
• C.Set the backup preference of HaContoso to Secondary only.
  Set the backup priority of Server02/HA to 10.
  Set the backup priority of Server03/HA to 20.
• D.set the exclude replica of Server01/HA to true.
  Set the backup priority of Server02/HA to 10.
  Set the backup priority of Server03/HA to 20.

Comment: *

Name: *

Email: *

Verification: *

Your database contains a table named SalesOrders. The table includes a DATETIME column named OrderTime that stores the date and time each order is placed. There is a non-clustered index on the OrderTime column. The business team wants a report that displays the total number of orders placed 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?

• A.SELECT COUNT(*) FROM SalesOrders
  WHERE CONVERT(VARCHAR, OrderTime, 112) = CONVERT(VARCHAR, GETDATE(I, 112))
• B.SELECT COUNT(*) FROM SalesOrders
  WHERE OrderTime = CONVERT(DATE, GETDATE())
• C.SELECT COUNT(*) FROM SalesOrders
  WHERE OrderTime = GETDATE()
• D.SELECT COUNT(*) FROM SalesOrders
  WHERE OrderTime >= CONVERT(DATE, GETDATE())
  AND OrderTime < DATEADD(DAY, CONVERT(DATE, GETDATE()))

Comment: *

Name: *

Email: *

Verification: *

You administer a Microsoft SQL Server database that includes a table named dbo.Log.
This table contains millions of records about user activity in an application.
Records in dbo.Log that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts.
You need to be able to modify dbo.Log without requiring any changes to the applications that utilize dbo.Log.
Which type of solution should you use?

• A.Partitioned tables
• B.Extended events
• C.Read committed snapshot
• D.Columnstore index

Comment: *

Name: *

Email: *

Verification: *

You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction.
You discover that query performance on the table is poor due to fragmentation on the IDX_AccountTransaction_AccountCode non-clustered index.
You need to defragment the index. You also need to ensure that user queries are able to use the index during the defragmenting process.
Which Transact-SQL batch should you use?

• A.ALTER INDEX ALL ON AccountTransaction REBUILD
• B.ALTER INDEX IDX_AccountTransaction_AccountCode
  ON AccountTransaction.AccountCode REORGANIZE
• C.CREATE INDEX IDXAccountTransactionAccountCode
  ON AccountTransaction.AccountCode WITH DROP EXISTING
• D.ALTER INDEX IDX_AccountTransaction_AccountCode
  ON AccountTransaction.AccountCode REBUILD

Comment: *

Name: *

Email: *

Verification: *

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?
A:

B:

C:

D:

• A.Option A
• B.Option B
• C.Option C
• D.Option D

Comment: *

Name: *

Email: *

Verification: *