Which configuration should you use?

You administer all the deployments of Microsoft SQL Server 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?

You administer all the deployments of Microsoft SQL Server 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:
http://msdn.microsoft.com/en-us/library/jj542414.aspx



Leave a Reply 16

Your email address will not be published. Required fields are marked *


Sohail

Sohail

Attempted today and got 923 !! User lead2pass premium vce. Be careful, maybe few answers are wrong but all questions are match. Best of Luck !!

Liam

Liam

How close was the Lead2Pass to this version 4 on here ?

soumya

soumya

Hi Sohail,

Is this V4 questions are valid…can we try the luck by reading only this..

ZVV

ZVV

Passed it today with 925 points.

Most questions (~80%) from this list (but not all replies are correct here).

~20% of Questions were either completely different ones or slightly changed questions from this list (that means that they can have another meaning and answers).

So you should not rely just on this list…

808

808

I passed, but not with high scores. I don’t think the answers here are correct. You need to read from different sources and have your own reasonable answer.

Jack

Jack

Passed the exam today with 830. Only studied in this v4 questions.

Mr PoPo

Mr PoPo

Jack, so you just studied the questions here and the answers of this list? No answers are wrong?

SQLDBA

SQLDBA

I failed exam yesterday. Answers are wrong. 80% questions matched.

sql

sql

where can we get correct answers?

Non_stop

Non_stop

are this dumps reliable can I pass using this?

DBA

DBA

Passed today. Studied only this dumps. 90% valid. only 3-4 new questions out of 45. Went with the answers in the comments section.

MMM

MMM

Passed yesterday. Studied only on v4. 80% matched. 5 new question. More encryption questions.

AdamB

AdamB

Passed yesterday mid 800s score – studied these questions and others – about 25% new questions.
Lots more questions on encryption, a number of questions have been reversed so the code that was in the question is now a drag and drop choice for the answer.

jin

jin

passed today using this website. Some answers are wrong. Use the comments.