You administer all the deployments of Microsoft SQLServer 2012 in your company.
You need to ensure that an OLTP database that includes up-to-the-minute reporting
requirements can be off-loaded from the primary database to another server.
You also Need to be able to add indexes to the secondary database.
Which configuration should you use?
A.
� Two servers configured in different data centers
� SQL Server Availability Group configured in Synchronous-Commit Availability
Mode
� One server configured as an Active Secondary
B.
� Two servers configured in the same data center
� SQL Server Availability Group configured in Asynchronous-Commit Availability
Mode
� One server configured as an Active Secondary
C.
� Two servers configured in the same data center
� A primary server configured to perform log-shipping every 10 minutes
� A backup server configured as a warm standby
D.
� Two servers configured in different data centers
� SQL Server Availability Group configured in Asynchronous-Commit Availability
Mode
E.
� Two servers configured on the same subnet
� SQL Server Availability Group configured in Synchronous-Commit Availability
Mode
F.
� SQL Server that includes an application database configured to perform
transactional replication
G.
� SQL Server that includes an application database configured to perform snapshot
replication
H.
� Two servers configured in a Windows Failover Cluster in the same data center
� SQL Server configured as a clustered instance
Explanation:
I’m not answering as I dont have any idea (originalis F)
Solution F) ist right. You can only create Indexes for Reporting when using Transaction Replication
Look at this at Microsoft:
http://msdn.microsoft.com/en-us/library/jj542414.aspx
There you can download this Word-Document:
http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/Offloading%20Read-Only%20Workloads%20to%20Secondary%20Replicas%20v1.docx
There is described in which ways you can offload reporting (Mirroring with snapshot, Replication, Log-Shipping, readable AlwaysOn-Secondary)
There are all Read-
The Answer is E:
In F;Indexes does not apply automatically from primary to secondary
Raj the answer is F because you need to be able to add indexes to the secondary database not to the primary.
Please update the 70-246 exam exam it? Thank you
Please update the 70-247 exam exam it? Thank you
so what is the correct answer?
Just for you jzed, the right answer is A….but don’t tell anyone !
F) Transactional Replication
Donk
+One