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

Exam 70-764 All Questions

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

Exam 70-764 topic 1 question 42 discussion

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

HOTSPOT -
You are planning the deployment of two new Always On Failover Cluster Instances (FCIs) of Microsoft SQL Server to a single Windows Server Cluster with three nodes. The planned configuration for the cluster is shown in the Server Layout exhibit. (Click the Exhibit button.)

The SAN team has configured storage for the cluster and sent the configuration to you in the email shown in the SAN Team Email exhibit. (Click the Exhibit button.)

Each node of the cluster has identical local storage available as shown in the Local Storage exhibit. (Click the Exhibit button.)

All local storage is on SSD.
You need to plan specific configurations for the new cluster.
For each of the following statement, select Yes if the statement is true. Otherwise, select No.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
by Spicy2312 at April 23, 2019, 2:39 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
jolsca
4 years, 3 months ago
Box 1: Yes tempdb on local storage. FCIs now support placement of tempdb on local non-shared storage, such as a local solid-state-drive, potentially offloading a significant amount of I/O from a shared SAN. Prior to SQL Server 2012, FCIs required tempdb to be located on a symmetrical shared storage volume that failed over with other system databases. Box 2: No The VNN is set on the group level, not on the instance level. Box 3: No You don’t configure the SAN from a SQL Server, instead you can use a Microsoft Server server.
upvoted 2 times
...
dbadude14
4 years, 3 months ago
I would go with Yes, No, Yes Though I would not store tempdb on the same drive as data, it can be there. VNN is handled in the Windows FCI cluster configuration The drives are formatted because they show usage.
upvoted 1 times
dbadude14
4 years, 3 months ago
Change that Yes, No, No
upvoted 1 times
...
...
ChinmayMarulkar
4 years, 5 months ago
Yes,Yes,No
upvoted 1 times
...
ChinmayMarulkar
4 years, 5 months ago
Yes,Yes,No
upvoted 1 times
...
MelKr
4 years, 6 months ago
yes, yes, no: part2: "Each SQL Server Instance in the cluster" = Failover-Cluster Instance. The question is talking about 2 FCIs to be configured. Each needs their own IP and Networkname.
upvoted 2 times
KC
4 years, 4 months ago
Agreed: https://blog.sqlauthority.com/2016/05/03/sql-server-qa-sql-clustering-virtual-server-name-instance-name/
upvoted 1 times
...
...
Guest
5 years ago
part 2 : you need a virtual network name for each FCI, not for every SQL Server instance So I also opt for yes,no,no
upvoted 1 times
...
msamm
5 years, 2 months ago
Yes, No, No
upvoted 2 times
...
cian
5 years, 5 months ago
Yes, No, No
upvoted 3 times
...
AnuragDobade
5 years, 7 months ago
Yes,Yes,No
upvoted 4 times
...
AlexandreVM
5 years, 7 months ago
Yes, No, No
upvoted 4 times
...
Spicy2312
5 years, 7 months ago
There isn't an answer for this one.
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago