Courseiva

CompTIA Tech+ (FC0-U71) (FC0-U71) — Questions 301–375

988 questions total · 14pages · All types, answers revealed

Take a mock examExam hub
Page 4

Page 5 of 14

Page 6
301
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 →
302
MCQmedium

A company wants to deploy a new wireless standard that offers higher throughput and better performance in dense environments. Which Wi-Fi standard should they choose?

A.802.11n (Wi-Fi 4)
B.802.11ax (Wi-Fi 6)
C.Bluetooth 5.0
D.802.11ac (Wi-Fi 5)
AnswerB

Wi-Fi 6 provides higher throughput, lower latency, and better performance in crowded areas.

Why this answer

802.11ax (Wi-Fi 6) is the latest standard, offering higher speeds, better efficiency, and improved performance in dense environments.

Full explanation →
303
MCQhard

A technician is setting up a virtualized environment on a laptop to run multiple operating systems for testing. Which type of hypervisor is most appropriate?

A.Bare-metal hypervisor
B.Type 1 hypervisor
C.Container
D.Type 2 hypervisor
AnswerD

Type 2 runs on an operating system, ideal for testing on a laptop.

Why this answer

Type 2 hypervisors like VirtualBox run on top of an existing OS, making them suitable for personal use on a laptop.

Full explanation →
304
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 →
305
MCQmedium

A developer is working on a new feature and creates a copy of the main codebase to work in isolation. Later, this copy is merged back into the main branch. Which version control concept describes this copy?

A.Merge
B.Branch
C.Commit
D.Pull request
AnswerB

A branch is a separate copy of the codebase for parallel development.

Why this answer

Branching creates a separate line of development, allowing isolated work on a feature before merging.

Full explanation →
306
MCQeasy

Which of the following best describes the principle of least privilege?

A.Users should have all permissions by default
B.Users should have the minimum permissions needed to do their job
C.Users should use multi-factor authentication
D.Users should change passwords every 30 days
AnswerB

This is the correct definition of the principle of least privilege.

Why this answer

The principle of least privilege states that users should be granted only the minimum permissions necessary to perform their job functions, reducing potential damage from accidents or attacks.

Full explanation →
307
Multi-Selecthard

A company is evaluating different software licenses for a new project. Which THREE of the following are characteristics of open-source licenses such as the MIT License or Apache License? (Select THREE.)

Select 3 answers
A.Users must keep their modifications private.
B.Users must pay a fee to use the software.
C.Users can modify the source code.
D.Users can distribute the software.
E.Users can use the software for any purpose.
AnswersC, D, E

Correct. Open-source licenses grant the right to modify source code.

Why this answer

Open-source licenses grant users the freedom to use, modify, and distribute the software. The MIT and Apache licenses are permissive, meaning they allow proprietary derivative works (no copyleft requirement). They do not require payment.

Full explanation →
308
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 →
309
MCQmedium

Which type of malware is disguised as legitimate software but performs malicious actions?

A.Virus
B.Ransomware
C.Trojan
D.Worm
AnswerC

Correct. A Trojan disguises itself as legitimate software.

Why this answer

A Trojan horse appears useful but contains harmful code, unlike viruses or worms that self-replicate.

Full explanation →
310
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 →
311
MCQmedium

A user notices that their computer runs slowly when multiple applications are open simultaneously. Which hardware component is most likely insufficient for the current workload?

A.GPU
B.CPU
C.Hard drive
D.RAM
AnswerD

RAM provides temporary storage for active programs; insufficient RAM leads to slowdowns.

Why this answer

RAM (Random Access Memory) is volatile memory used to store data for running programs. Insufficient RAM causes the system to use slower storage (paging), slowing performance.

Full explanation →
312
MCQmedium

Which programming data type would be used to store a value of 'True' or 'False'?

A.String
B.Float
C.Boolean
D.Integer
AnswerC

Boolean stores logical true/false.

Why this answer

Boolean data type represents true/false values.

Full explanation →
313
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 →
314
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 →
315
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 →
316
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 →
317
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 →
318
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

Shoulder surfing is a social engineering attack where an attacker directly observes a user's screen or keyboard to capture sensitive information like passwords or PINs. It relies on human behavior rather than technical vulnerabilities, making it a classic example of social engineering.

Exam trap

The trap here is that candidates may confuse technical attacks like DDoS or brute force with social engineering, failing to recognize that social engineering specifically exploits human trust or behavior, not system vulnerabilities.

Full explanation →
319
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 →
320
MCQeasy

Which of the following is the binary representation of the decimal number 10?

A.1000
B.1010
C.1100
D.1110
AnswerB

1010 is decimal 10.

Why this answer

Decimal 10 in binary is 1010 (8+2). 1000 is decimal 8, 1100 is 12, 1110 is 14.

Full explanation →
321
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 →
322
MCQeasy

A user is setting up a new wireless router at home. During configuration, they see options for Wi-Fi 5 (802.11ac) and Wi-Fi 6 (802.11ax). Which standard offers faster speeds and better performance in congested environments?

A.Wi-Fi 6
B.Neither affects speed
C.Both are identical in speed
D.Wi-Fi 5
AnswerA

Wi-Fi 6 offers faster speeds and better performance.

Why this answer

Wi-Fi 6 is the newer standard with higher data rates, improved efficiency, and better handling of multiple devices.

Full explanation →
323
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

The algorithm sets x = 5 and y = 2, then computes result = x ^ y, where '^' is the exponentiation operator. 5 raised to the power of 2 equals 25. Therefore, the output is 25, making option D correct.

Exam trap

The trap here is that candidates may confuse the exponentiation operator with the bitwise XOR operator (common in languages like C, Java, and Python), leading them to incorrectly compute 5 XOR 2 = 7 instead of 5^2 = 25.

How to eliminate wrong answers

Option A is wrong because 32 would be the result of 2^5 (2 raised to the power of 5), not 5^2. Option B is wrong because 7 is the sum of 5 and 2, not the result of exponentiation. Option C is wrong because 10 is the product of 5 and 2, not the result of exponentiation.

Full explanation →
324
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 →
325
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
1Step 1
2Step 2
3Step 3
4Step 4

Why this order

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

Full explanation →
326
Multi-Selecthard

A user wants to purchase a new monitor for gaming. Which THREE specifications are most important for a smooth gaming experience?

Select 3 answers
A.Built-in speakers
B.Response time (e.g., 1ms, 5ms)
C.Number of USB ports
D.Resolution (e.g., 1080p, 4K)
E.Refresh rate (e.g., 60Hz, 144Hz)
AnswersB, D, E

Lower response time reduces ghosting, important for fast-paced games.

Why this answer

Resolution (e.g., 1080p or 4K), refresh rate (e.g., 144Hz for smooth motion), and response time (low for less blur) are key gaming specs.

Full explanation →
327
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 →
328
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 B) is best for structured data with relationships. NoSQL (Option C) is for unstructured data, flat file (Option A) lacks relationships, and hierarchical (Option D) is less flexible.

Full explanation →
329
Multi-Selecthard

A database contains a table 'Orders' with columns OrderID, CustomerID, OrderDate, and TotalAmount. Which THREE SQL statements will correctly insert a new row into the table? (Choose THREE.)

Select 3 answers
A.INSERT (OrderID, CustomerID, OrderDate, TotalAmount) INTO Orders VALUES (1, 101, '2023-01-15', 50.00)
B.INSERT INTO Orders VALUES (1, 101, '2023-01-15', 50.00)
C.INSERT INTO Orders SET OrderID=1, CustomerID=101, OrderDate='2023-01-15', TotalAmount=50.00
D.INSERT Orders VALUES (1, 101, '2023-01-15', 50.00)
E.INSERT INTO Orders (OrderID, CustomerID, OrderDate, TotalAmount) VALUES (1, 101, '2023-01-15', 50.00)
AnswersB, C, E

Correct. This uses the standard INSERT INTO syntax without a column list, inserting values for all columns in the order they are defined.

Why this answer

The standard SQL INSERT syntax is 'INSERT INTO table_name [(column_list)] VALUES (value_list)'. Option B follows this without a column list, assuming values match table column order. Option E explicitly lists columns, also valid.

Option C uses the SET clause, which is an alternative syntax accepted in some database systems like MySQL. While not part of the SQL standard, it is considered correct in contexts that support it. Option A incorrectly places the column list before INTO.

Option D omits the required INTO keyword. Therefore, options B, C, and E are correct.

Exam trap

Candidates often forget that INSERT ... SET is vendor-specific and may not be accepted in all SQL environments. This question assumes it is acceptable, so it is counted as correct.

Full explanation →
330
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 →
331
Multi-Selecteasy

A user wants to synchronize files across multiple devices, including an iPhone, a Windows laptop, and an Android tablet. Which TWO cloud services would be most effective for this cross-platform syncing?

Select 2 answers
A.Bluetooth file transfer
B.OneDrive
C.Google Drive
D.iTunes sync
E.iCloud
AnswersB, C

