FC0-U61 Practice Test 13 — 15 Questions

Question 1

A company's database administrator notices that queries against a large customer table are running slowly. The table has millions of rows and is frequently filtered by the 'last_name' column. Which of the following is the BEST way to improve query performance without changing the application code?

Accepted Answer

Create an index on the 'last_name' column.. Creating an index on the 'last_name' column allows the database to locate rows matching filter conditions without scanning the entire table. This dramatically reduces I/O and CPU overhead for queries that filter by last_name, directly addressing the performance bottleneck without requiring any changes to application code.

Answer

Partition the table by row count.

Answer

Increase the database server's RAM.

Answer

Denormalize the table to reduce joins.

Question 2

A user wants to access a website but types the wrong URL. Which technology resolves domain names to IP addresses?

Accepted Answer

DNS. DNS (Domain Name System) is the technology that translates human-readable domain names (like www.example.com) into machine-readable IP addresses (like 192.0.2.1). When a user types a wrong URL, the browser still sends a DNS query to resolve the domain portion of the URL; if the domain is valid but the path is wrong, DNS resolves correctly, but if the domain itself is mistyped, DNS may fail or redirect to a different IP. This resolution is essential for locating the web server on the internet.

Answer

HTTP

Answer

NAT

Answer

DHCP

Question 3

A company stores sensitive data and wants to ensure that if a hard drive is stolen, the data cannot be read. Which security measure should be implemented?

Accepted Answer

Full disk encryption. Full disk encryption (FDE) encrypts the entire contents of a hard drive, including the operating system, applications, and all data, using algorithms such as AES-256. If the drive is stolen, the data remains unreadable without the decryption key or passphrase, even if the drive is physically removed and attached to another system. This directly addresses the requirement of protecting data at rest on a stolen drive.

Answer

RAID 1

Answer

Antivirus software

Answer

Strong passwords

Question 4

Which TWO of the following are appropriate steps when troubleshooting a user's inability to access the internet? (Select TWO.)

Accepted Answer

Check the IP address configuration. Option A is correct because checking the IP address configuration is a fundamental first step in troubleshooting network connectivity. A misconfigured IP address, such as an Automatic Private IP Addressing (APIPA) address in the 169.254.x.x range, indicates that the device failed to obtain a valid IP from a DHCP server, which would prevent internet access. Verifying the IP configuration with commands like `ipconfig` (Windows) or `ifconfig` (Linux/macOS) helps identify if the device has a proper IP, subnet mask, and default gateway.

Answer

Restart the computer

Answer

Replace the network cable

Answer

Power cycle the router

Question 5

A user reports that their printer is not working. The printer is connected via USB to a workstation, and other users can print to the same printer over the network. Which of the following should the technician check FIRST?

Accepted Answer

USB cable connection. Since other users can print to the same printer over the network, the printer itself is operational and reachable. The issue is isolated to the local workstation, making the USB cable connection the most likely point of failure. A loose, damaged, or disconnected USB cable would prevent the workstation from communicating with the printer, so checking the physical connection is the quickest and simplest first step.

Answer

Paper jam in the printer

Answer

Printer driver on the workstation

Answer

Printer sharing settings on the network

Question 6

Which TWO of the following are common Ethernet cable categories used in local area networks?

Accepted Answer

Cat5e. Cat5e and Cat6 are twisted-pair cables commonly used for Ethernet. Coaxial is used for cable TV, HDMI for audio/video, USB for peripherals.

Answer

USB

Answer

Coaxial

Answer

HDMI

Question 7

Which of the following cable types is MOST commonly used for Ethernet networks in an office?

Accepted Answer

Cat5e. Cat5e (Category 5 enhanced) is the most common twisted-pair copper cable used in office Ethernet networks because it supports speeds up to 1 Gbps (1000BASE-T) over distances up to 100 meters, and it is backward-compatible with older 10/100 Mbps standards. Its widespread adoption, low cost, and ease of termination make it the default choice for structured cabling in modern office environments.

Answer

Coaxial

Answer

Fiber optic

Answer

USB

Question 8

A small business wants to set up a wireless network for employees and guests. The owners are concerned about unauthorized access. Which of the following security measures would be MOST effective to prevent outsiders from connecting?

