What role does port security play in protecting a database infrastructure?

• A. It encrypts data being transmitted over the network
• B. It prevents unauthorized access to network switches
• C. It manages user access permissions
• D. It enhances database query performance

Answer: (B)

Port security plays a crucial role in protecting a database infrastructure by preventing unauthorized access to network switches. In a networked environment, switches are responsible for directing data traffic to and from devices, including databases. By implementing port security, organizations can restrict which devices are allowed to connect to a switch port. This ensures that only authorized devices have access to the network, significantly reducing the risk of unauthorized users attempting to access sensitive database information or introduce malicious activities.

When port security is properly configured, it can limit the number of MAC addresses recognized on a port, disable ports after a security violation, or configure sticky MAC addressing, where legitimate devices are recorded and permitted to maintain access. This layer of security provides an important defensive mechanism in a multi-user environment, helping to guard against data breaches and unauthorized access attempts that could compromise the integrity and availability of a database system.