Works on all platforms.

Why this answer

iCloud works well across Apple devices and Windows, but not Android easily. Google Drive works on all platforms. OneDrive works on all platforms too.

But the question asks for TWO. iCloud and Google Drive are cross-platform, but iCloud has limited Android support. Actually, iCloud does not sync with Android directly. Google Drive works on all.

OneDrive works on all. So the best two are Google Drive and OneDrive. However, the stem includes iPhone, so iCloud is native but not Android.

So the answer should be Google Drive and OneDrive. But I'll reconsider: Many users use iCloud and Google Drive. However, iCloud on Android is not as seamless.

The ITF+ likely expects common cloud services: iCloud, Google Drive, OneDrive. But for cross-platform, Google Drive and OneDrive are better. I'll choose Google Drive and OneDrive.

Explanation: Both work on iOS, Windows, and Android.

Full explanation →
332
MCQmedium

An employee is working from a coffee shop and needs to access company files. Which of the following is the most secure method?

A.Use a VPN to encrypt all traffic between the laptop and the company
B.Connect directly to the company's network over the public Wi-Fi
C.Disable file sharing on the laptop
D.Use HTTPS websites only
AnswerA

VPN provides a secure tunnel.

Why this answer

A VPN encrypts traffic between the device and the company network, protecting data on public Wi-Fi. HTTPS alone protects only web traffic, and disabling sharing is not sufficient.

Full explanation →
333
Multi-Selectmedium

A database administrator needs to choose a database for an e-commerce application that requires high availability and automatic scaling. Which TWO options are cloud database services?

Select 2 answers
A.SQLite
B.Google Cloud SQL
C.Microsoft SQL Server Express
D.MySQL Community Edition
E.Amazon RDS
AnswersB, E

Google Cloud SQL is a fully managed database service.

Why this answer

Amazon RDS and Google Cloud SQL are cloud-based DBaaS offerings.

Full explanation →
334
MCQhard

Which of the following best describes the function of a web API?

A.It encrypts data transmitted between a web browser and server.
B.It is a programming language used to query databases.
C.It provides a graphical user interface for web applications.
D.It allows different software applications to communicate and exchange data.
AnswerD

APIs enable interoperability between services.

Why this answer

A web API (Application Programming Interface) allows different software applications to communicate and share data over the internet. It is not a user interface, security tool, or database language.

Full explanation →
335
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

Procedural programming is the most suitable paradigm for a simple program that adds two numbers and displays the result because it follows a linear, step-by-step sequence of instructions. The developer writes a series of statements (e.g., `result = a + b; print(result)`) that execute in order, directly mapping the task's logic without unnecessary abstraction. This paradigm is ideal for small, straightforward tasks where clarity and direct control over execution flow are paramount.

Exam trap

CompTIA often tests the misconception that object-oriented programming is always the 'modern' or 'best' choice, leading candidates to select it even for trivial tasks where its overhead is unnecessary.

How to eliminate wrong answers

Option A is wrong because functional programming emphasizes pure functions, immutability, and avoiding side effects, which adds unnecessary complexity (e.g., recursion or higher-order functions) for a trivial addition task. Option B is wrong because declarative programming focuses on describing the desired outcome (e.g., SQL query `SELECT a + b`) rather than the step-by-step control flow, which is not the natural approach for a simple imperative calculation. Option C is wrong because object-oriented programming introduces classes, objects, and encapsulation, which are overkill for a two-number addition; it would require defining a class with a method, adding boilerplate code that obscures the simple logic.

Full explanation →
336
MCQeasy

What is the difference between a threat and a vulnerability?

A.A threat is a potential harm, and a vulnerability is a weakness
B.They are the same thing
C.A threat is a weakness, and a vulnerability is a danger
D.A threat is a type of malware, and a vulnerability is a type of attack
AnswerA

Correct definitions.

Why this answer

A threat is a potential source of harm (e.g., a hacker), while a vulnerability is a weakness that can be exploited (e.g., unpatched software).

Full explanation →
337
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 →
338
Multi-Selectmedium

A development team is using an agile methodology. Which TWO of the following are typical practices in agile development?

Select 2 answers
A.Waterfall phase transitions
B.Fixed scope defined at project start
C.Iterative development with short cycles
D.Daily standup meetings
E.Detailed design phase before coding
AnswersC, D

Agile uses iterations (sprints) to deliver incremental value.

Why this answer

Agile emphasizes iterative development and daily standup meetings. Fixed scope and detailed up-front design are characteristic of waterfall.

