CompTIA ITF+ FC0-U61 (FC0-U61) — Questions 526600

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

Page 7

Page 8 of 14

Page 9
526
Multi-Selecteasy

Which TWO of the following are features of productivity software?

Select 2 answers
A.Disk defragmentation
B.Spell check
C.Network firewall
D.Virus scanning
E.Conditional formatting
AnswersB, E

Spell check is a common feature in word processors.

Why this answer

Spell check is a core feature of productivity software such as word processors and office suites. It automatically compares words against a built-in dictionary to identify and suggest corrections for misspellings, enhancing document accuracy and user efficiency.

Exam trap

CompTIA often tests the distinction between system utilities (defragmentation, firewall, antivirus) and application-level features (spell check, conditional formatting) to see if candidates confuse operating system tools with productivity software capabilities.

527
MCQmedium

A developer writes the following pseudocode for a process that finds the largest number in a list: SET max = first element FOR each number in list IF number > max THEN SET max = number END IF ENDFOR OUTPUT max What programming concept does this pseudocode represent?

A.API
B.Algorithm
C.Data structure
D.Flowchart
AnswerB

This is a step-by-step procedure to solve a problem, which defines an algorithm.

Why this answer

An algorithm is a step-by-step procedure to solve a problem. This pseudocode describes a specific algorithm (finding the maximum).

528
MCQeasy

A user reports that their computer is unable to connect to the internet, but other devices on the same network work fine. Which of the following is the MOST likely cause?

A.Router firewall blocking traffic
B.DHCP server failure
C.DNS server misconfiguration
D.Faulty network cable
AnswerD

A faulty cable can cause connectivity loss for a single device.

Why this answer

A faulty network cable can prevent a single computer from connecting to the internet while other devices on the same network work fine. This is because the cable physically connects the computer to the network switch or router, and if it is damaged, the link may fail entirely or cause excessive packet loss, isolating only that device.

Exam trap

The trap here is that candidates often assume network issues are always logical (e.g., DNS or DHCP) and overlook the physical layer, but CompTIA tests the principle that a single-device failure with others working points to a local physical or configuration problem, not a shared infrastructure fault.

How to eliminate wrong answers

Option A is wrong because a router firewall blocking traffic would affect all devices behind the router, not just a single computer, unless specific MAC or IP filtering is configured, which is less common than a physical cable issue. Option B is wrong because a DHCP server failure would prevent all devices from obtaining IP addresses, causing a network-wide connectivity failure, not an isolated one. Option C is wrong because a DNS server misconfiguration would allow the computer to connect to the network and reach IP addresses directly, but domain name resolution would fail; the user reports no internet connectivity at all, not just name resolution issues.

529
MCQmedium

A network administrator wants to automatically assign IP addresses to all devices on the network. Which service should be configured on the server?

A.DNS
B.DHCP
C.HTTP
D.NAT
AnswerB

DHCP dynamically assigns IP addresses and other configuration to devices.

Why this answer

Dynamic Host Configuration Protocol (DHCP) is the correct service because it automatically assigns IP addresses, subnet masks, default gateways, and other network configuration parameters to devices on a network. This eliminates the need for manual static IP configuration and ensures each device receives a unique IP address from a defined pool, preventing address conflicts.

Exam trap

The trap here is that candidates often confuse DHCP with DNS because both are network services, but DNS resolves names to IPs while DHCP assigns IPs to devices.

How to eliminate wrong answers

Option A is wrong because DNS (Domain Name System) resolves human-readable domain names (e.g., www.example.com) to IP addresses; it does not assign IP addresses to devices. Option C is wrong because HTTP (Hypertext Transfer Protocol) is used for transferring web content between clients and servers; it has no role in IP address assignment. Option D is wrong because NAT (Network Address Translation) translates private IP addresses to a public IP address for internet access; it does not automatically assign IP addresses to devices on the local network.

530
MCQhard

An IT manager is evaluating a cloud storage service for backup of critical company data. The manager is concerned about data security and availability. The service offers encryption at rest and in transit, 99.9% uptime SLA, and geo-redundancy. However, the service uses multi-tenancy. Which of the following is a potential concern the manager should address?

A.The uptime SLA is not sufficient
B.The encryption might slow down data transfers
C.The geo-redundancy might cause latency
D.The data might be accessible by other tenants
AnswerD

Multi-tenancy increases the risk of data leakage if proper isolation fails.

Why this answer

The primary concern with multi-tenancy in a cloud storage service is the risk of data isolation failure, where a vulnerability or misconfiguration could allow one tenant to access another tenant's data. Even with strong encryption at rest and in transit, the data must be decrypted for processing, and if the hypervisor or storage layer has a flaw, other tenants could potentially read the decrypted data. This is a well-known security risk in shared infrastructure models like IaaS and PaaS.

Exam trap

The trap here is that candidates may focus on encryption or SLA metrics as the main security concern, overlooking the fundamental risk of data leakage in a shared multi-tenant architecture, which is a core concept in cloud computing security models.

How to eliminate wrong answers

Option A is wrong because a 99.9% uptime SLA (approximately 8.76 hours of downtime per year) is generally considered sufficient for most critical data backup scenarios, and the question does not specify a higher requirement. Option B is wrong because encryption overhead from AES-256 or TLS 1.3 is negligible on modern hardware and does not typically cause noticeable slowdowns for backup data transfers. Option C is wrong because geo-redundancy replicates data asynchronously to a secondary region, and while it may introduce slight write latency, it does not affect read latency for the primary copy and is a standard feature for disaster recovery.

531
MCQmedium

A user reports that a spreadsheet application crashes whenever they try to use a specific macro. The technician needs to identify the cause. Which of the following should the technician check first?

A.The macro code for errors.
B.The version of the operating system.
C.The file format of the spreadsheet.
D.The amount of RAM available.
AnswerA

A bug or error in the macro code can cause the application to crash when executed.

Why this answer

The macro code is the most direct cause of the crash because macros are custom scripts (often VBA) that execute within the application. If the code contains syntax errors, infinite loops, or attempts to access invalid objects, it will cause the application to terminate unexpectedly. Checking the code first follows the principle of isolating the specific change or action that triggers the fault.

Exam trap

The trap here is that candidates may assume a hardware or system-level issue (like RAM or OS version) is the root cause, when the problem is specifically tied to the execution of a single macro, making the macro code the most logical first check.

How to eliminate wrong answers

Option B is wrong because the operating system version is a broad environmental factor that would affect all applications and macros, not just a specific macro in a single spreadsheet. Option C is wrong because the file format (e.g., .xls vs .xlsm) might affect macro enablement or compatibility, but a crash triggered only when running a specific macro points to the macro logic, not the file container. Option D is wrong because insufficient RAM would cause system-wide slowdowns or out-of-memory errors across multiple applications, not a crash isolated to one macro in one spreadsheet.

532
Multi-Selecteasy

A user is printing a large document at home. The printer is an inkjet model. Which TWO consumables will need to be replaced periodically?

Select 2 answers
A.Drum unit
B.Fuser unit
C.Toner cartridge
D.Print head
E.Ink cartridge
AnswersD, E

Print heads can clog or wear out over time.

Why this answer

Inkjet printers use ink cartridges and print heads that wear out. Toner is for laser printers. Paper is consumable but not unique to inkjet.

533
Multi-Selecteasy

Which TWO of the following are examples of database management systems (DBMS)?

Select 2 answers
A.Microsoft SQL Server
B.Python
C.MySQL
D.HTML
E.Linux
AnswersA, C

Microsoft SQL Server is a relational DBMS.

Why this answer

Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It uses Structured Query Language (SQL) to store, retrieve, and manage data in a structured format, making it a core example of a DBMS.

Exam trap

