FC0-U71 Practice Exam 60 — 20 Questions

Question 1

Refer to the exhibit. What is the output of the SELECT statement?

Accepted Answer

Widget, 2. The SELECT statement uses COUNT(*) with GROUP BY Category and a HAVING clause that filters out groups with a count less than 2. The table has two rows with 'Widget' and one row with 'Gadget'. After grouping, the Widget group has a count of 2, and the Gadget group has a count of 1. The HAVING clause excludes the Gadget group because its count is less than 2. Therefore, the query returns only one row: Widget with count 2. Option A correctly displays 'Widget, 2'. Option B displays 'Gadget, 2' which is incorrect because the Gadget group is filtered out. Options C and D include extra rows that are not in the result.

Answer

Gadget, 2

Answer

Widget, 2; Gadget, 1

Answer

Widget, 2; Gadget, 1; Widget, 1

Question 2

A user reports that their computer is running slowly and the network activity light is constantly on. The technician runs the command shown in the exhibit. Based on the output, what is the most likely cause?

Accepted Answer

The computer is infected with malware communicating with a command-and-control server. The exhibit shows multiple established connections from the local computer to the same remote IP on port 443 (HTTPS). This pattern suggests a botnet or malware establishing multiple command-and-control channels. Option B is correct because it indicates a malware infection. Option A is wrong because a DoS attack would typically show many connections from different sources. Option C is wrong because excessive web browsing would show connections to various IPs, not just one. Option D is wrong because a firewall misconfiguration would block or allow traffic, not create multiple connections.

Answer

The computer is experiencing a denial-of-service (DoS) attack

Answer

The user is running excessive web browsing sessions

Answer

The firewall is misconfigured and blocking legitimate traffic

Question 3

Which THREE of the following are examples of Infrastructure as a Service (IaaS) offerings? (Select THREE.)

Accepted Answer

Object storage service. Object storage service is an IaaS offering because it provides raw storage resources over the internet, allowing users to store and retrieve data without managing the underlying hardware. In IaaS, the cloud provider handles the physical infrastructure, while the customer controls the storage configuration and access. This aligns with the IaaS model of offering fundamental computing resources like storage, compute, and networking.

Answer

Managed database service

Answer

Web-based email application

Question 4

Refer to the exhibit. What is the most likely cause of this installation error?

Accepted Answer

Lack of administrative privileges. The error message indicates that the installation cannot proceed because the user lacks the necessary permissions to write to protected system directories or registry keys. On Windows, installing software typically requires administrative privileges to modify the Program Files folder, system registry, and other protected resources. Without these privileges, the installer is blocked by User Account Control (UAC) or the operating system's security policies, resulting in this specific error.

Answer

Insufficient disk space

Answer

Corrupted DLL file

Answer

Missing system files

Question 5

A developer is debugging a program that produces incorrect output. The developer sets a breakpoint on a specific line of code and runs the program in a debugger. When execution stops at the breakpoint, the developer examines the values of variables at that point. What debugging technique is being used?

Accepted Answer

Step-through execution. Using breakpoints and inspecting variables is a common debugging technique to identify issues.

Answer

Logging

Answer

Unit testing

Answer

Code review

Question 6

A network technician is setting up a wireless network. To minimize interference from neighboring networks, which wireless frequency band is typically less congested?

Accepted Answer

5 GHz. The 5 GHz band is typically less congested than the 2.4 GHz band because it has more non-overlapping channels (23 vs. 3) and is used by fewer devices, including legacy Wi-Fi clients. This reduces co-channel interference from neighboring networks, making 5 GHz the preferred choice for minimizing interference in dense wireless environments.

Answer

900 MHz

Answer

2.4 GHz

Answer

60 GHz

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 user is trying to install a new application but receives an error that the system does not meet the minimum requirements. Which TWO hardware components should the user check first to ensure compatibility?

Accepted Answer

Available storage space. (Available storage space) is correct because applications require a minimum amount of free disk space to install and run. Option D (Amount of RAM) is correct because insufficient memory can prevent installation or cause poor performance. Option E (Monitor refresh rate) is irrelevant to application installation. Option B (CPU clock speed) is important but not as commonly checked as RAM and storage for typical applications; however, the question asks for TWO components, and storage and RAM are the most fundamental. Option C (Number of USB ports) is unrelated.

Answer

CPU clock speed

Answer

Number of USB ports

Answer

Monitor refresh rate

Question 9

Refer to the exhibit. A user on this computer can browse the internet but cannot ping another computer at 192.168.1.20. What is the most likely cause?

Accepted Answer

A firewall is blocking ICMP traffic. The user can browse the internet, which confirms that the default gateway, DNS resolution, and subnet mask are correctly configured. However, the ping command fails specifically to 192.168.1.20, a local address. This indicates that ICMP traffic (used by ping) is being blocked, most likely by a firewall on the target computer or an intermediate device, while other traffic (HTTP/HTTPS) is permitted.

Answer

The default gateway is incorrect

Answer

The DNS server is unreachable

Answer

The subnet mask is wrong

Question 10

A user reports that when they try to open a PDF file attached to an email, nothing happens. Which of the following is the most likely cause?

Accepted Answer

There is no software installed that can open PDF files.. If no software is installed that can handle PDF files, the operating system has no default handler to open the file. When a user clicks on a PDF attachment in an email client, the system attempts to launch the associated application (e.g., Adobe Acrobat Reader, a web browser with PDF support). If no such application is present, nothing happens—the file simply does not open, and no error message may appear depending on the email client's configuration.

Answer

The file permissions are set to read-only.

Answer

The antivirus software has quarantined the file.

Answer

The network connection is down.

Question 11

