Infosys Certified SQL Server 2012 High Availability Associate
Practice with real exam-pattern questions for Infosys Certified SQL Server 2012 High Availability Associate. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified SQL Server 2012 High Availability Associate practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified SQL Server 2012 High Availability Associate certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
How many replicas can be setup in SQL Server AlwaysOn?
- ✓ A.1 Correct
- B B.2
- C C.4
- D D.5
- Question 2
What is the Edition required to configure SQL Server 2012 AlwaysOn?
- ✓ A.Enterprise Edition Correct
- B B.Standard Edition
- C C.Web Edition
- D D.Developer Edition
- Question 3
What is the default quorum option available in SQL Server AlwaysOn?
- ✓ A.Node and Disk Majority Correct
- B B.Node and File Share Majority
- C C.Node Majority
- D D.No Majority
- Question 4
Which is the tool used for cluster administration?
- ✓ A.clusadmin Correct
- B B.cluadmin
- C C.cadmin
- D D.clusteradmin
- Question 5
Which of the following is not the prerequisite for Clustering?
- ✓ A.Windows Server 2003 Correct
- B B.Heartbeat Signal
- C C.SAN
- D D.Shared Folder
- Question 6
What is the purpose of Server Cluster in MS SQL Server 2012?
- ✓ A.For SQL server load balance Correct
- B B.This provides High availability by configuring active-active or active-passive cluster
- C C.Both A and B
- D D.Neither A nor B
- Question 7
What is the purpose of a File Share witness?
- ✓ A.This is a file share drive Correct
- B B.This is a drive shared to only administrators where the files will be available
- C C.The file share witness is used to establish a majority node set
- D D.File share witness is not possible in clustering
- Question 8
What is MNS cluster?
- ✓ A.This is an active-passive cluster mechanism Correct
- B B.This is an active- active cluster mechanism
- C C.MNS-based cluster can be located in a single site
- D D.This is an active-active cluster in different locations
- Question 9
What does a failover cluster do in Windows Server 2008 ?
- ✓ A.It will not perform any operation Correct
- B B.It will failover the services in cluster frequently
- C C.It will not give maximum high availability
- D D.A failover cluster is a group of independent computers that work together to increase the availability of applications and services.
- Question 10
Does a cluster aware application need to be rewritten to support MNS?
- ✓ A.Yes Correct
- B B.No
- C C.It depends on the cluster
- D D.None of the above
More in IMS Academy
Infosys Certified WebSphere Application Server 8.5 Administrator
Infosys Certified Windows 11 Administrator - Associate
Infosys Certified Windows Server 2022 Administrator – Associate
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.