The trap here is that candidates may confuse programming languages or operating systems with database management systems because they are often used together in development stacks, but only software specifically designed to manage databases qualifies as a DBMS.

534
MCQhard

A security analyst notices that a user's computer is running slowly and displaying many pop-up ads. Which type of malware is most likely causing this?

A.Spyware
B.Ransomware
C.Rootkit
D.Adware
AnswerD

Adware displays pop-up ads and can slow down the system.

Why this answer

Adware displays unwanted advertisements and often causes performance issues. Spyware collects information, ransomware encrypts files, and a rootkit hides itself.

535
MCQeasy

Which of the following is a characteristic of a strong password?

A.Contains a combination of uppercase, lowercase, numbers, and symbols
B.Is exactly 8 characters long
C.Uses only lowercase letters
D.Is the same as the username
AnswerA

This meets the criteria for a strong password.

Why this answer

Strong passwords are at least 12 characters long and include a mix of uppercase letters, lowercase letters, numbers, and symbols.

536
MCQhard

Refer to the exhibit. A technician sees an established connection to an external IP on port 443 from PID 3400. What is the most likely purpose of this connection?

A.File sharing over SMB
B.Remote Desktop Protocol (RDP) session
C.Email submission (SMTP)
D.Secure web browsing (HTTPS)
AnswerD

HTTPS uses port 443.

Why this answer

Port 443 is the default port for HTTPS (HTTP over TLS/SSL), which is used for secure web browsing. PID 3400 indicates a specific process, likely a web browser or an application making an encrypted HTTPS connection to an external IP. This matches the purpose of secure web browsing.

Exam trap

The trap here is that candidates may confuse port 443 with other common services like SMB or RDP, or assume any encrypted connection is SSH (port 22), but the question specifically ties port 443 to HTTPS, which is the standard for secure web traffic.

How to eliminate wrong answers

Option A is wrong because SMB (Server Message Block) uses ports 445 (direct SMB over TCP) or 139 (NetBIOS), not port 443. Option B is wrong because RDP uses port 3389 by default, not port 443. Option C is wrong because SMTP (email submission) typically uses port 25 (or 587 for submission), not port 443.

537
Multi-Selectmedium

Which THREE of the following are common methods to acquire software? (Select THREE).

Select 3 answers
A.Install from a USB drive
B.Use software-as-a-service (SaaS)
C.Purchase from a retail store
D.Obtain from an open-source repository
E.Download from a vendor's website
AnswersC, D, E

Retail purchase is a common method to acquire commercial software.

Why this answer

Purchasing software from a retail store is a traditional method of acquiring software, where the user buys a physical copy (e.g., on a DVD or CD-ROM) containing the installation files and a license key. This method provides a tangible medium and often includes a license agreement that grants the user the right to install and use the software on a specified number of devices. It is a common acquisition method, especially for commercial off-the-shelf (COTS) software.

Exam trap

The trap here is confusing the method of software delivery or deployment (e.g., USB drive) with the method of acquisition (how you first obtain the software), leading candidates to incorrectly select 'Install from a USB drive' as a valid acquisition method.

538
Multi-Selecthard

A database administrator needs to retrieve, update, and delete records from a customer table. Which THREE SQL commands are required? (Select THREE.)

Select 3 answers
A.INSERT
B.DELETE
C.UPDATE
D.CREATE
E.SELECT
AnswersB, C, E

Removes records.

Why this answer

SELECT retrieves data, UPDATE modifies existing records, DELETE removes records. INSERT adds new records, but the question specifies retrieve, update, delete.

539
Multi-Selecteasy

A database includes a table called 'Products' with columns: ProductID, ProductName, Price, and Quantity. Which TWO of the following SQL statements correctly insert a new product into the table? (Select TWO.)

Select 2 answers
A.INSERT INTO Products SET ProductID=1, ProductName='Widget'
B.INSERT INTO Products (ProductName, Price) VALUES ('Widget', 9.99, 100)
C.INSERT INTO Products (ProductID, ProductName, Price, Quantity) VALUES (1, 'Widget', 9.99, 100)
D.INSERT INTO Products VALUES (1, 'Widget', 9.99)
E.INSERT INTO Products VALUES (1, 'Widget', 9.99, 100)
AnswersC, E

Correct. This specifies all columns.

Why this answer

The INSERT statement can specify columns explicitly or omit them if values are provided for all columns. Both A and D are valid syntaxes.

540
Multi-Selectmedium

Which THREE of the following are common types of computer networks? (Select three.)

Select 3 answers
A.LAN
B.WAN
C.HDMI
D.USB
E.MAN
AnswersA, B, E

Local Area Network connects devices in a small area.

Why this answer

A LAN (Local Area Network) connects computers within a limited geographic area, such as a home, office, or school, using Ethernet or Wi-Fi. It is one of the most fundamental network types, typically operating at Layer 2 of the OSI model with high data transfer rates and low latency.

Exam trap

The trap here is that candidates confuse physical connectors or cables (HDMI, USB) with network types, but CompTIA tests the distinction between network topologies (LAN, WAN, MAN) and peripheral interfaces.

541
MCQhard

A technician is troubleshooting a computer that fails to boot. Which of the following types of firmware is responsible for initializing hardware and loading the operating system?

A.Operating system kernel
B.BIOS/UEFI
C.Boot loader
D.Device driver
AnswerB

BIOS/UEFI is firmware that performs POST and loads the OS.

Why this answer

BIOS/UEFI is firmware that initializes hardware and boots the OS. The OS itself, boot loader, and device drivers are software loaded later.

542
MCQhard

A development team is using a stack data structure to manage function calls. Which of the following correctly describes the order in which items are removed from a stack?

A.Last-In-First-Out (LIFO)
B.Random order
C.First-In-First-Out (FIFO)
D.Based on priority
AnswerA

Stacks use LIFO order for removal.

Why this answer

A stack follows Last-In-First-Out (LIFO), meaning the most recently added item is removed first.

543
Multi-Selecthard

Which THREE of the following are common features of word processing applications?

Select 3 answers
A.Creating slide shows
B.Spell check
C.Inserting tables into documents
D.Tracking financial transactions
E.Mail merge capability
AnswersB, C, E

Spell check is a standard word processor feature.

Why this answer

Option B is correct because spell check is a standard feature in word processing applications like Microsoft Word or Google Docs. It automatically scans text for spelling errors against a built-in dictionary and often provides suggestions for corrections, helping users produce error-free documents.

Exam trap

The trap here is that candidates may confuse the general productivity software categories, mistakenly associating slide shows or financial tracking with word processing because they are common in office suites, but each belongs to a distinct application type.

544
MCQmedium

A user receives an error message indicating 'insufficient memory' when opening several applications. Which action will most likely resolve the issue?

A.Install more RAM
B.Clear the browser cache
C.Increase virtual memory
D.Defragment the hard drive
AnswerA

Installing additional RAM directly increases the memory available to run applications.

Why this answer

The error message 'insufficient memory' indicates that the system has exhausted its physical RAM capacity while trying to load multiple applications. Installing more RAM directly increases the amount of physical memory available, allowing the operating system to keep more application data in memory without resorting to slower paging. This is the most effective long-term solution for resolving memory exhaustion caused by running several applications simultaneously.

Exam trap

The trap here is that candidates confuse 'insufficient memory' with 'low disk space' or 'slow performance,' leading them to choose clearing the cache or defragmenting the drive, when the error specifically refers to a shortage of RAM (volatile memory) needed to run applications.

How to eliminate wrong answers

