CompTIA ITF+ FC0-U61 FC0-U61 Questions 151–225 | Page 3/7

151

Multi-Selecteasy

Which TWO of the following are examples of cloud computing service models?

Select 2 answers

A.PaaS

B.IaaS

C.LAN

D.SAR

E.WAN

AnswersA, B

PaaS provides a platform for developing and deploying applications.

Why this answer

PaaS (Platform as a Service) is a cloud computing service model that provides a platform allowing customers to develop, run, and manage applications without the complexity of building and maintaining the underlying infrastructure. It includes operating systems, middleware, development tools, and database management, making it a core cloud service model alongside IaaS and SaaS.

Exam trap

The trap here is that candidates may confuse network types (LAN, WAN) or unfamiliar acronyms (SAR) with cloud service models, especially since the exam often includes plausible-sounding but incorrect options to test recognition of the standard NIST-defined models.

Full explanation →

152

MCQeasy

Which software license allows a user to install the software on multiple computers for personal use?

A.Trial version

B.Enterprise license

C.Open source license

D.Personal license

AnswerD

Personal licenses are designed for individual use on multiple devices.

Why this answer

A personal license grants a single user the right to install the software on multiple devices they own or control, typically for non-commercial use. This is distinct from a per-seat license, which limits installation to one computer per license key. The key differentiator is that the license is tied to the user, not the machine count.

Exam trap

The trap here is confusing a 'personal license' with a 'single-user, single-device' model, leading candidates to incorrectly choose an enterprise license for multi-computer use, when in fact enterprise licenses are for organizational scale, not personal multi-device rights.

How to eliminate wrong answers

Option A is wrong because a trial version is time-limited or feature-restricted and does not grant permanent multi-install rights; it is intended for evaluation only. Option B is wrong because an enterprise license is a volume licensing agreement for organizations, allowing deployment across many corporate devices, not for an individual's personal use. Option C is wrong because an open source license (e.g., GPL, MIT) grants rights to use, modify, and distribute the source code, but it does not specifically define a personal multi-computer installation allowance; the focus is on software freedom, not user-centric device limits.

Full explanation →

153

MCQeasy

Refer to the exhibit. A user executes: SELECT AVG(Salary) FROM Employees; What is the result?

A.55000

B.50000

C.165000

D.60000

AnswerA

The average is (50000+60000+55000)/3 = 55000.

Why this answer

The AVG function calculates the arithmetic mean of the Salary column across all rows in the Employees table. Given the salaries 50000, 60000, and 55000, the average is (50000 + 60000 + 55000) / 3 = 55000. Therefore, option A is correct.

Exam trap

The trap here is that candidates often confuse AVG with SUM or MIN/MAX, leading them to pick the sum (165000) or an extreme value (50000 or 60000) instead of correctly computing the mean.

How to eliminate wrong answers

Option B (50000) is wrong because it represents the minimum salary, not the average. Option C (165000) is wrong because it is the sum of all salaries (50000 + 60000 + 55000), not the average. Option D (60000) is wrong because it represents the maximum salary, not the average.

Full explanation →

154

MCQmedium

A database must be restored to the exact state at 11:00 AM. The last full backup was at 10:00 PM previous day, and transaction log backups were taken every hour. What is the minimum to restore?

A.Full backup plus all transaction log backups from after full backup

B.Transaction log backup only

C.Full backup only

D.Full backup plus differential backup

AnswerA

Enables restoration to any point in time.

Why this answer

To restore a database to a specific point in time (11:00 AM) when only full and transaction log backups exist, you must restore the most recent full backup (from 10:00 PM previous day) and then apply all subsequent transaction log backups in sequence. Transaction log backups contain all committed transactions up to the time of the backup, so applying them in order after the full backup brings the database to the exact state at the time of the last log backup (which would be 11:00 AM if the hourly log backup was taken at that time). Option A is correct because it includes the full backup and all transaction log backups taken after it, which is the minimum required for point-in-time recovery.

Exam trap

The trap here is that candidates often think a differential backup can achieve point-in-time recovery, but differentials only capture changes up to a point, not the granular transaction-level detail needed to restore to an exact time like 11:00 AM.

How to eliminate wrong answers

Option B is wrong because a transaction log backup alone cannot restore a database without a prior full backup to provide the base data structure and pages. Option C is wrong because a full backup alone only restores the database to the state at the time of that backup (10:00 PM previous day), not to the later point-in-time of 11:00 AM. Option D is wrong because a differential backup captures changes since the last full backup but does not provide point-in-time granularity to a specific hour; transaction log backups are required for that precision.

Full explanation →

155

MCQeasy

A company needs to store customer orders, where each order can contain multiple items. Which database design is most appropriate?

A.Three tables: Orders, Customers, and Items, with no direct link.

B.Two tables: Orders and OrderItems, linked by an OrderID foreign key.

C.A single table storing all data in a JSON column.

D.A single table with columns for order details and repeated item information.

AnswerB

This normalized design efficiently handles one-to-many relationships.

Why this answer

Option B is correct because it uses a normalized relational design with two tables: Orders (holding order-level data) and OrderItems (holding individual item details per order). The OrderID foreign key in OrderItems creates a one-to-many relationship, allowing each order to contain multiple items without data redundancy or update anomalies. This design ensures referential integrity and efficient querying, which is the standard approach for transactional order systems.

Exam trap

The trap here is that candidates often choose Option D (single table with repeated columns) because it seems simpler, but they overlook the violation of first normal form and the practical limitations of fixed-width schemas for variable-length data.

How to eliminate wrong answers

Option A is wrong because three tables with no direct link fail to establish any relationship between orders, customers, and items, making it impossible to associate a customer with their orders or items with specific orders. Option C is wrong because storing all data in a single JSON column violates first normal form (1NF), prevents efficient indexing and querying of individual fields, and makes it difficult to enforce data integrity or perform relational operations like joins. Option D is wrong because a single table with repeated item information (e.g., multiple columns for item1, item2) violates atomicity and leads to a fixed maximum number of items per order, causing data redundancy and update anomalies when item details change.

Full explanation →

156

Multi-Selectmedium

A user wants to share a large video file with colleagues. Which THREE methods are appropriate? (Choose THREE.)

Select 3 answers

A.Upload to a cloud storage service and share a link.

B.Copy the file to a USB drive and mail it.

C.Attach the file to an email.

D.Use a file transfer protocol (FTP) service.

E.Place the file on a network share and provide access.

AnswersA, D, E

Cloud storage like OneDrive or Google Drive allows large file sharing via links.

Why this answer

Uploading a large video file to a cloud storage service (e.g., Google Drive, OneDrive, Dropbox) and sharing a link is appropriate because cloud storage is designed to handle large files without size limits imposed by email servers. The recipient can download the file at their convenience, and the link can be set with permissions to control access. This method avoids bandwidth and attachment size restrictions common in email systems.

Exam trap

The trap here is that candidates often assume email can handle any file size because they have attached files before, but the FC0-U61 exam specifically tests knowledge of email attachment size limits (typically 10–25 MB) and that large files require alternative methods like cloud storage, FTP, or network shares.

Full explanation →

157

Multi-Selectmedium

Which TWO are characteristics of a network switch? (Select exactly two.)

Select 2 answers

A.Operates at Layer 2 of the OSI model

B.Forwards data based on MAC addresses

C.Operates at Layer 3

D.Connects different networks

E.Forwards data based on IP addresses

AnswersA, B

Switches work at the Data Link layer.

Why this answer

A network switch operates at Layer 2 (Data Link Layer) of the OSI model, where it uses MAC addresses to make forwarding decisions. Unlike hubs, switches learn and store MAC addresses in a Content Addressable Memory (CAM) table, allowing them to forward frames only to the specific port associated with the destination MAC address, which reduces collision domains and improves network efficiency.

Exam trap

The trap here is that candidates often confuse a switch's ability to perform some Layer 3 functions (like in a multilayer switch) with the standard definition of a switch, leading them to incorrectly select Layer 3 options when the question explicitly asks for characteristics of a 'network switch' in the context of the CompTIA FC0-U61 exam.

Full explanation →

158

MCQmedium

A database designer is creating a table to store employee information. To ensure that each employee can be uniquely identified, which constraint should be applied?

A.UNIQUE

B.FOREIGN KEY

C.PRIMARY KEY

D.NOT NULL

AnswerC

A primary key uniquely identifies each row and cannot contain NULL.

Why this answer

A PRIMARY KEY constraint uniquely identifies each record in a database table. It enforces both uniqueness and non-nullability, ensuring that no two employees can have the same primary key value and that the value is never NULL. This makes it the correct choice for guaranteeing each employee can be uniquely identified.

Exam trap

The trap here is that candidates often confuse UNIQUE with PRIMARY KEY, not realizing that UNIQUE allows a NULL value (which cannot serve as a guaranteed identifier) and that PRIMARY KEY inherently includes both uniqueness and non-nullability.

How to eliminate wrong answers

Option A is wrong because a UNIQUE constraint ensures all values in a column are distinct but allows a single NULL value, which would break the requirement for a guaranteed unique identifier for every employee. Option B is wrong because a FOREIGN KEY constraint enforces referential integrity between two tables and does not provide unique identification within the table itself. Option D is wrong because a NOT NULL constraint only prevents NULL values in a column but does not enforce uniqueness, so duplicate employee identifiers would still be allowed.

Full explanation →

159

MCQmedium

A database administrator adds an index on the 'Email' column of a 'Users' table. What is a likely consequence?

A.Reduced storage space

B.Improved query performance for all queries

C.Slower update operations on the table

D.Faster inserts on the table

AnswerC

Index maintenance adds overhead to INSERT/UPDATE/DELETE.

Why this answer

Adding an index on the 'Email' column improves the speed of SELECT queries that filter or sort by that column, but it introduces overhead on write operations. Every time a row is inserted, updated, or deleted, the database must also update the index structure (e.g., a B-tree). This additional work makes UPDATE operations slower, which is why option C is correct.

Exam trap

The trap here is that candidates assume indexes universally speed up all database operations, ignoring the write-performance penalty that occurs because the index must be maintained on every INSERT, UPDATE, and DELETE.

How to eliminate wrong answers

Option A is wrong because an index consumes additional storage space, not less; it stores a separate data structure (e.g., a B-tree) that maps index keys to row locations. Option B is wrong because an index only improves query performance for queries that use the indexed column in WHERE, JOIN, or ORDER BY clauses; queries that do not reference the 'Email' column or that perform full-table scans may see no benefit or even degraded performance. Option D is wrong because inserts become slower, not faster, due to the need to maintain the index by inserting a new entry into the index structure for each new row.

Full explanation →

160

MCQhard

A query uses a LEFT JOIN between Customers and Orders. The result set includes customers with no orders. What does the Orders columns show for those customers?

A.NULL

B.The same as the customer ID

C.Zero

D.Empty string

AnswerA

LEFT JOIN produces NULL when no match.

Why this answer

In a LEFT JOIN, all rows from the left table (Customers) are retained, and for rows with no matching rows in the right table (Orders), the columns from the right table are filled with NULL. This is the standard SQL behavior defined by the SQL standard (ISO/IEC 9075). Therefore, for customers with no orders, the Orders columns show NULL, not zero, an empty string, or any other default value.

Exam trap

The trap here is that candidates often confuse NULL with zero or an empty string, thinking a missing record should show a default value like 0 or '', but SQL strictly uses NULL to represent the absence of a matching row in a LEFT JOIN.

How to eliminate wrong answers

Option B is wrong because the Orders columns do not replicate the customer ID; they show NULL to indicate the absence of a matching order. Option C is wrong because zero is a numeric value that would imply an order exists with a zero value, not the absence of an order; SQL uses NULL for missing data. Option D is wrong because an empty string is a valid string value that would indicate an order with an empty field, not the lack of an order; NULL is the correct indicator for no matching row.

Full explanation →

161

MCQeasy

A user is creating a report that includes several photographs. After saving, the file size is larger than expected. Which data type is primarily responsible?

A.Audio

B.Text

C.Images

D.Video

AnswerC

Images, especially photographs, contain large amounts of pixel data that increase file size.

Why this answer

Images, especially high-resolution photographs, contain a large amount of pixel data (e.g., 24-bit color depth per pixel) and are typically stored in uncompressed or losslessly compressed formats like BMP or PNG, resulting in significantly larger file sizes compared to text. The question explicitly mentions 'several photographs,' making images the primary data type responsible for the unexpectedly large file size.

Exam trap

The trap here is that candidates may confuse 'file size' with 'data type complexity' and incorrectly select 'Video' because they assume video is always the largest, but the scenario specifically limits the content to photographs, making images the direct and correct answer.

How to eliminate wrong answers

Option A is wrong because audio files, while potentially large, are not mentioned in the scenario—the report includes photographs, not audio clips. Option B is wrong because text data is extremely compact (typically 1 byte per character in ASCII or 2 bytes in UTF-16), so even large amounts of text would not cause the file size to be 'larger than expected' in the context of photographs. Option D is wrong because video data is composed of many frames and is typically much larger than a few still images, but the scenario only includes photographs, not video footage.

Full explanation →

162

MCQeasy

A small business uses a single Linux server to host a custom inventory management application written in Python. The application reads from a CSV file on the server to display current stock levels. Recently, users have reported that the inventory numbers are incorrect and sometimes the application crashes with a 'Permission denied' error when trying to save updates. The server has two user accounts: 'admin' (with sudo privileges) and 'app_user' (a standard user under which the application runs). The CSV file is located at /var/data/inventory.csv and currently has permissions -rw-rw---- and owner root:root. The application code uses the open() function to read and write the file. Which of the following actions should be taken to resolve the issue?

A.Modify the application to run as 'admin' using sudo.

B.Set the file permissions to 644 so all users can read the file.

C.Change the file owner to 'app_user' and set permissions to 755.

D.Change the group ownership to a group that includes 'app_user' and ensure the file has group write permission.

AnswerD

This grants the application write access while maintaining security.

Why this answer

The application runs as 'app_user', which needs to write to /var/data/inventory.csv. The file is owned by root:root with permissions -rw-rw----, meaning only root and the root group can write. Changing the group ownership to a group that includes 'app_user' and granting group write permission (e.g., chown root:app_group /var/data/inventory.csv; chmod 664 /var/data/inventory.csv) allows the application to write without elevating privileges or exposing the file to all users.

Exam trap

The trap here is that candidates often assume changing file permissions to 644 (read for all) or changing the owner to the application user is sufficient, overlooking that the application needs write access and that group-based permissions provide a secure, least-privilege solution.

How to eliminate wrong answers

Option A is wrong because running the application as 'admin' with sudo would grant unnecessary root privileges, violating the principle of least privilege and introducing security risks. Option B is wrong because setting permissions to 644 would allow all users to read the file, but the application also needs to write; 644 does not include write permission for the group or others, so the 'Permission denied' error would persist on write attempts. Option C is wrong because changing the owner to 'app_user' with permissions 755 gives the owner write permission, but 755 grants read and execute to group and others, which is overly permissive and still does not address the group write requirement; additionally, changing owner to a non-root user may break other system processes that expect root ownership.

Full explanation →

163

MCQhard

Refer to the exhibit. A user reports that a recent Windows update failed to install. Which action should the technician take FIRST?

A.Run the Windows Update Troubleshooter

B.Disable the antivirus permanently

C.Manually download the update from Microsoft Update Catalog

D.Reinstall the operating system

AnswerA

The troubleshooter can automatically fix common update issues.

Why this answer

The Windows Update Troubleshooter is the correct first step because it is a built-in diagnostic tool that automatically detects and resolves common issues preventing updates from installing, such as corrupted update files, misconfigured Windows Update services, or incorrect proxy settings. Running this troubleshooter is a non-invasive, low-risk action that often resolves the problem without requiring manual intervention or system changes.

Exam trap

CompTIA often tests the principle of least invasive troubleshooting first, so the trap here is that candidates may jump to a more complex or permanent solution (like disabling antivirus or reinstalling) instead of using the built-in, automated diagnostic tool that is designed specifically for this scenario.

How to eliminate wrong answers

Option B is wrong because permanently disabling the antivirus exposes the system to security threats and is unnecessary; a temporary disable or adding an exclusion for Windows Update is more appropriate. Option C is wrong because manually downloading the update from the Microsoft Update Catalog should only be attempted after automated troubleshooting fails, as it bypasses the built-in update mechanism and may lead to dependency or compatibility issues. Option D is wrong because reinstalling the operating system is a drastic, last-resort measure that is not warranted for a single failed update, and it would cause data loss and significant downtime.

Full explanation →

164

MCQeasy

Based on the exhibit, which of the following best describes the file type?

A.Video file

B.Image file

C.Audio file

D.Text file

AnswerB

JPEG is a common image format.

Why this answer

The exhibit shows a file named 'screenshot.png'. The .png extension indicates a Portable Network Graphics file, which is a raster image format that uses lossless compression. Therefore, this file is an image file.

Exam trap

The trap here is that candidates may confuse file extensions with file content, assuming that any file with a common extension like .png could be a video or audio file if they don't recognize the standard mapping of extensions to file types.

How to eliminate wrong answers

Option A is wrong because a video file would have an extension like .mp4, .avi, or .mov, not .png. Option C is wrong because an audio file would have an extension like .mp3, .wav, or .aac, not .png. Option D is wrong because a text file would have an extension like .txt, .docx, or .pdf, not .png.

Full explanation →

165

Multi-Selectmedium

Which TWO of the following are examples of social engineering attacks?

Select 2 answers

A.DDoS

B.Shoulder surfing

C.Brute force

D.Man-in-the-middle

E.Phishing

AnswersB, E

Shoulder surfing involves observing a user's screen or keyboard to capture information.

Why this answer

Phishing and shoulder surfing rely on human interaction to obtain sensitive information, whereas DDoS, brute force, and man-in-the-middle are technical attacks.

Full explanation →

166

MCQmedium

A user reports that their computer is unable to access the internet, but can access local network resources. Which of the following is the most likely cause?

A.Windows Firewall blocking outbound traffic

B.Incorrect default gateway

C.DNS server not responding

D.Faulty Ethernet cable

AnswerB

The default gateway is needed to route traffic outside the local subnet.

Why this answer

The default gateway is the router that connects a local subnet to other networks, including the internet. If the default gateway is incorrect, the computer can communicate within its own subnet (local resources) but cannot route packets to external networks, causing internet access to fail while local access remains functional.

Exam trap

The trap here is that candidates often confuse DNS resolution with internet connectivity, assuming that if DNS is down, the internet is inaccessible, but the question specifies 'unable to access the internet' (not just resolve names), and local access works, which points to a routing issue at the default gateway.

How to eliminate wrong answers

Option A is wrong because Windows Firewall blocks traffic based on port/protocol rules, not routing; it would block both local and internet traffic if configured to block outbound, not selectively. Option C is wrong because a non-responding DNS server would prevent name resolution (e.g., cannot resolve google.com), but the user could still access the internet via IP address; the symptom here is complete inability to access the internet, not just name resolution failure. Option D is wrong because a faulty Ethernet cable would cause a complete loss of connectivity, including local network resources, not just internet access.

Full explanation →

167

MCQhard

Based on the exhibit, which of the following is the most likely cause of the error?

A.Hard drive failure

B.Application crash due to system library issue

C.Incorrect user permissions

D.Network connectivity loss

AnswerB

kernel32.dll is a system library; the error indicates the app crashed when trying to use it.

Why this answer

The error message indicates a missing system library (DLL) dependency, which prevents the application from launching. This is a classic symptom of an application crash due to a corrupted or missing shared library, not a hardware or network issue.

Exam trap

The trap here is that candidates may confuse a missing DLL error with a hard drive failure, because both can involve file access, but the specific error message points to a library dependency issue, not a hardware fault.

How to eliminate wrong answers

Option A is wrong because a hard drive failure would typically cause system-wide read/write errors, file corruption, or boot failures, not a specific missing DLL error for a single application. Option C is wrong because incorrect user permissions usually result in 'Access Denied' or 'Permission Denied' errors, not a missing library dependency. Option D is wrong because network connectivity loss would generate errors like 'Network path not found' or 'Connection timed out', not a missing system library error.

