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

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

Page 10

Page 11 of 14

Page 12
751
MCQeasy

Which of the following storage technologies uses spinning platters and a mechanical arm to read and write data?

A.RAM
B.HDD
C.Firmware
D.SSD
AnswerB

Correct.

Why this answer

HDDs (Hard Disk Drives) use spinning magnetic platters and a mechanical read/write head.

752
MCQeasy

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

A.Coaxial
B.Fiber optic
C.USB
D.Cat5e
AnswerD

Cat5e supports Gigabit Ethernet and is widely used.

Why this answer

Cat5e (Category 5 enhanced) is the most common twisted-pair copper cable used in office Ethernet networks because it supports speeds up to 1 Gbps (1000BASE-T) over distances up to 100 meters, and it is backward-compatible with older 10/100 Mbps standards. Its widespread adoption, low cost, and ease of termination make it the default choice for structured cabling in modern office environments.

Exam trap

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

How to eliminate wrong answers

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

753
MCQhard

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

A.The data has trailing spaces causing no match
B.The AND operator is incorrect
C.The column name is misspelled
D.Salary is stored as text
AnswerA

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

754
MCQmedium

A technician needs to install software on 50 company computers without user interaction. Which installation method should be used?

A.Manual installation
B.Installation from an app store
C.Silent installation
D.Trial installation
AnswerC

Runs without user prompts, ideal for bulk deployment.

Why this answer

Silent installation runs without prompts, suitable for automated deployments.

755
Multi-Selecthard

A network administrator is redesigning a small office network with 20 computers, two servers, and three printers. The network must be reliable and easy to troubleshoot. Which TWO network topologies should the administrator consider?

Select 2 answers
A.Star
B.Hybrid
C.Ring
D.Bus
E.Mesh
AnswersA, E

Easy to troubleshoot; failure of one node doesn't affect others.

Why this answer

Star topology is most common for office networks due to easy troubleshooting and expansion. Mesh provides high reliability but is expensive; for a small office, star is practical, and mesh could be considered if high fault tolerance is needed, but the question asks for two topologies to consider. Typically, star is the best; bus and ring are outdated.

However, the administrator might consider star and mesh (for critical links). But given the options, star is correct, and mesh is also a valid consideration for resilience. However, the exam expects star as primary, and perhaps hybrid? But the options: bus, ring, star, mesh, hybrid.

The best two for reliability and troubleshooting are star and mesh (though mesh costly). But in ITF+ context, star is recommended; mesh is for high-availability. I'll go with star and mesh.

Explanation: Star is easy to troubleshoot, mesh provides redundancy.

756
MCQeasy

Which of the following storage types uses spinning platters to read and write data?

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

HDDs use spinning platters.

Why this answer

HDDs (Hard Disk Drives) use spinning magnetic platters, while SSDs use flash memory.

757
MCQmedium

A technician is setting up a virtual machine on a laptop running Windows 10. The technician installs VirtualBox and creates a Linux VM. Which type of hypervisor is VirtualBox?

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

Type 2 runs on top of a host OS.

Why this answer

VirtualBox is a Type 2 hypervisor because it runs on top of a host operating system (Windows 10). Type 1 hypervisors run directly on hardware without an underlying OS.

758
Multi-Selectmedium

A junior developer is learning about data structures. The developer needs to choose a data structure for the following scenarios: - Storing a list of items where order matters and items can be accessed by index. - Storing key-value pairs for fast lookups. Which TWO data structures should the developer consider?

Select 2 answers
A.Dictionary
B.Tree
C.Array
D.Stack
E.Queue
AnswersA, C

Dictionaries store key-value pairs for fast lookups.

Why this answer

An array (or list) allows indexed access and maintains order. A dictionary (hash map) allows fast key-based lookups.

759
MCQhard

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

A.Incorrect default gateway
B.Incorrect subnet mask
C.Duplicate IP address on the network
D.Workstation and server are on different subnets with no routing
AnswerD

Without a router, devices on different subnets cannot communicate.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

760
MCQmedium

Which of the following best describes a web application?

A.An application that runs only on mobile devices
B.An application installed locally that has direct hardware access
C.An application that runs within a web browser and processes data on a server
D.An application that connects services using APIs
AnswerC

Web apps are browser-based with server-side logic.

Why this answer

Web applications run in a browser and rely on server-side processing.

761
MCQmedium

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

A.The default gateway is incorrect
B.The DNS server is unreachable
C.A firewall is blocking ICMP traffic
D.The subnet mask is wrong
AnswerC

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

762
MCQhard

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

A.Availability
B.Integrity
C.Accountability
D.Confidentiality
AnswerC

Accountability ensures user actions are traceable through identification and auditing.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

763
MCQeasy

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

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

RAM is volatile and loses data when power is off.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

764
MCQeasy

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

A.RAM
B.Video card
C.CPU
D.Hard drive
AnswerA

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

765
Multi-Selectmedium

An IT instructor is teaching about binary arithmetic operations. Which TWO of the following are correct results of a logical XOR operation on the binary inputs 1 and 0? (Select TWO.)

Select 2 answers
A.1 XOR 0 = 0
B.0 XOR 1 = 1
C.1 XOR 1 = 1
D.1 XOR 0 = 1
E.0 XOR 1 = 0
AnswersB, D

Inputs differ, result is 1.

Why this answer

XOR outputs 1 when inputs differ. 1 XOR 0 = 1. Also, 0 XOR 1 = 1. So both pairs produce 1.

766
Multi-Selectmedium

A small business is setting up a LAN. Which TWO of the following are characteristics of a LAN?

Select 2 answers
A.Uses cellular technology like 4G LTE
B.Requires a modem to connect all devices
C.Covers a large geographic area such as a city
D.Connects devices within a single building or campus
E.Typically uses Ethernet or Wi-Fi
AnswersD, E

LANs are local, covering a limited area.

Why this answer

LANs are confined to a small geographic area like a building, and typically use Ethernet or Wi-Fi. WANs cover larger areas.

767
MCQeasy

Which printer technology is most suitable for printing high-volume black-and-white text documents in an office environment due to its lower cost per page?

A.Laser
B.Inkjet
C.Thermal
D.Impact
AnswerA

Laser printers are fast and economical for high-volume monochrome printing.

Why this answer

Laser printers use toner and are efficient for high-volume text printing, with lower cost per page than inkjets.

768
MCQeasy

Which of the following is an example of a physical security control?

A.Password policy
B.Antivirus software
C.Biometric door lock
D.Firewall
AnswerC

A biometric door lock physically restricts access to a room.

Why this answer

Physical security controls include measures like locks, guards, and biometric scanners to protect physical assets.

769
MCQmedium

A small business needs a printer that can produce high-quality color documents quickly and at a low cost per page. Which type of printer is most suitable?

A.Dot matrix printer
B.Thermal printer
C.Laser printer
D.Inkjet printer
AnswerC

Laser printers are fast and cost-effective for high-volume color printing.

Why this answer

Laser printers are faster and have lower cost per page than inkjet printers, especially for high-volume color printing. Inkjets are better for photo quality but slower and more expensive per page.

770
Multi-Selectmedium

A developer is writing code and uses a variable to store a user's age. Which TWO data types are appropriate for storing a whole number age?

Select 2 answers
A.Boolean
B.Character
C.Integer
D.String
E.Float
AnswersC, E

Integer stores whole numbers.

Why this answer

Age is a whole number, so integer or float could store it, but float is for decimals. However, integer is most appropriate. The question expects integer and float as numeric types that can store numbers.

771
MCQmedium

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

A.The query would run faster because the index reduces the number of rows to scan for Department.
B.The query would return fewer rows because the index excludes the Salary condition.
C.The query would return more rows because the index includes both columns.
D.The query would fail because the index conflicts with the SELECT *.
AnswerA

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

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

772
MCQeasy

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

A.The application is not installed correctly.
B.The user does not have permission to run the application.
C.Antivirus software has quarantined the application file.
D.The required Microsoft Visual C++ redistributable package is not installed.
AnswerD

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

773
MCQeasy

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

A.Platform as a Service (PaaS)
B.Infrastructure as a Service (IaaS)
C.Desktop as a Service (DaaS)
D.Software as a Service (SaaS)
AnswerB

IaaS gives virtual machines where customers manage OS and applications.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

774
MCQhard

An attacker gains physical access to a building by following an employee through a secured door without using a badge. This is an example of which social engineering technique?

A.Phishing
B.Baiting
C.Pretexting
D.Tailgating
AnswerD

Following someone through a door without authorization.

Why this answer

Tailgating (also called piggybacking) is when an unauthorized person follows an authorized person into a restricted area.

775
Multi-Selecthard

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

Select 2 answers
A.Automatic synchronization of bookmarks across devices
B.Enhanced privacy through blocking of pop-ups and trackers
C.Ability to test how a website displays on different screen sizes
D.Improved page loading speed
E.Ability to inspect and modify the source code of a webpage
AnswersC, E

Developer tools often include device emulation to test responsiveness.

Why this answer

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

Exam trap

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

776
MCQmedium

What is the primary purpose of a firewall?

A.To encrypt data on the hard drive
B.To detect and remove viruses
C.To prevent unauthorized network access
D.To manage user passwords
AnswerC

Firewalls block unauthorized traffic.

Why this answer

A firewall controls incoming and outgoing network traffic based on predetermined security rules. It filters traffic by port, protocol, or IP address to block unauthorized access.

777
MCQeasy

Which component on the motherboard is responsible for temporarily storing frequently accessed data to speed up processing?

A.Cache
B.GPU
C.SSD
D.RAM
AnswerA

Correct.

Why this answer

CPU cache (L1, L2, L3) is a small, fast memory that stores frequently accessed data.

778
MCQhard

A cloud database service is being considered for a startup to avoid hardware maintenance and allow automatic scaling. Which type of service is this?

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

Correct. DBaaS offers managed database services with automatic scaling.

Why this answer

Database-as-a-Service (DBaaS) provides managed database instances in the cloud, handling maintenance, backups, and scaling.

779
MCQeasy

A user wants to install software on a Windows computer using the application's official installer. Which of the following file extensions is most likely associated with a Windows executable installer?

A..pkg
B..exe
C..dmg
D..deb
AnswerB

.exe is the standard executable file format for Windows installers.

Why this answer

The .exe extension is the standard executable file format for Windows installers. .dmg is for macOS disk images, .deb is for Debian-based Linux, and .pkg is for macOS installer packages.

780
MCQmedium

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

A.STP
B.DNS
C.NAT
D.DHCP
AnswerA

STP prevents loops by disabling redundant paths.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

781
MCQmedium

Which type of malware attaches to legitimate files and spreads when those files are executed?

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

Correct. A virus attaches to files and spreads when executed.

Why this answer

A virus attaches itself to files or programs and replicates when the infected file is executed. Worms spread without a host file; trojans disguise as legitimate software.

782
MCQmedium

A database designer wants to reduce data redundancy and avoid update anomalies. Which process should be applied?

A.Denormalization
B.Normalization
C.Encryption
D.Indexing
AnswerB

Correct. Normalization reduces data redundancy and improves integrity.

Why this answer

Normalization is the process of organizing data to minimize redundancy and dependency, typically by dividing tables and establishing relationships.

783
MCQmedium

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

A.The motherboard manual
B.The BIOS manufacturer's website
C.The computer case documentation
D.The operating system help
AnswerA

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

Why this answer

The motherboard manual is the best resource because it contains the specific beep code patterns defined by the BIOS manufacturer for that exact motherboard model. Beep codes are generated by the BIOS during Power-On Self-Test (POST) and vary between BIOS vendors (e.g., AMI, Award, Phoenix), so the motherboard manual provides the authoritative mapping of beep sequences to hardware faults.