Option B is wrong because clearing the browser cache frees disk space used for temporary web files, not system memory (RAM), and does not address the 'insufficient memory' error which is a RAM shortage. Option C is wrong because increasing virtual memory expands the pagefile on disk, which can temporarily alleviate low RAM but relies on much slower disk I/O and does not resolve the underlying physical memory deficit; it may even increase thrashing. Option D is wrong because defragmenting the hard drive reorganizes file fragments to improve disk read/write performance but has no effect on the amount of available RAM or the 'insufficient memory' error.

545
MCQeasy

Which of the following is a primary advantage of using a database instead of a flat file system?

A.Supports concurrent multi-user access with data integrity
B.No need for data validation
C.Data is stored in a single file for easy backup
D.Simpler to set up and maintain
AnswerA

Databases handle concurrent access and maintain data integrity through ACID properties.

Why this answer

Databases provide structured storage, multi-user access, query capabilities, and data integrity, whereas flat files lack concurrent access and query languages.

546
MCQeasy

A user reports that a spreadsheet application crashes every time they try to open a specific file. The file was created in a newer version of the software. What is the most likely cause?

A.The computer does not have enough RAM.
B.The file was saved in a format incompatible with the installed version.
C.The file is corrupted.
D.The user does not have permission to access the file.
AnswerB

Newer file formats may cause crashes in older versions due to unsupported features.

Why this answer

Option B is correct because the most likely cause of a crash when opening a file created in a newer version of the software is a format incompatibility. Newer versions often use updated file formats (e.g., .xlsx vs. .xls in Excel) that older versions cannot parse correctly, leading to application instability or crashes. This is a common scenario in backward compatibility issues, where the installed software lacks the necessary codecs or schema to interpret the file's structure.

Exam trap

The trap here is that candidates often assume file corruption (Option C) is the cause, but the key clue is that the file was created in a newer version, pointing to a format incompatibility rather than data corruption.

How to eliminate wrong answers

Option A is wrong because insufficient RAM typically causes system-wide slowdowns or out-of-memory errors, not a crash specific to opening one particular file; the issue is isolated to that file, not a resource shortage. Option C is wrong because file corruption usually results in error messages like 'file is corrupt and cannot be opened' or data loss, not a consistent crash on every open attempt; the file opens in the newer version, indicating it is structurally valid. Option D is wrong because permission errors generate a specific access-denied message (e.g., 'You do not have permission to open this file') and do not cause the application to crash; the user can open other files, ruling out a permissions issue.

547
Multi-Selectmedium

Which TWO of the following are benefits of using a cloud database service (DBaaS) over an on-premises database?

Select 2 answers
A.No need to manage physical hardware
B.Full control over the operating system
C.Lower latency guaranteed
D.Data is always stored locally
E.Automatic scaling of resources
AnswersA, E

The cloud provider handles hardware maintenance.

Why this answer

DBaaS eliminates the need for hardware management and allows easy scaling of resources on demand.

548
MCQeasy

A small office has a network with all devices connected to a central switch. If one device fails, only that device is affected and the rest of the network continues to function. Which network topology does this describe?

A.Star topology
B.Ring topology
C.Bus topology
D.Mesh topology
AnswerA

Star topology uses a central switch; failure of one node does not affect others.

Why this answer

In a star topology, all devices connect to a central device. A failure in one node does not affect others.

549
Multi-Selecteasy

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

Select 2 answers
A.Adware
B.Spoofing
C.Tailgating
D.Phishing
E.Shoulder surfing
AnswersC, D

Tailgating is a social engineering attack where an unauthorized person follows an authorized individual into a restricted area.

Why this answer

Tailgating (option C) is a social engineering attack where an unauthorized person physically follows an authorized individual into a restricted area, bypassing access controls such as card readers or biometric scanners. This exploits human courtesy or inattention rather than technical vulnerabilities, making it a classic social engineering technique.

Exam trap

The trap here is that candidates often confuse shoulder surfing (a direct observation method) with social engineering, but CompTIA categorizes shoulder surfing as a physical security threat, not a social engineering attack, because it does not involve psychological manipulation or deception of the victim.

550
MCQmedium

A technician is troubleshooting a desktop that does not power on. The power supply fan spins, but there is no display and no beep codes. Which component should the technician check first?

A.RAM
B.Motherboard
C.CPU
D.Power supply
AnswerA

Faulty or loose RAM often prevents booting and can be fixed by reseating.

Why this answer

When the power supply fan spins but there is no display and no beep codes, the system is likely failing the Power-On Self-Test (POST) before it can initialize the video subsystem. RAM is the most common cause of a 'no POST' condition because if the memory is faulty, loose, or incompatible, the motherboard cannot complete the memory initialization step, halting the boot process silently without beeps or display.

Exam trap

The FC0-U61 exam often tests the misconception that a spinning power supply fan guarantees the PSU is fully functional, leading candidates to overlook RAM as the first component to check in a no-POST scenario.

How to eliminate wrong answers

Option B (Motherboard) is wrong because a completely dead motherboard would typically prevent the power supply fan from spinning or cause continuous beep codes, not a silent no-POST state; the fan spinning indicates the motherboard is receiving power and the PSU is functional. Option C (CPU) is wrong because a failed CPU usually results in a specific beep code pattern (e.g., continuous short beeps on AMI BIOS) or the system may power on with fans but no POST, but RAM is far more likely to be the first check due to its higher failure rate and ease of reseating. Option D (Power supply) is wrong because the fan spinning confirms the PSU is delivering at least some power; a faulty PSU would typically cause no fan movement or intermittent power, not a clean spin with no POST.

551
MCQeasy

A user reports that their computer is running slowly and the hard drive activity light is constantly on. The technician checks Task Manager and sees that disk usage is at 100%. What is the most likely cause?

A.Malware infection that is encrypting files in the background
B.Insufficient RAM causing the system to use the hard drive as virtual memory excessively
C.A failing hard drive that needs to be replaced immediately
D.The hard drive is almost full and needs to be defragmented
AnswerB

High disk usage with constant activity often indicates insufficient RAM causing excessive paging.

Why this answer

When RAM is insufficient, the operating system compensates by using a portion of the hard drive as virtual memory (the page file). This causes constant swapping of data between RAM and the disk, resulting in 100% disk usage and a continuously active hard drive light. Task Manager would show high disk usage even if the CPU and memory percentages appear moderate.

Exam trap

The trap here is that candidates often associate 100% disk usage with malware or a failing drive, overlooking the classic symptom of insufficient RAM causing excessive paging to the page file.

How to eliminate wrong answers

Option A is wrong because while a malware encrypting files could cause disk activity, it would typically also show high CPU usage and unusual process names, not consistently 100% disk usage with normal CPU. Option C is wrong because a failing hard drive usually produces clicking noises, bad sectors, or file corruption errors, not sustained 100% disk usage with the drive light constantly on. Option D is wrong because a nearly full hard drive does not inherently cause 100% disk usage; defragmentation is only beneficial for mechanical drives and does not address the root cause of excessive paging.

552
Multi-Selectmedium

Which TWO of the following are examples of open-source software licenses?

Select 2 answers
A.Apple App Store License
B.GNU GPL
C.MIT License
D.Microsoft EULA
E.Adobe EULA
AnswersB, C

The GNU General Public License is a widely used open-source license.

Why this answer

The GNU General Public License (GPL) is a widely used open-source license that grants users the freedom to run, study, share, and modify the software. It requires that any distributed derivative work be licensed under the same GPL terms, ensuring the software remains free and open.

Exam trap

The trap here is that candidates may confuse proprietary licenses (like EULAs) with open-source licenses, or think that any license that allows free download is open-source, ignoring the specific grant of modification and redistribution rights.

553
MCQhard

A small accounting office uses three desktop computers running Windows 10. One computer has become extremely slow over the past week. The user reports that the computer takes a long time to start up and applications are unresponsive. The technician checks Task Manager and sees that physical memory usage is at 95% and the page file is heavily used. The hard drive activity light is solid. The computer has 4GB of RAM and a 1TB HDD with 200GB free. Which course of action should the technician take first to most directly address the performance issue?