Refer to the exhibit. The query returns two rows. If the database had an index on the Department column only, how would the query execution be affected?

Accepted Answer

The query would run faster because the index reduces the number of rows to scan for Department.. An index on the Department column allows the database engine to quickly locate rows matching the Department condition without scanning the entire table. This reduces the number of rows that need to be evaluated for the Salary condition, speeding up the query. The index does not affect the result set—it only improves access path efficiency.

Answer

The query would return fewer rows because the index excludes the Salary condition.

Answer

The query would return more rows because the index includes both columns.

Answer

The query would fail because the index conflicts with the SELECT *.

Question 12

A user is trying to choose a web browser. Which TWO features are considered advantages of using a browser with built-in developer tools? (Select TWO).

Accepted Answer

Ability to test how a website displays on different screen sizes. Built-in developer tools, such as those in Chrome DevTools or Firefox Developer Tools, include a device emulation mode that allows developers to simulate various screen sizes and resolutions. This enables testing of responsive web design without needing physical devices, ensuring the website displays correctly across smartphones, tablets, and desktops.

Answer

Automatic synchronization of bookmarks across devices

Answer

Enhanced privacy through blocking of pop-ups and trackers

Answer

Improved page loading speed

Question 13

Which TWO of the following are valid SQL functions used to aggregate data?

Accepted Answer

COUNT. COUNT and SUM are both aggregate functions in SQL. COUNT returns the number of rows in a result set or the number of non-NULL values in a column, while SUM calculates the total sum of a numeric column. These functions operate on a set of rows and return a single summary value, which is the defining characteristic of aggregate functions in SQL.

Answer

SORT

Answer

LENGTH

Answer

APPEND

Question 14

A technician is troubleshooting a network slowdown. The technician suspects a loop in the network. Which of the following protocols would prevent such a loop?

Accepted Answer

STP. STP (Spanning Tree Protocol) is the correct answer because it is specifically designed to prevent network loops in Ethernet networks by dynamically blocking redundant paths. When a loop occurs, broadcast frames can circulate endlessly, causing a broadcast storm that degrades network performance. STP ensures a loop-free topology by placing some switch ports into a blocking state while maintaining redundant links for failover.

Answer

DNS

Answer

NAT

Answer

DHCP

Question 15

A developer is troubleshooting a program that produces unexpected results. The code includes a loop that repeats 10 times but the output shows only 9 values. Which debugging step should be taken first?

Accepted Answer

Check the loop condition and initial value. The loop produces 9 outputs instead of 10, indicating the loop body executes one fewer time than intended. The first debugging step should be to examine the loop condition and initial value, as this directly controls how many iterations occur. For example, if the loop initializes at 1 and runs while `i < 10`, it will iterate 9 times (1 through 9), not 10. Checking these values immediately identifies off-by-one errors without adding unnecessary complexity.

Answer

Add a print statement inside the loop

Answer

Reinstall the programming environment

Answer

Comment out all lines except the loop

Question 16

Which of the following BEST describes the primary function of an operating system?

Accepted Answer

Manage hardware resources. The primary function of an operating system is to manage hardware resources, including the CPU, memory, storage, and input/output devices, by abstracting them into a usable interface for applications. Without an OS, software cannot directly coordinate hardware access, as the OS handles scheduling, memory allocation, and device drivers. This resource management is fundamental to all other OS roles, such as file system management and process control.

Answer

Secure network traffic

Answer

Create documents

Answer

Provide internet access

Question 17

An office has a single shared printer connected via USB to a Windows 10 desktop. Other users in the office need to print to this printer from their own computers, which are connected to the same local network. What is the simplest way to share the printer without additional hardware?

Accepted Answer

Enable printer sharing on the desktop and connect from other computers using the network path. Windows 10 includes built-in printer sharing via the SMB protocol, which allows the printer connected via USB to be shared over the local network without any additional hardware. Enabling printer sharing on the desktop and connecting from other computers using the network path (e.g., \desktop-name\printer-name) is the simplest method that leverages existing network infrastructure.

Answer

Set up a print server using a Raspberry Pi

Answer

Install the printer on each computer by connecting it via USB when needed

Answer

Connect the printer directly to the network switch using an Ethernet cable

Question 18

A programmer needs to store a true/false value. Which data type is most appropriate?

Accepted Answer

Boolean. A Boolean data type is specifically designed to store true/false values, representing binary logic states. In most programming languages, including Python, Java, and C++, a Boolean variable can only hold one of two values: true or false, making it the most appropriate choice for this requirement.

Answer

Integer

Answer

String

Answer

Float

Question 19

A database administrator is designing a normalized database for an e-commerce site. Which TWO actions represent best practices for normalization?

Accepted Answer

Removing duplicate data from tables by creating separate tables for each entity. Normalization aims to reduce data redundancy and improve data integrity by removing duplicate data and organizing it into separate, related tables. By creating separate tables for each distinct entity (e.g., Customers, Orders, Products), you eliminate repeating groups and ensure each fact is stored only once, which is a core principle of database normalization.

Answer

Creating separate tables for each customer order without linking them

Answer

Storing all product details in a single column as a list

Answer

Storing calculated totals in the same table to avoid joins

Question 20

A small office needs a centralized storage solution that all employees can access over the network to share files. Which type of storage should they implement?

Accepted Answer

NAS. A NAS (Network Attached Storage) is a dedicated file-level storage device connected to a network, allowing multiple users to access and share files over standard protocols like SMB/CIFS (Windows) or NFS (Linux/Unix). This makes it the ideal centralized solution for a small office needing shared network file access without requiring a dedicated server.

Answer

JBOD

Answer

SAN

Answer

DAS