Exam trap

The trap here is that candidates assume the BIOS manufacturer's website is the definitive source, but the motherboard manual is the correct answer because it includes board-specific beep code tables that may override or supplement the generic BIOS vendor codes.

How to eliminate wrong answers

Option B is wrong because the BIOS manufacturer's website provides generic beep code tables for their chipsets, but these may not account for motherboard-specific customizations or additional codes implemented by the board vendor. Option C is wrong because computer case documentation typically covers physical installation, front panel connectors, and airflow, not POST beep code diagnostics. Option D is wrong because the operating system is not loaded until after POST completes successfully; if the system is beeping, the OS is not running, so OS help cannot interpret hardware-level beep codes.

784
MCQeasy

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

A.Manually type each cell reference separated by plus signs.
B.Use the COUNT function to count the number of cells.
C.Use the AVERAGE function to find the average of the values.
D.Use the SUM function in a formula to add the three cells.
AnswerD

SUM is designed to add numerical values.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

785
MCQeasy

A software development team is working on a project with fixed requirements and a strict deadline. The project manager decides to use a methodology where each phase must be completed before moving to the next. Which development methodology is being used?

A.Agile
B.Scrum
C.Waterfall
D.Spiral
AnswerC

Waterfall follows a linear sequential flow through phases.

Why this answer

The waterfall model follows sequential phases with fixed scope, making it suitable for predictable projects with stable requirements.

786
MCQhard

A developer modifies a database and wants to ensure that every value in a column meets a specific condition, such as age must be between 0 and 120. Which type of integrity constraint should be used?

A.Referential integrity
B.Domain integrity
C.User-defined integrity
D.Entity integrity
AnswerB

Correct. Domain integrity enforces valid data values for columns.

Why this answer

Domain integrity ensures that data falls within a valid range or set of values, often enforced with CHECK constraints.

787
Multi-Selectmedium

A support technician is explaining binary operations to a junior technician. Which TWO of the following are valid binary arithmetic operations? (Select TWO.)

Select 2 answers
A.NOT
B.AND
C.SUBTRACT
D.DIVIDE
E.XOR
AnswersB, E

AND is a valid binary operation.

Why this answer

AND and XOR are standard binary operations; NOT is unary; OR is included but only TWO must be selected. The correct ones are AND and XOR.

788
MCQhard

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

A.The user does not have permission to access the database.
B.The GRANT command requires a COMMIT.
C.The user also needs UPDATE privilege.
D.The table name is misspelled in the GRANT command.
AnswerA

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

789
MCQhard

A network technician is configuring a device and needs to enter a MAC address. Which of the following is a valid MAC address in hexadecimal notation?

A.1G:2H:3I:4J:5K:6L
B.AB:CD:EF
C.3A:4B:5C:6D:7E:8F
D.0X:1Z:2Y:3X:4W:5V
AnswerC

Valid MAC address with hex digits.

Why this answer

MAC addresses are 12 hexadecimal digits (0-9, A-F), often separated by colons or hyphens. Option A is a valid MAC address. Option B uses 'G' (invalid hex), C has too few digits, D uses 'Z' (invalid).

790
MCQhard

A database designer wants to ensure that every value in a column called 'Status' is either 'Active', 'Inactive', or 'Pending'. Which type of constraint should be applied?

A.Entity integrity
B.Domain integrity
C.User-defined integrity
D.Referential integrity
AnswerB

Correct; domain integrity limits the allowable values for a column.

Why this answer

Domain integrity is enforced by data type and check constraints. A CHECK constraint on the Status column can restrict values to the allowed list.

791
Multi-Selectmedium

A company is deploying mobile devices for its sales team. The devices need to access corporate email and calendars securely. Which THREE features are most important for managing these devices centrally?

Select 3 answers
A.NFC for mobile payments
B.Remote wipe capability
C.High-resolution camera
D.GPS tracking
E.Mobile Device Management (MDM) software
AnswersB, D, E