A.Increase the page file size
B.Upgrade the RAM to at least 8GB
C.Disable unnecessary startup programs
D.Run a full antivirus scan
AnswerB

Upgrading RAM directly addresses the memory shortage, reducing swapping and improving overall speed.

Why this answer

The system has only 4GB of RAM, and physical memory usage is at 95% with heavy page file utilization. This indicates the computer is thrashing — constantly swapping data between RAM and the slow HDD, causing the solid hard drive activity light and unresponsiveness. Adding more RAM (to at least 8GB) directly reduces reliance on the page file, alleviating the bottleneck and addressing the root cause of the performance issue.

Exam trap

The trap here is that candidates often choose 'Increase the page file size' (Option A) thinking more virtual memory will help, but they fail to recognize that the bottleneck is the speed of the HDD, not the size of the page file, and that adding physical RAM is the only way to reduce paging activity.

How to eliminate wrong answers

Option A is wrong because increasing the page file size would only allocate more space on the already slow HDD for swapping, which does not fix the underlying shortage of physical memory; it may even worsen thrashing. Option C is wrong because disabling startup programs reduces boot time and background load, but the primary symptom here is near-total memory exhaustion (95% usage) and heavy paging, which is a capacity issue, not a startup configuration problem. Option D is wrong while malware can cause high memory usage, the specific evidence of 95% physical memory usage and heavy page file activity on a 4GB system points to insufficient RAM as the most direct cause; an antivirus scan is a secondary step after addressing the obvious hardware limitation.

554
MCQeasy

Refer to the exhibit. A user reports that an application is running slowly. Based on the exhibit, which process is using the most memory?

A.explorer.exe
B.svchost.exe (PID 832)
C.notepad.exe
D.System
AnswerA

explorer.exe uses 30,456 K, the highest memory usage in the list.

Why this answer

The exhibit shows that explorer.exe is using the highest memory value (e.g., 1,234 MB) among the listed processes. In Windows Task Manager, the 'Memory' column displays the current working set in megabytes, and explorer.exe's memory consumption exceeds that of the other processes, making it the correct answer.

Exam trap

The trap here is that candidates often assume svchost.exe or System always consume the most memory because they host critical OS services, but the question requires reading the actual numeric values in the exhibit rather than relying on general assumptions.

How to eliminate wrong answers

Option B (svchost.exe PID 832) is wrong because, while svchost.exe hosts multiple Windows services, its memory usage in the exhibit is lower than explorer.exe. Option C (notepad.exe) is wrong because notepad.exe typically uses minimal memory (often under 10 MB) and is not shown as the highest consumer. Option D (System) is wrong because the System process (NT Kernel & System) usually has a moderate memory footprint, but in the exhibit it is not the top memory user.

555
MCQhard

A file is compressed using a lossless algorithm. Which of the following file types is most likely the result?

A.MP3
B.JPEG
C.PNG
D.ZIP
AnswerC

PNG uses lossless compression.

Why this answer

PNG uses lossless compression. JPEG is lossy. MP3 is lossy audio.

ZIP is a lossless archive format. The question asks for a file type (not archive).

556
MCQeasy

A user reports that their laptop battery drains quickly even when plugged in. What is the most likely cause?

A.The battery is faulty
B.The laptop is set to high performance mode
C.The power adapter is not delivering enough voltage
D.The CPU is overheating
AnswerC

If the adapter is underpowered, the laptop may supplement with battery power, causing drain.

Why this answer

When a laptop battery drains quickly while plugged in, the most likely cause is that the power adapter is not delivering enough voltage or current to simultaneously power the system and charge the battery. This can occur if the adapter is undersized, damaged, or not the original equipment manufacturer (OEM) specification, causing the system to draw power from the battery even when connected to AC power. A faulty battery would typically fail to hold a charge at all, not drain while plugged in.

Exam trap

The trap here is that candidates often assume a battery drain while plugged in must be a battery fault, but the CompTIA FC0-U61 exam tests understanding that the power adapter's output capacity is the first thing to verify in such a scenario.

How to eliminate wrong answers

Option A is wrong because a faulty battery usually results in no charge retention, sudden shutdowns, or failure to power on, not a gradual drain while the AC adapter is connected. Option B is wrong because high performance mode increases power consumption but does not cause the battery to drain when plugged in; the adapter should still supply sufficient power unless it is inadequate. Option D is wrong because CPU overheating triggers thermal throttling to reduce performance and power draw, which would not cause the battery to drain; it is a symptom of cooling failure, not a power delivery issue.

557
Multi-Selecthard

A technician is troubleshooting a computer that cannot connect to the network. Which THREE steps should the technician perform first in the troubleshooting process?

Select 3 answers
A.Reinstall the operating system
B.Check if the network cable is securely connected
C.Verify IP address configuration
D.Check link lights on the network adapter
E.Replace the network interface card
AnswersB, C, D

A loose cable is a common cause; checking it is a first step.

Why this answer

Option B is correct because checking the physical connection is the first step in the CompTIA A+ troubleshooting methodology. A loose or damaged network cable is a common cause of connectivity failure, and verifying it eliminates the simplest issue before moving to software or configuration checks.

Exam trap

The trap here is that candidates may jump to software or hardware replacement steps (like reinstalling the OS or replacing the NIC) without first performing basic physical and configuration checks, which are the foundation of systematic troubleshooting.

558
Multi-Selectmedium

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

Select 2 answers
A.DHCP
B.LAN
C.SaaS
D.VPN
E.IaaS
AnswersC, E

Software as a Service is a cloud service model.

Why this answer

SaaS (Software as a Service) is a cloud computing service model where users access software applications over the internet on a subscription basis, with the provider managing the underlying infrastructure, platform, and application. This model eliminates the need for local installation and maintenance, as seen in services like Google Workspace or Microsoft 365.

Exam trap

The trap here is that candidates confuse network services and protocols (DHCP, VPN) or network types (LAN) with cloud service models, because all are IT infrastructure components but only SaaS and IaaS represent distinct service delivery categories.

559
Multi-Selecthard

Which THREE of the following are advantages of using a cloud database service (DBaaS) over an on-premises database? (Select THREE.)

Select 3 answers
A.No need to manage physical hardware
B.Built-in backup and disaster recovery options
C.Lower latency than on-premises in all cases
D.Automatic scaling based on demand
E.Full control over the operating system
AnswersA, B, D

Correct. The cloud provider handles hardware.

Why this answer

DBaaS provides managed services, automatic scaling, and no hardware management, reducing operational overhead.

560
Multi-Selecteasy

Which TWO of the following are examples of physical security controls?

Select 2 answers
A.A security guard at the entrance
B.A firewall
C.Antivirus software
D.An intrusion detection system
E.A lock on a server room door
AnswersA, E

A security guard is a physical control to prevent unauthorized access.

Why this answer

Physical security controls protect the physical environment and assets.

561
Multi-Selecteasy

Which TWO of the following are examples of output devices?

Select 2 answers
A.Scanner
B.Keyboard
C.Monitor
D.Printer
E.Mouse
AnswersC, D

A monitor displays visual output from the computer.

Why this answer

A monitor is an output device because it receives processed data from the computer's graphics card and displays it visually to the user. Output devices convert electronic signals into human-readable form, such as text, images, or video, which is exactly what a monitor does.

Exam trap

The trap here is that candidates often confuse 'interactive' devices like touchscreen monitors or all-in-one printers as both input and output, but the question specifically asks for output devices, so only devices that exclusively output data (monitor, printer) are correct.

562
MCQmedium

