nerdexam
CompTIA

CV0-002 · Question #460

An administrator is creating new severs in a public cloud. The workflow creates and application group with three VMs, one web server, one application server and one database server. The three VMs are

The correct answer is C. Misconfigured firewall rule. When all VMs are SSH accessible but a website reports a database error, the most likely cause is a misconfigured firewall rule blocking specific database communication ports.

Troubleshooting

Question

An administrator is creating new severs in a public cloud. The workflow creates and application group with three VMs, one web server, one application server and one database server. The three VMs are all accessible via SSH, but the websites shows a 503-error referring to a database issue. Which of the following is the MOST likely cause of the error?

Options

  • AMisconfigured VLAN
  • BMisconfigured proxy
  • CMisconfigured firewall rule
  • DMisconfigure routing

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    8% (2)
  • C
    72% (18)
  • D
    16% (4)

Why each option

When all VMs are SSH accessible but a website reports a database error, the most likely cause is a misconfigured firewall rule blocking specific database communication ports.

AMisconfigured VLAN

If VLANs were misconfigured to prevent inter-tier communication, SSH access to affected VMs would also likely be compromised, contradicting that all VMs are SSH accessible.

BMisconfigured proxy

A misconfigured proxy typically affects client-to-web server or outbound internet traffic, not internal application-to-database communication which is the source of the 503 database error.

CMisconfigured firewall ruleCorrect

A misconfigured firewall rule is the most likely cause. While SSH (port 22) might be permitted for administrative access to all VMs, firewall rules often block specific application ports like those for database communication (e.g., 3306, 1433) between the application and database servers, leading to connection failures and database-related errors.

DMisconfigure routing

If routing were fundamentally misconfigured between the VMs, SSH access to some or all VMs would likely be impacted, or connectivity between specific tiers would fail more broadly, not just for the database port.

Concept tested: Troubleshooting cloud network security-firewall rules

Source: https://learn.microsoft.com/en-us/azure/virtual-network/network-security-groups-overview

Topics

#Troubleshooting#Application connectivity#Database access#Firewall rules

Community Discussion

No community discussion yet for this question.

Full CV0-002 Practice