nerdexam
CompTIA

XK0-004 · Question #469

A developer reports a web sever is unable to connect to the database server. The developer reviews the following output from each server: Web server output: Database server output: Which of the…

The correct answer is B. Add a static route between the two networks. When a web server and database server reside on different network segments with no route between them, adding a static route is the correct fix to restore connectivity.

Troubleshooting and Diagnostics

Question

A developer reports a web sever is unable to connect to the database server. The developer reviews the following output from each server:

Web server output:

Database server output:

Which of the following will resolve the issue?

Exhibit

XK0-004 question #469 exhibit

Options

  • AStart the database on the web server and enable it to survive reboot
  • BAdd a static route between the two networks
  • CRemove the drcp command on the database firewall
  • DEnable the network interfaces on the database server

How the community answered

(60 responses)
  • A
    5% (3)
  • B
    70% (42)
  • C
    17% (10)
  • D
    8% (5)

Why each option

When a web server and database server reside on different network segments with no route between them, adding a static route is the correct fix to restore connectivity.

AStart the database on the web server and enable it to survive reboot

Installing the database engine on the web server conflates two tiers that should remain separate and does not address the underlying network routing gap.

BAdd a static route between the two networksCorrect

The server outputs (not visible in this text rendering) indicate the hosts are on separate subnets with no routing path between them. Adding a static route with 'ip route add' or via the network configuration files tells the kernel how to forward packets between the two networks, restoring TCP connectivity to the database port.

CRemove the drcp command on the database firewall

Removing a firewall rule on the database server alone cannot fix a missing route - packets that never arrive at the database host cannot be filtered.

DEnable the network interfaces on the database server

If the database server's network interfaces were fully down, the developer would see no ARP or TCP responses at all; the output shown implies partial connectivity exists.

Concept tested: Static routing to restore inter-subnet connectivity

Source: https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html/configuring_and_managing_networking/configuring-static-routes_configuring-and-managing-networking

Topics

#network routing#static routes#database connectivity#firewall rules

Community Discussion

No community discussion yet for this question.

Full XK0-004 Practice