Senior SQL Server Database Administrator Interview Questions and Answers

Security concept in SQL server involves controlling access to data and ensuring confidentiality, integrity, and availability.

• Authentication and authorization

• Encryption and decryption

• Auditing and monitoring

• Role-based security

• Row-level security

• Transparent Data Encryption (TDE)

• Always Encrypted

• Dynamic Data Masking

• Firewall and IP restrictions

HA stands for High Availability and refers to the ability of a system to remain operational even after a component failure.

• SQL Server offers several HA options, including Always On Availability Groups, Failover Cluster Instances, and Database Mirroring.

• Always On Availability Groups provide a high level of availability and can be used for disaster recovery as well.

• Failover Cluster Instances use shared storage and provide automatic failover in case of a node failure.

• Database Mi...read more