Full explanation →

168

MCQhard

Consider the following algorithm: SET x = 5 SET y = 2 SET result = x ^ y OUTPUT result Assuming '^' is the exponentiation operator, what is the output?

A.32

B.7

C.10

D.25

AnswerD

5^2 = 25.

Why this answer

5 raised to the power of 2 equals 25. The caret (^) is commonly used for exponentiation in some languages. Multiplication would be 10, addition 7, bitwise XOR would be 7 (5 XOR 2 = 7) but here it's exponentiation.

Full explanation →

169

MCQmedium

Refer to the exhibit. A technician is troubleshooting a connectivity issue. The user can access local resources but cannot reach the internet. Based on the output, what is the most likely cause?

A.No default gateway

B.IP address conflict

C.Incorrect subnet mask

D.Missing DNS server configuration

AnswerD

No DNS server is shown; without DNS, internet hostnames cannot be resolved.

Why this answer

The user can access local resources but cannot reach the internet, which indicates that local network communication (e.g., ARP, broadcast) is functioning, but name resolution is failing. The output likely shows that the DNS server configuration is missing or incorrect, preventing the resolution of internet domain names to IP addresses. Without a valid DNS server, the user cannot translate URLs like www.example.com into routable IP addresses, even if the default gateway and IP configuration are correct.

Exam trap

CompTIA often tests the distinction between a missing default gateway (which breaks all off-subnet traffic) and a missing DNS server (which breaks name resolution but allows IP-based access), and the trap here is that candidates assume internet access requires only a default gateway, overlooking that most internet access relies on DNS to resolve domain names.

How to eliminate wrong answers

Option A is wrong because a missing default gateway would prevent all traffic destined for non-local subnets, including local resource access if those resources are on a different subnet; however, the user can access local resources, and the symptom of being able to reach local resources but not the internet specifically points to a DNS issue, not a routing issue. Option B is wrong because an IP address conflict would cause intermittent connectivity or complete loss of network access for both local and internet resources, not a scenario where local resources are reachable but internet is not. Option C is wrong because an incorrect subnet mask would cause the device to misclassify local vs. remote destinations, typically breaking communication with hosts on the same subnet or causing routing failures for all external traffic, not selectively blocking only internet access while local access works.

Full explanation →

170

Drag & Dropmedium

Drag and drop the steps to connect a Bluetooth device to a Windows 10 computer into the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

Why this order

Pairing a Bluetooth device requires making it discoverable and adding it via Settings.

Full explanation →

171

MCQhard

A technician is recommending a device to protect a server from data loss during a power outage. Which device should the technician recommend?

A.Uninterruptible Power Supply (UPS)

B.Generator

C.Power strip

D.Surge protector

AnswerA

A UPS provides battery backup, allowing safe shutdown during an outage.

Why this answer

An Uninterruptible Power Supply (UPS) provides battery backup power to the server during a power outage, allowing for a safe shutdown or continued operation until power is restored. This directly prevents data loss by ensuring the server does not abruptly lose power while writing data to disk. Unlike other devices, a UPS combines surge protection with battery backup, making it the correct choice for this scenario.

Exam trap

The trap here is that candidates may confuse a surge protector's ability to protect against spikes with the UPS's ability to provide continuous power during an outage, or they may think a generator is suitable despite its startup delay and lack of instantaneous failover.

How to eliminate wrong answers

Option B (Generator) is wrong because a generator provides long-term backup power but has a startup delay (typically 10–30 seconds) that cannot prevent data loss from an instantaneous power outage; it also requires fuel and maintenance. Option C (Power strip) is wrong because it merely distributes power to multiple devices with no protection against power loss, surges, or data loss. Option D (Surge protector) is wrong because it only protects against voltage spikes and does not provide any battery backup to keep the server running during a power outage.

Full explanation →

172

MCQeasy

A small business wants to store customer contact information and order history. The data is structured and relationships between customers and orders must be enforced. Which type of database is most appropriate?

A.Flat-file database

B.Relational database

C.NoSQL database

D.Hierarchical database

AnswerB

Correct because it enforces relationships and supports structured data.

Why this answer

A relational database (Option A) is best for structured data with relationships. NoSQL (B) is for unstructured data, flat file (C) lacks relationships, and hierarchical (D) is less flexible.

Full explanation →

173

MCQmedium

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

A.Paper jam in the printer

B.USB cable connection

C.Printer driver on the workstation

D.Printer sharing settings on the network

AnswerB

A loose or faulty USB cable would affect only the local user.

Why this answer

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

Exam trap

The trap here is that candidates often jump to software or network issues (driver or sharing settings) when the problem is actually a simple physical layer failure, ignoring the OSI model's Layer 1 as the first troubleshooting step.

How to eliminate wrong answers

Option A is wrong because a paper jam would affect all users printing to that printer, not just one workstation. Option C is wrong because while a corrupted printer driver could cause local printing issues, it is less likely than a simple physical connection problem and should be checked after verifying the cable. Option D is wrong because printer sharing settings on the network are irrelevant; other users can already print, confirming the network sharing configuration is correct.

Full explanation →

174

MCQeasy

A junior developer needs to create a simple program that adds two numbers and displays the result. Which programming paradigm is most suitable for this task?

A.Functional programming

B.Declarative programming

C.Object-oriented programming

D.Procedural programming

AnswerD

Procedural programming uses a linear sequence of instructions, ideal for simple calculations.

Why this answer

The correct answer is A: Procedural programming. A simple sequential task like adding numbers is well-suited to procedural programming. OOP (B) adds unnecessary complexity.

Functional (C) and declarative (D) are not typical for such straightforward tasks.

Full explanation →

175

MCQeasy

A technician needs to set up a small office network with 15 computers. The computers should be able to communicate with each other and share a single internet connection. Which device is required to enable internet sharing?

A.Modem

B.Hub

C.Router

D.Switch

AnswerC

A router connects multiple networks and provides NAT for internet sharing.

Why this answer

A router is required to enable internet sharing because it performs Network Address Translation (NAT), which allows multiple devices on a local network to share a single public IP address provided by the ISP. The router also routes traffic between the local subnet and the internet, making it the essential device for both inter-device communication and internet access.

Exam trap

The trap here is that candidates often confuse a switch with a router, thinking that a switch can provide internet access because it connects devices, but they overlook that internet sharing requires Layer 3 routing and NAT, which only a router can perform.

How to eliminate wrong answers

Option A is wrong because a modem only converts signals between the ISP's line (e.g., DSL, cable) and the local network; it does not perform NAT or routing, so it cannot enable multiple computers to share a single internet connection. Option B is wrong because a hub operates at Layer 1 (physical layer) and simply repeats electrical signals to all ports; it provides no intelligence for IP addressing, NAT, or internet sharing. Option D is wrong because a switch operates at Layer 2 (data link layer) and forwards frames based on MAC addresses; while it allows local communication between computers, it cannot perform NAT or route traffic to the internet.

Full explanation →

176

MCQhard

Which type of malware replicates itself across a network without user interaction?

A.Virus

B.Ransomware

C.Worm

D.Trojan

AnswerC

Worms self-propagate across networks without human intervention.

Why this answer

A worm is a standalone malware program that replicates itself across a network by exploiting vulnerabilities or using network protocols (e.g., SMB, HTTP) without requiring any user action, such as opening a file or executing a payload. Unlike a virus, which attaches to a host file and needs user interaction to spread, a worm self-propagates automatically, making it the correct answer for malware that spreads without user interaction.

Exam trap

The trap here is that candidates confuse a worm with a virus, assuming both require user interaction, but the key distinction is that a worm self-replicates over a network autonomously, while a virus requires a host file and user action to spread.

How to eliminate wrong answers

Option A is wrong because a virus requires user interaction (e.g., opening an infected file or running a malicious macro) to attach to a host program and replicate; it does not autonomously spread across a network. Option B is wrong because ransomware is a type of malware that encrypts files or locks a system for ransom, but its primary mechanism is extortion, not self-replication across a network without user interaction. Option D is wrong because a Trojan disguises itself as legitimate software to trick users into installing it, relying on social engineering and user action, and it does not replicate itself at all.

Full explanation →

177

MCQhard

A small business has a single server running Windows Server 2019 that acts as a domain controller, file server, and DHCP server. The server has a single network interface with IP address 192.168.1.10/24. The office has 30 client computers running Windows 10. All clients obtain IP addresses automatically. The network uses a single unmanaged switch. The internet connection is provided by a cable modem with IP 192.168.1.1. The server is configured with a static IP of 192.168.1.10, and the DHCP scope is 192.168.1.100-192.168.1.200. Recently, users have reported that they cannot access the internet. The technician checks that the cable modem is online and that the server can ping the modem. The technician runs 'ipconfig /all' on a client and sees: IP: 192.168.1.101, Subnet: 255.255.255.0, Default Gateway: 192.168.1.10, DNS: 192.168.1.10. The client can ping the server (192.168.1.10) but cannot ping the modem (192.168.1.1). What is the most likely cause?

A.Disable the Windows Firewall on the server to allow traffic

B.Replace the cable modem as it is not routing traffic correctly

C.Configure the DNS server to forward queries to 8.8.8.8

D.Change the DHCP scope option for the default gateway to 192.168.1.1

AnswerD

Clients are getting the wrong gateway; they need the modem's IP.

Why this answer