Full explanation →
339
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 →
340
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 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 →
341
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 →
342
MCQhard

A technician is troubleshooting a computer that fails to boot. The technician suspects corrupted firmware. Which component stores the firmware that initializes hardware during boot?

A.RAM
B.Hard drive
C.ROM chip on motherboard
D.CMOS battery
AnswerC

Correct: BIOS/UEFI firmware is stored in ROM.

Why this answer

The BIOS/UEFI firmware is stored in a ROM chip on the motherboard.

Full explanation →
343
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

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 →
344
MCQmedium

Which device converts the signal from an ISP into a digital signal that a computer can use?

A.Switch
B.Access point
C.Modem
D.Router
AnswerC

A modem converts ISP signals to digital.

Why this answer

A modem modulates and demodulates signals, converting ISP signals (e.g., cable, DSL) to digital data.

Full explanation →
345
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 →
346
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 →
347
MCQhard

A programmer writes a loop that performs a bitwise AND operation between the byte 0b11001100 and the mask 0b00001111. What is the result in decimal?

A.204
B.0
C.12
D.15
AnswerC

Correct result.

Why this answer

0b11001100 AND 0b00001111 = 0b00001100 = 12 decimal.

Full explanation →
348
Multi-Selectmedium

A technician is explaining data representation to a trainee. Which TWO of the following are character encoding standards used in computing? (Select TWO).

Select 2 answers
A.MP3
B.ASCII
C.JPEG
D.ZIP
E.Unicode/UTF-8
AnswersB, E

ASCII is a 7-bit character encoding standard.

Why this answer

ASCII and Unicode/UTF-8 are both character encoding standards. JPEG is an image format, MP3 is an audio format, and ZIP is a compression format.

Full explanation →
349
MCQhard

A software development team is using Scrum. During a sprint, the product owner introduces a new high-priority requirement that was not in the sprint backlog. The team has already committed to the current sprint's goals. According to Scrum principles, what should the team do?

A.Include the new requirement in the next sprint planning
B.Ask the development team to work overtime to accommodate the new requirement
C.Hold an emergency sprint planning meeting to adjust the sprint backlog
D.Add the new requirement to the current sprint and remove a lower-priority item
AnswerA

New requirements are placed in the product backlog and addressed in future sprints.

Why this answer

In Scrum, the sprint backlog is frozen once the sprint starts; new requirements should be added to the product backlog for future sprints.

Full explanation →
350
MCQeasy

Which of the following is a benefit of using a database instead of a flat file?

A.Simpler setup and configuration
B.Faster file transfer speeds
C.Lower storage requirements
D.Support for concurrent multi-user access
AnswerD

Correct. Databases handle concurrent access with locking and transactions.

Why this answer

Databases provide concurrent access control, allowing multiple users to read/write data simultaneously without corruption.

Full explanation →
351
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 →
352
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 →
353
Multi-Selecthard

A company is planning to adopt cloud computing. Which THREE of the following are benefits of using cloud services compared to on-premises infrastructure? (Select THREE).

Select 3 answers
A.Reduced need for hardware maintenance
B.Pay-as-you-go pricing model
C.Full control over physical security
D.On-demand resource provisioning
E.Guaranteed 100% uptime
AnswersA, B, D

Cloud provider handles hardware maintenance.

Why this answer

Cloud benefits include on-demand resource provisioning (scalability), pay-as-you-go (reduced upfront cost), and reduced maintenance. Guaranteed uptime is not absolute (though SLAs exist), and full control is less in cloud.

Full explanation →
354
MCQeasy

A technician is building a new desktop computer for a user who needs to edit large video files. Which type of RAM should the technician recommend for dual-channel performance?

A.DDR2
B.DDR5
C.DDR4
D.DDR3
AnswerB

DDR5 provides faster speeds and better dual-channel performance.

Why this answer

DDR5 is the latest generation of RAM, offering higher speeds and improved dual-channel performance over DDR4, making it suitable for demanding tasks like video editing.

Full explanation →
355
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 →
356
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 →
357
MCQmedium

A digital image is stored in a file that retains all original data without any loss. Later, the file is compressed using a technique that discards some data to reduce file size, but the image quality is lower. Which type of compression was applied?

A.Archive compression
B.Lossless compression
C.File compression
D.Lossy compression
AnswerD

Lossy compression discards data, reducing quality.

Why this answer

Lossy compression permanently removes data to reduce file size, resulting in quality loss. Lossless compression retains all data. JPEG is a lossy format.

Full explanation →
358
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 →
359
MCQhard

