FC0-U71 Practice Test 30 — 15 Questions

Question 1

Refer to the exhibit. PC1 (192.168.1.10) cannot communicate with PC2 (192.168.2.10). What is the most likely cause?

Accepted Answer

Router1 lacks a route to the 192.168.2.0/24 network. Router1 lacks a route to the 192.168.2.0/24 network, so when PC1 sends traffic to PC2, Router1 does not have a destination network entry in its routing table to forward the packets. Without a route, the router drops the packets and may send an ICMP Destination Unreachable message back to PC1. This is the most likely cause because PC1 can reach its default gateway (Router1), but Router1 cannot forward traffic to the remote subnet.

Answer

PC2 has an incorrect default gateway

Answer

Switch1 is not routing between VLANs

Answer

PC1 has an incorrect subnet mask

Question 2

Refer to the exhibit. A database administrator runs the following query:

SELECT c.Name, SUM(o.Quantity) AS TotalItems
FROM Customers c
LEFT JOIN Orders o ON c.ID = o.CustomerID
GROUP BY c.Name;

What is the result for 'Alice'?

Accepted Answer

7. The LEFT JOIN ensures that Alice's record from the Customers table is retained even if there are no matching rows in Orders. The SUM(o.Quantity) aggregates the Quantity values from the joined Orders rows for Alice. Since Alice has two orders with quantities 2 and 5, the sum is 7, making option D correct.

Answer

2

Answer

NULL

Answer

5

Question 3

A company's server room is experiencing intermittent overheating. The administrator notices that the perforated floor tiles are blocked by equipment. What is the most likely consequence of this obstruction?

Accepted Answer

Reduced cooling efficiency and hot spots. Blocking perforated floor tiles restricts the flow of cold air from the raised-floor plenum into the server room. This reduces the overall cooling efficiency of the HVAC system and creates localized hot spots around the obstructed tiles, which can lead to equipment overheating and failure.

Answer

Increased electrical load on the UPS

Answer

Increased humidity levels

Answer

Reduced battery backup time

Question 4

Which of the following best describes the function of a DNS server?

Accepted Answer

Resolves domain names to IP addresses. A DNS (Domain Name System) server translates human-readable domain names (e.g., www.example.com) into machine-readable IP addresses (e.g., 192.0.2.1). This resolution process is fundamental to network communication, as applications rely on IP addresses to locate and connect to servers. Without DNS, users would need to memorize numeric IP addresses for every website or service.

Answer

Hosts web pages

Answer

Forwards traffic between networks

Answer

Assigns IP addresses to devices

Question 5

Which TWO of the following are benefits of virtualization in a data center?

Accepted Answer

Improved disaster recovery capabilities. Virtualization enables rapid restoration of virtual machines (VMs) from snapshots or backups, often within minutes, regardless of underlying hardware failures. This decoupling of the OS from physical hardware allows VMs to be migrated or recovered on different hosts, significantly improving recovery time objectives (RTOs) and recovery point objectives (RPOs) compared to physical server recovery.

Answer

Increased hardware reliability

Answer

Enhanced physical security

Answer

Simplified network configuration

Question 6

Match each network protocol to its well-known port number.

Accepted Answer

HTTP: 80. HTTP uses port 80 (A is correct). HTTPS uses port 443 (B is correct). FTP uses port 21 (C is correct). SSH uses port 22 (D is correct). SMTP uses port 25, not 53, so E is incorrect. DNS uses port 53, not 25, so F is incorrect.

Answer

SMTP: 53

Answer

DNS: 25

Question 7

A developer writes code in a high-level language and then uses a tool to translate the entire source code into machine code before execution. This process is known as:

Accepted Answer

Compilation. Compilation translates the entire source code into machine code (binary) before execution. Interpretation executes code line by line without prior translation into machine code. Debugging is the process of finding errors, and linking combines object files into an executable.

Answer

Interpretation

Answer

Debugging

Answer