Accepted Answer

Use WPA2 encryption with a strong passphrase. Option B is correct because WPA2 encryption with a strong password is the standard for securing Wi-Fi. Option A is wrong because SSID broadcast hiding is easily bypassed. Option C is wrong because MAC filtering can be spoofed. Option D is wrong while disabling DHCP may hinder but not prevent connection; static IP can be guessed.

Answer

Enable MAC address filtering

Answer

Disable SSID broadcast

Answer

Disable DHCP on the router

Question 9

A small business purchases a cable modem from the ISP. They need to obtain a public IP address to access the internet. Which method does the cable modem typically use?

Accepted Answer

DHCP. Cable modems typically use DHCP to obtain a public IP address from the ISP. When the modem powers on, it sends a DHCPDISCOVER broadcast, and the ISP's DHCP server responds with an IP address, subnet mask, default gateway, and DNS server information. This is the standard method for dynamically assigning public IP addresses to customer premises equipment (CPE) in cable networks.

Answer

NAT

Answer

Static assignment

Answer

APIPA

Question 10

Refer to the exhibit. A user reports that they cannot access the internet. Based on the output, which of the following is the MOST likely issue?

Accepted Answer

The router at 192.168.1.1 is down. The default gateway 192.168.1.1 is unreachable, as shown by the 100% packet loss in the ping output. Without a functional gateway, traffic cannot be routed from the local subnet to external networks, so internet access fails even if the local IP configuration is valid.

Answer

The subnet mask is incorrect

Answer

The IP address is invalid

Answer

The DNS suffix is missing

Question 11

A technician is installing a new network in a home office. The devices are spaced far apart, and the technician needs to make long runs of cable. Which of the following cable types is BEST suited for this scenario to minimize signal loss?

Accepted Answer

Fiber optic cable. Fiber optic cable uses light pulses to transmit data, which is immune to electromagnetic interference and can carry signals over much longer distances (often kilometers) without significant attenuation. In a home office with long cable runs, fiber optic cable is the best choice to minimize signal loss compared to copper-based cables.

Answer

Cat5e UTP

Answer

Cat6 UTP

Answer

Coaxial cable

Question 12

Which TWO of the following are effective methods to help secure a wireless network from unauthorized access?

Accepted Answer

Enabling WPA2 encryption. WPA2 encryption and MAC filtering are effective. WEP is weak and easily broken, broadcasting SSID makes the network visible, and disabling the firewall reduces security.

Answer

Enabling WEP encryption

Answer

Disabling the firewall

Answer

Broadcasting the SSID

Question 13

A user reports that their computer is unable to connect to the internet, but other devices on the same network work fine. Which of the following is the MOST likely cause?

Accepted Answer

Faulty network cable. A faulty network cable can prevent a single computer from connecting to the internet while other devices on the same network work fine. This is because the cable physically connects the computer to the network switch or router, and if it is damaged, the link may fail entirely or cause excessive packet loss, isolating only that device.

Answer

Router firewall blocking traffic

Answer

DHCP server failure

Answer

DNS server misconfiguration

Question 14

A network administrator wants to restrict access to the wireless network to only approved devices. Which security feature should be enabled on the access point?

Accepted Answer

MAC filtering. MAC filtering allows the access point to permit or deny network access based on the device's MAC address, which is a unique hardware identifier. By creating an allowlist of approved MAC addresses, the administrator can restrict the wireless network to only those devices. This directly addresses the requirement to limit access to approved devices.

Answer

Firewall rules

Answer

Disable SSID broadcast

Answer

WPA2 encryption

Question 15

A user wants to upgrade their workstation's storage without losing existing data. Which of the following is the BEST method?

Accepted Answer

Clone the existing drive to the new one. Option B is correct because cloning copies the entire drive to a new one, preserving data and OS. Option A is incorrect because a clean install erases data. Option C is incorrect because RAID requires multiple drives. Option D is incorrect because external backup is for backup, not upgrading internal storage.

Answer

Perform a clean installation on the new drive

Answer

Back up data to external drive, then restore

Answer

Set up a RAID 1 array