Allows erasing data if device is lost or stolen.

Why this answer

MDM enables remote management, remote wipe protects data if lost, and GPS tracking helps locate devices.

792
MCQeasy

A technician is selecting a storage interface for a new solid-state drive that offers the fastest data transfer speeds. Which interface should they choose?

A.SATA
B.PATA
C.NVMe M.2
D.USB 2.0
AnswerC

NVMe M.2 can achieve speeds over 3 GB/s.

Why this answer

NVMe M.2 drives use the PCIe bus directly, providing significantly faster performance than SATA-based SSDs.

793
MCQmedium

Which wireless standard is commonly known as Wi-Fi 5 and operates on the 5 GHz band?

A.802.11ax
B.802.11g
C.802.11n
D.802.11ac
AnswerD

802.11ac is Wi-Fi 5, commonly used.

Why this answer

802.11ac (Wi-Fi 5) operates on 5 GHz and offers faster speeds than previous standards. Wi-Fi 6 is 802.11ax.

794
MCQeasy

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

A.Availability
B.Integrity
C.Confidentiality
D.Authentication
AnswerD

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

Why this answer

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

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

Exam trap

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

How to eliminate wrong answers

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

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

795
MCQmedium

A user wants to edit a plain text configuration file on a Linux system. Which type of application is most appropriate?

A.Integrated Development Environment (IDE)
B.Text editor
C.Word processor
D.Media player
AnswerB

Text editors are designed for plain text files.

Why this answer

A text editor like Vim or Nano is used for editing plain text files on Linux. IDEs are for programming, media players for multimedia, and word processors for formatted documents.

796
MCQeasy

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

A.for loop
B.while loop
C.if-else
D.switch
AnswerA

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

Why this answer

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

797
MCQmedium

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

A.It denies delete access to the bucket for requests from the 192.0.2.0/24 IP range
B.It allows delete access to the bucket for all IPs
C.It allows read access to the bucket from the IP range
D.It denies all s3 actions to the bucket
AnswerA

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

Why this answer

The policy explicitly denies `s3:DeleteObject` actions for requests originating from the `192.0.2.0/24` IP range. This is achieved by using a `Deny` effect in the IAM policy's `Condition` block with the `aws:SourceIp` condition key. The policy does not affect other actions or IP ranges, so only delete access is denied for that specific CIDR block.

Exam trap

The trap here is that candidates often confuse a Deny statement for a specific action with a blanket denial of all actions, or they misinterpret the IP condition as applying to all actions instead of only the listed action.

How to eliminate wrong answers

Option B is wrong because the policy does not allow delete access for all IPs; it specifically denies delete access for the 192.0.2.0/24 range, and other IPs are not explicitly allowed (they would need a separate Allow statement). Option C is wrong because the policy does not mention read access (e.g., `s3:GetObject`) at all; it only references delete actions. Option D is wrong because the policy only denies delete actions, not all S3 actions; other actions like read or write are not restricted by this policy.

798
MCQmedium

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

A.Set up a print server using a Raspberry Pi
B.Enable printer sharing on the desktop and connect from other computers using the network path
C.Install the printer on each computer by connecting it via USB when needed
D.Connect the printer directly to the network switch using an Ethernet cable
AnswerB

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

799
MCQhard

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

A.DHCP is disabled on the computer.
B.The DNS server address is incorrect or not functioning for external lookups.
C.The IP address is a private address and cannot access the internet.
D.The subnet mask should be 255.255.0.0.
AnswerB

Router may not provide DNS resolution for external domains.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

800
Multi-Selectmedium

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

Select 2 answers
A.Creating separate tables for each customer order without linking them
B.Storing all product details in a single column as a list
C.Removing duplicate data from tables by creating separate tables for each entity
D.Splitting customer information into Customers and Orders tables linked by a foreign key
E.Storing calculated totals in the same table to avoid joins
AnswersC, D

This reduces redundancy and improves data integrity.

Why this answer

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