Linking

Question 8

Which TWO of the following are common characteristics of object-oriented programming languages?

Accepted Answer

Inheritance. Inheritance is a core characteristic of object-oriented programming (OOP) that allows a class to derive properties and behaviors from a parent class, promoting code reuse and hierarchical relationships. This is a defining feature of OOP languages like Java, C++, and Python, distinguishing them from procedural or functional paradigms.

Answer

Procedural programming

Answer

Polymorphism

Answer

Functional programming

Question 9

A software application is experiencing performance degradation. The team suspects a memory leak. Which development practice should be used to identify the source of the leak?

Accepted Answer

Profiling. Profiling is the correct practice because it involves monitoring the application's runtime behavior, including memory allocation and garbage collection. A memory profiler can track object creation and retention, pinpointing which objects are not being released and causing the leak. This is the standard approach for diagnosing memory leaks in languages like Java or C#.

Answer

Unit testing

Answer

Debugging

Answer

Code review

Question 10

Which type of malware is designed to replicate itself and spread to other computers without needing to attach to a host file?

Accepted Answer

Worm. Worms are self-replicating and spread independently, unlike viruses which attach to files.

Answer

Trojan

Answer

Virus

Answer

Ransomware

Question 11

A database administrator needs to ensure that a transaction either completes fully or not at all. Which property of database transactions is this?

Accepted Answer

Atomicity. Atomicity ensures that a transaction is treated as a single, indivisible unit of work: either all of its operations are committed successfully, or none are applied. This is the 'all-or-nothing' property described in the ACID model. If any part of the transaction fails, the database management system (DBMS) rolls back the entire transaction, leaving the database unchanged.

Answer

Isolation

Answer

Consistency

Answer

Durability

Question 12

A company's IT policy requires that all employees use a specific word-processing application for creating official documents. An employee, who prefers a different application, uses that application to create a document and then saves it in the required application's native format. The employee gives the file to a coworker, who cannot open it. Which of the following is the MOST likely reason the coworker cannot open the file?

Accepted Answer

The file format is not fully compatible with the required application.. The employee saved the document in the required application's native format, but because it was originally created in a different application, the file may contain features, formatting, or metadata that are not fully supported by the required application. This can result in a file that appears to be in the correct format but is actually corrupted or unreadable when opened in the required application. Option B is correct because the core issue is format incompatibility, not the absence of the application itself.

Answer

The coworker does not have the required application installed.

Answer

The file has restrictive permissions set by the operating system.

Answer

The file is being blocked by antivirus software due to suspicious content.

Question 13

Which TWO of the following are characteristics of a client-server network?

Accepted Answer

Resources are shared from servers. In a client-server network, resources such as files, printers, and applications are hosted on dedicated servers and shared with client devices. This centralized resource sharing is a defining characteristic, as servers are designed to provide services to multiple clients, unlike peer-to-peer networks where each device shares its own resources directly.

Answer

No dedicated server required

Answer

All devices are equal

Answer

Typically used in small offices with few computers

Question 14

A database administrator needs to ensure that only authorized users can access sensitive data. Which of the following concepts describes this requirement?

Accepted Answer

Confidentiality. Confidentiality ensures that sensitive data is accessible only to authorized users, typically enforced through access controls, encryption, and authentication mechanisms. In database administration, this is implemented via permissions, roles, and encryption at rest (e.g., AES-256) to prevent unauthorized disclosure.

Answer

Availability

Answer

Non-repudiation

Answer

Integrity

Question 15

A technician is configuring a new computer for a graphic designer who needs to process large images. Which hardware component should be upgraded to improve performance?

Accepted Answer

RAM. Processing large images requires storing and rapidly accessing massive amounts of temporary data. RAM provides the workspace for active files; upgrading it allows the system to hold more image data in memory, reducing reliance on slower storage and preventing performance bottlenecks during editing.

Answer

CPU

Answer

Monitor

Answer

Hard drive