A user wants to connect an external monitor to their laptop. The monitor supports a resolution of 3840x2160 at 60Hz. Which of the following ports on the laptop would be BEST suited for this display?

A.USB 3.0 Type-A
B.DisplayPort
C.VGA
D.HDMI 1.4
AnswerB

DisplayPort supports 4K at 60Hz and higher.

Why this answer

DisplayPort can support 4K at 60Hz. HDMI 1.4 supports 4K at 30Hz, while HDMI 2.0 and Thunderbolt can also work, but DisplayPort is a common and reliable choice.

563
MCQmedium

A technician is converting the decimal number 255 to binary. Which binary value is correct?

A.10000000
B.11111110
C.1111111
D.11111111
AnswerD

Correct: 11111111 equals 255 decimal.

Why this answer

255 in binary is 11111111 (eight 1s).

564
MCQhard

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

A.Interpretation
B.Debugging
C.Compilation
D.Linking
AnswerC

Compilation translates the entire source code into machine code before execution.

Why this answer

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

565
MCQmedium

A company has two office buildings 1.5 km apart and needs to connect their networks with a high-speed, reliable link. Which cabling type is most appropriate?

A.Cat6a
B.Fiber optic
C.Coaxial
D.Cat5e
AnswerB

Fiber optic supports long distances and high bandwidth, ideal for inter-building connections.

Why this answer

Fiber optic cabling is the most appropriate choice for connecting two office buildings 1.5 km apart because it supports high-speed data transmission over long distances (up to several kilometers) with minimal signal loss and immunity to electromagnetic interference (EMI). Unlike copper-based cables, fiber optic uses light pulses to transmit data, making it ideal for reliable, high-bandwidth links between separate buildings.

Exam trap

The trap here is that candidates often overlook the distance limitation of copper cabling (100 meters for twisted-pair) and assume that higher-category cables like Cat6a can magically extend beyond that range, when in fact the 100-meter rule applies regardless of category for Ethernet standards.

How to eliminate wrong answers

Option A is wrong because Cat6a is a copper twisted-pair cable limited to a maximum segment length of 100 meters for high-speed Ethernet (10GBASE-T), making it unsuitable for a 1.5 km link. Option C is wrong because coaxial cable, while capable of longer distances than twisted-pair, typically supports up to 500 meters for 10BASE5 or 185 meters for 10BASE2, and its lower bandwidth and susceptibility to interference make it inadequate for modern high-speed requirements. Option D is wrong because Cat5e is also a copper twisted-pair cable with a maximum effective distance of 100 meters for 1000BASE-T, and it cannot span 1.5 km without repeaters or switches, which would add cost and complexity.

566
MCQmedium

A user wants to save a photo with the highest quality but does not care about file size. Which file format should they use?

A.JPEG
B.ZIP
C.PNG
D.MP3
AnswerC

PNG is lossless, preserving all image data.

Why this answer

Lossless formats like PNG preserve all data, while lossy formats like JPEG reduce quality for smaller size.

567
MCQeasy

Which of the following types of networks covers the largest geographical area?

A.WLAN
B.LAN
C.PAN
D.WAN
AnswerD

WAN covers the largest area, interconnecting LANs over long distances.

Why this answer

A WAN (Wide Area Network) spans large geographic areas, such as cities, countries, or even globally (the Internet).

568
Multi-Selectmedium

A company is implementing physical security measures. Which two of the following are examples of physical security controls? (Select TWO.)

Select 2 answers
A.Enforcing strong passwords
B.Using a firewall
C.Installing antivirus software
D.Locking screens when leaving the desk
E.Shredding sensitive documents
AnswersD, E

Correct. This is a physical security practice.

Why this answer

Locking screens prevent unauthorized viewing, and shredding documents destroys sensitive paper data. Both are physical security.

569
Multi-Selectmedium

An IT technician is setting up a home office network. The technician needs to connect multiple devices to the internet and ensure they can communicate with each other. Which THREE devices are essential for this setup?

Select 3 answers
A.Modem
B.Hub
C.Router
D.Firewall appliance
E.Switch
AnswersA, C, E

Provides connection to the ISP.

Why this answer

A modem connects to the ISP, a router routes traffic between devices and the internet, and a switch connects multiple wired devices within the LAN. A hub is outdated and not essential; a firewall is often integrated into the router.

570
MCQhard

A developer accidentally committed a bug that broke the build. The team wants to undo the commit without losing the commit history. Which Git command should be used?

A.git reset HEAD~1
B.git checkout HEAD~1
C.git revert HEAD
D.git branch -d bugfix
AnswerC

git revert creates a new commit that undoes the changes, keeping history intact.

Why this answer

Option C is correct because `git revert HEAD` creates a new commit that undoes the changes introduced by the most recent commit, preserving the full commit history. This is the only safe way to undo a commit that has already been pushed or shared, as it does not rewrite history.

Exam trap

The trap here is that candidates confuse `git revert` (safe, history-preserving) with `git reset` (destructive, history-rewriting), often choosing `git reset` because it seems simpler, but it violates the requirement to keep the commit history intact.

How to eliminate wrong answers

Option A is wrong because `git reset HEAD~1` moves the branch pointer back one commit, effectively removing the last commit from the branch history; this rewrites history and can cause issues if the commit has already been shared with others. Option B is wrong because `git checkout HEAD~1` detaches the HEAD and switches the working directory to the state of the previous commit, but it does not undo the commit or remove it from the branch history. Option D is wrong because `git branch -d bugfix` deletes a branch named 'bugfix', which does not undo any commit or affect the current branch's history.

571
MCQmedium

A technician is troubleshooting a computer that will not power on. Which of the following should be checked FIRST?

A.Whether the power cable is plugged in
B.The network connection
C.The operating system version
D.The amount of free disk space
AnswerA

The most basic cause is often a loose or unplugged power cable.

Why this answer

The most fundamental requirement for a computer to power on is a stable electrical connection. Checking whether the power cable is plugged in is the first step in the troubleshooting methodology because it eliminates the simplest and most common cause of a no-power condition before moving to more complex diagnostics. Without verifying the power source, any other troubleshooting is premature.

Exam trap

The trap here is that candidates may jump to advanced software or hardware diagnostics (like checking the OS or disk space) without first verifying the most basic physical layer—the power connection—which is the cornerstone of the CompTIA troubleshooting methodology.

How to eliminate wrong answers

Option B is wrong because the network connection is irrelevant to the computer's ability to power on; a computer can boot and operate without any network connectivity. Option C is wrong because the operating system version is a software attribute that cannot be checked if the computer does not power on, as the system never reaches the POST or boot loader stage. Option D is wrong because free disk space is a storage metric that has no bearing on the initial power-up sequence; the computer must first receive power and initialize the hardware before the OS or disk is accessed.

572
Multi-Selecthard

A user reports that a web application fails to load in a browser. The IT technician suspects a compatibility issue. Which TWO actions should the technician take to diagnose the problem?

Select 2 answers
A.Reinstall the web browser application.
B.Check the browser console for error messages.
C.Test the application using a different web browser.
D.Clear the browser cache and cookies.
E.Update the operating system to the latest version.
AnswersB, C

The console shows JavaScript and network errors relevant to web application failures.

Why this answer

Option B is correct because the browser console displays JavaScript errors, network request failures, and other runtime issues that can prevent a web application from loading. Checking the console is a direct diagnostic step to identify compatibility problems, such as unsupported APIs or deprecated features. Option C is correct because testing the application in a different browser isolates whether the issue is browser-specific, which is a common compatibility troubleshooting technique.

Exam trap

The trap here is that candidates confuse general troubleshooting steps (clearing cache or reinstalling) with targeted diagnostic actions for compatibility issues, leading them to pick options that are too broad or unrelated to the specific symptom.