Exam trap

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

801
MCQhard

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

A.The default gateway is unreachable
B.The network connection is down
C.DNS server is misconfigured
D.A firewall is blocking ICMP traffic
AnswerB

Both pings fail, indicating no network connectivity.

Why this answer

The ping to the loopback address (127.0.0.1) succeeds, confirming that the TCP/IP stack is functioning correctly on the local host. However, the ping to the remote host (e.g., 8.8.8.8) fails, indicating that the issue lies beyond the local machine. Since the loopback test passes, the most likely cause is that the network connection (e.g., cable, NIC, switch port) is down, preventing any Layer 2 or Layer 3 communication with the external network.

Exam trap

Cisco often tests the distinction between loopback and external pings to trap candidates into assuming a firewall or DNS issue, when the real problem is a physical or data link layer failure that prevents any external communication.

How to eliminate wrong answers

Option A is wrong because if the default gateway were unreachable, the ping to the remote host would fail, but the loopback ping would still succeed; however, the question does not provide evidence that the gateway is the specific point of failure, and a down network connection is a more fundamental cause that would also make the gateway unreachable. Option C is wrong because DNS is not involved in this scenario, as the ping command uses an IP address (8.8.8.8) directly, not a hostname, so a misconfigured DNS server would not affect the outcome. Option D is wrong because a firewall blocking ICMP traffic would typically allow the ping to the loopback address (127.0.0.1) to succeed, but it would also allow the ping to the remote host to fail; however, the question does not indicate any firewall rules or logs, and a down network connection is a more common and direct cause of total connectivity loss.

802
MCQeasy

Which of the following is used to translate human-readable domain names (like www.example.com) into IP addresses that computers use to identify each other on the network?

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

DNS translates domain names to IP addresses.

Why this answer

DNS (Domain Name System) resolves domain names to IP addresses, allowing users to access websites using easy-to-remember names instead of numeric IP addresses.

803
MCQhard

A technician is troubleshooting a network connectivity issue. The user can access local network resources but cannot browse the internet. The technician suspects a DNS problem. Which of the following is the primary function of DNS?

A.Filter unwanted network traffic
B.Translate domain names to IP addresses
C.Provide wireless network access
D.Assign IP addresses to devices on the network
AnswerB

DNS does name resolution.

Why this answer

DNS translates human-readable domain names (e.g., www.example.com) into IP addresses that computers use to communicate.

804
MCQmedium

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

A.NAS
B.JBOD
C.SAN
D.DAS
AnswerA

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

805
Multi-Selectmedium

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

Select 2 answers
A.Presentation software.
B.Database software.
C.Spreadsheet software.
D.Desktop publishing software.
E.Word processing software.
AnswersD, E

Desktop publishing apps like Adobe InDesign also support these features.

Why this answer

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

Exam trap

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

806
Multi-Selecteasy

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

Select 2 answers
A.Full control over underlying hardware
B.Requires dedicated IT staff for database administration
C.Managed maintenance and updates
D.Higher initial capital expenditure
E.Automatic scalability
AnswersC, E

Correct; the provider handles maintenance.

Why this answer

DBaaS provides managed maintenance and automatic scalability without hardware management. High availability is inherent, and initial cost is lower (pay-as-you-go).

807
MCQmedium

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

808
Multi-Selecteasy

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

Select 2 answers
A.Cat5e
B.USB
C.Coaxial
D.Cat6
E.HDMI
AnswersA, D

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

Why this answer

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

809
MCQmedium

A user is trying to install software on a macOS computer and has downloaded a file with a .dmg extension. What should the user do with this file to install the software?

A.Use the command line to run 'installer -pkg file.dmg'.
B.Extract the .dmg file using a decompression tool.
C.Rename the file to .app and drag it to the Applications folder.
D.Double-click the .dmg file to mount it, then run the installer inside.
AnswerD

This is the typical macOS process.

Why this answer

.dmg files are disk images that need to be mounted to access the installer.

810
Multi-Selecthard

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

