Smartek21 MS SQL DBA Interview Questions and Answers

AlwaysOn is a high availability and disaster recovery feature in SQL Server that provides redundancy and failover capabilities.

• AlwaysOn Availability Groups allow you to create a group of user databases that fail over together

• AlwaysOn Failover Cluster Instances provide high availability for a single SQL Server instance

• Automatic failover and read-only secondary replicas are key features of AlwaysOn

High Availability refers to the ability of a system to remain operational and accessible for a high percentage of time.

• Ensures minimal downtime by providing redundancy and failover mechanisms

• Involves clustering, replication, and load balancing to distribute workload

• Common technologies used for achieving high availability include Always On Availability Groups in SQL Server

Clustering is the process of grouping together similar data points based on certain criteria.

• Clustering helps in organizing data into meaningful groups for analysis.

• It is commonly used in data mining and machine learning.

• Examples include K-means clustering and hierarchical clustering.