The correct answer is D. The DHCP scope is configured with the default gateway option set to 192.168.1.10 (the server's IP), but the actual default gateway for internet access is the cable modem at 192.168.1.1. Since clients receive their gateway via DHCP, they are sending all off-subnet traffic to the server, which is not configured to route to the internet.

Changing the DHCP scope option for the default gateway to 192.168.1.1 will allow clients to route internet traffic through the modem.

Exam trap

The trap here is that candidates may assume the server can act as a router because it is a domain controller and file server, but without enabling routing services (like RRAS), the server will not forward traffic between subnets or to the internet.

How to eliminate wrong answers

Option A is wrong because disabling the Windows Firewall on the server would not fix the routing issue; the server is not acting as a router, and the firewall is not blocking client traffic to the modem. Option B is wrong because the cable modem is online and the server can ping it, indicating the modem is functioning correctly; the problem is that clients are not using the modem as their gateway. Option C is wrong because DNS forwarding to 8.8.8.8 would not resolve the connectivity issue; the client cannot ping the modem, which is a layer 3 routing problem, not a DNS resolution problem.

Full explanation →

178

MCQmedium

A user reports that their laptop cannot connect to the corporate Wi-Fi network. Other users in the same area are connected without issues. The laptop shows it is connected to the Wi-Fi but has no internet access. Which of the following is the MOST likely cause?

A.Weak Wi-Fi signal

B.SSID broadcast disabled

C.Incorrect IP configuration

D.MAC address filter enabled

AnswerC

Static IP or wrong DHCP settings can cause local connectivity but no internet.

Why this answer

The laptop shows it is connected to Wi-Fi but has no internet access, which indicates that the Layer 3 (network layer) configuration is faulty. An incorrect IP configuration, such as a static IP in the wrong subnet or a failed DHCP lease, prevents the laptop from obtaining a valid default gateway and DNS server, breaking internet connectivity while the Wi-Fi association (Layer 2) remains intact.

Exam trap

The trap here is that candidates confuse a successful Layer 2 association (connected to Wi-Fi) with full Layer 3 connectivity, leading them to choose weak signal or MAC filtering instead of recognizing that the issue is at the IP configuration layer.

How to eliminate wrong answers

Option A is wrong because a weak Wi-Fi signal would cause intermittent disconnections or a very low link quality, not a stable connection with no internet access. Option B is wrong because if the SSID broadcast were disabled, the laptop would not see the network in the scan list and could not connect at all, but the user reports it is connected. Option D is wrong because a MAC address filter enabled would block the laptop from associating with the access point entirely, resulting in a failure to connect to the Wi-Fi, not a connected state with no internet.

Full explanation →

179

Multi-Selecteasy

Which TWO of the following are advantages of server virtualization? (Select TWO.)

Select 2 answers

A.Easier backup and recovery using snapshots

B.Increased security by isolating VMs

C.Eliminates the need for operating system licenses

D.Improved performance over physical servers

E.Better hardware utilization through consolidation

AnswersA, E

Snapshots provide point-in-time recovery.

Why this answer

Option A is correct because server virtualization allows administrators to take snapshots of virtual machines (VMs) at a specific point in time. These snapshots capture the entire VM state, including disk, memory, and power state, enabling quick and consistent backup and recovery without the complexity of traditional physical server backups.

Exam trap

The trap here is that candidates mistakenly believe VM isolation guarantees security (Option B) or that virtualization eliminates OS licensing costs (Option C), when in fact isolation is a feature that requires proper configuration and licensing still applies per VM.

Full explanation →

180

MCQeasy

What is the binary representation of the decimal number 10?

A.1001

B.1110

C.1010

D.1100

AnswerC

1010 binary equals 10 decimal.

Why this answer

The decimal number 10 is converted to binary by dividing by 2 repeatedly: 10 ÷ 2 = 5 remainder 0, 5 ÷ 2 = 2 remainder 1, 2 ÷ 2 = 1 remainder 0, 1 ÷ 2 = 0 remainder 1. Reading the remainders from bottom to top gives 1010. This matches option C.

Exam trap

The trap here is that candidates often confuse the binary for 10 with the binary for 12 (1100) or 14 (1110) by misplacing the '1' bits, or they incorrectly convert by adding 1 to the binary for 9 (1001) instead of performing proper division.

How to eliminate wrong answers

Option A (1001) is wrong because it represents decimal 9, not 10 — the binary place values are 8+0+0+1 = 9. Option B (1110) is wrong because it represents decimal 14 (8+4+2+0 = 14), which is a common confusion when misplacing the most significant bit. Option D (1100) is wrong because it represents decimal 12 (8+4+0+0 = 12), often chosen by candidates who incorrectly double the value or misremember the pattern.

Full explanation →

181

Multi-Selecteasy

Which TWO of the following are types of optical disc storage? (Select exactly two.)

Select 2 answers

A.DVD

B.SSD

C.HDD

D.Flash drive

E.CD

AnswersA, E

Digital Versatile Disc is an optical storage medium.

Why this answer

DVD (Digital Versatile Disc) is a type of optical disc storage that uses a laser to read and write data on a reflective plastic disc. It is a standard optical media format, distinct from magnetic or solid-state storage technologies.

Exam trap

The trap here is that candidates often confuse storage categories, mistakenly classifying SSDs or flash drives as 'optical' because they are removable or used for similar purposes, but the exam strictly tests the physical media type (laser-read vs. magnetic or solid-state).

Full explanation →

182

MCQhard

A technician is configuring a small office network with 15 computers. The computers need to share files and a printer. The technician decides to use a topology where each computer is connected to a central device. Which physical topology is being implemented?

A.Ring

B.Mesh

C.Bus

D.Star

AnswerD

A star topology connects all devices to a central switch or hub.

Why this answer

The star topology connects each computer directly to a central device, such as a switch or hub. This allows all 15 computers to share files and a printer through the central device, making it the correct choice for the described small office network.

Exam trap

The trap here is that candidates often confuse the logical topology (e.g., Ethernet uses a logical bus) with the physical topology, assuming that because Ethernet uses CSMA/CD, it must be a physical bus, but modern Ethernet networks physically use a star topology with switches.

How to eliminate wrong answers

Option A is wrong because a ring topology connects each computer to two neighbors in a closed loop, requiring data to pass through each device sequentially, which does not use a central device. Option B is wrong because a mesh topology connects each computer to every other computer directly, which is impractical and costly for 15 devices and does not rely on a single central device. Option C is wrong because a bus topology uses a single backbone cable with drop lines to each computer, lacking a central device and being prone to collisions and single-point failures.

Full explanation →

183

MCQeasy

Refer to the exhibit. A user can ping 192.168.1.1 but cannot ping 8.8.8.8. What is most likely the issue?

A.The default gateway is not forwarding traffic to external networks

B.IP address is invalid

C.Subnet mask is incorrect

D.DNS server is not configured

AnswerA

The gateway is reachable but may not have a route to the internet.

Why this answer

The user can ping the local gateway (192.168.1.1), which confirms that the local IP configuration, subnet mask, and ARP resolution are working correctly. However, the inability to ping 8.8.8.8 (a public IP) indicates that traffic is not being routed beyond the local subnet. The most likely cause is that the default gateway is either misconfigured, down, or not performing IP forwarding to external networks, as the gateway is the router responsible for forwarding packets destined outside the local network.

Exam trap

CompTIA often tests the distinction between local connectivity (Layer 2/3 within subnet) and external routing (Layer 3 beyond the gateway), and the trap here is that candidates confuse DNS resolution with IP reachability, selecting DNS even though the ping uses a raw IP address.

How to eliminate wrong answers

Option B is wrong because an invalid IP address would prevent any successful ping, including to the local gateway; since 192.168.1.1 is reachable, the IP address is valid. Option C is wrong because an incorrect subnet mask would typically cause local communication failures or inability to reach the gateway, but the user can ping the gateway, indicating the subnet mask is correct for the local network. Option D is wrong because DNS is used for name resolution, not for IP-based ping to 8.8.8.8; the ping command uses the IP address directly, so DNS configuration is irrelevant to this issue.

Full explanation →

184

MCQhard

Based on the exhibit, which device is directly responsible for separating traffic into VLAN10 and VLAN20?

A.Firewall

B.Internet

C.Router

D.Switch

AnswerD

Switches are used to create and separate VLANs.

Why this answer

The switch is directly responsible for separating traffic into VLAN10 and VLAN20 because VLANs are configured at Layer 2 on a switch, using VLAN tagging (IEEE 802.1Q) to isolate broadcast domains. The switch assigns each port to a specific VLAN, ensuring that frames from VLAN10 are not forwarded to VLAN20 ports without a Layer 3 device.

Exam trap

The trap here is that candidates often confuse the switch's role in VLAN creation with the router's role in inter-VLAN routing, assuming the router separates the VLANs when it only routes between them after the switch has already isolated them.

How to eliminate wrong answers

Option A is wrong because a firewall operates at Layer 3 and above, filtering traffic based on IP addresses and ports, but it does not create or separate VLANs—VLAN separation is a Layer 2 function. Option B is wrong because the Internet is an external WAN and has no role in internal VLAN segmentation; it is a network of networks, not a device. Option C is wrong because a router can route between VLANs (inter-VLAN routing) but does not directly separate traffic into VLANs; that separation is performed by the switch at Layer 2 using VLAN membership.

Full explanation →

185

MCQeasy

A user wants to create a presentation with slides, animations, and speaker notes. Which application type should they use?

A.Word processing software.

B.Database software.

C.Spreadsheet software.

D.Presentation software.

AnswerD

Presentation applications like PowerPoint or Keynote provide the required features.

Why this answer

Presentation software, such as Microsoft PowerPoint or Google Slides, is specifically designed to create slide-based presentations with multimedia elements like animations, transitions, and speaker notes. The speaker notes feature allows the presenter to see private notes below each slide while the audience views only the slides, which is a core function of this application type.

Exam trap

The trap here is that candidates may confuse word processing software (Option A) as suitable for presentations because it can include images and text, but it lacks slide-based navigation, animation timelines, and dedicated speaker notes functionality.

How to eliminate wrong answers

Option A is wrong because word processing software (e.g., Microsoft Word) is optimized for creating and formatting text documents, not for slide-based presentations with animations or speaker notes. Option B is wrong because database software (e.g., Microsoft Access) is used for storing, querying, and managing structured data, not for creating visual presentations. Option C is wrong because spreadsheet software (e.g., Microsoft Excel) is designed for numerical data analysis, charting, and calculations, lacking native support for slide decks, animations, or speaker notes.

Full explanation →

186

MCQmedium

Which of the following best describes the function of an operating system?

A.Encrypts all data on the computer

B.Controls hardware and provides a user interface

C.Manages only file storage

D.Provides internet connectivity

AnswerB

The OS acts as an intermediary between user and hardware.

Why this answer

The operating system (OS) is system software that manages computer hardware, software resources, and provides common services for computer programs. Its core functions include process management, memory management, device management, and providing a user interface (such as a command-line interface or graphical user interface) for interaction. Without an OS, a user cannot directly control hardware or run application software.

Exam trap

The trap here is that candidates often confuse a specific feature (like encryption or internet connectivity) with the OS's fundamental purpose, leading them to pick a narrow or secondary function instead of the broad, correct definition of hardware control and user interface provision.

How to eliminate wrong answers

Option A is wrong because encryption is not a core function of an operating system; while some OSes include encryption tools (e.g., BitLocker, FileVault), the primary role of the OS is not to encrypt all data, and encryption is an optional security feature, not a fundamental OS function. Option C is wrong because managing only file storage is too narrow; the OS manages much more, including processes, memory, devices, and security, not just files. Option D is wrong because providing internet connectivity is typically handled by network interface hardware and drivers, not the OS itself; the OS provides networking stacks (e.g., TCP/IP) and APIs, but connectivity is a service built on top of the OS, not its defining function.

Full explanation →

187

MCQhard

Refer to the exhibit. A security analyst reviews the NTFS permissions on the C:\Shared folder. Which user or group has the ability to delete files created by other users?

A.Users

B.No user or group

C.Admin

D.Everyone

AnswerA

Users have Modify (M) permissions, which include the ability to delete files and subfolders, even those created by other users.

Why this answer

The 'Users' group in Windows NTFS has the 'Modify' permission on the C:\Shared folder by default, which includes the 'Delete Subfolders and Files' advanced permission. This allows members of the Users group to delete files created by other users, even if they are not the owner of those files. The 'Delete' permission alone only allows deletion of one's own files, but 'Delete Subfolders and Files' overrides that restriction for the container.

Exam trap

Cisco often tests the distinction between the standard 'Delete' permission and the advanced 'Delete Subfolders and Files' permission, trapping candidates who assume that only the file owner or an administrator can delete files created by others.

How to eliminate wrong answers

Option B is wrong because the 'Users' group explicitly has the ability to delete files created by other users via the 'Delete Subfolders and Files' permission, so there is a user/group with that capability. Option C is wrong because the 'Admin' group (typically Administrators) has full control, but the question asks which user or group has the ability to delete files created by other users, and 'Users' is the correct answer, not 'Admin' (though Admin also has that ability, it is not the best answer as 'Users' is the group specifically granted that permission in the exhibit). Option D is wrong because 'Everyone' includes all users, including anonymous and guest accounts, and while it may have read or execute permissions, it does not inherently have the 'Delete Subfolders and Files' permission on the C:\Shared folder; the exhibit shows that 'Users' is the group with that specific permission.

Full explanation →

188

Multi-Selecteasy

Which TWO of the following are common types of network cables used in wired Ethernet networks?

Select 2 answers

A.HDMI

B.Coaxial

C.Cat5e

D.USB

E.Fiber optic

AnswersC, E

Cat5e is a standard twisted-pair cable for Ethernet networks.

Why this answer

Cat5e (Category 5 enhanced) is a twisted-pair copper cable standard that supports Gigabit Ethernet (1000BASE-T) up to 100 meters. It is one of the most common cable types for wired Ethernet networks because it provides sufficient bandwidth (up to 1000 Mbps) and is backward compatible with older 10/100 Mbps standards.

Exam trap

The trap here is that candidates often confuse coaxial cable's historical use in Ethernet (e.g., 10BASE2) with modern wired Ethernet standards, forgetting that today's common Ethernet deployments use twisted-pair (Cat5e/Cat6) or fiber, not coax.

Full explanation →

189

MCQmedium

Which security threat is indicated in the exhibit?

A.DDoS

B.Phishing

C.Malware infection

D.Brute force attack

AnswerD

The log shows failed login attempts, characteristic of a brute force attack.

Why this answer

The exhibit shows repeated failed login attempts from a single IP address, which is characteristic of a brute force attack. This attack systematically tries many username/password combinations to gain unauthorized access, often targeting services like SSH, RDP, or web login portals.

Exam trap

The trap here is that candidates may confuse repeated failed logins with a malware infection or DDoS, but the key indicator is the systematic, single-source attempt pattern targeting authentication, not traffic volume or malicious code.

How to eliminate wrong answers

Option A is wrong because a DDoS (Distributed Denial of Service) attack floods a target with traffic from multiple sources to overwhelm resources, not repeated login attempts. Option B is wrong because phishing involves deceptive messages (e.g., emails) tricking users into revealing credentials, not automated login trials. Option C is wrong because a malware infection requires malicious software execution, whereas brute force is a direct authentication attack without code execution.

Full explanation →

190

MCQhard

Refer to the exhibit. Which type of license does Acme Corp hold?

A.Site license

B.Per-user license

C.Volume license

D.Concurrent license

AnswerC

The field 'license_type': 'volume' indicates a volume license.

Why this answer

The exhibit shows a license key format that includes 'VOL' (volume) and a large number of users (e.g., 1000), which is characteristic of a volume license. Volume licenses are sold in bulk to organizations, allowing deployment on multiple devices under a single agreement, often with a single product key. This contrasts with per-user or concurrent licenses, which track individual or simultaneous usage.

Exam trap

The trap here is that candidates confuse 'volume license' with 'site license' because both involve multiple users, but a site license is location-specific and unlimited within that site, whereas a volume license is a bulk purchase with a specific count and is not tied to a single physical location.

How to eliminate wrong answers

Option A is wrong because a site license covers all users at a specific physical location (e.g., a campus) and typically does not use a key with 'VOL' or a user count; it is location-based, not user-count-based. Option B is wrong because a per-user license assigns a unique license to each named user, often requiring individual keys or accounts, not a single bulk key with a user limit. Option D is wrong because a concurrent license limits the number of simultaneous users accessing the software, not the total number of licensed users, and would typically be managed via a license server, not a single product key with a user count.

Full explanation →

191

Multi-Selectmedium

Which TWO concerns are most critical when selecting a backup method? (Select exactly two.)

Select 2 answers

A.Recovery time objective

B.Network topology

C.Data size

D.Display resolution

E.Operating system version

AnswersA, C

RTO defines the maximum acceptable downtime for restoring data, critical for business continuity.

Why this answer

Recovery time objective (RTO) is critical because it defines the maximum acceptable downtime after a failure, directly influencing the choice of backup method (e.g., full vs. incremental) and storage medium (e.g., local disk vs. cloud). A shorter RTO requires faster restoration, often necessitating more frequent backups or technologies like snapshots or replication.

Exam trap

CompTIA often tests the distinction between operational metrics (RTO, RPO, data size) and unrelated hardware/software specifications (display resolution, OS version) to see if candidates can identify which factors truly drive backup strategy decisions.

Full explanation →

192

MCQhard

A technician is setting up a new computer on a network. The computer receives an IP address of 169.254.1.5. Which of the following is the most likely issue?

A.The network cable is faulty

B.The DNS server is unreachable

C.The gateway is misconfigured

D.The DHCP server is unavailable

AnswerD

APIPA is assigned when DHCP is not available.

Why this answer

The IP address 169.254.1.5 falls within the Automatic Private IP Addressing (APIPA) range (169.254.0.0/16), which Windows automatically assigns when a DHCP client fails to receive an IP lease from a DHCP server. This indicates that the DHCP server is either unreachable or not responding, making D the correct answer.

Exam trap

The trap here is that candidates often confuse APIPA with a DNS or gateway problem, but APIPA is a direct indicator of DHCP failure, not name resolution or routing issues.

How to eliminate wrong answers

Option A is wrong because a faulty network cable would typically cause a link light failure or complete lack of connectivity, but the computer still obtained an APIPA address, which requires a functional physical layer to send DHCP discovery broadcasts. Option B is wrong because DNS server unreachability does not prevent DHCP lease assignment; DNS is a separate service used for name resolution after IP configuration is complete. Option C is wrong because a misconfigured gateway affects routing beyond the local subnet, but the computer would still receive a valid DHCP lease if the DHCP server were available; APIPA only occurs when no DHCP server responds.

Full explanation →

193

MCQeasy

Which of the following is an example of a strong password?

A.123456

B.Cr@zy8#s

C.abc123

D.password

AnswerB

This password uses uppercase, lowercase, numbers, and symbols, making it strong.

Why this answer

Option B (Cr@zy8#s) is correct because it meets all strong password criteria: it is at least 8 characters long, includes uppercase and lowercase letters, a digit, and special characters (@ and #). This complexity makes it resistant to brute-force attacks and dictionary attacks, as it increases the entropy and does not contain common words or sequential patterns.

Exam trap

The trap here is that candidates often choose passwords like 'abc123' or '123456' because they seem easy to remember, but the exam tests the understanding that a strong password must include a mix of character types and avoid common patterns or dictionary words.

How to eliminate wrong answers

Option A is wrong because '123456' is a sequential numeric string that is one of the most commonly used passwords, making it trivial to guess or crack with a simple brute-force attack. Option C is wrong because 'abc123' combines a common alphabetical sequence with a numeric sequence, lacks special characters and uppercase letters, and is frequently found in password dictionaries. Option D is wrong because 'password' is a single common English word that is the most classic example of a weak password, easily guessed by dictionary attacks and appearing in every password cracking list.

Full explanation →

194

Drag & Dropmedium

Drag and drop the steps to check for Windows Updates in Windows 10 into the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

Why this order

Windows Update keeps the system secure and up to date.

Full explanation →

195

MCQeasy

A database designer wants to ensure that no two employees have the same email address. Which constraint should be applied to the Email column?

A.UNIQUE

B.PRIMARY KEY

C.CHECK

D.FOREIGN KEY

AnswerA

UNIQUE constraint ensures no duplicate email addresses.

Why this answer

The UNIQUE constraint ensures that all values in the Email column are distinct, preventing any two employees from having the same email address. Unlike PRIMARY KEY, UNIQUE allows NULL values (though typically email columns are set to NOT NULL), and it can be applied to non-key columns. This directly enforces the business rule of unique email addresses without requiring the column to be the table's primary identifier.

Exam trap

The trap here is that candidates often confuse UNIQUE with PRIMARY KEY, assuming uniqueness can only be enforced by a primary key, but PRIMARY KEY imposes additional non-null and single-per-table restrictions that are not required for simply ensuring unique email addresses.

How to eliminate wrong answers

Option B (PRIMARY KEY) is wrong because while it also enforces uniqueness, it additionally requires the column to be non-null and uniquely identify each row, which is not necessary for just ensuring unique emails; the Email column may not be the natural primary key. Option C (CHECK) is wrong because CHECK constraints validate data against a Boolean expression (e.g., ensuring email format contains '@'), but they cannot enforce uniqueness across rows. Option D (FOREIGN KEY) is wrong because it enforces referential integrity between tables by requiring values in the Email column to match values in another table's primary key or unique column, which does not prevent duplicate emails within the same table.

Full explanation →

196

MCQeasy

Which principle ensures that data is not modified by unauthorized users?

A.Authentication

B.Confidentiality

C.Availability

D.Integrity

AnswerD

Integrity ensures data is not altered by unauthorized means.

Why this answer

Integrity ensures that data has not been altered or tampered with by unauthorized users. This is typically enforced through mechanisms like hashing (e.g., SHA-256) or digital signatures, which detect any modification to the original data. Without integrity controls, an attacker could change financial records or system files without detection.

Exam trap

CompTIA often tests the distinction between confidentiality and integrity, where candidates mistakenly choose confidentiality because they associate 'protection' with encryption, but encryption only prevents reading, not modification.

How to eliminate wrong answers

Option A is wrong because authentication verifies the identity of a user or system (e.g., via passwords or certificates), but does not prevent data modification after access is granted. Option B is wrong because confidentiality protects data from unauthorized disclosure (e.g., via encryption), not from unauthorized modification. Option C is wrong because availability ensures that data and systems are accessible when needed (e.g., through redundancy or load balancing), but does not address data tampering.

Full explanation →

197

MCQeasy

A company wants to ensure that data is not lost if a hard drive fails. Which of the following best practices should be implemented?

A.Using strong passwords

B.Regularly updating antivirus software

C.Using a surge protector

D.Performing regular backups

AnswerD

Backups enable data recovery after drive failure.

Why this answer

Regular backups create copies of data that can be restored if the original is lost due to hard drive failure. This directly addresses data loss by providing a recovery point, unlike other options that focus on security or power protection.

Exam trap

The trap here is that candidates confuse fault tolerance (like RAID) with backups, but RAID only protects against drive failure, not data loss from corruption or deletion, whereas backups ensure data can be restored regardless of the cause.

How to eliminate wrong answers

Option A is wrong because strong passwords prevent unauthorized access but do not protect against hardware failure or data loss. Option B is wrong because antivirus software protects against malware, not physical drive failure or data recovery. Option C is wrong because a surge protector guards against power spikes damaging hardware, but does not preserve data if the drive fails.

Full explanation →

198

MCQhard

A small real estate office with 12 employees has been using the same network setup for five years. Employees use both company-issued laptops and personal smartphones to access email and client listings. Last week, an employee clicked a link in a phishing email, which led to a ransomware infection on the company file server. The server was encrypted, and the attackers demanded a ransom. The office had no backups; all client data and contracts were lost. The office manager wants to prevent such incidents in the future. Which of the following should be the FIRST security measure implemented, considering the root cause of the breach?

A.Install antivirus software on all company laptops and personal devices

B.Deploy a next-generation firewall with intrusion prevention

C.Enable full-disk encryption on all company laptops

D.Mandate security awareness training for all employees, focusing on phishing identification

AnswerD

Training addresses the root cause by empowering users to avoid phishing attacks.

Why this answer

The root cause was a phishing email that tricked an employee. While technical controls like antivirus (A), firewalls (C), and encryption (D) are valuable, they do not address the human factor. Security awareness training (B) educates users to recognize phishing attempts, reducing the likelihood of similar incidents.

Without training, other controls can be bypassed. Option B is the most direct and effective first step.

Full explanation →

199

Multi-Selecthard

Which THREE are common steps in troubleshooting software issues?

Select 3 answers

A.Test the solution

B.Identify the problem

C.Reinstall the operating system

D.Replace hardware

E.Document findings

AnswersA, B, E

After implementing a fix, testing ensures it works.

Why this answer

Options A, C, and E are correct because identifying the problem, testing the solution, and documenting findings are standard steps. Option B is wrong because reinstalling the OS is an extreme measure. Option D is wrong because replacing hardware is not a software troubleshooting step.

Full explanation →

200

Multi-Selecteasy

Which TWO of the following are advantages of using a relational database over a NoSQL database? (Choose two.)

Select 2 answers

A.Schema flexibility

B.Low latency for large volumes

C.ACID compliance

D.Standard query language (SQL)

E.Horizontal scalability

AnswersC, D

Relational databases enforce ACID properties, ensuring transaction reliability.

Why this answer

Relational databases offer ACID compliance and a standard query language (SQL), which are key advantages.

Full explanation →

201

MCQhard

A small business uses a legacy desktop application for inventory management. The application was designed for Windows 7 and has not been updated. The company recently upgraded its workstations to Windows 10. Now, when employees try to run the inventory application, it either crashes immediately or displays errors about missing components. The company relies on this application daily and cannot afford downtime. The IT administrator has tried running the application in compatibility mode for Windows 7, but the crashes persist. There is no alternative application available, and the vendor is out of business. Which of the following is the BEST course of action to allow the business to continue using this application?

A.Contact the vendor for an updated version of the software.

B.Hire a developer to rewrite the application for Windows 10.

C.Set up a virtual machine running Windows 7 and install the application there.

D.Uninstall the application and reinstall it using the original installation media.

AnswerC

A VM provides a compatible OS environment for legacy software.

Why this answer

Option C is correct because using a virtual machine with Windows 7 provides a full compatible environment, allowing the legacy application to run as before. Option A is wrong because reinstalling the application on Windows 10 will likely result in the same issues since the application is incompatible. Option B is wrong because contacting a vendor that is out of business is futile.

Option D is wrong because rewriting the application is costly, time-consuming, and not a quick fix.

Full explanation →

202

MCQeasy

A technician needs to verify that a twisted-pair Ethernet cable is wired correctly and has no breaks. Which tool should be used?

A.Multimeter

B.Loopback plug

C.Cable tester

D.Toner probe

AnswerC

Cable testers verify pinouts, continuity, and proper wiring of Ethernet cables.

Why this answer

A cable tester sends signals through each conductor in the twisted-pair cable and checks for continuity, correct pin-to-pin wiring (e.g., T568A or T568B), and shorts or opens. This makes it the correct tool to verify proper wiring and detect breaks in an Ethernet cable.

Exam trap

The trap here is that candidates confuse a multimeter's ability to check continuity with the cable tester's ability to verify correct pairing and wiring standards, leading them to choose the multimeter when only a cable tester can confirm proper Ethernet wiring.

How to eliminate wrong answers

Option A is wrong because a multimeter can only test basic continuity or resistance on individual wires, but it cannot verify correct pairing, split pairs, or the full wiring scheme of an Ethernet cable. Option B is wrong because a loopback plug is used to test the transmit/receive capability of a network interface port, not to check the wiring or integrity of a cable itself. Option D is wrong because a toner probe is used to trace and identify a specific cable within a bundle or patch panel, not to verify wiring correctness or detect breaks.

Full explanation →

203

Matchingmedium

Match each network type to its description.

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

Concepts

Matches

Small geographic area

Large geographic area

Personal devices around a person

City-sized network

Why these pairings

Network classification by scope.

Full explanation →

204

MCQmedium

A user reports that the company's customer relationship management (CRM) application is slow after a recent network upgrade. What could be the cause?

A.The network firewall is blocking certain CRM traffic.

B.The application has too many users.

C.The user's password has expired.

D.The user is entering data too quickly.

AnswerA

Firewall rules may inadvertently throttle or block necessary ports, causing slowdown.

Why this answer

A network firewall can introduce latency or block traffic if its rules are misconfigured after an upgrade. If the CRM application relies on specific ports or protocols (e.g., HTTPS on TCP 443, or a proprietary port like TCP 8080), the firewall might be inspecting, throttling, or dropping packets, causing perceived slowness. This is a common post-upgrade issue when ACLs or stateful inspection rules change.

Exam trap

CompTIA often tests the misconception that slowness after a network change must be caused by bandwidth or user load, rather than a firewall or ACL misconfiguration that introduces latency or packet loss.

How to eliminate wrong answers

Option B is wrong because too many users would cause slow performance due to resource contention on the server, not specifically after a network upgrade; the issue is network-related, not capacity-related. Option C is wrong because an expired password prevents login entirely (HTTP 401 or access denied), not causing slowness after authentication. Option D is wrong because data entry speed is a client-side input rate that does not affect network throughput or application response time; the application processes keystrokes asynchronously.

Full explanation →

205

MCQmedium

A user reports that a SELECT query on a large table with millions of records is very slow. The table has no indexes. Which index type would most likely improve the performance of equality searches (e.g., WHERE id = 100)?

A.Full-text index on the column

B.Nonclustered index on the column

C.Clustered index on the column

D.Unique index on the column

AnswerC

A clustered index sorts and stores the data rows in order, making equality lookups very fast via binary search.

Why this answer

A clustered index on the column used in equality searches (e.g., WHERE id = 100) is the most effective because it physically reorders the table data in the same order as the index key. This allows the database engine to perform a single seek operation directly to the exact row, rather than scanning millions of records. For a large table with no indexes, a clustered index provides the fastest possible access for equality lookups on the indexed column.

Exam trap

The trap here is that candidates often confuse 'nonclustered index' as the default or best choice for all searches, but for equality searches on a large table, a clustered index eliminates the extra lookup step and is the most performant option.

How to eliminate wrong answers

Option A is wrong because a full-text index is designed for linguistic searches on large text fields (e.g., searching for words or phrases within documents), not for exact equality matches on a single value like an ID. Option B is wrong because a nonclustered index on the column would improve performance but requires an additional lookup step (key lookup or bookmark lookup) to retrieve the actual data row, making it slower than a clustered index for direct equality searches. Option D is wrong because a unique index enforces uniqueness of values but does not inherently improve performance more than a non-unique index; its primary purpose is constraint enforcement, not query speed optimization.

Full explanation →

206

MCQmedium

Refer to the exhibit. A computer displays this error during startup. Which component is most likely the cause of the issue?

A.RAM

B.Power supply

C.Hard drive

D.CPU

AnswerC

The error message directly indicates the hard disk is not detected, pointing to a failed drive, loose cable, or incorrect BIOS settings.

Why this answer

Option C (Hard drive) is correct because the error explicitly states that the hard disk is not found, indicating a problem with the storage device or its connection. Option A (RAM) would typically cause beep codes or a blank screen, not a boot device error. Option B (CPU) failure usually results in no power or beeps.

Option D (Power supply) issues often lead to no power or intermittent shutdowns, not a specific hard disk error.

Full explanation →

207

MCQmedium

A technician is troubleshooting a slow network and suspects a loop. Which command-line tool should the technician use to identify the loop?

A.tracert example.com

B.netstat -a

C.ping -t 1 192.168.1.1

D.nslookup example.com

AnswerC

Ping with a TTL of 1 will fail if there is a loop, and multiple 'Time Exceeded' messages can indicate a loop.

Why this answer

Option C is correct because the `ping -t 1 192.168.1.1` command sends ICMP echo requests with a Time-to-Live (TTL) value of 1. If a network loop exists, the packet will be forwarded in a cycle, and each hop decrements the TTL. When the TTL reaches 0, the router discards the packet and sends an ICMP Time Exceeded message back.

By observing repeated Time Exceeded responses from the same or multiple IPs, the technician can identify the loop's location.

Exam trap

The trap here is that candidates often confuse `ping -t` (continuous ping) with `tracert` (trace route), thinking that `tracert` is the standard tool for loop detection, but `tracert` is designed for path discovery, not for actively triggering TTL expiration in a loop scenario.

How to eliminate wrong answers

Option A is wrong because `tracert` (or `tracert example.com`) traces the route to a destination by incrementing TTL values, but it is designed to show the path and measure hop delays, not to actively detect a loop; it may hang or time out in a loop but does not provide a direct loop identification mechanism. Option B is wrong because `netstat -a` displays active network connections and listening ports, which is useful for checking open connections or services, but it does not send packets or analyze TTL behavior to detect loops. Option D is wrong because `nslookup example.com` is a DNS query tool used to resolve domain names to IP addresses; it has no capability to detect network loops.

Full explanation →

208

MCQhard

A software developer writes code that stores sensitive user data. To comply with data protection regulations, which application-level security measure should be implemented?

A.Install a firewall on the server.

B.Run regular antivirus scans.

C.Use encryption for data storage and transmission.

D.Require multi-factor authentication for login.

AnswerC

Encryption renders data unreadable without a key, ensuring confidentiality.

Why this answer

Option C is correct because encryption (e.g., AES-256 for data at rest and TLS 1.3 for data in transit) renders sensitive user data unreadable to unauthorized parties, directly addressing data protection regulations such as GDPR or HIPAA that mandate confidentiality. This is an application-level security measure implemented within the software code or database layer, not a network or perimeter control.

Exam trap

The trap here is that candidates often confuse access control measures (like MFA) with data protection measures (like encryption), assuming that restricting who can log in is sufficient to protect stored data, but regulations require data to be encrypted regardless of access controls.

How to eliminate wrong answers

Option A is wrong because a firewall is a network-level security measure that controls traffic based on IP addresses and ports; it does not protect data stored or transmitted by the application itself. Option B is wrong because antivirus scans detect and remove malware on the host system but do not protect the confidentiality or integrity of application data at rest or in transit. Option D is wrong because multi-factor authentication (MFA) controls access to the application but does not secure the stored data itself; once authenticated, the data remains exposed without encryption.

Full explanation →

209

Multi-Selecthard

Which THREE of the following are characteristics of a relational database? (Choose THREE.)

Select 3 answers

A.The database uses a hierarchical model.

B.Queries are written using SQL.

C.The database is schema-less and flexible.

D.Data is stored as JSON documents.

E.Data is stored in tables with rows and columns.

.ACID transactions ensure data integrity.

AnswersB, E

SQL is the standard language for relational databases.

Why this answer

Option B is correct because SQL (Structured Query Language) is the standard language used to query and manipulate data in relational databases. It allows users to perform operations such as SELECT, INSERT, UPDATE, and DELETE on structured data stored in tables.

Exam trap

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

Full explanation →

210

MCQhard

A university database includes a table named 'Students' and a table named 'Enrollments'. The 'Enrollments' table has a foreign key column 'StudentID' that references the 'StudentID' primary key in the 'Students' table. The university policy requires that when a student withdraws (i.e., their record is deleted from the 'Students' table), all of their associated enrollment records must be automatically removed to maintain data consistency. The database administrator wants to enforce this rule at the database level. Which referential action should be applied when creating the foreign key constraint on the 'Enrollments' table?

A.ON DELETE CASCADE

B.ON DELETE SET NULL

C.ON DELETE NO ACTION

D.ON DELETE RESTRICT

AnswerA

CASCADE automatically deletes child records when parent is deleted.

Why this answer

Option A (ON DELETE CASCADE) is correct because it automatically deletes all child rows in the 'Enrollments' table when the corresponding parent row in the 'Students' table is deleted. This enforces the university policy of removing associated enrollment records upon student withdrawal, maintaining referential integrity at the database level without manual intervention.

Exam trap

The trap here is that candidates often confuse ON DELETE CASCADE with ON DELETE SET NULL or ON DELETE RESTRICT, mistakenly thinking that preventing deletion or setting NULL satisfies the automatic removal requirement, when only CASCADE actually deletes the child records automatically.

How to eliminate wrong answers

Option B (ON DELETE SET NULL) is wrong because it would set the 'StudentID' foreign key column in 'Enrollments' to NULL when the parent student record is deleted, which does not remove the enrollment records and may violate NOT NULL constraints. Option C (ON DELETE NO ACTION) is wrong because it prevents the deletion of a student record if any referencing enrollment rows exist, requiring manual deletion of enrollments first, which contradicts the automatic removal policy. Option D (ON DELETE RESTRICT) is wrong because it also blocks the deletion of a student record if referencing enrollments exist, similar to NO ACTION, and does not automatically remove associated records.

Full explanation →

211

Multi-Selecthard

A small business is expanding and needs to ensure their network infrastructure supports growth. Which THREE practices should they implement?

Select 3 answers

A.Deploy redundant power supplies for critical devices

B.Implement network segmentation using VLANs

C.Use a single subnet for simplicity

D.Regularly update firmware on networking equipment

E.Use static IP addressing for all devices

AnswersA, B, D

Redundant power supplies increase uptime and reliability.

Why this answer

Redundant power supplies ensure that critical network devices like switches and routers remain operational even if one power supply fails, minimizing downtime during business expansion. This practice directly supports network availability and growth by providing fault tolerance for essential infrastructure components.

Exam trap

The trap here is that candidates may choose 'Use a single subnet for simplicity' thinking it reduces complexity, but it actually hinders scalability and introduces broadcast domain issues that degrade performance in a growing network.

Full explanation →

212

Multi-Selectmedium

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

Select 2 answers

A.Procedural programming

B.Polymorphism

C.Functional programming

D.Inheritance

E.Encapsulation

AnswersD, E

Inheritance allows a class to derive properties from another class.

Why this answer

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

Exam trap

The trap here is that candidates may confuse 'characteristics of OOP' with 'programming paradigms' and incorrectly select procedural or functional programming, which are separate paradigms, not OOP features.

Full explanation →

213

MCQhard

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

A.Unit testing

B.Debugging

C.Profiling

D.Code review

AnswerC

Profiling tools track resource usage, including memory allocation, to identify leaks.

Why this answer

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

Exam trap

The trap here is that candidates confuse debugging (step-by-step logic inspection) with profiling (runtime performance and memory analysis), assuming any performance issue can be solved by stepping through code, but memory leaks require heap analysis tools.

How to eliminate wrong answers

Option A is wrong because unit testing validates individual code units for correctness, not runtime memory usage patterns; it cannot detect a memory leak that manifests over time. Option B is wrong because debugging is used to step through code logic and inspect variables at a specific point, but it does not provide continuous memory allocation statistics or identify unreleased objects. Option D is wrong because code review involves manually examining source code for logical errors or style issues, but it cannot reveal runtime memory behavior such as objects that are inadvertently held in memory.

Full explanation →

214

MCQhard

A database analyst is designing a schema for a library system. Each book can have multiple authors, and each author can write multiple books. Which relationship type should be used?

A.Many-to-one

B.One-to-many

C.Many-to-many

D.One-to-one

AnswerC

Many-to-many is correct because a book can have multiple authors and an author can write multiple books, requiring a junction table.

Why this answer

The correct relationship is many-to-many because a book can have multiple authors and an author can write multiple books. In database schema design, this requires a junction table (also known as a linking or associative table) to resolve the many-to-many relationship into two one-to-many relationships, ensuring referential integrity and avoiding data redundancy.

Exam trap

The trap here is that candidates often confuse one-to-many with many-to-many when the problem statement mentions 'multiple' on one side only, but the key is that both entities can have multiple related records, which requires a junction table.

How to eliminate wrong answers

Option A is wrong because many-to-one is the inverse of one-to-many and implies that many books could be associated with a single author, but it fails to capture the scenario where a book has multiple authors. Option B is wrong because one-to-many would mean one book can have many authors, but it does not allow an author to write many books, which violates the bidirectional requirement. Option D is wrong because one-to-one would mean each book has exactly one author and each author writes exactly one book, which directly contradicts the given requirement that both sides can have multiple instances.

Full explanation →

215

MCQmedium

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

A.Add a print statement inside the loop

B.Check the loop condition and initial value

C.Reinstall the programming environment

D.Comment out all lines except the loop

AnswerB

A wrong condition or initialization can cause off-by-one errors.

Why this answer

Option B is correct because checking the loop's condition is the most direct way to verify the iteration count. Option A (commenting out code) may hide the issue; Option C (adding print statements) is useful but condition check is more fundamental; Option D (reinstalling) is overkill.

Full explanation →

216

MCQhard

A company wants to deploy a custom application to 500 employees. The IT team needs to ensure each workstation has the same version and configuration. Which deployment method should be used?

A.Use Group Policy to publish the application to all workstations.

B.Place the installer on a network share and instruct users to run it.

C.Distribute USB drives with the installer to each employee.

D.Email the installer to all employees.

AnswerA

Group Policy allows centralized deployment and configuration management.

Why this answer

Group Policy (GPO) allows centralized deployment of software via Active Directory, ensuring all workstations receive the same version and configuration automatically during startup or user logon. This method uses the Windows Installer service (MSI) and can assign or publish applications, enforcing consistency without user intervention. It is the only option that guarantees uniform deployment across 500 machines with minimal administrative overhead.

Exam trap

The trap here is that candidates may think a network share (Option B) is centralized enough, but they overlook that without Group Policy enforcement, users must manually run the installer, breaking the requirement for consistent version and configuration across all workstations.

How to eliminate wrong answers

Option B is wrong because placing the installer on a network share and instructing users to run it relies on manual user action, which risks inconsistent versions, configuration drift, and non-compliance if users skip or delay installation. Option C is wrong because distributing USB drives to each employee is impractical for 500 workstations, introduces version control issues (e.g., outdated media), and lacks centralized management or enforcement. Option D is wrong because emailing the installer is insecure (potential for attachment blocking, malware risks), unreliable (large files may be rejected), and again depends on users manually executing the installer, leading to version and configuration inconsistencies.

Full explanation →

217

MCQhard

Two developers have edited the same file and created different versions. To integrate their changes, which Git operation should they perform?

A.git pull

B.git merge

C.git rebase

D.git commit

AnswerB

git merge combines branches, integrating changes.

Why this answer

The correct answer is A: git merge. Merging combines different branches. git rebase (B) rewrites commit history. git pull (C) fetches and merges, but the question specifically asks for the operation to integrate changes. git commit (D) saves local changes.

Full explanation →

218

MCQmedium

A company's IT department is developing a new internal tool to track employee leave requests. The development team is using a waterfall model. After the requirements phase, they create a detailed design document. During implementation, a key stakeholder requests a new feature that requires a change to the database schema. The team is reluctant to accommodate the change because they have already started coding. Which approach should the team take to best handle this situation while adhering to the waterfall model?

A.Switch to an agile methodology to handle the change.

B.Immediately stop coding and incorporate the change into the design document.

C.Complete the current phase, then formally review and update the design document before moving to testing.

D.Ignore the request because it wasn't in the original requirements.

AnswerC

This follows waterfall's phase-gate approach, allowing changes between phases.

Why this answer

In waterfall, changes are typically handled at phase boundaries. Completing the current implementation phase, then formally updating the design before testing allows structured change control. Ignoring the request or stopping immediately disrupts the process.

Switching to agile mid-project is not practical.

Full explanation →

219

MCQeasy

Based on the exhibit, what will be the last value output?

A.6

B.5

C.10

D.1

AnswerB

5 is output when count=5, then count becomes 6 and loop terminates.

Why this answer

The loop runs while count <= 5. It outputs 1,2,3,4,5. The last output is 5.

Then count becomes 6 and loop exits. 1 is first, 6 is not output because loop ends.

Full explanation →

220

Multi-Selecthard

Which THREE of the following are common methods for securing a wireless network?

Select 3 answers

A.Implementing MAC address filtering

B.Disabling SSID broadcast

C.Enabling WEP encryption

D.Using WPA2 encryption

E.Changing the default IP address range

AnswersA, B, D

Restricts access to allowed devices.

Why this answer

MAC address filtering is a common method for securing a wireless network because it allows the administrator to create an allowlist of specific MAC addresses that are permitted to connect to the access point. This prevents unauthorized devices from associating with the network, even if they know the SSID and password. However, it is not foolproof, as MAC addresses can be spoofed using tools like `macchanger`.

Exam trap

The trap here is that candidates often think WEP is still acceptable for security because it was once a standard, but the exam expects you to know it is deprecated and easily broken, while changing the IP range is a common misconception that offers no real security benefit.

Full explanation →

221

MCQmedium

Given the following pseudocode that calculates the average of a list of numbers, which error will occur? SET total = 0 SET count = 0 FOR EACH number IN list total = total + number count = count + 1 ENDFOR SET average = total / count OUTPUT average

A.Compile-time error

B.Logic error

C.Syntax error

D.Runtime error

AnswerD

If the list is empty, division by zero causes a runtime error.

Why this answer

If the list is empty, count remains 0, and division by zero occurs. No syntax error exists. A logic error would produce wrong results but division by zero is a runtime error.

Compile-time errors are not relevant to pseudocode.

Full explanation →

222

MCQmedium

A user reports that a previously working word-processing application now crashes immediately after launch. The user has not installed any new software recently. Which of the following should the user try first?

A.Run a system file checker (SFC) scan.

B.Disable the antivirus software.

C.Run the application as an administrator.

D.Reinstall the operating system.

AnswerA

SFC can repair corrupted system files that may be causing the crash.

Why this answer

A system file checker (SFC) scan is the correct first step because it verifies and repairs protected system files, including those that the word-processing application may depend on. Since the application previously worked and no new software was installed, the most likely cause is a corrupted or missing system file, which SFC can detect and restore from the Windows Component Store.

Exam trap

The trap here is that candidates often jump to disabling antivirus or reinstalling the OS, but the CompTIA FC0-U61 exam emphasizes starting with the least invasive and most targeted troubleshooting step, which is checking system file integrity via SFC.

How to eliminate wrong answers

Option B is wrong because disabling antivirus software is a troubleshooting step for false positives or blocked execution, but it does not address the underlying cause of a crash immediately after launch, which is more likely a corrupted system file. Option C is wrong because running the application as an administrator only elevates permissions and would not fix a crash caused by a damaged system file or missing dependency. Option D is wrong because reinstalling the operating system is an extreme and unnecessary measure that should only be considered after all other less invasive troubleshooting steps have failed.

Full explanation →

223

MCQeasy

Which of the following is an example of an input device?

A.Printer

B.Monitor

C.Keyboard

D.Speaker

AnswerC

A keyboard allows user input.

Why this answer

A keyboard is an input device because it allows users to send data and commands to a computer by pressing keys, which are converted into electrical signals that the system processes. Input devices are defined as hardware components that provide data and control signals to a computer, and the keyboard is a classic example of this category.

Exam trap

The trap here is that candidates often confuse input and output devices by focusing on the device's function in a general sense (e.g., a printer 'inputs' paper) rather than the direction of data flow relative to the computer, leading them to select output devices like monitors or printers as input devices.

How to eliminate wrong answers

Option A is wrong because a printer is an output device that receives data from a computer to produce a physical copy, not an input device that sends data to the computer. Option B is wrong because a monitor is an output device that displays visual information from the computer, not an input device that provides data to the system. Option D is wrong because a speaker is an output device that converts electrical audio signals into sound waves, not an input device that captures or sends data to the computer.

Full explanation →

224

MCQeasy

Which security principle is being applied?

A.Least privilege

B.Need to know

C.Separation of duties

D.Defense in depth

AnswerA

Least privilege grants only the minimal necessary access; this rule restricts SSH to only the required subnet.

Why this answer

The principle of least privilege ensures that users or systems are granted only the minimum permissions necessary to perform their tasks. In this scenario, applying least privilege would restrict access rights to only what is required, reducing the attack surface and limiting potential damage from compromised accounts or insider threats.

Exam trap

CompTIA often tests least privilege by presenting a scenario where a user has more access than needed, and candidates confuse it with 'need to know'—the trap is that need to know applies to data access based on job necessity, while least privilege applies to all permissions (including system functions and files).

How to eliminate wrong answers

Option B (Need to know) is wrong because it focuses on restricting access to information based on whether it is necessary for a specific job function, rather than limiting overall permissions; it is a subset of least privilege but not the primary principle here. Option C (Separation of duties) is wrong because it divides critical tasks among multiple individuals to prevent fraud or error, not to minimize individual permissions. Option D (Defense in depth) is wrong because it involves layering multiple security controls (e.g., firewalls, antivirus, encryption) to protect assets, not specifically limiting user rights.

Full explanation →

225

MCQmedium

A database administrator needs to modify the 'Phone' column in the 'Employees' table to allow up to 15 characters. Which SQL statement should the administrator use?

A.CREATE TABLE Employees (Phone VARCHAR(15));

B.ALTER TABLE Employees ALTER COLUMN Phone VARCHAR(15);

C.UPDATE Employees SET Phone = VARCHAR(15);

D.INSERT INTO Employees (Phone) VALUES ('123456789012345');

AnswerB

This changes the column's data type to allow up to 15 characters.

Why this answer

The ALTER TABLE statement is used to modify an existing table's structure, and the ALTER COLUMN clause specifically changes a column's data type or size. Option B correctly uses ALTER TABLE Employees ALTER COLUMN Phone VARCHAR(15) to change the Phone column to allow up to 15 characters, which is the standard SQL syntax for this operation.

Exam trap

CompTIA often tests the distinction between DDL (ALTER TABLE) and DML (UPDATE, INSERT) commands, trapping candidates who confuse modifying table structure with modifying data.

How to eliminate wrong answers

Option A is wrong because CREATE TABLE is used to create a new table, not to modify an existing one, and it would attempt to create a duplicate table or fail if the table already exists. Option C is wrong because UPDATE is a Data Manipulation Language (DML) statement used to modify existing row data, not to change the column's schema or data type; VARCHAR(15) is not a valid value for an UPDATE statement. Option D is wrong because INSERT INTO adds a new row of data to the table, not to alter the column definition, and it would simply insert a specific phone number without changing the column's maximum length.

Full explanation →

CompTIA ITF+ FC0-U61 (FC0-U61) — Questions 151–225