Select 3 answers
A.Granting SELECT only on specific tables to a read-only user
B.Revoking INSERT and DELETE from a user who only needs to view data
C.Allowing remote access from any IP address for flexibility
D.Granting DBA privileges to all developers for convenience
E.Granting access to a specific database schema rather than the entire server
AnswersA, B, E

This restricts the user to only read necessary data.

Why this answer

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

Exam trap

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

811
MCQeasy

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

A.The application does not have permission to write to the folder.
B.Antivirus software is blocking the application.
C.The data file is corrupted.
D.The hard drive is full.
AnswerA

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

812
MCQhard

A company's IT policy requires that all employees use a specific word-processing application for creating official documents. An employee, who prefers a different application, uses that application to create a document and then saves it in the required application's native format. The employee gives the file to a coworker, who cannot open it. Which of the following is the MOST likely reason the coworker cannot open the file?

A.The coworker does not have the required application installed.
B.The file format is not fully compatible with the required application.
C.The file has restrictive permissions set by the operating system.
D.The file is being blocked by antivirus software due to suspicious content.
AnswerB

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

Why this answer

The employee saved the document in the required application's native format, but because it was originally created in a different application, the file may contain features, formatting, or metadata that are not fully supported by the required application. This can result in a file that appears to be in the correct format but is actually corrupted or unreadable when opened in the required application. Option B is correct because the core issue is format incompatibility, not the absence of the application itself.

Exam trap

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

How to eliminate wrong answers

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

813
MCQmedium

An organization is implementing a new payroll system. Before final deployment, a group of actual payroll employees test the system to ensure it meets their business needs and processes payroll correctly. Which testing phase is this?

A.Unit testing
B.User acceptance testing
C.System testing
D.Integration testing
AnswerB

UAT is performed by users to confirm the system meets their needs.

Why this answer

User acceptance testing (UAT) involves end users validating that the system meets their requirements.

814
MCQmedium

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

A.Router
B.Hub
C.Bridge
D.Switch
AnswerD

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

815
MCQmedium

A database administrator wants to enforce that every record in the 'Orders' table must have a non-null unique value in the 'OrderID' column. Which database concept ensures this?

A.Referential integrity
B.Entity integrity
C.Input validation
D.Domain integrity
AnswerB

Entity integrity is enforced by the primary key constraint.

Why this answer

Entity integrity requires a primary key to be unique and not null for each row.

816
MCQeasy

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

A.Open the attachment to check if it is a legitimate invoice.
B.Reply to the sender requesting more information.
C.Forward the email to the IT security team and then delete it.
D.Delete the email without opening any attachments.
AnswerC

Reporting suspicious emails to IT helps protect the organization.

Why this answer

Option C is correct because the most secure action when receiving an unsolicited email with an attachment from an unknown sender is to forward it to the IT security team for analysis and then delete it. This prevents potential malware execution (e.g., macro-based payloads in PDFs) and allows the security team to investigate the threat, such as checking for phishing indicators or malicious scripts. Opening or replying could compromise the system or reveal user information, while simply deleting may miss the opportunity to alert others.

Exam trap

The trap here is that candidates may think deleting the email is sufficient (Option D), but the exam emphasizes the importance of reporting security incidents to IT for organizational defense, not just individual action.

How to eliminate wrong answers

Option A is wrong because opening the attachment risks executing malicious code, such as JavaScript embedded in a PDF or a macro-enabled document, which could install ransomware or exfiltrate data. Option B is wrong because replying to the sender confirms the email address is active, increasing the risk of targeted phishing attacks, and may trigger social engineering tactics. Option D is wrong because deleting the email without reporting it fails to notify the IT security team, potentially allowing the same threat to reach other users without mitigation.

817
Multi-Selecteasy

Which TWO of the following are characteristics of a strong password? (Select TWO.)

Select 2 answers
A.Includes uppercase letters, numbers, and symbols
B.Uses a common dictionary word
C.At least 12 characters long
D.Based on your birth date
E.Contains only lowercase letters
AnswersA, C