573
MCQhard

In Git, which action creates a snapshot of changes in the repository?

A.Merge
B.Commit
C.Push
D.Branch
AnswerB

Commit saves a snapshot of changes.

Why this answer

A commit records changes to the local repository.

574
MCQeasy

Which SQL statement is used to retrieve all columns from a table named 'Employees'?

A.SELECT * FROM Employees
B.RETRIEVE Employees
C.SHOW * FROM Employees
D.GET * FROM Employees
AnswerA

Correct syntax for retrieving all columns.

Why this answer

The SELECT * statement retrieves all columns from the specified table.

575
Multi-Selecthard

Which THREE of the following are best practices for database security?

Select 3 answers
A.Use strong, complex passwords
B.Grant all database privileges to all users
C.Disable audit logs to save storage
D.Encrypt sensitive data at rest
E.Implement least privilege access
AnswersA, D, E

Strong passwords resist brute-force attacks.

Why this answer

Using strong, complex passwords is a fundamental security practice that reduces the risk of brute-force or dictionary attacks against database authentication. Passwords should meet length and complexity requirements (e.g., at least 12 characters with mixed case, numbers, and special characters) and be stored using salted, cryptographically strong hashes like bcrypt or PBKDF2. This prevents unauthorized access even if the password hash is compromised.

Exam trap

CompTIA often tests the misconception that disabling security features like audit logs is acceptable for performance or storage savings, when in fact it eliminates critical accountability and detection capabilities required for secure database operations.

576
Multi-Selecteasy

Which THREE are common types of network cables? (Select exactly three.)

Select 3 answers
A.Fiber optic
B.USB
C.HDMI
D.Coaxial
E.Twisted pair
AnswersA, D, E

Fiber optic cable uses light for high-speed data transmission.

Why this answer

Fiber optic cables use light pulses transmitted through glass or plastic fibers to carry data, offering high bandwidth, long-distance transmission, and immunity to electromagnetic interference. They are a standard network cable type in modern infrastructure, especially for backbone and high-speed connections.

Exam trap

The trap here is that candidates often confuse common peripheral or multimedia cables (USB, HDMI) with network cables, forgetting that network cables specifically refer to those used for local area network (LAN) or wide area network (WAN) data transmission, such as fiber optic, coaxial, and twisted pair.

577
Multi-Selectmedium

A technician is troubleshooting a network issue and needs to identify the IP address of a device. Which of the following are private IPv4 addresses? (Select TWO).

Select 1 answer
A.8.8.8.8
B.192.168.1.10
C.203.0.113.5
D.169.254.1.1
E.172.16.0.1
AnswersB

192.168.x.x is a private IP range.

Why this answer

Private IP addresses are reserved for internal networks. 192.168.1.10 and 10.0.0.25 are within private ranges (192.168.0.0/16 and 10.0.0.0/8).

578
MCQmedium

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

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

Boolean is specifically designed for true/false values.

Why this answer

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

Exam trap

The trap here is that candidates may confuse the concept of 'truthy' and 'falsy' values in loosely typed languages (e.g., JavaScript or Python), where integers like 0 or strings like "" can be coerced to Boolean, leading them to incorrectly choose Integer or String as appropriate for storing a true/false value.

How to eliminate wrong answers

Option A is wrong because an Integer stores whole numbers (e.g., -1, 0, 1, 42) and is not inherently restricted to true/false semantics, though some languages allow using 0 for false and non-zero for true, which is error-prone and not the intended use. Option B is wrong because a String stores sequences of characters (e.g., "true" or "false"), which wastes memory, is case-sensitive, and requires parsing to interpret as a logical value. Option D is wrong because a Float stores decimal numbers (e.g., 3.14, -0.5) and is designed for numeric calculations, not binary state representation.

579
MCQmedium

A developer is writing a program that stores a collection of unique student IDs. The program needs to quickly look up a student by ID and does not require the IDs to be stored in any particular order. Which data structure is most appropriate for this task?

A.Dictionary
B.Queue
C.Array
D.Stack
AnswerA

Dictionaries map keys to values and provide O(1) average lookup.

Why this answer

A dictionary (hash map) provides fast key-based lookups and automatically handles uniqueness.

580
MCQhard

A network administrator is setting up a small office network with 20 computers. The network must be easy to troubleshoot and resilient to a single cable failure affecting only one device. Which topology is most appropriate?

A.Ring
B.Bus
C.Star
D.Mesh
AnswerC

Star topology isolates failures per device and is easy to troubleshoot.

Why this answer

Star topology connects each device to a central switch. If one cable fails, only that device is affected, making it easy to troubleshoot. It is the most common for modern networks.

581
MCQmedium

A user downloads a trial version of a photo editing application that is fully functional for 30 days. After the trial period, the user must purchase a license. This type of software distribution model is known as:

A.Open source
B.Shareware
C.Freeware
D.Trialware
AnswerD

Correct. Trialware is time-limited fully functional software.

Why this answer

Trial software (also called trialware) is fully functional for a limited time, after which payment is required to continue using it. This is a common marketing strategy.

582
MCQeasy

A user reports that their computer is running slowly. Which of the following is the MOST likely cause?

A.Running too many applications simultaneously
B.The monitor is too small
C.The keyboard is unresponsive
D.The mouse needs batteries
AnswerA

Excessive applications consume RAM and CPU, causing slowness.

Why this answer

When too many applications are running simultaneously, the computer's RAM and CPU resources become oversubscribed, forcing the operating system to rely heavily on virtual memory (paging to disk). This causes excessive disk I/O and context switching, which directly degrades system responsiveness and leads to the perception of slowness.

Exam trap

CompTIA often tests the misconception that peripheral issues (like monitor size or battery status) are the primary cause of system slowness, when in fact resource contention from concurrent processes is the most common culprit.

How to eliminate wrong answers

Option B is wrong because monitor size affects display real estate and resolution, not the processing speed or resource availability of the computer. Option C is wrong because an unresponsive keyboard is an input device issue that prevents typing but does not impact overall system performance or CPU/RAM utilization. Option D is wrong because low mouse batteries cause intermittent cursor movement or failure, but they have no effect on the computer's computational throughput or memory management.

583
MCQhard

A hospital's IT team manages a virtualized server hosting a patient records database. The server has one physical processor with 6 cores, 32 GB of RAM, and a RAID 5 array of three 1 TB HDDs. The virtual machine (VM) running the database is configured with 2 vCPUs, 8 GB RAM, and a 500 GB virtual disk stored on the RAID array. Users report that database queries are taking much longer than usual. The host server shows CPU utilization at 20%, memory at 60%, and the disk queue length frequently stays above 5. Which of the following is the most likely cause of the performance issue?

A.Disk I/O bottleneck
B.Network bandwidth limitation
C.Insufficient memory
D.Insufficient CPU resources
AnswerA

A high disk queue length indicates that the storage subsystem is overloaded, causing slow response times.

Why this answer

The disk queue length consistently exceeding 5 indicates that I/O requests are waiting for the storage subsystem, which is a classic sign of a disk I/O bottleneck. The RAID 5 array of three 1 TB HDDs provides limited IOPS compared to SSDs, and the single virtual disk on this array cannot keep up with the database workload. Even though CPU and memory utilization are moderate, the high queue length shows the disks are the limiting factor.

Exam trap

CompTIA often tests the misconception that high disk queue length is always caused by insufficient memory, but here memory is adequate and the queue is due to slow HDDs in RAID 5, not paging.

How to eliminate wrong answers

Option B is wrong because network bandwidth limitation would manifest as slow data transfer between clients and the server, not as high disk queue length on the host. Option C is wrong because memory utilization at 60% (with 32 GB total) is not critically low, and insufficient memory would cause paging or swapping, not a persistently high disk queue length. Option D is wrong because CPU utilization at 20% is well below saturation, and 2 vCPUs on a 6-core host are not overloaded; insufficient CPU would show high CPU usage, not a disk queue issue.

584
MCQhard

A system administrator needs to automatically assign IP addresses to devices on the network. Which protocol should be configured on the server?

A.DNS
B.ICMP
C.ARP
D.DHCP
AnswerD

DHCP dynamically assigns IP addresses to clients.

Why this answer

The Dynamic Host Configuration Protocol (DHCP) is the correct protocol because it is specifically designed to automatically assign IP addresses and other network configuration parameters (such as subnet mask, default gateway, and DNS servers) to devices on a network. A DHCP server maintains a pool of available addresses and leases them to clients, eliminating the need for manual static IP configuration.

Exam trap

The trap here is that candidates often confuse DNS with DHCP because both are 'automatic configuration' services, but DNS only resolves names, while DHCP is the protocol that actually hands out IP addresses.

How to eliminate wrong answers

Option A (DNS) is wrong because the Domain Name System resolves human-readable domain names (e.g., www.example.com) to IP addresses; it does not assign IP addresses to devices. Option B (ICMP) is wrong because the Internet Control Message Protocol is used for diagnostic and error-reporting purposes (e.g., ping, traceroute) and has no role in IP address assignment. Option C (ARP) is wrong because the Address Resolution Protocol maps a known IP address to a corresponding MAC address on a local network segment; it does not assign or distribute IP addresses.

585
Multi-Selectmedium

Which TWO of the following are advantages of using a relational database management system (RDBMS) over a file-based system?

Select 2 answers
A.Enforcement of data integrity
B.Faster data access for all queries
C.Reduced data redundancy
D.No need for a database administrator
E.Simpler setup and maintenance
AnswersA, C

Constraints enforce accuracy and consistency.

Why this answer

A relational database management system (RDBMS) enforces data integrity through constraints such as primary keys, foreign keys, unique constraints, and check constraints. These rules ensure that data entered into the database adheres to defined business rules and referential integrity, preventing orphaned records and invalid data entries. In contrast, a file-based system relies on application code to enforce such rules, which is error-prone and inconsistent.

Exam trap

The trap here is that candidates often assume 'faster data access' is always true for RDBMS due to indexing, but they overlook the overhead of SQL processing and the fact that file-based systems can be faster for simple, non-relational lookups.

586
MCQmedium

A small business needs to share files among employees within the same building. Which network topology is most efficient for this scenario?

A.Ring
B.Bus
C.Mesh
D.Star
AnswerD

Star topology is the most common for LANs due to centralized management and easy fault detection.

Why this answer

The star topology is most efficient for this scenario because all employee workstations connect to a central switch, which provides dedicated bandwidth per connection and simplifies troubleshooting. In a small office, the star topology allows easy addition or removal of devices without disrupting the network, and the central switch can manage traffic efficiently using MAC address tables.

Exam trap

The trap here is that candidates may confuse 'efficiency' with 'simplicity' and choose bus topology, overlooking that star topology provides better fault isolation and scalability for a shared file environment.

How to eliminate wrong answers

Option A is wrong because a ring topology passes data in a unidirectional loop, and a single cable break can disrupt the entire network, making it less reliable for a small business. Option B is wrong because a bus topology uses a single backbone cable that can become a bottleneck and is prone to collisions, especially as the number of employees increases. Option C is wrong because a mesh topology requires every device to connect to every other device, which is impractical and costly for a small office due to excessive cabling and configuration overhead.

587
MCQeasy

Refer to the exhibit. A database administrator executes the following query: SELECT COUNT(*) FROM employees WHERE department_id = 10; What is the result?

A.2
B.3
C.0
D.1
AnswerA

Employees with department_id 10 are John Doe and Bob Johnson.

Why this answer

The query `SELECT COUNT(*) FROM employees WHERE department_id = 10;` counts all rows in the `employees` table where the `department_id` column equals 10. According to the exhibit (not shown here but implied), there are exactly two employees in department 10, so the result is 2.

Exam trap

The FC0-U61 exam often tests the difference between `COUNT(*)`, `COUNT(column)`, and `COUNT(DISTINCT column)`, and the trap here is that candidates might miscount the rows in the exhibit or confuse the filter condition with a different department ID.

How to eliminate wrong answers

Option B (3) is wrong because it would imply three employees in department 10, but the data shows only two. Option C (0) is wrong because it would mean no employees in department 10, but the data clearly contains two. Option D (1) is wrong because it would indicate a single employee, but the query counts two matching rows.

588
MCQmedium

Refer to the exhibit. A technician notices high CPU usage from a process called 'svchost.exe'. What is the most appropriate action?

A.Scan for malware
B.End the process immediately
C.Increase virtual memory
D.Update Windows
AnswerA

High CPU usage from svchost can indicate malware; a thorough scan is the best initial diagnostic step.

Why this answer

Svchost.exe is a legitimate Windows process that hosts services. High CPU usage could indicate a malfunctioning service or malware disguised as svchost. Scanning for malware is the safest first step.

Ending the process could cause system instability; updating Windows might fix service issues but not malware; virtual memory is not relevant.

589
MCQmedium

Refer to the exhibit. A technician is troubleshooting why a user cannot run a custom application installed in D:\Apps. Based on the exhibit, what is the MOST likely reason?

A.The path rule for C:\Program Files is too broad.
B.The policy does not include a rule for D:\Apps.
C.The publisher rule is incorrect.
D.The enforcement mode is set to Enforce, blocking all unlisted apps.
AnswerB

No rule allows execution from D:\Apps, so the custom app is blocked.

Why this answer

The exhibit shows a software restriction policy that includes path rules for C:\Program Files and C:\Windows, but no rule for D:\Apps. Since the policy does not explicitly allow the custom application installed in D:\Apps, it is blocked by default. This is the most likely reason the user cannot run the application.

Exam trap

The trap here is that candidates may assume 'Enforce' mode blocks all unlisted apps, but the actual issue is the missing path rule for D:\Apps, not the enforcement mode itself.

How to eliminate wrong answers

Option A is wrong because the path rule for C:\Program Files is not too broad; it correctly targets the standard installation directory and does not affect D:\Apps. Option C is wrong because the publisher rule is irrelevant here; the issue is the absence of a path rule for D:\Apps, not an incorrect publisher certificate or signature. Option D is wrong because the enforcement mode being set to Enforce does not block all unlisted apps; it enforces the existing rules, and the problem is the lack of a rule for D:\Apps, not the enforcement mode itself.

590
MCQhard

A database has a 'Students' table with columns: StudentID (primary key), Name, Major. Another table 'Enrollments' has columns: EnrollmentID (primary key), StudentID (foreign key), CourseID. Which SQL query correctly lists each student's name and their enrolled courses by joining the tables?

A.SELECT Name, CourseID FROM Students RIGHT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID;
B.SELECT Name, CourseID FROM Students INNER JOIN Enrollments ON Students.StudentID = Enrollments.StudentID;
C.SELECT Name, CourseID FROM Students, Enrollments WHERE Students.StudentID = Enrollments.StudentID;
D.SELECT Name, CourseID FROM Students LEFT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID;
AnswerB

Correct INNER JOIN syntax with matching keys.

Why this answer

INNER JOIN returns only rows with matching foreign key values; Students.StudentID = Enrollments.StudentID is the join condition.

591
Multi-Selecthard

A user wants to ensure software is legitimate and free from malware before installation. Which THREE of the following are recommended practices?

Select 3 answers
A.Use a cracked version to save money
B.Read user reviews and check hash values
C.Download from the official vendor website
D.Verify digital signatures
E.Disable antivirus to speed up installation
AnswersB, C, D

