ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-465 All Questions

View all questions & answers for the 70-465 exam
Go to Exam

Exam 70-465 topic 1 question 45 discussion

Actual exam question from Microsoft's 70-465
Question #: 45
Topic #: 1
[All 70-465 Questions]

DRAG DROP -
You plan to install two SQL Server 2014 environments named Environment1 and Environment.
Your company identifies the following availability requirements for each environment:
✑ Environment1 must have mirroring with automatic failover implemented.
✑ Environment2 must have AlwaysOn with automatic failover implemented.
You need to identify the minimum number of SQL Server 2014 servers that must be deployed to each environment to ensure that all data remains available if a physical server fails.
How many servers should you identify?
To answer, drag the appropriate number to the correct environment in the answer area.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
References:
Database Mirroring (SQL Server)
Failover and Failover Modes (AlwaysOn Availability Groups)
by AlexandreVM at March 5, 2020, 8:46 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
AlexandreVM
Highly Voted 5 years, 4 months ago
Answers: 3 and 2 Mirroring needs 3 servers to have automatic failover.
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel