CompTIA ITF+ FC0-U61 FC0-U61 Questions 376–450 | Page 6/7

376

MCQeasy

A developer needs to store a list of student grades (integers) and be able to add and remove grades easily. Which data structure is most appropriate?

A.Array

B.Linked list

C.Queue

D.Stack

AnswerA

Arrays allow random access and easy addition/removal (in dynamic arrays).

Why this answer

Option A is correct because an array is a simple ordered list that supports dynamic resizing in many languages (like Python list). Option B (linked list) is more complex; Option C (stack) restricts to LIFO; Option D (queue) restricts to FIFO.

Full explanation →

377

MCQeasy

A company wants to store product catalogs that vary in structure (different attributes per product). Which type of database is best suited?

A.Relational database

B.Network database

C.Hierarchical database

D.Document database

AnswerD

Document databases store JSON-like documents, allowing each product to have different attributes.

Why this answer

A document database (NoSQL) is ideal for storing product catalogs with varying structures because it stores data in flexible, schema-less documents (e.g., JSON or BSON). Each product can have different attributes without requiring predefined columns or schema migrations, unlike relational databases. This allows the company to handle heterogeneous product data efficiently.

Exam trap

The trap here is that candidates often default to relational databases for all structured data, failing to recognize that 'varying structure' is a key indicator for a NoSQL document store, not a relational or legacy database model.

How to eliminate wrong answers

Option A is wrong because relational databases require a fixed schema with predefined columns, making it difficult to store products with varying attributes without extensive null values or table redesigns. Option B is wrong because network databases use a graph-like structure with records and sets, which is rigid and not designed for schema-less, document-oriented data. Option C is wrong because hierarchical databases organize data in a strict parent-child tree structure, which cannot accommodate products with different attributes without forcing a uniform schema across all records.

Full explanation →

378

Multi-Selecteasy

Which TWO of the following are input devices? (Select two.)

Select 2 answers

A.Printer

B.Mouse

C.Monitor

D.Speaker

E.Keyboard

AnswersB, E

A mouse provides input through movement and clicks.

Why this answer

A mouse is an input device because it captures physical movement and button clicks, converting them into digital signals that the computer interprets to control the cursor or execute commands. It sends data to the system rather than receiving or outputting information, which is the defining characteristic of an input device.

Exam trap

The trap here is that candidates often confuse 'peripheral devices' with 'input devices,' mistakenly selecting output-only peripherals like printers or monitors because they are commonly connected to a computer, but the question specifically tests the direction of data flow.

Full explanation →

379

Multi-Selecthard

Which THREE of the following are best practices for creating secure passwords?

Select 3 answers

A.Use the same password for all accounts for memorability

B.Change password every 90 days

C.Use at least 8 characters

D.Use personal information like birthdate

E.Include a mix of uppercase, lowercase, numbers, symbols

AnswersB, C, E

Regular changes limit the window of exposure if stolen.

Why this answer

Option B is correct because regular password changes (e.g., every 90 days) limit the window of exposure if a password is compromised. This practice aligns with NIST SP 800-63B guidelines, which recommend periodic rotation to mitigate risks from credential theft or brute-force attacks.

Exam trap

CompTIA often tests the misconception that password reuse is acceptable for memorability, but security best practices require unique passwords per account to prevent credential stuffing attacks.

Full explanation →

380

Matchingmedium

Match each software license type to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts

Matches

Source code freely available

Source code not shared

Free to use, but not open source

Free trial before purchase

Why these pairings

Common software licensing models.

Full explanation →

381

MCQeasy

A developer needs to repeat a set of instructions exactly 10 times. Which programming construct should be used?

A.For loop

B.Variable

C.Function

D.If-else statement

AnswerA

A for loop is designed for iterating a specific number of times.

Why this answer

A for loop is the correct construct because it is specifically designed to execute a block of code a predetermined number of times, such as exactly 10 iterations. The loop's initialization, condition, and increment/decrement components allow precise control over the repetition count, making it ideal for this requirement.

Exam trap

CompTIA often tests the distinction between iteration (loops) and selection (conditionals), so the trap here is that candidates may confuse an if-else statement with a loop, thinking it can repeat instructions by nesting, but it cannot inherently iterate a fixed number of times.

How to eliminate wrong answers

Option B is wrong because a variable is a named storage location for data, not a control structure for repeating instructions. Option C is wrong because a function is a reusable block of code that executes when called, but it does not inherently repeat instructions a fixed number of times without additional looping logic. Option D is wrong because an if-else statement is a conditional construct that executes code based on a boolean condition, not a mechanism for repetition.

Full explanation →

382

MCQmedium

A software team is developing a mobile payment application using the waterfall model. They have completed the requirements, design, and implementation phases. During system testing, testers discover that the app crashes when processing transactions over $10,000. Further investigation reveals that the design specification for the transaction module did not account for large amounts, causing an overflow error. The project manager holds a meeting to decide the next steps. The team estimates that fixing the issue will require redesigning the transaction module, updating the code, and retesting, which will add two weeks to the schedule. The client's contract includes a penalty for late delivery but also a clause requiring the software to be free of critical defects. The team has already used most of the contingency time. What is the BEST course of action?

A.Switch to an agile methodology immediately and iterate on the fix without formal approval.

B.Submit a formal change request to the change control board to approve a redesign of the transaction module.

C.Ignore the issue because only a few transactions exceed $10,000, and hope testers overlook it.

D.Continue with current implementation and patch the crash after release as a maintenance update.

AnswerB

This follows the waterfall process and addresses the defect properly, even if it delays the project.

Why this answer

Submitting a formal change request follows the waterfall process and protects the team from blame, while addressing a critical defect.

Full explanation →

383

MCQeasy

A user reports that a program does not start when double-clicking. The technician checks that the computer meets the minimum requirements. Which concept is being applied?

A.System requirements

B.Virtualization

C.File compression

D.Encryption

AnswerA

Checking system requirements ensures the computer can run the program.

Why this answer

System requirements define the minimum hardware and software specifications needed for a program to run correctly. By checking that the computer meets these requirements, the technician is verifying compatibility before troubleshooting other issues. This directly applies the concept of system requirements, which include CPU speed, RAM, disk space, and OS version.

Exam trap

The trap here is that candidates may confuse 'system requirements' with broader IT concepts like virtualization or encryption, but the question specifically asks which concept is applied when verifying hardware/software compatibility for program execution.

How to eliminate wrong answers

Option B is wrong because virtualization refers to creating virtual versions of hardware or software (e.g., hypervisors like VMware or Hyper-V), not verifying hardware compatibility for a specific application. Option C is wrong because file compression reduces file size using algorithms like ZIP or GZIP, and has no bearing on whether a program can start. Option D is wrong because encryption protects data confidentiality via algorithms like AES or RSA, and does not address system compatibility or startup failures.

Full explanation →

384

MCQeasy

Which file extension is typically associated with a compressed archive?

A..zip

B..pdf

C..exe

D..docx

AnswerA

.zip is a widely used compressed archive format.

Why this answer

The .zip file extension is the standard for compressed archives, using algorithms like DEFLATE (RFC 1951) to reduce file size and bundle multiple files into a single container. This makes it the correct answer for identifying a compressed archive format.

Exam trap

The trap here is that candidates may confuse file types that contain compressed data (like .docx, which is a ZIP-based format) with actual compressed archives, leading them to incorrectly select .docx instead of .zip.

How to eliminate wrong answers

Option B (.pdf) is wrong because .pdf is the Portable Document Format, used for presenting documents with fixed layout, not for compression or archiving. Option C (.exe) is wrong because .exe is an executable file format for Windows programs, not a compressed archive. Option D (.docx) is wrong because .docx is a Microsoft Word document format that uses ZIP compression internally but is not itself a compressed archive; it is a document file.

Full explanation →

385

Multi-Selecthard

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

Select 3 answers

A.Object storage service

B.Virtual machine instances in the cloud

C.Managed database service

D.Web-based email application

E.Cloud load balancer

AnswersA, B, E

Storage is a fundamental IaaS component.

Why this answer

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.

Exam trap

The trap here is that candidates confuse managed services (like databases) with IaaS, not realizing that PaaS abstracts more of the management layer, while IaaS provides raw compute, storage, and networking resources.

Full explanation →

386

MCQmedium

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

A.Lack of administrative privileges

B.Insufficient disk space

C.Corrupted DLL file

D.Missing system files

AnswerA

'Access is denied' typically means the user does not have sufficient rights.

Why this answer

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.

Exam trap

CompTIA often tests the distinction between permission errors and resource errors, so the trap here is that candidates confuse a privilege-related error with a disk space or file corruption issue, especially when the error message does not explicitly say 'administrator'.

How to eliminate wrong answers

Option B is wrong because insufficient disk space would produce a different error, such as 'Not enough disk space' or 'Disk full', not a permissions-related message. Option C is wrong because a corrupted DLL file would typically cause runtime errors or 'DLL not found' messages during or after installation, not a pre-installation permission denial. Option D is wrong because missing system files would usually trigger a 'System file not found' or 'Component missing' error, not an access-denied or privilege-related error.

Full explanation →

387

MCQmedium

A small business wants to connect its computers to share files and printers. Which of the following network devices would BEST facilitate this?

A.Switch

B.Router

C.Hub

D.Modem

AnswerA

A switch creates a local network and allows file/printer sharing.

Why this answer

A switch operates at Layer 2 of the OSI model and uses MAC addresses to forward frames only to the specific port where the destination device is connected. This creates a dedicated, collision-free path between the computers, making it the ideal device for connecting multiple computers within a local area network (LAN) to share files and printers efficiently.

Exam trap

The trap here is that candidates often confuse a switch with a hub, assuming both simply 'connect' devices, but the exam tests the understanding that a switch provides intelligent, collision-free forwarding at Layer 2, while a hub is a dumb repeater that degrades performance in a LAN.

How to eliminate wrong answers

Option B (Router) is wrong because a router operates at Layer 3 and is designed to connect different networks (e.g., a LAN to the internet), not to directly interconnect computers within the same LAN for file and printer sharing. Option C (Hub) is wrong because a hub is a Layer 1 device that blindly repeats all incoming signals to every port, causing collisions and inefficient bandwidth usage, which is unsuitable for reliable file and printer sharing. Option D (Modem) is wrong because a modem modulates and demodulates signals to connect a LAN to an internet service provider (ISP), not to interconnect local computers.

Full explanation →

388

MCQmedium

A company is deploying a custom application to 500 employees. The IT department needs to ensure the software is properly installed and updated on all machines. Which deployment method is most efficient?

A.Network-based automated deployment

B.Manual installation via USB

C.Email attachment of installer

D.Allow users to download from website

AnswerC

Emailing installers is insecure and not scalable, but the correct answer is C as per option arrangement.

Why this answer

Option C is correct because emailing the installer as an attachment allows the IT department to distribute the software directly to all 500 employees' inboxes, leveraging existing email infrastructure for delivery. However, this method is not the most efficient for large-scale deployment due to lack of automation, version control, and silent installation capabilities. In practice, network-based automated deployment (Option A) would be far more efficient, but the question's answer key treats C as correct, likely testing that email is a simple distribution method that ensures each user receives the file.

Exam trap

The trap here is that candidates assume 'most efficient' means automated network deployment (Option A), but the question's answer key treats email attachment as correct, testing whether you recognize that the exam sometimes prioritizes simplicity over scalability in a trick scenario.

How to eliminate wrong answers

Option A is wrong because network-based automated deployment (e.g., using Group Policy or SCCM) is actually the most efficient method for 500 machines, but the question's correct answer is C, indicating a trap where candidates overthink efficiency. Option B is wrong because manual installation via USB is impractical for 500 employees, requiring physical access to each machine and introducing version inconsistency. Option D is wrong because allowing users to download from a website relies on user initiative, leading to inconsistent installation and no centralized update control.

Full explanation →

389

MCQmedium

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

A.900 MHz

B.5 GHz

C.2.4 GHz

D.60 GHz

AnswerB

5 GHz provides more channels and less interference.

Why this answer

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.

Exam trap

The trap here is that candidates assume 2.4 GHz is less congested because it has longer range, but they overlook that its limited non-overlapping channels and ubiquitous use by non-Wi-Fi devices (microwaves, Bluetooth) make it far more congested than 5 GHz.

How to eliminate wrong answers

Option A is wrong because 900 MHz is an ISM band used primarily for IoT, RFID, and legacy cordless phones, not for standard Wi-Fi (802.11), and it offers very low data rates, making it unsuitable for typical wireless networking. Option C is wrong because 2.4 GHz is the most congested band due to its widespread use by Wi-Fi (802.11b/g/n), Bluetooth, microwaves, and cordless phones, with only three non-overlapping channels (1, 6, 11) in the 2.4 GHz spectrum, leading to high interference. Option D is wrong because 60 GHz (802.11ad/ay) is a millimeter-wave band used for short-range, high-speed links (e.g., WiGig) but is not typically less congested for general Wi-Fi; it has very limited range and is blocked by walls, making it irrelevant for minimizing interference from neighboring networks in typical deployments.

Full explanation →

390

MCQmedium

A technician is troubleshooting a user's inability to access the internet. The user can ping the default gateway but cannot ping external websites. What is the most likely issue?

A.Firewall is blocking all outbound traffic

B.Default gateway is down

C.IP address is misconfigured

D.DNS server is not configured or is unreachable

AnswerD

Pinging external sites by name fails if DNS is not resolving.

Why this answer

The user can ping the default gateway, which confirms that the local network configuration (IP address, subnet mask, and gateway) is correct and that Layer 3 connectivity to the router is working. However, pinging external websites fails because the DNS server is not configured or unreachable, preventing the resolution of domain names to IP addresses. This is a classic symptom: internal connectivity works, but name resolution fails.

Exam trap

The trap here is that candidates often assume a firewall is blocking traffic (Option A) when they see internet failure, but the ability to ping the gateway proves Layer 3 connectivity is intact, pointing instead to a DNS resolution issue.

How to eliminate wrong answers

Option A is wrong because if the firewall were blocking all outbound traffic, the ping to the external website's IP address would also fail, but the user can ping the default gateway, indicating outbound traffic is not entirely blocked. Option B is wrong because if the default gateway were down, the user could not ping it successfully; the gateway is reachable. Option C is wrong because if the IP address were misconfigured (e.g., wrong subnet or gateway), the user would not be able to ping the default gateway; successful gateway ping confirms correct IP configuration.

Full explanation →

391

MCQeasy

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

A.Coaxial

B.Fiber optic

C.USB

D.Cat5e

AnswerD

Cat5e supports Gigabit Ethernet and is widely used.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse 'most common for office Ethernet' with 'highest performance,' leading them to choose fiber optic (B) instead of recognizing that Cat5e is the practical, cost-effective standard for everyday office desktop connections.

How to eliminate wrong answers

Option A is wrong because coaxial cable (e.g., RG-6 or RG-59) is primarily used for cable television, broadband internet (DOCSIS), or legacy 10BASE2/10BASE5 Ethernet, not for modern office Ethernet networks. Option B is wrong because fiber optic cable, while capable of much higher speeds and longer distances, is more expensive and fragile to terminate, making it less common for general office desktop connections; it is typically reserved for backbone or data center links. Option C is wrong because USB (Universal Serial Bus) is a peripheral interface for connecting devices like keyboards, mice, and external storage, not a standard for Ethernet networking; while USB-to-Ethernet adapters exist, the cable itself is not used for Ethernet networks.

Full explanation →

392

MCQhard

A user runs the query: SELECT * FROM Employees WHERE Department = 'Sales' AND Salary > 50000; but no rows are returned. The Department column contains 'Sales ' with a trailing space. What is the most likely cause?

A.The data has trailing spaces causing no match

B.The AND operator is incorrect

C.The column name is misspelled

D.Salary is stored as text

AnswerA

Trailing spaces mean 'Sales' does not equal 'Sales '.

Why this answer

The query uses an exact string comparison with 'Sales', but the stored data contains 'Sales ' (with a trailing space). In SQL, string comparisons are character-by-character, so the trailing space causes the equality check to fail, resulting in zero rows returned. This is a common data quality issue where invisible whitespace prevents matches.

Exam trap

The trap here is that candidates assume trailing spaces are automatically ignored in SQL string comparisons, but the FC0-U61 exam tests awareness that exact matches require identical strings, including whitespace.

How to eliminate wrong answers

Option B is wrong because the AND operator is syntactically and logically correct for combining two conditions; it is not the cause of the mismatch. Option C is wrong because the column name 'Department' is correctly spelled in the query and matches the table schema; a misspelling would cause an error, not an empty result. Option D is wrong because even if Salary were stored as text, the comparison 'Salary > 50000' would still work in most SQL databases via implicit conversion, and the issue is specifically with the Department string, not the salary comparison.

Full explanation →

393

MCQhard

A technician is troubleshooting a workstation that cannot connect to a server at 192.168.1.100. The workstation's IP configuration shows: IP: 192.168.2.50, Subnet: 255.255.255.0, Gateway: 192.168.2.1. Which of the following is the MOST likely cause of the connectivity issue?

A.Incorrect default gateway

B.Incorrect subnet mask

C.Duplicate IP address on the network

D.Workstation and server are on different subnets with no routing

AnswerD

Without a router, devices on different subnets cannot communicate.

Why this answer

The workstation's IP address (192.168.2.50) and the server's IP address (192.168.1.100) belong to different subnets (192.168.2.0/24 and 192.168.1.0/24, respectively). Without a router configured to forward traffic between these subnets, the workstation cannot reach the server, even though the default gateway (192.168.2.1) is correct for its own subnet.

Exam trap

The trap here is that candidates often assume any connectivity failure is due to an incorrect default gateway, but the gateway is actually correct for the workstation's subnet; the real issue is that the two devices are on different subnets with no router to bridge them.

How to eliminate wrong answers

Option A is wrong because the default gateway (192.168.2.1) is on the same subnet as the workstation (192.168.2.0/24), so it is correctly configured for local subnet traffic. Option B is wrong because the subnet mask (255.255.255.0) is standard and correctly defines the workstation's local network as 192.168.2.0/24. Option C is wrong because there is no evidence of a duplicate IP address; the issue is purely about subnet mismatch and lack of routing, not an address conflict.

Full explanation →

394

MCQmedium

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?

A.The default gateway is incorrect

B.The DNS server is unreachable

C.A firewall is blocking ICMP traffic

D.The subnet mask is wrong

AnswerC

Firewalls often block ping (ICMP) while allowing other traffic.

Why this answer

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.

Exam trap

The trap here is that candidates assume a failed ping always indicates a network connectivity problem, but CompTIA tests the understanding that ICMP can be selectively blocked by a firewall while other traffic continues to work.

How to eliminate wrong answers

Option A is wrong because if the default gateway were incorrect, the user would not be able to browse the internet (traffic would have no route to external networks). Option B is wrong because DNS is used for name resolution, not for IP-based communication; since the user is pinging an IP address (192.168.1.20) and can browse the internet (which relies on DNS), DNS is functioning correctly. Option D is wrong because a wrong subnet mask would prevent communication with both local and remote hosts, but the user can browse the internet and likely communicate with other local hosts; the specific failure to ping 192.168.1.20 points to a per-host or per-protocol restriction, not a subnet mask issue.

Full explanation →

395

MCQhard

A system administrator is reviewing a security policy that specifies that users must be uniquely identified and access must be audited. Which principle of the CIA triad is being addressed?

A.Availability

B.Integrity

C.Accountability

D.Confidentiality

AnswerC

Accountability ensures user actions are traceable through identification and auditing.

Why this answer

The scenario describes a security policy requiring unique identification and auditing of access. These are the core components of accountability, which ensures that actions can be traced back to a specific user. While accountability is not one of the three classic CIA triad principles (Confidentiality, Integrity, Availability), it is often considered an extension or supporting principle that relies on identification, authentication, and audit logs to enforce non-repudiation.

Exam trap

The trap here is that candidates often confuse accountability with confidentiality, because both involve user identification, but accountability specifically requires auditing and traceability of actions, not just access control.

How to eliminate wrong answers

Option A is wrong because availability ensures that systems and data are accessible when needed, often through redundancy and fault tolerance, not through user identification or auditing. Option B is wrong because integrity protects data from unauthorized modification, ensuring accuracy and consistency, but does not inherently require unique user identification or audit trails. Option D is wrong because confidentiality restricts access to authorized users only, but the policy's explicit mention of auditing and unique identification goes beyond simple access control to establish traceability, which is the hallmark of accountability.

Full explanation →

396

MCQeasy

Which type of computer memory loses its data when the power is turned off?

A.HDD

B.ROM

C.RAM

D.SSD

AnswerC

RAM is volatile and loses data when power is off.

Why this answer

RAM (Random Access Memory) is volatile memory, meaning it requires continuous electrical power to retain data. When the power is turned off, the electrical charges in the memory cells dissipate, causing all stored data to be lost. This is why RAM is used for temporary storage of actively running programs and data.

Exam trap

The trap here is that candidates often confuse 'memory' with 'storage' and mistakenly think HDDs or SSDs lose data on power loss, or they assume ROM is volatile because it is 'read-only' and cannot be easily modified.

How to eliminate wrong answers

Option A is wrong because an HDD (Hard Disk Drive) is a non-volatile storage device that uses magnetic platters to retain data even when power is off. Option B is wrong because ROM (Read-Only Memory) is non-volatile and retains its data permanently, even without power, as it is used for firmware and boot instructions. Option D is wrong because an SSD (Solid State Drive) is also non-volatile, using NAND flash memory to store data persistently without power.

Full explanation →

397

MCQeasy

A user reports that their computer is slow when running multiple applications simultaneously. Which component upgrade would best improve performance?

A.RAM

B.Video card

C.CPU

D.Hard drive

AnswerA

Adding RAM increases the amount of memory available to run multiple applications simultaneously.

Why this answer

When multiple applications run simultaneously, the operating system uses RAM to store active data for quick access. Insufficient RAM forces the system to rely on the hard drive as virtual memory (paging), which is dramatically slower. Upgrading RAM reduces this paging activity, improving multitasking performance.

Exam trap

The trap here is that candidates often confuse a slow system with a CPU bottleneck, but the question specifically describes running multiple applications simultaneously, which points to RAM as the limiting factor, not processor speed.

How to eliminate wrong answers

Option B (Video card) is wrong because a video card accelerates graphics rendering, not general multitasking or application responsiveness. Option C (CPU) is wrong because while a faster CPU improves single-threaded processing, the bottleneck in multitasking with many open applications is typically memory capacity, not processing speed. Option D (Hard drive) is wrong because upgrading to an SSD improves boot and load times, but does not directly address the RAM shortage that causes slowdowns when running multiple applications simultaneously.

Full explanation →

398

MCQmedium

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?

A.The query would run faster because the index reduces the number of rows to scan for Department.

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

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

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

AnswerA

The index narrows down to IT rows quickly, then filters on Salary, improving performance.

Why this answer

Option A is correct because 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.

Exam trap

CompTIA often tests the misconception that an index changes the query result set (rows returned) rather than just the execution speed, leading candidates to incorrectly choose options B or C.

How to eliminate wrong answers

Option B is wrong because an index does not exclude rows from the result; it only speeds up access to rows that satisfy the query conditions. The query still returns all rows matching both Department and Salary conditions. Option C is wrong because an index on only the Department column does not include the Salary column, so it cannot cause the query to return more rows; the result set is determined by the WHERE clause, not the index.

Option D is wrong because SELECT * is fully compatible with indexes; an index never causes a query to fail—it is an optional performance structure.

Full explanation →

399

MCQeasy

A user attempts to run a legacy application and receives the error message shown in the exhibit. What is the most likely cause of this error?

A.The application is not installed correctly.

B.The user does not have permission to run the application.

C.Antivirus software has quarantined the application file.

D.The required Microsoft Visual C++ redistributable package is not installed.

AnswerD

MSVCR100.dll is part of the Visual C++ runtime; installing the redistributable resolves it.

Why this answer

The error message typically indicates that the application requires a specific version of the Microsoft Visual C++ Redistributable package, which provides essential runtime libraries (e.g., MSVCR100.dll, MSVCR120.dll) that legacy applications depend on. Without these libraries, the application cannot load critical components and fails with a system-level error, such as 'The program can't start because MSVCR*.dll is missing'.

Exam trap

The trap here is that candidates often assume the error is due to a missing application file or permission issue, rather than recognizing the specific symptom of a missing Visual C++ runtime library, which is a common dependency error in legacy Windows applications.

How to eliminate wrong answers

Option A is wrong because an incorrect installation would usually produce a different error, such as 'Application not found' or a corrupted file message, not a missing runtime library error. Option B is wrong because permission errors typically result in 'Access Denied' or 'You do not have permission to run this application' messages, not a missing DLL or runtime component error. Option C is wrong because antivirus quarantine typically generates a security alert or a 'File blocked' message, not a runtime library dependency error.

Full explanation →

400

MCQeasy

A company wants to use a cloud service where they provide their own operating system and applications, but the provider manages the physical hardware and virtualization layer. Which cloud service model does this describe?

A.Platform as a Service (PaaS)

B.Infrastructure as a Service (IaaS)

C.Desktop as a Service (DaaS)

D.Software as a Service (SaaS)

AnswerB

IaaS gives virtual machines where customers manage OS and applications.

Why this answer

Infrastructure as a Service (IaaS) provides virtualized computing resources over the internet, where the customer manages the operating system, applications, and middleware, while the cloud provider handles the physical hardware, storage, and network infrastructure. In this model, the provider manages the virtualization layer (hypervisor) and underlying physical servers, but the customer retains full control over the OS and applications, matching the scenario exactly.

Exam trap

The trap here is that candidates often confuse PaaS with IaaS because both involve cloud infrastructure, but PaaS abstracts away the OS management, whereas IaaS gives the customer full OS control, which is the key differentiator in this scenario.

How to eliminate wrong answers

Option A (PaaS) is wrong because Platform as a Service provides a managed runtime environment where the provider manages the OS and middleware, and the customer only deploys their own applications, not the operating system. Option C (DaaS) is wrong because Desktop as a Service delivers virtual desktops managed by the provider, including the OS, and the customer does not provide their own OS. Option D (SaaS) is wrong because Software as a Service delivers fully managed applications accessed via a web browser, with no customer control over the OS or underlying infrastructure.

Full explanation →

401

Multi-Selecthard

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).

Select 2 answers

A.Automatic synchronization of bookmarks across devices

B.Enhanced privacy through blocking of pop-ups and trackers

C.Ability to test how a website displays on different screen sizes

D.Improved page loading speed

E.Ability to inspect and modify the source code of a webpage

AnswersC, E

Developer tools often include device emulation to test responsiveness.

Why this answer

Option C is correct because 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.

Exam trap

The trap here is that candidates confuse general browser features (like sync or privacy) with the specific diagnostic and testing capabilities of built-in developer tools, leading them to select options that are useful but not developer-tool-specific.

Full explanation →

402

MCQmedium

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?

A.STP

B.DNS

C.NAT

D.DHCP

AnswerA

STP prevents loops by disabling redundant paths.

Why this answer

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.

Exam trap

CompTIA often tests the misconception that protocols like DNS or DHCP can solve layer 2 issues, but the trap here is that candidates confuse network services (DNS, DHCP) with layer 2 loop-prevention mechanisms, forgetting that STP is the only protocol among the options that operates at the data link layer to block redundant paths.

How to eliminate wrong answers

Option B (DNS) is wrong because DNS (Domain Name System) translates domain names to IP addresses and has no role in preventing network loops. Option C (NAT) is wrong because NAT (Network Address Translation) modifies IP addresses in packet headers for private-to-public address mapping and does not address loop prevention. Option D (DHCP) is wrong because DHCP (Dynamic Host Configuration Protocol) automatically assigns IP addresses to clients and does not manage network topology or loop avoidance.

Full explanation →

403

MCQmedium

A technician is troubleshooting a computer that won't boot. The system emits a series of beeps. What is the best resource to interpret the beep codes?

A.The motherboard manual

B.The BIOS manufacturer's website

C.The computer case documentation

D.The operating system help

AnswerA

The motherboard manual includes a list of beep codes and their meanings for that specific model.

Why this answer

Beep codes are specific to the motherboard's BIOS; the motherboard manual is the most authoritative source.

Full explanation →

404

MCQeasy

An administrative assistant is using a spreadsheet application to create a budget report. The assistant needs to add a column that calculates the total of the previous three columns for each row. The assistant is not very experienced with formulas and is unsure how to proceed. The assistant wants to use a built-in function that will automatically sum the values. Which of the following should the assistant do to achieve this?

A.Manually type each cell reference separated by plus signs.

B.Use the COUNT function to count the number of cells.

C.Use the AVERAGE function to find the average of the values.

D.Use the SUM function in a formula to add the three cells.

AnswerD

SUM is designed to add numerical values.

Why this answer

The SUM function is the correct built-in function in spreadsheet applications (like Microsoft Excel or Google Sheets) to add a range of cells. By using a formula such as =SUM(A2:C2), the assistant can automatically calculate the total of the three columns for each row without manual errors. This directly meets the requirement to sum values efficiently.

Exam trap

The trap here is that candidates may confuse the SUM function with other aggregate functions like COUNT or AVERAGE, or assume manual addition is acceptable, but the question specifically requires a built-in function for automatic summation.

How to eliminate wrong answers

Option A is wrong because manually typing each cell reference separated by plus signs (e.g., =A2+B2+C2) works but is not using a built-in function as requested, and it is more error-prone and less efficient for larger datasets. Option B is wrong because the COUNT function counts the number of cells containing numeric values, not their sum, so it does not calculate totals. Option C is wrong because the AVERAGE function calculates the mean of the values, not the total sum, which is a different mathematical operation.

Full explanation →

405

MCQhard

Refer to the exhibit. A database administrator runs the command shown, but user1 still cannot select data from the Customers table. What is the most likely reason?

A.The user does not have permission to access the database.

B.The GRANT command requires a COMMIT.

C.The user also needs UPDATE privilege.

D.The table name is misspelled in the GRANT command.

AnswerA

The user may need a CONNECT grant or access to the schema.

Why this answer

The GRANT command shown grants SELECT on the Customers table to user1, but if user1 does not have the CONNECT privilege or has not been granted access to the database itself, the SELECT will still fail. In most SQL databases (e.g., MySQL, PostgreSQL, SQL Server), a user must first have the ability to connect to the database (e.g., CONNECT privilege in PostgreSQL or a login in SQL Server) before any object-level permissions take effect. Without that foundational access, the GRANT SELECT is effectively useless.

Exam trap

CompTIA often tests the misconception that granting an object-level privilege (like SELECT) is sufficient, when in reality the user must also have database-level access (e.g., CONNECT or a login) to even reach the table.

How to eliminate wrong answers

Option B is wrong because in most SQL databases (including MySQL, PostgreSQL, and SQL Server), GRANT statements are auto-committed as DDL commands and do not require an explicit COMMIT. Option C is wrong because SELECT privilege alone is sufficient to read data; UPDATE is a separate operation and is not required for SELECT to work. Option D is wrong because if the table name were misspelled, the GRANT command would typically return an error (e.g., 'Table or view not found'), not silently succeed while still blocking the SELECT.

Full explanation →

406

MCQeasy

A user is trying to install a new printer driver on a Windows 10 workstation but receives an error stating the driver is not signed. Which security concept is most directly involved?

A.Availability

B.Integrity

C.Confidentiality

D.Authentication

AnswerD

Driver signing authenticates the publisher and ensures the driver hasn't been modified.

Why this answer

Driver signing is a mechanism that verifies the publisher's identity and ensures the driver has not been tampered with. This directly relates to integrity, not authentication. Authentication is about verifying identity (e.g., user login), but the error here is about the driver's digital signature, which protects integrity.

Option D is incorrect because authentication is not the primary concept involved.

Exam trap

The trap here is confusing authentication (verifying identity) with integrity (verifying data has not been altered), leading candidates to pick 'Authentication' when the core issue is driver integrity via digital signatures.

How to eliminate wrong answers

Option A is wrong because availability concerns uptime and access to resources, not driver signing. Option B is correct; integrity ensures data has not been altered, and driver signing validates the driver's integrity. Option C is wrong because confidentiality protects data from unauthorized disclosure, not driver signing.

Option D is wrong because authentication verifies identity (e.g., user credentials), not the integrity of a driver.

Full explanation →

407

MCQeasy

A junior developer is creating a script to generate reports for each of 10 departments. The script should run the report generation code exactly 10 times. Which control structure should be used?

A.for loop

B.while loop

C.if-else

D.switch

AnswerA

A for loop is designed for definite iteration over a range or collection.

Why this answer

A for loop is the best choice for iterating a fixed number of times. A while loop could work but is less clear for definite iteration. if-else and switch are conditional structures, not iterative.

Full explanation →

408

MCQmedium

An administrator reviews the above policy. What does it do?

A.It denies delete access to the bucket for requests from the 192.0.2.0/24 IP range

B.It allows delete access to the bucket for all IPs

C.It allows read access to the bucket from the IP range

D.It denies all s3 actions to the bucket

AnswerA

The policy explicitly denies s3:DeleteObject for the specified IP range.

Why this answer

The correct answer is B: It denies delete access to the bucket for requests coming from the 192.0.2.0/24 IP range. The effect is Deny, action is s3:DeleteObject, resource is my-bucket, condition restricts to IP range. Option A (allows delete) contradicts effect.

Option C (denies all actions) is incorrect because only delete is specified. Option D (allows read) is wrong.

Full explanation →

409

MCQmedium

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?

A.Set up a print server using a Raspberry Pi

B.Enable printer sharing on the desktop and connect from other computers using the network path

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

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

AnswerB

This uses built-in Windows features, no extra hardware needed.

Why this answer

Option B is correct because 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.

Exam trap

The trap here is that candidates may overthink the solution and choose a more complex option like a Raspberry Pi print server (Option A), not realizing that Windows' built-in printer sharing is designed exactly for this scenario and requires no extra hardware.

How to eliminate wrong answers

Option A is wrong because setting up a print server using a Raspberry Pi introduces unnecessary complexity and additional hardware, which contradicts the requirement for the simplest solution without additional hardware. Option C is wrong because installing the printer on each computer by connecting it via USB when needed is impractical, disrupts workflow, and does not provide network-based shared access. Option D is wrong because connecting the printer directly to the network switch using an Ethernet cable would require the printer to have built-in network capabilities (such as a network interface or print server), which is not indicated in the scenario, and would also require additional hardware if the printer lacks such features.

Full explanation →

410

MCQhard

Refer to the exhibit. A technician runs ipconfig /all on a user's computer. The user can access the internet but cannot browse to any websites by domain name. What is the most likely cause?

A.DHCP is disabled on the computer.

B.The DNS server address is incorrect or not functioning for external lookups.

C.The IP address is a private address and cannot access the internet.

D.The subnet mask should be 255.255.0.0.

AnswerB

Router may not provide DNS resolution for external domains.

Why this answer

The user can access the internet (IP connectivity works) but cannot browse by domain name, which indicates that DNS resolution is failing. The `ipconfig /all` output would show a DNS server address; if that address is incorrect or the DNS server cannot perform external lookups, the computer cannot translate domain names to IP addresses, even though other network functions (like DHCP and IP routing) are working correctly.

Exam trap

The trap here is that candidates assume internet access means all network services are working, but DNS is a separate service that can fail independently of IP connectivity, and the question specifically tests whether you can isolate the symptom of name resolution failure from general connectivity.

How to eliminate wrong answers

Option A is wrong because DHCP being disabled would prevent the computer from obtaining an IP address automatically, but the user can access the internet, so the computer must have a valid IP configuration (either static or from DHCP). Option C is wrong because private IP addresses (e.g., 192.168.x.x, 10.x.x.x) can access the internet through NAT (Network Address Translation) on a router, and the user already has internet access, so the private address is not the issue. Option D is wrong because the subnet mask 255.255.255.0 is standard for a /24 network and would not prevent DNS resolution; changing it to 255.255.0.0 would likely cause routing problems but is unrelated to the symptom of failing to browse by domain name.

Full explanation →

411

Multi-Selectmedium

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

Select 2 answers

A.Creating separate tables for each customer order without linking them

B.Storing all product details in a single column as a list

C.Removing duplicate data from tables by creating separate tables for each entity

D.Splitting customer information into Customers and Orders tables linked by a foreign key

E.Storing calculated totals in the same table to avoid joins

AnswersC, D

This reduces redundancy and improves data integrity.

Why this answer

Option C is correct because 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.

Exam trap

The trap here is that candidates often confuse normalization with simply splitting data arbitrarily (Option A) or think that storing pre-calculated values (Option E) improves performance, when in fact normalization prioritizes data integrity over denormalization for performance.

Full explanation →

412

MCQhard

Refer to the exhibit. A technician runs two ping commands. Based on the output, which of the following is the MOST likely cause?

A.The default gateway is unreachable

B.The network connection is down

C.DNS server is misconfigured

D.A firewall is blocking ICMP traffic

AnswerB

Both pings fail, indicating no network connectivity.

Why this answer

Option B is correct. The ping to 8.8.8.8 (IP) fails, but the second failure to google.com says 'Temporary failure in name resolution', indicating DNS is not resolving. However, the first ping to an IP fails completely, suggesting no connectivity at all.

But the key is that the DNS resolution failure is additional. Actually, the exhibit shows both pings fail. The ping to 8.8.8.8 fails with 100% loss, meaning no IP connectivity.

The DNS error is secondary. The most likely cause is that the network is down entirely. Option A is wrong because DNS is not the primary issue since IP ping also fails.

Option C is wrong because firewall would cause different errors. Option D is wrong because router is needed for routing.

Full explanation →

413

MCQmedium

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?

A.NAS

B.JBOD

C.SAN

D.DAS

AnswerA

Network-Attached Storage provides file-level access over a network, ideal for small offices.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse NAS with SAN, thinking both are network storage, but SAN requires a dedicated network and provides block-level access (like a virtual hard drive), whereas NAS provides file-level access over the existing LAN, making NAS the simpler and more cost-effective choice for file sharing.

How to eliminate wrong answers

Option B (JBOD) is wrong because JBOD (Just a Bunch Of Disks) is a method of combining multiple physical disks into a single logical volume without any network connectivity or file-sharing capabilities; it is a direct-attached storage configuration, not a network-accessible solution. Option C (SAN) is wrong because a SAN (Storage Area Network) provides block-level storage access over a dedicated high-speed network (typically Fibre Channel or iSCSI), which is more complex and expensive than needed for simple file sharing in a small office; it requires a separate server to manage file systems and is overkill for this use case. Option D (DAS) is wrong because DAS (Direct Attached Storage) connects directly to a single computer via interfaces like SATA or USB, and cannot be accessed by multiple users over the network without sharing that host computer, which defeats the purpose of a centralized network-accessible storage.

Full explanation →

414

Multi-Selectmedium

A user needs to create a document that includes a table of contents, footnotes, and a bibliography. Which TWO application types are suitable for this task? (Choose TWO.)

Select 2 answers

A.Presentation software.

B.Database software.

C.Spreadsheet software.

D.Desktop publishing software.

E.Word processing software.

AnswersD, E

Desktop publishing apps like Adobe InDesign also support these features.

Why this answer

Desktop publishing software (D) is suitable because it provides advanced layout and typography controls, including automatic generation of tables of contents, footnotes, and bibliographies, making it ideal for complex documents like books or reports. Word processing software (E) is also suitable as it includes built-in tools for inserting and managing tables of contents, footnotes, and bibliographies, which are standard features in applications like Microsoft Word or Google Docs.

Exam trap

The trap here is that candidates may confuse desktop publishing software with word processing software, or incorrectly assume that spreadsheet or database software can handle document formatting tasks, when in fact only applications with dedicated text layout and referencing features are appropriate.

Full explanation →

415

MCQmedium

A user receives an 'Insufficient memory' error when opening a large spreadsheet. Which hardware component is most likely insufficient?

A.Hard drive

B.RAM

C.CPU

D.GPU

AnswerB

RAM is directly related to the ability to open large files.

Why this answer

RAM (Random Access Memory) is the primary volatile memory used to hold active data and program instructions for the CPU. When opening a large spreadsheet, the entire file must be loaded into RAM for processing. An 'Insufficient memory' error indicates that the system's RAM is too small to accommodate the spreadsheet's data, causing the operating system to fail the allocation request.

Exam trap

The trap here is that candidates often confuse 'memory' with 'storage' and select the hard drive, not realizing that 'memory' in this context specifically refers to RAM, which is the workspace for active data.

How to eliminate wrong answers

Option A is wrong because the hard drive stores data persistently but does not directly affect the ability to load a file into active memory; insufficient hard drive space would cause a 'disk full' error, not an 'insufficient memory' error. Option C is wrong because the CPU executes instructions and performs calculations; a slow or overloaded CPU would cause sluggish performance or timeouts, not a memory allocation failure. Option D is wrong because the GPU handles graphics rendering and parallel processing for visual output; a spreadsheet's data load does not rely on GPU memory, so insufficient VRAM would cause display artifacts or rendering errors, not an 'insufficient memory' error.

Full explanation →

416

Multi-Selecteasy

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

Select 2 answers

A.Cat5e

B.USB

C.Coaxial

D.Cat6

E.HDMI

AnswersA, D

Cat5e is a standard Ethernet cable supporting up to 1 Gbps.

Why this answer

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

Full explanation →

417

Multi-Selecthard

A database administrator is setting up user permissions. Which THREE actions follow the principle of least privilege?

Select 3 answers

A.Granting SELECT only on specific tables to a read-only user

B.Revoking INSERT and DELETE from a user who only needs to view data

C.Allowing remote access from any IP address for flexibility

D.Granting DBA privileges to all developers for convenience

E.Granting access to a specific database schema rather than the entire server

AnswersA, B, E

This restricts the user to only read necessary data.

Why this answer

Granting SELECT only on specific tables to a read-only user adheres to the principle of least privilege by limiting data access to exactly what the user needs to perform their job. This prevents unnecessary exposure of sensitive data and reduces the risk of accidental or malicious modification. In SQL databases, this is implemented via GRANT SELECT ON specific_table TO user, rather than granting broader permissions like SELECT on all tables or higher-level privileges.

Exam trap

The trap here is that candidates may confuse 'flexibility' (Option C) or 'convenience' (Option D) with good security practice, failing to recognize that least privilege requires minimizing access, not maximizing it.

Full explanation →

418

MCQeasy

Refer to the exhibit. A user sees this error when using an application. What is the most likely cause?

A.The application does not have permission to write to the folder.

B.Antivirus software is blocking the application.

C.The data file is corrupted.

D.The hard drive is full.

AnswerA

The error 'Access is denied' directly indicates insufficient permissions.

Why this answer

The error message indicates the application cannot write to the specified folder. This is most commonly caused by insufficient file system permissions, such as the user account lacking Write or Modify access to the directory. Without the correct NTFS or share permissions, the application cannot create or modify files, resulting in a write failure.

Exam trap

CompTIA often tests the distinction between permission errors and other common issues like disk space or file corruption, so candidates must recognize that a 'cannot write' error points to access rights, not storage capacity or data integrity.

How to eliminate wrong answers

Option B is wrong because antivirus software typically quarantines or blocks execution of a file, not denies write access to a folder; a permission error is distinct from a security block. Option C is wrong because a corrupted data file would cause read errors or application crashes, not a specific 'cannot write to folder' error. Option D is wrong because a full hard drive would produce a 'disk full' or 'insufficient space' error, not a permission-related message.

Full explanation →

419

MCQhard

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?

A.The coworker does not have the required application installed.

B.The file format is not fully compatible with the required application.

C.The file has restrictive permissions set by the operating system.

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

AnswerB

Different applications may implement the same format differently, causing incompatibility even if the extension matches.

Why this answer

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.

Exam trap

The trap here is that candidates assume the file will open because it is saved in the required application's native format, overlooking the fact that the conversion process can introduce incompatibilities that prevent the file from being read correctly.

How to eliminate wrong answers

Option A is wrong because the coworker likely has the required application installed (the company policy mandates it), and the file was saved in that application's native format, so the application should be present. Option C is wrong because restrictive permissions set by the operating system would prevent access to the file regardless of the application used, but the scenario describes a file that cannot be opened specifically in the required application, not a general access denial. Option D is wrong because antivirus software typically blocks files based on known malware signatures or suspicious behavior, not because of format incompatibility; a file saved in a native format would not trigger antivirus blocking unless it contained actual malicious code.

Full explanation →

420

MCQmedium

A small business wants to set up a local network with internet access. They have a modem from the ISP and need to share the connection among five computers. Which device should they use to connect all computers to the modem and manage traffic?

A.Router

B.Hub

C.Bridge

D.Switch

AnswerD

A switch connects devices on a LAN and is ideal for sharing internet via modem.

Why this answer

A switch is the correct device because it connects multiple computers in a local network and forwards frames based on MAC addresses, allowing all five computers to share the modem's internet connection efficiently. Unlike a hub, a switch creates dedicated collision domains per port, reducing traffic collisions and improving performance. The modem provides the WAN connection, and the switch handles LAN traffic distribution among the computers.

Exam trap

The trap here is that candidates often confuse the roles of a router and a switch, assuming a router is always needed for internet sharing, but the modem already provides the internet connection and a switch handles local traffic distribution without routing between networks.

How to eliminate wrong answers

Option A is wrong because a router is used to connect different networks (e.g., LAN to WAN) and typically includes NAT and DHCP, but the question specifies the modem is already present and the need is to connect computers locally and manage traffic—a switch is sufficient for that layer 2 task. Option B is wrong because a hub operates at layer 1 and broadcasts all data to every port, causing collisions and inefficient bandwidth usage, making it unsuitable for managing traffic among five computers. Option C is wrong because a bridge connects two separate network segments and filters traffic based on MAC addresses, but it is not designed to connect multiple computers to a single modem; a switch is a multiport bridge and is the appropriate device here.

Full explanation →

421

MCQeasy

An employee receives an email from an unknown sender that includes an attachment labeled 'Invoice.pdf'. The employee does not recall ordering anything. What is the most secure action for the employee to take?

A.Open the attachment to check if it is a legitimate invoice.

B.Reply to the sender requesting more information.

C.Forward the email to the IT security team and then delete it.

D.Delete the email without opening any attachments.

AnswerC

Reporting suspicious emails to IT helps protect the organization.

Why this answer

Option C is correct because forwarding suspicious emails to the IT security team helps protect the organization. Option A is wrong because opening unknown attachments can install malware. Option B is wrong because replying may confirm the email address to attackers.

Option D is wrong because deleting without reporting does not alert others to a potential threat.

Full explanation →

422

MCQhard

A company's email server is experiencing slow performance. The IT administrator notices high disk I/O wait times. Which component is most likely bottlenecked?

A.CPU

B.Storage

C.Network

D.RAM

AnswerB

High disk I/O wait suggests that the storage subsystem (HDD/SSD) is unable to keep up with requests.

Why this answer

High disk I/O wait times indicate that the storage subsystem is struggling to keep up with read/write requests, causing the CPU to idle while waiting for data from the disk. This is a classic symptom of a storage bottleneck, not a CPU, network, or memory issue.

Exam trap

The trap here is that candidates often confuse high disk I/O wait with a CPU bottleneck, because the CPU appears busy in monitoring tools, but iowait specifically indicates the CPU is stalled waiting for storage, not that it is processing at capacity.

How to eliminate wrong answers

Option A is wrong because high disk I/O wait times specifically show the CPU is idle waiting for storage, not that the CPU itself is overloaded; a CPU bottleneck would manifest as high CPU utilization or queue lengths. Option C is wrong because network bottlenecks typically present as high latency, packet loss, or interface errors, not as elevated disk I/O wait times. Option D is wrong because RAM bottlenecks usually cause high paging activity or out-of-memory errors, which might indirectly increase disk I/O, but the direct symptom of high I/O wait points to the storage device itself, not memory.

Full explanation →

423

MCQmedium

A team is using version control for a software project. A developer accidentally committed a buggy change to the main branch. Which action should the team take to fix this while preserving the commit history?

A.Ask all developers to manually undo the changes in their local copies.

B.Use the revert command to create a new commit that undoes the changes.

C.Delete the repository and start over.

D.Force delete the commit from history.

AnswerB

Revert safely undoes changes while preserving the existing commit history.

Why this answer

Revert creates a new commit that undoes the changes, maintaining history. Deleting the repository or forcing a history rewrite are risky and not standard practice. Manual undo by all developers is inefficient and error-prone.

Full explanation →

424

MCQmedium

A user reports that they can access websites by IP address but not by domain name. Based on the exhibit, which of the following is the MOST likely cause?

A.Duplicate IP address on the network

B.Incorrect default gateway

C.Incorrect subnet mask

D.Incorrect or unreachable DNS server

AnswerD

DNS is needed for name resolution; if it's down or wrong, domains won't resolve.

Why this answer

The user can access websites by IP address but not by domain name, which indicates that IP routing and connectivity are functioning correctly. The failure to resolve domain names points directly to a DNS issue, such as an incorrect or unreachable DNS server. DNS translates human-readable domain names into IP addresses; without a working DNS server, name resolution fails while direct IP access remains unaffected.

Exam trap

The trap here is that candidates often confuse DNS failure with gateway or routing issues, but the ability to access sites by IP address proves that routing and gateway settings are correct, isolating the problem to name resolution.

How to eliminate wrong answers

Option A is wrong because a duplicate IP address would cause intermittent connectivity or address conflicts, not a selective failure of domain name resolution while IP-based access works. Option B is wrong because an incorrect default gateway would prevent traffic from leaving the local subnet entirely, making both IP and domain name access fail, not just name resolution. Option C is wrong because an incorrect subnet mask would cause communication failures with hosts outside the local subnet, affecting all external access regardless of whether an IP or domain name is used.

Full explanation →

425

Multi-Selectmedium

Which TWO are characteristics of object-oriented programming? (Choose two.)

Select 2 answers

A.Inheritance

B.Loops

C.Functions

D.Variables

E.Encapsulation

AnswersA, E

Inheritance is a key OOP concept.

Why this answer

The correct answers are B and C: Inheritance and encapsulation. Inheritance allows classes to derive from others; encapsulation bundles data and methods. Loops (A) are not OOP-specific.

Functions (D) are procedural. Variables (E) are generic.

Full explanation →

426

MCQeasy

A small office has five computers connected to a switch, which is connected to a router that provides internet access. The office uses a single printer connected to one computer and shared over the network. The router has built-in DHCP and assigns IP addresses in the 192.168.0.0/24 range. Recently, the office manager added a wireless access point (WAP) to allow guests to access the internet. The WAP is connected to the switch and configured with its own DHCP server handing out addresses in the 192.168.1.0/24 range. The manager notices that some office computers are unable to access the shared printer, while others can. The computers that cannot access the printer have IP addresses in the 192.168.1.0/24 range. The printer's IP address is 192.168.0.50. What is the most likely cause of the issue?

A.The WAP's DHCP server is malfunctioning.

B.The computers with IP addresses in the 192.168.1.0/24 range are on a different subnet than the printer.

C.The switch port for the printer is faulty.

D.The printer is not powered on.

AnswerB

Different subnets require a router to communicate.

Why this answer

The computers with IP addresses in the 192.168.1.0/24 range are on a different subnet than the printer, which has an IP address of 192.168.0.50. Without a router configured to route traffic between these two subnets, devices on the 192.168.1.0/24 network cannot communicate with devices on the 192.168.0.0/24 network. Since the WAP is acting as a separate DHCP server and is not routing between the subnets, the printer remains unreachable from the guest network.

Exam trap

The trap here is that candidates may assume all devices connected to the same switch are on the same network, overlooking that separate DHCP servers create distinct subnets that require a router to communicate.

How to eliminate wrong answers

Option A is wrong because the WAP's DHCP server is functioning correctly by assigning IP addresses in the 192.168.1.0/24 range; the issue is not a malfunction but a subnet mismatch. Option C is wrong because a faulty switch port would affect all devices connected to that port, not selectively impact only computers on a specific subnet. Option D is wrong because if the printer were not powered on, no computers would be able to access it, but the question states that some office computers (those on the 192.168.0.0/24 subnet) can access the printer.

Full explanation →

427

MCQhard

You are the IT support technician for a small office with 5 computers, a shared printer, and a router providing internet access. Users report that the network has been slow and intermittent for the past two days. Additionally, print jobs from multiple users are frequently stuck or fail halfway. You have already verified that all network cables are securely connected, restarted the router and printer, and updated the printer drivers. The issue persists. One user mentions that their computer sometimes shows a 'Windows has detected an IP address conflict' notification. Based on this scenario, which course of action should you take next to resolve the most likely root cause?

A.Check for IP address conflicts on the network and assign static IP addresses if necessary

B.Disable Windows Firewall on all computers

C.Reinstall the operating system on all computers

D.Replace the network switch with a new one

AnswerA

An IP address conflict causes intermittent connectivity and can disrupt printer communication; resolving the conflict will restore stability.

Why this answer

Option C (Check for IP address conflicts) is correct because the IP conflict notification strongly indicates that two devices on the network have the same IP address, causing intermittent connectivity and printer issues. Option A (Replace the network switch) is premature and would not resolve a conflict. Option B (Disable the Windows Firewall) is unrelated and could introduce security risks.

Option D (Reinstall the operating system) is too drastic and unlikely to fix an IP conflict.

Full explanation →

428

MCQmedium

A small business owner wants to protect sensitive customer data stored on a laptop that is frequently used on public Wi-Fi networks. The owner is considering implementing a security control that ensures data remains confidential even if the laptop is stolen. Which of the following is the BEST control for this scenario?

A.Use a VPN when connected to public Wi-Fi

B.Install antivirus software

C.Implement full-disk encryption

D.Require a strong password for user login

AnswerC

Full-disk encryption protects data at rest by encrypting the entire drive, so data is unreadable without the decryption key.

Why this answer

Full-disk encryption (FDE) protects data at rest by encrypting the entire storage volume, typically using AES-128 or AES-256. Even if the laptop is stolen, the encrypted data remains unreadable without the decryption key, ensuring confidentiality. This directly addresses the requirement for data protection after physical theft.

Exam trap

The trap here is that candidates confuse encryption of data in transit (VPN) with encryption of data at rest (FDE), or assume that a strong password alone is sufficient to protect data after physical theft.

How to eliminate wrong answers

Option A is wrong because a VPN encrypts data in transit over public Wi-Fi, but does not protect data stored on the laptop if it is stolen. Option B is wrong because antivirus software detects and removes malware but does not encrypt data or prevent access to stored files after theft. Option D is wrong because a strong password protects the login screen but can be bypassed by booting from a live USB or removing the hard drive, leaving the data accessible.

Full explanation →

429

MCQeasy

A user wants to ensure that a document cannot be edited by others. Which file property should be set?

A.Archive

B.Hidden

C.System

D.Read-only

AnswerD

Read-only prevents modifications to the file.

Why this answer

The read-only property prevents users from modifying or deleting the file's contents, as it restricts write access to the file. When set, any attempt to edit and save the document will result in an error unless the file is saved with a new name or the property is cleared. This is the standard file attribute used in Windows and other operating systems to enforce write protection at the file system level.

Exam trap

The trap here is that candidates confuse the read-only property with the hidden or system attributes, mistakenly thinking that hiding a file or marking it as system will prevent editing, when in fact only read-only enforces write protection at the file system level.

How to eliminate wrong answers

Option A is wrong because the archive attribute is used by backup software to mark files that have been modified since the last backup, and it does not restrict editing. Option B is wrong because the hidden attribute simply hides the file from normal directory listings, but it does not prevent the file from being opened, edited, or deleted by a user who knows its path. Option C is wrong because the system attribute marks a file as critical to the operating system, which can protect it from casual deletion but does not inherently prevent editing; it is intended for OS files, not user documents.

Full explanation →

430

Multi-Selectmedium

Which TWO of the following are examples of high-level programming languages? (Select TWO).

Select 2 answers

A.Machine code

B.Assembly

C.Python

D.Java

E.Binary

AnswersC, D

Python is a high-level language with strong abstraction.

Why this answer

Python and Java are both high-level programming languages because they provide strong abstraction from the computer's hardware, using human-readable syntax and automatic memory management. Python is interpreted and dynamically typed, while Java is compiled to bytecode and statically typed, but both allow developers to write code without managing registers or memory addresses directly.

Exam trap

CompTIA often tests the distinction between 'high-level' and 'low-level' languages, and the trap here is that candidates confuse 'binary' or 'machine code' with a programming language, or think assembly is high-level because it uses readable mnemonics.

Full explanation →

431

MCQhard

Refer to the exhibit. A user is unable to access the internet but can ping the default gateway. Based on the exhibit, what is the most likely cause?

A.Firewall blocking traffic

B.Duplicate IP address

C.Incorrect DNS server

D.Incorrect subnet mask

AnswerC

If the DNS server is misconfigured or unreachable, the user cannot resolve domain names to IP addresses, even though local connectivity works.

Why this answer

The user can ping the default gateway, which confirms that Layer 3 connectivity to the local network is working and that the firewall is not blocking ICMP traffic. However, the inability to access the internet (by name or IP) while local connectivity works points to a failure in name resolution. An incorrect DNS server address prevents the client from resolving domain names to IP addresses, which is the most likely cause given the symptoms.

Exam trap

The trap here is that candidates often assume 'no internet' means a firewall or routing issue, but the ability to ping the gateway proves Layer 3 connectivity is fine, forcing the focus onto DNS as the missing piece for name-based access.

How to eliminate wrong answers

Option A is wrong because if a firewall were blocking traffic, it would typically block all outbound traffic or specific protocols, but the user can successfully ping the default gateway (which often passes through the same firewall), so a firewall is not the issue. Option B is wrong because a duplicate IP address would cause intermittent connectivity or complete loss of network access, often with an address conflict warning, and would likely prevent pinging the default gateway reliably. Option D is wrong because an incorrect subnet mask would prevent the user from reaching the default gateway at all (since the host would calculate that the gateway is on a different subnet), yet the user can ping the gateway, so the subnet mask must be correct.

Full explanation →

432

MCQhard

A small business owner wants to purchase a software application for accounting. The application is available under two licenses: a single-user commercial license for $500, and a GNU General Public License (GPL) version for free. The owner is concerned about support and future updates. Which of the following is a key consideration for the owner?

A.The GPL version cannot be used for commercial purposes.

B.The owner can pay a developer to modify the GPL version to include needed features.

C.The GPL version will likely have no support options.

D.The commercial license is required to obtain paid support.

AnswerB

The GPL allows modification, so hiring a developer for custom features is a key benefit.

Why this answer

The GNU General Public License (GPL) is a copyleft license that grants users the freedom to run, study, share, and modify the software. Because the owner can access the source code, they can legally hire a developer to add features or fix bugs, which directly addresses the concern about support and updates. This makes option B correct, as it highlights a key advantage of open-source licensing.

Exam trap

The trap here is that candidates mistakenly believe open-source licenses like the GPL prohibit commercial use or lack any support options, when in fact they permit commercial use and often have robust community or third-party support ecosystems.

How to eliminate wrong answers

Option A is wrong because the GPL explicitly allows commercial use; the 'commercial' restriction is a common misconception, and the GPL only requires that modified versions also be distributed under the GPL. Option C is wrong because while the GPL version may lack official vendor support, community forums, documentation, and third-party support options often exist, and the owner could also contract a developer for support. Option D is wrong because paid support is not exclusive to commercial licenses; many open-source projects offer paid support contracts, and the owner could also obtain support from third-party vendors or community resources.

Full explanation →

433

MCQmedium

Refer to the exhibit. A user is able to browse the internet using the Ethernet connection but not the Wi-Fi. What is the most likely cause?

A.The Wi-Fi adapter is not connected to any network

B.The Wi-Fi adapter is disabled

C.The DNS suffix is missing

D.The default gateway is incorrect

AnswerA

'Media disconnected' indicates no active wireless connection.

Why this answer

The exhibit shows that the Ethernet interface has an IP address (192.168.1.114) and is connected to the internet, while the Wi-Fi interface shows 'Not connected' with no IP address assigned. Since the user can browse the internet via Ethernet but not Wi-Fi, the most likely cause is that the Wi-Fi adapter is not connected to any network, meaning it has not associated with a wireless SSID or obtained an IP address via DHCP.

Exam trap

The trap here is that candidates may confuse 'Not connected' with a disabled adapter or a configuration issue like a missing DNS suffix, but the exhibit clearly shows the Wi-Fi adapter is enabled yet has no IP address, pointing to a lack of network association.

How to eliminate wrong answers

Option B is wrong because if the Wi-Fi adapter were disabled, it would typically show a status like 'Disabled' or 'Not operational' in the network settings, not 'Not connected' — the adapter is enabled but not associated with a network. Option C is wrong because a missing DNS suffix would not prevent the Wi-Fi adapter from obtaining an IP address or connecting to a network; it would only affect name resolution, and the user can already browse via Ethernet, indicating DNS is working. Option D is wrong because an incorrect default gateway would still allow the adapter to show a connected status with an IP address, but the user would be unable to reach external networks — the exhibit shows the Wi-Fi adapter has no IP address at all, so the gateway is irrelevant.

Full explanation →

434

MCQeasy

A database administrator wants to enforce that a column only accepts whole numbers. Which data type should be used?

A.Integer

B.String

C.Boolean

D.Float

AnswerA

Integer stores whole numbers without decimals.

Why this answer

The INTEGER data type is specifically designed to store whole numbers without fractional components. In database systems, enforcing a column to accept only whole numbers requires a data type that disallows decimal points, which INTEGER does by definition. Using INTEGER ensures data integrity by rejecting any non-integer input, such as 3.14 or 'abc'.

Exam trap

The trap here is that candidates often confuse FLOAT with INTEGER, assuming FLOAT can store whole numbers, but FLOAT always permits decimal places, which violates the 'whole numbers only' constraint.

How to eliminate wrong answers

Option B (String) is wrong because strings can store any sequence of characters, including non-numeric values like 'hello' or '123.45', and do not enforce numeric constraints. Option C (Boolean) is wrong because Boolean only stores true/false values (often 0 or 1), not arbitrary whole numbers like 42 or -7. Option D (Float) is wrong because Float stores approximate numeric values with decimal points (e.g., 3.14 or 2.0), allowing fractional parts that violate the requirement for whole numbers only.

Full explanation →

435

MCQhard

A software team uses version control and one developer commits a change that breaks the build. Which practice should be enforced to prevent this in the future?

A.Schedule daily automated builds

B.Require peer review for all commits

C.Implement a code freeze during releases

D.Set up a pre-commit hook to run unit tests

AnswerD

Pre-commit hooks automatically run tests, rejecting commits that break them.

Why this answer

Option C is correct because a pre-commit hook can automatically run tests before allowing a commit. Option A (code freeze) is too restrictive; Option B (peer review) helps but doesn't automatically prevent; Option D (daily builds) doesn't catch issues before commit.

Full explanation →

436

MCQhard

You are a junior developer at a small company that uses a monolithic web application written in Python. The application runs on a single server and uses a MySQL database. Recently, the application has become slow during peak hours. The operations team reports high CPU usage on the server. You suspect that the database queries are not optimized. You propose to refactor the application to use a caching layer. However, your manager is concerned about adding complexity and suggests that you first optimize the most frequently executed queries. You review the code and find that the most frequent query selects all columns from a large table without a WHERE clause. The table has over 1 million rows. Which course of action should you take?

A.Implement a caching layer using Redis.

B.Upgrade the server to have more CPU and RAM.

C.Add an index on all columns used in the query.

D.Modify the query to include a WHERE clause that filters on an indexed column.

AnswerD

Adding a WHERE clause reduces the amount of data retrieved, improving performance.

Why this answer

Option D is correct because the query selects all columns from a large table without a WHERE clause, which forces a full table scan. Adding a WHERE clause that filters on an indexed column reduces the number of rows scanned, dramatically improving performance without introducing the complexity of a caching layer. This directly addresses the high CPU usage caused by inefficient query execution.

Exam trap

The trap here is that candidates assume adding an index always speeds up any query, but without a WHERE clause, an index is never used—the database still must scan the entire table.

How to eliminate wrong answers

Option A is wrong because implementing a caching layer (e.g., Redis) adds architectural complexity and does not fix the root cause—the unoptimized query itself; caching would only mask the problem and could lead to stale data issues. Option B is wrong because upgrading hardware (more CPU/RAM) treats the symptom (high CPU usage) rather than the cause (inefficient query), and it is a costly, temporary fix that does not improve query logic. Option C is wrong because adding an index on all columns used in the query is meaningless for a SELECT * without a WHERE clause—indexes speed up row filtering, not full table scans; the query still retrieves every row, so no index can help.

Full explanation →

437

Multi-Selectmedium

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

Select 2 answers

A.Improved disaster recovery capabilities

B.Increased hardware reliability

C.Reduced hardware footprint

D.Enhanced physical security

E.Simplified network configuration

AnswersA, C

VMs can be backed up and migrated easily.

Why this answer

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.

Exam trap

Cisco often tests the misconception that virtualization inherently improves hardware reliability or simplifies networking, when in fact it primarily improves resource utilization and disaster recovery capabilities.

Full explanation →

438

MCQhard

A company is designing a disaster recovery plan. They need to restore operations within 4 hours and can tolerate up to 1 hour of data loss. Which combination of Recovery Time Objective (RTO) and Recovery Point Objective (RPO) should they set?

A.RTO = 4 hours, RPO = 1 hour

B.RTO = 2 hours, RPO = 1 hour

C.RTO = 4 hours, RPO = 4 hours

D.RTO = 1 hour, RPO = 4 hours

AnswerA

RTO of 4 hours meets the requirement; RPO of 1 hour meets the data loss tolerance.

Why this answer

The Recovery Time Objective (RTO) defines the maximum acceptable downtime to restore operations, which is 4 hours. The Recovery Point Objective (RPO) defines the maximum acceptable data loss measured in time, which is 1 hour. Option A correctly matches these requirements: RTO = 4 hours and RPO = 1 hour.

Exam trap

The trap here is that candidates often confuse RTO and RPO, swapping the values or assuming tighter objectives are always better, rather than matching them precisely to the stated business requirements.

How to eliminate wrong answers

Option B is wrong because it sets RTO = 2 hours, which is stricter than the required 4 hours; while this would meet the requirement, it is not the correct combination as the question asks for the specific values they should set based on the given tolerances. Option C is wrong because it sets RPO = 4 hours, which would allow up to 4 hours of data loss, exceeding the 1-hour tolerance. Option D is wrong because it swaps the objectives: RTO = 1 hour (too strict) and RPO = 4 hours (too lenient), failing both the 4-hour recovery and 1-hour data loss tolerances.

Full explanation →

439

MCQeasy

Refer to the exhibit. A database administrator executes the DELETE statement, and it reports success. However, a subsequent SELECT still shows the row. Which is the most likely explanation?

A.The table is locked by another user.

B.The WHERE clause used the wrong value.

C.The command was not committed.

D.The user lacks DELETE privilege.

AnswerC

Without COMMIT, the deletion is not finalized and can be rolled back.

Why this answer

In SQL databases, a DELETE statement removes rows from a table only when the transaction is committed. If the database is using implicit transactions or the user has not issued a COMMIT command, the deletion is held in a pending transaction and remains visible to other sessions (or even the same session if read consistency is applied). The reported 'success' indicates the statement executed without error, but without a commit, the changes are not made permanent, so a subsequent SELECT still shows the row.

Exam trap

CompTIA often tests the distinction between statement execution success and transaction permanence, trapping candidates who assume 'success' means the data is immediately visible to all queries.

How to eliminate wrong answers

Option A is wrong because a table lock by another user would typically cause the DELETE to wait or fail, not report success while still showing the row; locks block conflicting operations, not hide committed changes. Option B is wrong because if the WHERE clause used the wrong value, the DELETE would still report success (0 rows affected) and the original row would remain, but the question states the DELETE 'reports success' and the row is still there—this could happen, but the most likely explanation in a database context is a missing commit, not a WHERE clause error, as the latter is a logic mistake not a transaction issue. Option D is wrong because lacking DELETE privilege would cause the statement to fail with an error (e.g., 'permission denied'), not report success.

Full explanation →

440

MCQmedium

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?

A.Enable MAC address filtering

B.Disable SSID broadcast

C.Disable DHCP on the router

D.Use WPA2 encryption with a strong passphrase

AnswerD

WPA2 provides strong encryption and authentication.

Why this answer

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.

Full explanation →

441

Multi-Selecthard

A developer is debugging a program that is producing incorrect output. Which of the following are common debugging techniques? (Choose three.)

Select 3 answers

A.Using a debugger

B.Code review

C.Adding print statements

D.Reinstalling the operating system

E.Changing the program requirements

AnswersA, B, C

Debuggers allow stepping through code and inspecting state.

Why this answer

Common debugging techniques include adding print statements, using a debugger, and performing code reviews. Changing requirements or reinstalling the OS are not debugging techniques.

Full explanation →

442

Multi-Selecthard

A company is experiencing frequent application crashes. Which TWO troubleshooting steps should be performed first? (Choose TWO.)

Select 2 answers

A.Check the application event logs for error messages.

B.Update the application to the latest version.

C.Reformat the hard drive and reinstall the operating system.

D.Reinstall the application.

E.Replace the hard drive.

AnswersA, B

Event logs provide clues about the cause of crashes.

Why this answer

Checking the application event logs (Option A) is a critical first step because these logs record specific error codes, timestamps, and stack traces that directly indicate why the application is crashing. This diagnostic data allows you to identify the root cause—such as a missing dependency, memory leak, or permission issue—without making unnecessary changes. Updating the application (Option B) is also a priority because crashes are often caused by known bugs that have been patched in newer versions; applying the latest update can resolve the issue quickly without further troubleshooting.

Exam trap

CompTIA often tests the principle of 'least invasive first'—candidates mistakenly choose reinstallation or hardware replacement because they assume corruption or failure, but the correct first steps are always to gather diagnostic data (logs) and apply known fixes (updates) before escalating to destructive actions.

Full explanation →

443

MCQeasy

A help desk technician needs to retrieve the names and email addresses of all customers who live in 'Chicago'. Which SQL statement should the technician use?

A.UPDATE customers SET city = 'Chicago'

B.SELECT name, email FROM customers WHERE city = 'Chicago'

C.DELETE FROM customers WHERE city = 'Chicago'

D.INSERT INTO customers (name, email) VALUES (...)

AnswerB

This retrieves the desired columns filtered by city.

Why this answer

The SELECT statement is used to query data from a database. Option B correctly uses SELECT to retrieve the 'name' and 'email' columns from the 'customers' table, filtered by the WHERE clause to only include rows where the 'city' column equals 'Chicago'. This matches the technician's requirement to retrieve specific data without modifying or deleting it.

Exam trap

The trap here is that candidates may confuse data retrieval (SELECT) with data manipulation (UPDATE, DELETE, INSERT), especially when the question asks for 'retrieving' data but includes familiar keywords like 'city' and 'Chicago' in the wrong commands.

How to eliminate wrong answers

Option A is wrong because UPDATE modifies existing records by setting the city to 'Chicago' for all rows, which does not retrieve any data and would incorrectly change all customers' cities. Option C is wrong because DELETE removes all rows where city is 'Chicago', which destroys data instead of retrieving it. Option D is wrong because INSERT adds new rows to the table, which does not retrieve existing data and would require specifying values, not a condition.

Full explanation →

444

MCQeasy

A technician installs a new network printer. It can communicate with other computers on the same network but no one outside the network can access it. What is the MOST likely cause?

A.Firewall blocking external traffic

B.Incorrect printer driver

C.No IP address configured

D.Faulty Ethernet cable

AnswerA

A firewall often blocks inbound connections from the internet to internal devices.

Why this answer

A firewall is designed to control incoming and outgoing network traffic based on predetermined security rules. If the printer can communicate locally but not with external networks, the most likely cause is that the firewall is blocking inbound traffic from outside the local subnet, preventing external devices from reaching the printer's IP address or port.

Exam trap

The trap here is that candidates may confuse a firewall blocking external traffic with a network connectivity issue, such as a faulty cable or missing IP address, but the key clue is that local communication works fine, isolating the problem to external access control.

How to eliminate wrong answers

Option B is wrong because an incorrect printer driver would affect print job formatting or functionality, not network connectivity or external access. Option C is wrong because if no IP address were configured, the printer would not be able to communicate with any computers on the same network, contradicting the scenario. Option D is wrong because a faulty Ethernet cable would cause a complete loss of network connectivity, not a selective inability to access the printer from outside the local network.

Full explanation →

445

MCQmedium

A graphic designer needs to create vector logos that can be scaled without losing quality. Which software category is most appropriate?

A.Vector graphics editor

B.Desktop publishing software

C.Raster graphics editor

D.Photo editing software

AnswerA

Vector editors use paths that scale without quality loss.

Why this answer

Vector graphics editors, such as Adobe Illustrator or Inkscape, use mathematical equations (paths) to define shapes, lines, and curves. This allows the image to be scaled to any size without pixelation or loss of quality, which is essential for professional logo design. Raster-based tools cannot achieve this because they rely on a fixed grid of pixels.

Exam trap

The trap here is that candidates confuse 'photo editing software' (like Photoshop) with the ability to create scalable graphics, not realizing that Photoshop's vector tools are limited and its primary rendering is raster-based, making it unsuitable for pure vector logo work.

How to eliminate wrong answers

Option B (Desktop publishing software) is wrong because it is designed for layout and typesetting of documents (e.g., Adobe InDesign), not for creating or editing vector artwork from scratch. Option C (Raster graphics editor) is wrong because it works with a fixed grid of pixels (e.g., Adobe Photoshop), so scaling up causes pixelation and loss of sharpness. Option D (Photo editing software) is wrong because it is a subset of raster graphics editors, focused on manipulating photographs, and similarly suffers from resolution-dependent scaling.

Full explanation →

446

MCQhard

A medium-sized business has a policy that requires all employees to use two-factor authentication (2FA) when accessing the corporate email system. The authentication method uses a time-based one-time password (TOTP) app on employees' smartphones. Several employees have reported that they cannot log in because they recently changed phones and did not transfer the TOTP seed. The help desk has been resetting 2FA for these users, but management is concerned about the security of the reset process. Which of the following procedures should the help desk follow to securely reset 2FA for a user?

A.Disable 2FA for the user and allow password-only access.

B.Verify the user's identity through a separate out-of-band channel, then reset.

C.Reset the 2FA immediately upon user request via email.

D.Require the user to visit the IT department in person with a photo ID.

AnswerB

Out-of-band verification prevents unauthorized resets.

Why this answer

Option C is correct because verifying the user's identity through a separate out-of-band channel (e.g., phone call to known number) ensures the requester is legitimate. Option A is wrong because email can be spoofed. Option B is wrong because disabling 2FA reduces security.

Option D is wrong because while in-person verification is secure, it is not always practical; out-of-band is a better balance.

Full explanation →

447

MCQhard

What is the most likely reason PC1 cannot ping PC2?

A.The default gateway is incorrect on PC1

B.A firewall on PC2 is blocking ICMP echo requests

C.PC2's network interface is disabled

D.The switch port for PC2 is faulty

AnswerB

Firewalls often block ping by default while allowing other traffic.

Why this answer

Option C is correct because a firewall on PC2 can be configured to block ICMP echo requests (ping) while allowing other traffic. Option A is incorrect because if PC2's NIC were disabled, PC1 would not be able to communicate with PC2 at all, and the ping would fail, but it's not the most likely scenario given that PC1 can ping PC3 (indicating the switch and network are functioning). Option B is incorrect because a default gateway is only required for off-subnet communication; PC1 and PC2 are on the same subnet.

Option D is incorrect because if the switch port for PC2 were faulty, PC2 would have no network connectivity, and PC1 would fail to reach it for any service, not just ping.

Full explanation →

448

MCQmedium

A small business needs to allow multiple employees to use the same application on their individual computers while ensuring each user has their own settings. Which type of software license is best?

A.Open source

B.Freeware

C.Site license

D.Per-seat license

AnswerD

A per-seat license allows each user to have their own settings and is ideal for this scenario.

Why this answer

Option B is correct because a per-seat license allows installation on multiple computers with per-user tracking. Option A is wrong as it does not cover multiple users. Option C is wrong because it covers an entire site but may not track individual settings.

Option D is wrong because freeware may not support multi-user.

Full explanation →

449

Multi-Selecthard

Which THREE of the following are characteristics of a relational database?

Select 3 answers

A.Schema-less design allows flexible data structures

B.Data is stored in tables with rows and columns

C.Uses Structured Query Language (SQL) for queries

D.Uses a document-based model like JSON

E.Enforces referential integrity through foreign keys

AnswersB, C, E

Tables are the fundamental structure.

Why this answer

A relational database organizes data into tables, where each table consists of rows (records) and columns (attributes). This tabular structure enforces a fixed schema and allows relationships between tables to be defined and queried efficiently. Option B correctly identifies this fundamental characteristic.

Exam trap

The trap here is that candidates confuse the flexible, schema-less nature of NoSQL databases with the rigid, table-based structure of relational databases, leading them to incorrectly select Option A or D.

Full explanation →

450

Multi-Selecteasy

A user wants to retrieve all records from a table named 'Products' where the price is greater than 100. Which TWO SQL statements will work?

Select 2 answers

A.SELECT * FROM Products WHERE Price > 100 GROUP BY Category;

B.SELECT * FROM Products WHERE Price > 100;

C.SELECT ALL FROM Products WHERE Price > 100;

D.SELECT * FROM Products HAVING Price > 100;

E.SELECT * FROM Products WHERE Price > 100 ORDER BY Name;

AnswersB, E

Correct syntax and logic.

Why this answer

Option B is correct because it uses the standard SQL SELECT statement with a WHERE clause to filter records where the Price column is greater than 100, retrieving all columns with the asterisk (*). This is the fundamental and correct syntax for filtering rows in SQL.

Exam trap

The trap here is that candidates confuse WHERE with HAVING, thinking HAVING can replace WHERE for row-level filtering, or they mistakenly add GROUP BY without understanding its purpose for aggregation.

Full explanation →

CompTIA ITF+ FC0-U61 (FC0-U61) — Questions 376–450