Reviews and hash comparisons help verify legitimacy.

Why this answer

Option B is correct because reading user reviews can reveal community reports of malware or tampering, and checking hash values (e.g., SHA-256) against the vendor's published digest verifies file integrity, ensuring the software hasn't been altered. This combination provides both social and cryptographic verification of legitimacy.

Exam trap

The trap here is that candidates may think disabling antivirus speeds up installation without realizing it removes a critical security layer, or they might confuse 'cracked version' with a legitimate free trial, missing that cracking inherently bypasses integrity checks.

592
MCQeasy

Which of the following is an input device?

A.Monitor
B.Keyboard
C.Printer
D.Speaker
AnswerB

Keyboard is an input device.

Why this answer

A keyboard is an input device used to type data into a computer.

593
Multi-Selectmedium

Which TWO of the following are advantages of using a virtual private network (VPN) for remote employees?

Select 2 answers
A.Eliminates need for antivirus software
B.Provides encrypted communication
C.Allows access to internal resources
D.Reduces hardware costs
E.Increases network bandwidth
AnswersB, C

VPNs encrypt data to ensure confidentiality.

Why this answer

Options B and C are correct. VPNs provide encrypted communication (B) and allow access to internal resources (C). Option A is incorrect because VPNs typically reduce bandwidth due to encryption overhead.

Option D is incorrect because VPNs do not directly reduce hardware costs. Option E is incorrect because a VPN does not eliminate the need for antivirus software.

594
MCQmedium

Which device converts the signal from an ISP (e.g., cable or fiber) into a digital signal that a home network can use?

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

The modem converts the ISP's signal to digital for the home network.

Why this answer

A modem modulates/demodulates signals from the ISP to digital data. It is essential for internet connectivity.

595
MCQhard

A technician is diagnosing performance issues in a wireless network. Users report intermittent slowdowns. Which of the following is the MOST likely cause?

A.WPA2 encryption overhead
B.Weak signal from the access point
C.Interference from neighboring networks
D.Incorrect channel width setting
AnswerC

Interference can cause sporadic slowdowns.

Why this answer

Intermittent slowdowns in a wireless network are most commonly caused by co-channel or adjacent-channel interference from neighboring networks. Wi-Fi operates on shared, unlicensed spectrum (2.4 GHz and 5 GHz), and overlapping channels or high utilization from nearby access points force stations to wait for clear channel access, causing latency spikes and throughput drops. WPA2 encryption overhead is negligible for modern hardware, and weak signal or incorrect channel width would typically cause consistent, not intermittent, issues.

Exam trap

The trap here is that candidates confuse 'intermittent slowdowns' with 'weak signal' or 'incorrect channel width,' but CompTIA emphasizes that interference from neighboring networks is the most common cause of sporadic performance issues in dense wireless environments.

How to eliminate wrong answers

Option A is wrong because WPA2 encryption overhead is minimal (typically <5% CPU impact on modern devices) and causes a constant, predictable latency increase, not intermittent slowdowns. Option B is wrong because a weak signal from the access point results in consistently low data rates or frequent disconnections, not intermittent slowdowns that come and go. Option D is wrong because an incorrect channel width setting (e.g., 40 MHz in 2.4 GHz) would cause persistent performance degradation or compatibility issues, not intermittent slowdowns, and is less common than interference as a root cause.

596
Multi-Selecthard

A programmer is using a version control system. Which THREE are core Git concepts?

Select 3 answers
A.Variable
B.Repository
C.Branch
D.Commit
E.Compilation
AnswersB, C, D

A repository stores the project and its history.

Why this answer

Git concepts include repository, commit, branch, merge, etc.

597
MCQhard

A developer needs to track changes to source code over time, collaborate with other developers, and maintain a history of all modifications. Which tool is specifically designed for these tasks?

A.Text editor
B.Integrated Development Environment (IDE)
C.Git
D.Debugger
AnswerC

Git is a version control system that tracks changes and facilitates collaboration.

Why this answer

Git is a version control system that tracks changes, enables collaboration, and maintains a history. An IDE is for writing code, a debugger finds errors, and a text editor edits text files but lacks version control features.

598
MCQmedium

A user receives an error 'This application cannot run on your PC' when trying to install a legacy program on Windows 10. What is the most likely cause?

A.Incompatible architecture (32-bit vs 64-bit)
B.Corrupted hard drive
C.Insufficient RAM
D.Missing antivirus
AnswerA

The program may be incompatible with the system's processor architecture.

Why this answer

The error 'This application cannot run on your PC' typically occurs when a 32-bit legacy program is incompatible with the 64-bit architecture of Windows 10, or vice versa. 64-bit Windows cannot execute 16-bit or certain older 32-bit applications that rely on deprecated system components like NTVDM (NT Virtual DOS Machine) without proper compatibility layers. This is the most likely cause because the error specifically points to an architecture mismatch, not hardware or security issues.

Exam trap

The trap here is that candidates may confuse this architecture-specific error with general hardware or security issues, such as insufficient RAM or missing antivirus, because they assume any installation failure is due to resource constraints or security blocks rather than a fundamental CPU instruction set mismatch.

How to eliminate wrong answers

Option B is wrong because a corrupted hard drive would cause file read/write errors, boot failures, or data loss, not a specific application compatibility error during installation. Option C is wrong because insufficient RAM would result in system slowdowns, out-of-memory errors, or application crashes after launch, not a pre-installation architecture-related error. Option D is wrong because missing antivirus software does not prevent application installation; it only increases vulnerability to malware, and the error message is unrelated to security software.

599
MCQhard

A company wants to ensure that its corporate data is secure if a mobile device is lost. The IT department needs to remotely wipe the device and enforce a passcode policy. Which technology should be implemented?

A.Firewall
B.MDM
C.Antivirus
D.VPN
AnswerB

MDM provides remote wipe and policy enforcement.

Why this answer

Mobile Device Management (MDM) solutions allow remote wipe and policy enforcement (like passcode requirements) on mobile devices, protecting corporate data.

600
MCQhard

A database manager is designing a new table to store customer information for a retail company. The table needs to store a unique identifier for each customer, the customer's first and last name, email address, phone number, and date of birth. The manager also wants to ensure that the email address is always provided and that no two customers have the same email. Which of the following SQL constraints should be applied to the email column?

A.INDEX
B.FOREIGN KEY
C.PRIMARY KEY
D.UNIQUE and NOT NULL
AnswerD

These constraints ensure email is mandatory and distinct.

Why this answer

The email column must be both unique (to prevent duplicate email addresses) and NOT NULL (to ensure an email is always provided). The UNIQUE constraint enforces that no two rows have the same value, and NOT NULL guarantees that the column cannot be left empty. Together, they satisfy the requirement that every customer has a distinct, mandatory email address.

Exam trap

The trap here is that candidates confuse PRIMARY KEY with UNIQUE+NOT NULL, not realizing that a table can have only one primary key and that email is often a natural key requiring both uniqueness and mandatory presence, but not necessarily the table's primary identifier.

How to eliminate wrong answers

Option A is wrong because an INDEX is a performance optimization for faster data retrieval, not a constraint that enforces data integrity or uniqueness. Option B is wrong because a FOREIGN KEY links a column to a primary key in another table, ensuring referential integrity, but it does not enforce uniqueness or non-null values within the same table. Option C is wrong because a PRIMARY KEY enforces both uniqueness and non-null, but a table can have only one primary key, and the customer ID (not the email) is the natural choice for that role; applying PRIMARY KEY to email would prevent using a separate customer identifier.

Page 7

Page 8 of 14

Page 9
CompTIA ITF+ FC0-U61 FC0-U61 Questions 526–600 | Page 8/14 | Courseiva