Demo The SecOps Group CNSP Exam Questions

Microsoft SQL Server (MSSQL) relies on specific ports for its core services, as defined by Microsoft
and registered with IANA:
1433/TCP: The default port for the SQL Server Database Engine. Clients connect here for querying
databases (e.g., via ODBC or JDBC). It’s a well-known port, making it a frequent target for attacks if
exposed.
1434/UDP: Used by the SQL Server Browser Service, which listens for incoming requests and
redirects clients to the correct port/instance (especially for named instances). It’s critical for
discovering dynamic ports when 1433 isn’t used.
1434/TCP: Less commonly highlighted but used in some configurations, such as dedicated admin
connections (DAC) or when the Browser Service responds over TCP for specific instances. While
1433/TCP is the primary engine port, 1434/TCP can be involved in multi-instance setups.
Technical Details:
Ports can be customized (e.g., via SQL Server Configuration Manager), but these are defaults.
Named instances often use dynamic ports (allocated from the ephemeral range), with the Browser
Service (1434/UDP) guiding clients to them.
Firewalls must allow these ports for MSSQL to function externally, posing risks if not secured (e.g.,
brute-force attacks on 1433/TCP).
Security Implications: CNSP likely covers MSSQL port security, as vulnerabilities like SQL Slammer
(2003) exploited 1434/UDP misconfigurations. Hardening includes restricting access, changing
defaults, and monitoring traffic.
Why other options are incorrect:
A . 1433/TCP, 2433/UDP, 3433/TCP: 2433/UDP and 3433/TCP are not MSSQL standards; they’re likely
typos or unrelated ports.
C . 1433/TCP, 2433/UDP, 1434/TCP: 2433/UDP is incorrect; 1434/UDP is the Browser Service port.
D . 1533/TCP, 1434/UDP, 2434/TCP: 1533/TCP and 2434/TCP aren’t associated with MSSQL; they
deviate from documented defaults.
Real-World Context: Tools like netstat -an | find "1433" on Windows confirm MSSQL’s port usage
during audits.
Reference: CNSP Official Documentation (Database Security and Ports); Microsoft SQL Server
Documentation, IANA Port Registry.

Authentication and Authorization (often abbreviated as AuthN and AuthZ) are foundational pillars of
access control in network security:
Authentication (AuthN): Verifies "who you are" by validating credentials against a trusted source.
Examples include passwords, MFA (multi-factor authentication), certificates, or biometrics. It ensures
the entity (user, device) is legitimate, typically via protocols like Kerberos or LDAP.
Authorization (AuthZ): Determines "what you can do" after authentication, enforcing policies on
resource access (e.g., read/write permissions, API calls). It relies on mechanisms like Access Control
Lists (ACLs), Role-Based Access Control (RBAC), or Attribute-Based Access Control (ABAC).
Option A correctly separates these roles:
Authorization governs access decisions (e.g., "Can user X read file Y?").
Authentication establishes identity (e.g., "Is this user X?").
In practice, these processes are sequential: AuthN precedes AuthZ. For example, logging into a VPN
authenticates your identity (e.g., via username/password), then authorizes your access to specific
subnets based on your role. CNSP likely stresses this distinction for designing secure systems, as
conflating them risks privilege escalation or identity spoofing vulnerabilities.
Why other options are incorrect:
B: Reverses the definitions—Authentication doesn’t grant/deny access (that’s AuthZ), and
Authorization doesn’t validate identity (that’s AuthN). This mix-up could lead to flawed security
models.
C: Falsely equates AuthN and AuthZ and attributes access rules to AuthN. They’re distinct processes;
treating them as identical undermines granular control (e.g., NIST SP 800-53 separates IA-2 for
AuthN and AC-3 for AuthZ).
D: Misassigns access control to AuthN and claims they don’t interoperate, which is false—they work
together in every modern system (e.g., SSO with RBAC). This would render auditing impossible,
contradicting security best practices.
Real-World Context: A web server (e.g., Apache) authenticates via HTTP Basic Auth, then authorizes
via .htaccess rules—two separate steps.
Reference: CNSP Official Study Guide (Access Control Fundamentals); NIST SP 800-53 (Security and
Privacy Controls).

TCP (Transmission Control Protocol) uses a three-way handshake (SYN, SYN-ACK, ACK) to establish
connections, as per RFC 793. When a client sends a SYN packet to a port:
Open Port: The server responds with SYN-ACK.
Closed Port (no firewall): The server sends an RST (Reset) packet, often with ACK, to terminate the
attempt immediately.
However, when a firewall is present, its configuration dictates the response. Modern firewalls
typically operate in stealth mode, using a "drop" rule for closed ports rather than a "reject" rule:
Drop: Silently discards the packet without replying, resulting in no response. The client experiences a
timeout (e.g., 30 seconds), as no feedback is provided.
Reject: Sends an RST or ICMP "Port Unreachable," but this is less common for security reasons, as it
confirms the firewall’s presence.
For a closed TCP port behind a firewall, "no response" (drop) is the standard behavior in secure
configurations, minimizing information leakage to attackers. This aligns with CNSP’s focus on firewall
best practices to obscure network topology during port scanning (e.g., with Nmap).
Why other options are incorrect:
A . A FIN and an ACK packet: FIN-ACK is used to close an established TCP connection gracefully (e.g.,
after data transfer), not to respond to an initial SYN on a closed port.
B . RST and an ACK packet: RST-ACK is the host’s response to a closed port without a firewall. A
firewall’s drop rule overrides this by silently discarding the packet.
C . A SYN and an ACK packet: SYN-ACK indicates an open port accepting a connection, the opposite of
a closed port scenario.
Real-World Context: Tools like Nmap interpret "no response" as "filtered" (firewall likely present) vs.
"closed" (RST received), aiding in firewall detection.

Reference: CNSP Official Study Guide (Firewall Operations and TCP/IP); RFC 793 (TCP).