Complexity from character variety strengthens the password.

Why this answer

A strong password is at least 12 characters and includes a mix of character types. Using common words or personal information weakens the password.

818
Multi-Selecthard

A user receives a suspicious email with an attachment claiming to be an invoice. Which three practices should the user follow? (Select THREE.)

Select 3 answers
A.Do not download unexpected attachments
B.Verify the sender's email address carefully
C.Forward the email to all employees for awareness
D.Hover over any links to see the actual URL before clicking
E.Download and open the attachment to check its content
AnswersA, B, D

Correct. Unexpected attachments may contain malware.

Why this answer

Verify the sender, avoid downloading unexpected attachments, and hover over links to check URL. Forwarding to all users spreads potential risk.

819
MCQeasy

Which of the following file extensions is associated with a compressed archive file?

A..exe
B..zip
C..jpg
D..docx
AnswerB

.zip is a compressed archive.

Why this answer

.zip is a common compressed archive format.

820
MCQhard

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

A.CPU
B.Storage
C.Network
D.RAM
AnswerB

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

821
MCQmedium

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

A.Ask all developers to manually undo the changes in their local copies.
B.Use the revert command to create a new commit that undoes the changes.
C.Delete the repository and start over.
D.Force delete the commit from history.
AnswerB

Revert safely undoes changes while preserving the existing commit history.

Why this answer

Option B is correct because the `git revert` command creates a new commit that undoes the changes introduced by a previous commit, effectively fixing the buggy code while preserving the full commit history. This is the standard, safe approach in Git for undoing changes on a shared branch like main, as it does not rewrite history or require force-pushing.

Exam trap

The trap here is that candidates may confuse `git revert` with `git reset`, thinking that deleting the commit from history (Option D) is acceptable, but Cisco tests that preserving history on a shared branch is a fundamental version control best practice.

How to eliminate wrong answers

Option A is wrong because manually undoing changes in local copies does not fix the remote main branch, and it leads to inconsistencies and merge conflicts when developers push their changes. Option C is wrong because deleting the repository and starting over is an extreme, unnecessary action that destroys all project history and work, and is never a recommended fix for a single bad commit. Option D is wrong because force deleting a commit from history (e.g., using `git reset --hard` followed by force push) rewrites shared history, which can corrupt other developers' repositories and is considered a dangerous practice on a shared branch like main.

822
MCQmedium

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

A.Duplicate IP address on the network
B.Incorrect default gateway
C.Incorrect subnet mask
D.Incorrect or unreachable DNS server
AnswerD

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

823
MCQeasy

Which SQL command is used to add a new row to a table?

A.INSERT INTO
B.ADD
C.CREATE
D.UPDATE
AnswerA

INSERT adds new records.

Why this answer

INSERT INTO is the SQL command for adding new rows.

824
Multi-Selectmedium

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

Select 2 answers
A.Inheritance
B.Loops
C.Functions
D.Variables
E.Encapsulation
AnswersA, E

Inheritance is a key OOP concept.

Why this answer

Inheritance is a core characteristic of object-oriented programming (OOP) that allows a class (child) to derive properties and behaviors from another class (parent). This promotes code reuse and establishes a hierarchical relationship between classes, which is fundamental to OOP design.

Exam trap

Cisco often tests the distinction between general programming concepts (like loops, functions, variables) and the specific pillars of OOP (inheritance, encapsulation, polymorphism, abstraction), leading candidates to mistakenly select common but non-defining features.

825
MCQeasy

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

A.The WAP's DHCP server is malfunctioning.
B.The computers with IP addresses in the 192.168.1.0/24 range are on a different subnet than the printer.
C.The switch port for the printer is faulty.
D.The printer is not powered on.
AnswerB

Different subnets require a router to communicate.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Page 10

Page 11 of 14

Page 12
CompTIA ITF+ FC0-U61 FC0-U61 Questions 751–825 | Page 11/14 | Courseiva