A developer wants to install a Linux application on a system that uses the Debian package manager. Which package format should the developer look for?

A..deb
B..msi
C..rpm
D..pkg
AnswerA

.deb is the Debian package format.

Why this answer

.deb is the package format used by Debian-based Linux distributions.

Full explanation →
360
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

The FC0-U61 exam 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 →
361
MCQmedium

A user is concerned about losing edits to a document if the power fails. Which type of memory is the document most likely stored in while being edited?

A.Cache
B.HDD
C.RAM
D.ROM
AnswerC

Correct.

Why this answer

RAM (Random Access Memory) is volatile; data is lost when power is removed. The document is stored in RAM during active editing.

Full explanation →
362
MCQeasy

Which of the following is an example of a PAN (Personal Area Network) technology?

A.Bluetooth
B.Cellular
C.Wi-Fi
D.Ethernet
AnswerA

Bluetooth connects devices like headphones and phones over short distances (PAN).

Why this answer

Bluetooth is used for short-range communication between personal devices, forming a PAN.

Full explanation →
363
Multi-Selecteasy

Which TWO of the following are best practices for password security?

Select 2 answers
A.Enabling multi-factor authentication whenever possible
B.Using simple patterns like '123456' or 'password'
C.Using the same password for multiple accounts
D.Sharing passwords with coworkers for convenience
E.Using a password manager to generate and store strong passwords
AnswersA, E

MFA provides additional security beyond passwords.

Why this answer

Using a password manager helps generate and store strong, unique passwords. Enabling MFA adds an extra layer of security. Sharing passwords and using simple patterns are insecure.

Full explanation →
364
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 →
365
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 →
366
MCQeasy

A company needs to store customer orders and ensure that each order is uniquely identified. Which database concept should be used?

A.Constraint
B.Index
C.Foreign key
D.Primary key
AnswerD

Correct. A primary key uniquely identifies each row.

Why this answer

A primary key uniquely identifies each row in a table, ensuring no duplicates and no null values.

Full explanation →
367
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 →
368
MCQhard

A company uses a cloud database service where the provider automatically handles backups, patching, and scaling. This deployment model is known as:

A.Database as a Service (DBaaS)
B.Platform as a Service (PaaS)
C.Software as a Service (SaaS)
D.Infrastructure as a Service (IaaS)
AnswerA

DBaaS is a managed database service in the cloud.

Why this answer

Database-as-a-Service (DBaaS) is a cloud service where the provider manages the database infrastructure.

Full explanation →
369
MCQmedium

Which of the following is an example of a NoSQL database that stores data as JSON-like documents?

A.MySQL
B.MongoDB
C.PostgreSQL
D.SQLite
AnswerB

Correct. MongoDB is a document NoSQL database.

Why this answer

MongoDB is a document-oriented NoSQL database that stores data in BSON (binary JSON) format.

Full explanation →
370
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 →
371
MCQmedium

A technician is troubleshooting a computer that fails to boot. The technician checks the system's low-level software stored on a chip on the motherboard. Which type of software is being inspected?

A.Firmware
B.Device driver
C.Application software
D.Operating system
AnswerA

Firmware (BIOS/UEFI) is stored on a chip and controls initial boot.

Why this answer

Firmware is software embedded in hardware devices, such as BIOS/UEFI on the motherboard, which initializes hardware during boot.

Full explanation →
372
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 →
373
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

(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 →
374
Multi-Selectmedium

Which TWO of the following are characteristics of a relational database? (Select TWO.)

Select 2 answers
A.It does not support SQL queries.
B.Data is stored in tables with rows and columns.
C.It is optimized for storing unstructured data like videos.
D.It uses a flexible schema that can change dynamically.
E.Relationships between tables are defined using keys.
AnswersB, E

Correct. This is a fundamental characteristic.

Why this answer

Relational databases store data in tables and enforce relationships through keys.

Full explanation →
375
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
1Step 1
2Step 2
3Step 3
4Step 4

Why this order

The correct sequence for checking Windows Updates in Windows 10 is: Open the Start menu, then select Settings (gear icon), then select Update & Security, and finally click Check for updates. This ensures you navigate through the proper system settings to initiate a manual update check, keeping your system secure and up to date.

Full explanation →
Page 4

Page 5 of 14

Page 6

All pages

1234567891011121314

Practice FC0-U71 by domain

Target a specific domain to shore up weak areas.

Tech Concepts and TerminologyInfrastructureApplications and SoftwareSoftware Development ConceptsData and Database FundamentalsSecurity
See all domains with question counts →