Courseiva

CompTIA Tech+ (FC0-U71) (FC0-U71) — Questions 175

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

Page 1 of 14

Page 2
1
Multi-Selecteasy

During the SDLC, testing is performed at different levels. Which TWO of the following are recognized levels of testing? (Select TWO.)

Select 2 answers
A.Maintenance
B.Code review
C.Integration testing
D.Unit testing
E.Deployment
AnswersC, D

Integration testing checks interactions between components.

Why this answer

Unit and integration testing are standard testing levels. Code review is a quality activity, not a testing level. Deployment and maintenance are phases, not testing levels.

2
MCQmedium

A small e-commerce website uses a relational database to manage its products and orders. The most common query is retrieving a product by its unique product ID. This query is executed thousands of times per minute. The database currently has no indexes, and the query is slow, causing user-facing delays. The database administrator wants to improve performance with minimal downtime and cost. Which action should be taken first?

A.Partition the table by product category
B.Add an index on the product ID column
C.Increase the server's memory to allow more caching
D.Change the database to a NoSQL system for faster key-value access
AnswerB

An index on the searched column accelerates lookups.

Why this answer

Adding an index on the product ID column creates a B-tree data structure that allows the database to locate rows using a logarithmic search instead of a full table scan. Since the query is executed thousands of times per minute and the table has no indexes, this single-column index directly addresses the bottleneck with minimal downtime and cost, as it requires only a CREATE INDEX statement.

Exam trap

The trap here is that candidates often choose increasing memory (Option C) because they confuse caching with indexing, not realizing that caching only helps after the first access and does not prevent full table scans on cache misses or for new data.

How to eliminate wrong answers

Option A is wrong because partitioning the table by product category would add complexity and overhead without directly speeding up lookups by product ID, and it requires significant schema changes and downtime. Option C is wrong because increasing server memory may improve caching of frequently accessed data, but it does not eliminate the need for a full table scan on a cold cache or first access, and it incurs hardware cost without addressing the root cause. Option D is wrong because migrating to a NoSQL system would require a complete architectural overhaul, significant downtime, and application rewrites, which contradicts the requirement for minimal downtime and cost.

3
Multi-Selectmedium

A technician is selecting a storage solution for a home server that requires fast access speeds and redundancy against a single drive failure. Which TWO technologies should be considered?

Select 2 answers
A.SSD
B.Cloud storage
C.HDD
D.RAID 1
E.RAID 0
AnswersA, D

SSDs offer fast read/write speeds compared to HDDs.

Why this answer

SSD (Solid State Drive) provides fast access speeds due to its use of NAND flash memory, which eliminates mechanical seek times and rotational latency found in HDDs. This makes it ideal for a home server requiring rapid data retrieval. RAID 1 (mirroring) writes identical data to two drives, offering redundancy against a single drive failure by allowing the system to continue operating if one drive fails.

Exam trap

The trap here is that candidates often confuse RAID 0 with RAID 1, mistakenly thinking RAID 0 provides redundancy because it improves performance, or they overlook that SSDs are necessary for fast access speeds, assuming HDDs are sufficient for a home server.

4
MCQeasy

Which component of a computer stores data permanently even when the power is turned off?

A.SSD
B.CPU cache
C.GPU
D.RAM
AnswerA

Correct: SSD is non-volatile storage.

Why this answer

SSDs and HDDs are non-volatile storage; they retain data without power.

5
Multi-Selectmedium

A company is planning to deploy tablets for field sales representatives. Which TWO mobile device features would be most useful for navigation and contactless payments?

Select 2 answers
A.Biometric authentication (fingerprint)
B.Gyroscope
C.Accelerometer
D.GPS
E.NFC
AnswersD, E

GPS is used for navigation and location-based services.

Why this answer

GPS provides location for navigation, and NFC enables contactless payments (e.g., via digital wallets).

6
MCQmedium

A web developer wants to identify why a web page is loading slowly. Which built-in browser tool is most appropriate to analyze network requests?

A.Password manager
B.Developer Tools
C.Download manager
D.Bookmark manager
AnswerB

Developer Tools provide network analysis and performance metrics.

Why this answer

Developer Tools (F12) include a Network tab that captures all HTTP/HTTPS requests made by the page, showing timing details (DNS lookup, TCP handshake, TLS negotiation, time to first byte, content download) and response sizes. This allows the developer to pinpoint slow resources, such as large images, unoptimized scripts, or server delays, making it the correct tool for analyzing network performance.

Exam trap

The trap here is that candidates confuse the general-purpose 'Developer Tools' with other browser utilities that have 'manager' in their name, assuming any 'manager' can handle performance analysis, when only Developer Tools provides the network waterfall and timing breakdowns.

How to eliminate wrong answers

Option A is wrong because a password manager stores and autofills credentials; it has no capability to monitor or analyze network traffic. Option C is wrong because a download manager handles file downloads from the browser but does not provide a timeline or waterfall view of all page resources. Option D is wrong because a bookmark manager organizes saved URLs and cannot inspect request/response headers, status codes, or load times.

7
MCQhard

A network technician observes that a DHCP server is not issuing IP addresses to clients. The DHCP server is running on a Windows Server with a static IP of 192.168.1.10. Clients are on the same subnet. Which of the following should the technician check FIRST?

A.Whether the DHCP Server service is running
B.Whether the DHCP scope is full
C.Whether a router is forwarding DHCP broadcasts
D.Whether the clients have a wireless connection
AnswerA

The DHCP service must be active to lease IP addresses.

Why this answer

The most fundamental check when a DHCP server fails to issue IP addresses is whether the DHCP Server service itself is running. If the service is stopped, the server cannot respond to any DHCP Discover messages, regardless of scope configuration or network topology. Since the clients are on the same subnet, no router forwarding is required, making service status the logical first step.

Exam trap

The trap here is that candidates jump to scope exhaustion or router configuration issues, forgetting that the most basic service-level check is the first step in any troubleshooting methodology.

How to eliminate wrong answers

Option B is wrong because a full DHCP scope would prevent new leases but the server would still respond with a DHCPNAK; the service must be running to send any response. Option C is wrong because clients are on the same subnet as the DHCP server, so DHCP broadcasts do not need to cross a router; checking router forwarding is irrelevant here. Option D is wrong because the question states clients are on the same subnet and does not mention wireless issues; a wireless connection problem would manifest as no link, not a DHCP-specific failure.

8
Multi-Selectmedium

A company is setting up a new branch office. The network administrator needs to choose a wireless standard and a frequency band. Which TWO of the following options would provide the fastest speeds and least interference? (Select TWO.)

Select 2 answers
A.5GHz
B.2.4GHz
C.802.11ax
D.802.11ac
E.Bluetooth
AnswersA, C

5GHz has less interference and higher speeds.

Why this answer

802.11ax (Wi-Fi 6) is the latest standard, and 5GHz offers faster speeds and less interference than 2.4GHz.

9
MCQmedium

A company requires all employees to use a smart card and a PIN to access the building. This is an example of which concept?

A.Authorization
B.Biometrics
C.Multi-factor authentication
D.Single sign-on
AnswerC

Two different factors are used: possession (smart card) and knowledge (PIN).

Why this answer

Multi-factor authentication combines something you have (smart card) and something you know (PIN).

10
MCQmedium

A user saves a document as 'report.docx'. Based on the file extension, what type of file is it?

A.PDF file
B.Presentation
C.Spreadsheet
D.Word processing document
AnswerD

.docx is a Word document format.

Why this answer

The .docx extension is associated with Microsoft Word documents.

11
MCQeasy

Which of the following is the primary function of a router in a home network?

A.Converts ISP signal to digital
B.Assigns IP addresses to devices
C.Provides wireless connectivity only
D.Connects the home network to the internet
AnswerD

Routers direct traffic between networks.

Why this answer

A router connects the home network to the internet and performs NAT to share the public IP.

12
MCQmedium

A web application is not responding to user input. The developer checks the code and finds an infinite loop. Which change will fix the infinite loop?

A.Remove the loop body
B.Add a break statement
C.Add a counter variable that increments and check it in the condition
D.Change from a for loop to a while loop
AnswerC

A counter limits the number of iterations, ensuring the loop eventually ends.

Why this answer

An infinite loop occurs when the loop's termination condition is never met. By adding a counter variable that increments with each iteration and checking it in the condition, the loop will eventually exit when the counter reaches a specified limit, thus breaking the infinite loop.

Exam trap

The trap here is that candidates may think changing the loop type (e.g., for to while) or removing the body will fix the infinite loop, but the core issue is the lack of a proper termination condition, which only a counter or similar mechanism can resolve.

How to eliminate wrong answers

Option A is wrong because removing the loop body does not change the loop's condition; the loop will still run infinitely if the condition never becomes false. Option B is wrong because adding a break statement will exit the loop immediately, but it does not address the root cause of the infinite loop and may lead to premature termination or logic errors. Option D is wrong because changing from a for loop to a while loop does not inherently fix an infinite loop; the condition must still be properly defined to allow termination.

13
MCQhard

A software developer writes code that interacts with the operating system to access hardware. Which layer of software is being used?

A.Application software
B.Firmware
C.System software
D.Utility software
AnswerC

System software like the OS manages hardware resources.

Why this answer

System software, specifically the operating system kernel, provides the interface between application software and hardware. When a software developer writes code that interacts with the OS to access hardware, they are using system calls (e.g., Windows API, POSIX syscalls) that are part of the system software layer. This layer manages hardware resources and abstracts them for higher-level programs.

Exam trap

The trap here is that candidates confuse 'system software' with 'application software' because they think writing code that 'accesses hardware' must be an application, but the key phrase 'interacts with the operating system' points directly to the system software layer.

How to eliminate wrong answers

Option A is wrong because application software (e.g., word processors, web browsers) runs on top of the OS and does not directly interact with hardware; it relies on system software for hardware access. Option B is wrong because firmware is low-level software stored in ROM/Flash that initializes hardware (e.g., BIOS/UEFI) but is not the layer used by a developer to interact with the OS for hardware access during runtime. Option D is wrong because utility software (e.g., disk defragmenters, antivirus) is a subset of system software focused on maintenance tasks, not the primary layer for general hardware access via OS calls.

14
MCQhard

A company is deciding between using open-source software and proprietary software for a new project. Which of the following is a primary advantage of open-source software?

A.No cost for any type of use or distribution.
B.The ability to modify the source code to fit specific needs.
C.Guaranteed professional technical support.
D.Vendor lock-in with regular updates.
AnswerB

Open-source licenses grant the right to modify and distribute changes.

Why this answer

Open-source software provides access to its source code under a license (e.g., GPL, Apache 2.0) that permits users to study, modify, and redistribute it. This ability to customize the code to meet specific business or technical requirements is a primary advantage, as proprietary software typically restricts such modifications through end-user license agreements (EULAs).

Exam trap

The trap here is that candidates often assume 'free' means 'no cost for any use,' but the CompTIA FC0-U61 exam emphasizes that open-source refers to license freedoms (access to source code) rather than zero monetary cost, and that 'no cost' is not a guaranteed or primary advantage.

How to eliminate wrong answers

Option A is wrong because while open-source software is often available at no cost, many licenses impose conditions on distribution or commercial use (e.g., copyleft requirements), and some open-source projects charge for enterprise features or support, so 'no cost for any type of use or distribution' is not universally true. Option C is wrong because professional technical support is not guaranteed with open-source software; it may rely on community forums or optional paid support contracts, whereas proprietary software often includes vendor-provided support. Option D is wrong because vendor lock-in is a characteristic of proprietary software, not open-source; open-source software avoids vendor lock-in by allowing users to switch providers or self-support, and regular updates are not guaranteed by a single vendor.

15
MCQeasy

A small e-commerce company uses a monolithic web application hosted on a single server. During peak shopping hours, the server becomes overloaded, causing slow page loads and occasional timeouts. The development team wants to improve scalability and maintainability. They are considering breaking the application into smaller, independent services that can be developed, deployed, and scaled separately. Which approach should the team adopt?

A.Migrate to a microservices architecture.
B.Move the application to a serverless computing platform.
C.Implement a service-oriented architecture (SOA) with an enterprise service bus.
D.Containerize the existing monolithic application.
AnswerA

Microservices break the app into small, independent services for better scalability and maintainability.

Why this answer

Microservices architecture involves decomposing an application into small, independent services. Option A is correct. Option B is incorrect because serverless computing is a cloud execution model, not an architecture specific to breaking up a monolith; it still requires code to be structured.

Option C is incorrect because service-oriented architecture (SOA) is similar but typically relies on an enterprise service bus (ESB) for communication, which can create a single point of failure and is less granular than microservices. Option D is incorrect because containerization packages the application into containers but does not inherently split the monolith; the app remains monolithic unless the code is refactored.

16
MCQhard

Refer to the exhibit. A database administrator runs the following query: SELECT c.Name, SUM(o.Quantity) AS TotalItems FROM Customers c LEFT JOIN Orders o ON c.ID = o.CustomerID GROUP BY c.Name; What is the result for 'Alice'?

A.2
B.NULL
C.5
D.7
AnswerD

SUM of both orders (2+5=7).

Why this answer

The LEFT JOIN ensures that Alice's record from the Customers table is retained even if there are no matching rows in Orders. The SUM(o.Quantity) aggregates the Quantity values from the joined Orders rows for Alice. Since Alice has two orders with quantities 2 and 5, the sum is 7, making option D correct.

Exam trap

The trap here is that candidates may mistakenly pick the quantity of a single order (2 or 5) instead of computing the SUM, or incorrectly assume that a LEFT JOIN would produce NULL for Alice when she actually has matching orders.

How to eliminate wrong answers

Option A is wrong because 2 is only the quantity of one of Alice's orders, not the total sum of all her order quantities. Option B is wrong because NULL would only appear if there were no matching Orders rows for Alice, but she has two orders (IDs 101 and 102) with quantities 2 and 5. Option C is wrong because 5 is the quantity of only the second order, not the sum of both orders.

17
Multi-Selectmedium

A user notices their computer is running slowly and has many applications open. Which TWO hardware components are most likely to impact the speed at which multiple applications can run simultaneously? (Select TWO).

Select 2 answers
A.SSD vs HDD
B.Amount of RAM
C.Hard drive capacity
D.GPU memory
E.CPU speed and cores
AnswersB, E

More RAM allows more applications to run concurrently without swapping.

Why this answer

RAM provides working memory for running programs; more RAM allows more programs to run smoothly. CPU speed and cores affect processing. HDD/SSD affect loading times but not simultaneous execution as directly.

GPU is for graphics.

18
MCQhard

A user downloads a freeware application that displays occasional ads and offers paid upgrade options. This distribution model is best described as:

A.Shareware
B.Freeware
C.Freemium
D.Commercial
AnswerC

Freemium offers basic features free with optional paid upgrades.

Why this answer

Freemium offers basic features free and charges for premium features. Freeware is completely free with no payment required. Shareware is trial-based.

Commercial is paid upfront.

19
MCQmedium

Which type of malware is designed to replicate itself and spread to other computers without needing to attach to a host file?

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

Worms spread without needing a host file.

Why this answer

Worms are self-replicating and spread independently, unlike viruses which attach to files.

20
MCQmedium

A user is trying to connect a laptop to a high-definition monitor that supports 4K resolution at 60Hz. Which of the following ports on the laptop will support this video output?

A.HDMI
B.Ethernet RJ45
C.3.5mm audio jack
D.USB-A 3.0
AnswerA

HDMI supports 4K@60Hz.

Why this answer

DisplayPort and HDMI 2.0+ support 4K@60Hz. USB-A and Thunderbolt 3/4 can also carry video, but USB-A alone does not. Among the options, HDMI is the most common and correct.

21
MCQmedium

A developer is trying to find why a program is producing incorrect output. The developer runs the program with a debugging tool, sets a breakpoint at a specific line, and examines the values of variables at that point. Which debugging technique is being used?

A.Code review
B.Step-through execution
C.Logging
D.Breakpoint inspection
AnswerD

Breakpoints halt execution for variable inspection.

Why this answer

The developer is using breakpoint inspection, a debugging technique where execution is paused at a specific line of code (the breakpoint) to examine variable values at that exact moment. This allows the developer to inspect the program's state without stepping through each subsequent line, directly identifying why incorrect output occurs.

Exam trap

The trap here is that candidates confuse breakpoint inspection with step-through execution, but step-through involves actively moving through code line by line, whereas breakpoint inspection pauses at a single point for variable examination without stepping.

How to eliminate wrong answers

Option A is wrong because code review is a manual or automated analysis of source code without executing it, not a runtime debugging technique involving breakpoints or variable inspection. Option B is wrong because step-through execution involves executing code line by line, often using 'step into' or 'step over' commands, which is different from simply setting a breakpoint and examining variables without stepping. Option C is wrong because logging involves writing messages to a log file or console during execution, not pausing at a breakpoint to inspect variables interactively.

22
MCQhard

A system administrator needs to deploy a software update to 500 computers without user interaction. Which installation method should be used?

A.Run the installer with the /quiet or /silent switch
B.Email the installer to each user and ask them to run it
C.Copy the program files manually to each computer
D.Install from an app store
AnswerA

Correct. Silent installation uses switches like /quiet to suppress UI.

Why this answer

Silent installation (also called unattended installation) uses command-line switches or configuration files to install software without prompts, ideal for mass deployments.

23
MCQmedium

A graphic designer needs to choose a software for vector illustration. Which of the following is best suited?

A.Adobe Illustrator
B.GIMP
C.Adobe Photoshop
D.Microsoft Word
AnswerA

Correct. Adobe Illustrator is a dedicated vector graphics editor, ideal for creating and editing scalable illustrations.

Why this answer

Adobe Illustrator is the industry-standard vector graphics editor, designed specifically for creating and editing scalable vector illustrations. GIMP and Adobe Photoshop are primarily raster (pixel-based) editors, while Microsoft Word offers only basic shape tools and is not intended for professional vector illustration. Therefore, Adobe Illustrator is the best suited choice.

Exam trap

Candidates may confuse raster and vector graphics, or assume that a common office tool like Word can handle professional vector illustration. The question specifically tests knowledge of dedicated vector software.

How to eliminate wrong answers

Option A is correct because Adobe Illustrator is the industry-standard vector illustration software, using mathematical paths (Bezier curves) to create scalable graphics. Option B is wrong because GIMP (GNU Image Manipulation Program) is a raster-based image editor focused on pixel manipulation, not vector graphics. Option C is wrong because Adobe Photoshop is primarily a raster graphics editor, though it has limited vector capabilities, it is not best suited for pure vector illustration.

Option D is wrong because Microsoft Word is a word processing application with only basic drawing tools, not a dedicated vector illustration program.

24
MCQhard

A user reports being unable to access the internet, but can reach other devices on the local network. Based on the exhibit, what is the most likely cause?

A.The default gateway is missing.
B.The IP address is in the wrong subnet.
C.The subnet mask is incorrect.
D.The DNS server is not reachable.
AnswerD

The DNS server 8.8.8.8 might be blocked or unreachable.

Why this answer

Since the user can reach other devices on the local network but cannot access the internet, the issue is likely with the default gateway or DNS resolution. Option D is correct because if the DNS server is unreachable, the user can still communicate with local devices via IP addresses but cannot resolve domain names to access internet resources. The exhibit likely shows a valid IP address and subnet mask, but the DNS server address is missing or incorrect, preventing name resolution.

Exam trap

The trap here is that candidates often assume internet access failure is always a gateway problem, but the ability to reach local devices isolates the issue to DNS or gateway; the exhibit likely shows a valid gateway IP, making DNS the correct answer.

How to eliminate wrong answers

Option A is wrong because if the default gateway were missing, the user would not be able to reach any devices outside the local subnet, but they can still communicate with local devices; however, the question states they cannot access the internet, which could also be caused by a missing gateway, but the exhibit likely shows a configured gateway, making DNS the more specific issue. Option B is wrong because an IP address in the wrong subnet would prevent communication with any devices on the local network, which contradicts the user's ability to reach other local devices. Option C is wrong because an incorrect subnet mask would cause the device to misidentify which addresses are local versus remote, typically breaking local communication as well, which is not the case here.

25
MCQeasy

A small office has five desktop computers that need to be connected to share files and a printer. Which network device should be used to create a local area network?

A.Hub
B.Switch
C.Modem
D.Router
AnswerB

Switches forward data based on MAC addresses, ideal for creating a local network.

Why this answer

A switch is the correct device because it operates at Layer 2 of the OSI model, using MAC addresses to forward frames only to the specific port where the destination device is connected. This creates a dedicated, collision-free path between any two communicating devices, which is essential for a small office LAN where five computers need to share files and a printer efficiently.

Exam trap

The trap here is that candidates often confuse a hub with a switch because both have multiple Ethernet ports, but the hub's lack of intelligence and shared collision domain makes it obsolete for any practical LAN beyond legacy or lab use.

How to eliminate wrong answers

Option A is wrong because a hub operates at Layer 1, simply repeating electrical signals out all ports, which forces all devices to share the same collision domain and halves throughput under load — it is not suitable for a modern LAN. Option C is wrong because a modem (modulator-demodulator) converts digital signals to analog for transmission over telephone or cable lines; it connects a LAN to a WAN (e.g., the internet) but does not create the internal LAN itself. Option D is wrong because a router operates at Layer 3, forwarding packets based on IP addresses and typically connecting different networks; while it can include a built-in switch, a standalone router is overkill and not the primary device for creating a single local network segment.

26
MCQeasy

A user wants to permanently delete files from a USB flash drive without any possibility of recovery. Which of the following techniques should be used?

A.Quick format
B.Change the file extension
C.Delete and empty Recycle Bin
D.Overwrite the drive with random data
AnswerD

Overwriting ensures original data is no longer recoverable.

Why this answer

Overwriting the data with random patterns ensures the original data cannot be recovered. Quick format only removes the file system index, and deletion marks space as available.

27
MCQmedium

An attacker gains physical access to a secure area by following an authorized employee through a door that requires a badge. This social engineering technique is known as:

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

Tailgating is physically following someone through a door without authorization.

Why this answer

Tailgating (or piggybacking) is when an unauthorized person follows an authorized person into a restricted area without proper authentication.

28
MCQhard

A small business owner wants to protect customer data stored on laptops in case the devices are stolen. Which encryption method provides the best protection for the entire hard drive?

A.HTTPS encryption for web traffic
B.File-level encryption on individual documents
C.A VPN when connecting to the internet
D.Full disk encryption
AnswerD

Correct: full disk encryption protects all data on the drive.

Why this answer

Full disk encryption (e.g., BitLocker or FileVault) encrypts the entire drive, making data unreadable without the decryption key even if the physical device is stolen.

29
MCQmedium

A user wants to connect a high-resolution 4K monitor to their desktop computer for gaming at 144Hz. Which port should they use to ensure the best performance?

A.DisplayPort
B.DVI
C.VGA
D.HDMI 1.4
AnswerA

DisplayPort 1.2 or higher supports 4K at 144Hz.

Why this answer

DisplayPort supports high resolutions and refresh rates, including 4K at 144Hz, while HDMI 1.4 is limited to 4K at 30Hz.

30
MCQhard

A company wants to run multiple operating systems on a single physical server to maximize resource utilization. Which technology should they use?

A.Dual booting
B.Cloud computing
C.Virtual machines
D.Containerization
AnswerC

Correct.

Why this answer

Virtualization, via a hypervisor, allows multiple VMs (each with its own OS) to run on one physical host.

31
Multi-Selecthard

A technician is evaluating the CPU specifications of two computers. Which THREE factors directly affect the CPU's performance? (Select THREE.)

Select 3 answers
A.Number of cores
B.Amount of RAM installed
C.Clock speed (GHz)
D.Power supply wattage
E.Cache size (L1/L2/L3)
AnswersA, C, E

More cores allow parallel processing.

Why this answer

Clock speed (GHz), number of cores, and cache size directly affect CPU performance. RAM size and PSU wattage do not directly affect CPU speed.

32
MCQmedium

An employee allows a delivery person to enter a secure office building by holding the door open. The delivery person does not have an access badge. Which social engineering attack is this?

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

Correct. Following someone into a secure area is tailgating.

Why this answer

Tailgating (or piggybacking) occurs when an unauthorized person follows an authorized person into a restricted area without proper authentication.

33
Multi-Selectmedium

Which TWO of the following are effective measures to protect against ransomware attacks? (Select two.)

Select 2 answers
A.Using the same password for all accounts
B.Installing the latest software updates and patches
C.Disabling the firewall
D.Regularly backing up important files
E.Opening email attachments from unknown senders
AnswersB, D

Patches fix vulnerabilities that ransomware might exploit.

Why this answer

Regular backups allow restoration without paying ransom; keeping systems patched closes vulnerabilities that ransomware exploits.

34
Multi-Selectmedium

Which TWO of the following are common characteristics of compiled programming languages?

Select 2 answers
A.The code is executed line-by-line by an interpreter.
B.The resulting executable is platform-specific.
C.Variables do not need to be declared before use.
D.The source code is translated into machine code before execution.
E.The source code is compiled every time the program runs.
AnswersB, D

Machine code is tied to a specific CPU architecture and OS.

Why this answer

Compiled languages produce machine code that is specific to the target operating system and processor architecture. This platform-specific executable cannot run on a different OS or CPU without recompilation, which is a defining characteristic of compiled languages like C or C++.

Exam trap

The trap here is that candidates often confuse 'compiled every time the program runs' (Option E) with the actual compilation process, mistakenly thinking recompilation occurs at each execution, when in fact the executable is pre-built and reused.

35
MCQmedium

Which network topology connects all devices to a single central cable?

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

Bus topology uses one main cable.

Why this answer

A bus topology uses a single central cable, often called a backbone or trunk, to which all devices are connected via drop lines or taps. Data transmitted by any device travels along the entire cable, and each device checks the destination address to determine if it should accept the data. This contrasts with other topologies that use different physical or logical connection methods.

Exam trap

The trap here is that candidates often confuse the 'single central cable' of a bus topology with the 'central device' of a star topology, mistakenly thinking a hub or switch is a cable, or they assume 'central' implies a star layout.

How to eliminate wrong answers

Option A is wrong because a ring topology connects each device to exactly two neighbors, forming a closed loop, and data travels in one direction around the ring, not along a single central cable. Option B is wrong because a star topology connects all devices to a central hub or switch, not to a single shared cable; each device has its own dedicated link to the central device. Option C is wrong because a mesh topology provides multiple redundant paths between devices, with each device potentially connected to every other device, not a single shared cable.

36
MCQeasy

Which of the following is a characteristic of a relational database table?

A.Rows represent records and columns represent fields
B.Rows represent fields and columns represent records
C.Each table must have a composite key
D.Tables are stored in a hierarchical structure
AnswerA

Correct definition.

Why this answer

In a relational database, each row represents a single record (tuple) and each column represents an attribute (field).

37
MCQmedium

A graphic designer is working with a large image file in a proprietary software format. The designer needs to send the image to a client who uses a different operating system and does not have the same software. Which of the following is the BEST method to ensure the client can open the file?

A.Compress the file into a ZIP archive before sending.
B.Email the client the software license so they can install the same application.
C.Change the file extension to .jpg without altering the file contents.
D.Export the file to a commonly used format such as JPEG or PNG.
AnswerD

Standard formats are universally supported across operating systems and software.

Why this answer

Exporting the file to a commonly used format like JPEG or PNG ensures cross-platform compatibility without requiring the client to have the proprietary software. JPEG and PNG are standardized, universally supported formats that can be opened by any operating system's default image viewer or basic graphics application, solving the problem of different OS and missing software.

Exam trap

The trap here is that candidates may think changing the file extension or compressing the file is sufficient, failing to recognize that the underlying file format must be converted to a universally supported standard for cross-platform compatibility.

How to eliminate wrong answers

Option A is wrong because compressing the file into a ZIP archive only reduces file size and bundles the file, but does not change the proprietary format; the client still cannot open the proprietary file without the correct software. Option B is wrong because emailing a software license does not provide the actual application installer, and the client may not be able to run the proprietary software on a different operating system due to platform incompatibility. Option C is wrong because simply changing the file extension to .jpg without converting the internal data does not change the file's binary structure; the client's system will attempt to decode it as a JPEG and fail, resulting in a corrupted or unopenable file.

38
Multi-Selecthard

A security analyst is evaluating risks to the company's network. According to the risk formula (Risk = Likelihood × Impact), which THREE of the following are considered vulnerabilities?

Select 3 answers
A.Weak encryption used for data in transit
B.A hacker attempting to guess passwords
C.A fire in the data center
D.Employees not trained to recognize phishing emails
E.Unpatched software on the company's web server
AnswersA, D, E

Weak encryption is a vulnerability that can be exploited to intercept data.

Why this answer

A vulnerability is a weakness that can be exploited by a threat.

39
MCQmedium

A user is working on a presentation for a client meeting. The user has been using Microsoft PowerPoint and has completed the slides. The user now needs to create handouts for the audience so they can follow along. The handouts should show the slides with space for notes. Which of the following is the BEST way to create these handouts?

A.Print the presentation with full-page slides.
B.Use PowerPoint's handout feature to print slides with note lines.
C.Manually copy each slide into a word processing document.
D.Take screenshots of each slide and arrange them in a document.
AnswerB

PowerPoint offers a handout layout specifically for this purpose.

Why this answer

PowerPoint's handout feature is specifically designed to create printed handouts that include slide thumbnails and adjacent note lines for audience notes. This built-in functionality (File > Print > Handouts) allows you to select the number of slides per page and automatically adds ruled lines for note-taking, making it the most efficient and correct method for this task.

Exam trap

The trap here is that candidates may think printing full-page slides (Option A) is sufficient for handouts, overlooking the specific requirement for note-taking space, or they may assume that manual methods (Options C and D) are acceptable workarounds when the built-in handout feature is the intended solution.

How to eliminate wrong answers

Option A is wrong because printing full-page slides produces one slide per page with no space for notes, which does not meet the requirement for handouts with note lines. Option C is wrong because manually copying each slide into a word processing document is time-consuming, error-prone, and lacks the automatic formatting and note lines provided by PowerPoint's handout feature. Option D is wrong because taking screenshots and arranging them in a document is inefficient, may result in inconsistent sizing and quality, and does not include the structured note lines that the handout feature provides.

40
MCQhard

An IT specialist is explaining ASCII and Unicode to a trainee. Which statement accurately describes a difference between ASCII and Unicode?

A.ASCII uses 8 bits per character and supports 256 characters.
B.Unicode uses 16 bits per character, while ASCII uses 7 bits.
C.ASCII is a variable-width encoding, while Unicode uses a fixed width.
D.Unicode can represent characters from multiple languages, while ASCII is limited to English.
AnswerD

Unicode supports global scripts; ASCII covers English and basic symbols.

Why this answer

ASCII uses 7 bits and can represent 128 characters. Unicode is a variable-width encoding that supports characters from many languages.

41
MCQeasy

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

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

RAM is volatile.

Why this answer

RAM (Random Access Memory) is volatile and loses data on power loss.

42
MCQmedium

An employee receives an email with an attachment that claims to be an invoice. The employee is unsure of the sender. What is the best practice?

A.Delete the email and report it to the IT department.
B.Forward the email to a personal email for later review.
C.Reply to the sender requesting confirmation.
D.Open the attachment to verify its contents.
AnswerA

Deleting removes the threat; reporting allows IT to warn others.

Why this answer

The safest response to an unsolicited email with an attachment from an unknown sender is to delete it and report it to the IT department. This follows the principle of least privilege and zero-trust security, as opening or interacting with the attachment could trigger a malware payload, such as a macro virus or ransomware, that exploits vulnerabilities in the email client or operating system.

Exam trap

The trap here is that candidates may think replying or forwarding is harmless, but CompTIA tests the understanding that any interaction with an untrusted email—even a reply—can expose the user to phishing or confirm a live target, while opening the attachment is the most direct path to a security breach.

How to eliminate wrong answers

Option B is wrong because forwarding the email to a personal email account bypasses corporate security controls, such as email filtering and Data Loss Prevention (DLP) policies, and could introduce malware into a less-protected personal environment. Option C is wrong because replying to the sender confirms the email address is active and monitored, which can lead to targeted phishing attacks or social engineering; the sender may be spoofed, making the reply useless. Option D is wrong because opening the attachment is the most dangerous action—it could execute malicious code (e.g., a VBA macro or JavaScript) that compromises the system, even if the file appears to be a harmless PDF or DOCX.

43
Multi-Selectmedium

A REST API is used by a mobile app to retrieve data. The API returns responses in a specific format. Which THREE of the following are typical characteristics of a REST API?

Select 3 answers
A.Uses SOAP for message exchange
B.Maintains server-side session state
C.Is stateless between requests
D.Returns data in JSON format
E.Uses HTTP methods like GET and POST
AnswersC, D, E

Statelessness is a key constraint of REST.

Why this answer

REST APIs are stateless by design, meaning each request from a client to the server must contain all the information needed to understand and process the request. The server does not store any client context between requests, which improves scalability and reliability. This statelessness is a core constraint of the REST architectural style, as defined by Roy Fielding in his doctoral dissertation.

Exam trap

A common misconception in the CompTIA ITF+ exam is that REST APIs must use JSON exclusively, but while JSON is common, REST can return data in any format (e.g., XML, HTML, plain text) as long as it adheres to REST constraints.

44
MCQeasy

A database table contains repeating groups of fields for multiple phone numbers per customer. Which normal form is being violated?

A.Second Normal Form
B.Third Normal Form
C.First Normal Form
D.No violation
AnswerC

Repeating groups violate 1NF.

Why this answer

First Normal Form (1NF) requires that each column in a table contains atomic (indivisible) values and that there are no repeating groups of columns. Storing multiple phone numbers per customer in a single row, such as Phone1, Phone2, Phone3, violates 1NF because it creates a repeating group of fields. To comply with 1NF, the phone numbers should be stored in a separate child table with one row per phone number per customer.

Exam trap

CompTIA often tests the misconception that repeating groups are a violation of Second or Third Normal Form, but the trap is that repeating groups are the defining characteristic of a First Normal Form violation, not a higher normal form.

How to eliminate wrong answers

Option A is wrong because Second Normal Form (2NF) addresses partial dependencies on a composite key, not repeating groups; it assumes 1NF is already satisfied. Option B is wrong because Third Normal Form (3NF) deals with transitive dependencies (non-key attributes depending on other non-key attributes), which is a higher-level concern after 1NF and 2NF are met. Option D is wrong because the presence of repeating groups is a clear violation of First Normal Form, so the table is not in 1NF.

45
MCQmedium

Which of the following best describes the function of a hypervisor?

A.It is a type of operating system designed for servers
B.It manages cloud resource allocation across multiple data centers
C.It allows multiple operating systems to run on a single physical machine
D.It provides antivirus protection for virtual machines
AnswerC

A hypervisor creates and manages virtual machines.

Why this answer

A hypervisor allows multiple operating systems to run on one physical machine by virtualizing hardware. It does not manage cloud resources directly, nor is it an OS or antivirus.

46
MCQmedium

A company needs to store customer orders with items and quantities. The database currently has a table 'Customers' and a table 'Products'. Which of the following is the best way to represent the many-to-many relationship between orders and products?

A.Create a single table containing all customer, order, and product information.
B.Create an Order_Items table with foreign keys to Orders and Products, plus a Quantity column.
C.Store a JSON list of product IDs in an OrderProducts column in the Orders table.
D.Add columns Product1, Product2, Product3 to the Orders table.
AnswerB

This correctly implements a junction table for a many-to-many relationship.

Why this answer

It creates a junction table (Order_Items) that resolves the many-to-many relationship between Orders and Products. The Order_Items table includes foreign keys referencing both the Orders and Products tables, plus a Quantity column to store the number of each product in an order, which is the standard normalized relational database design.

Exam trap

The trap here is that candidates may think storing data in a single table or using a JSON column is simpler and acceptable, but the FC0-U61 exam tests the fundamental principle of normalization and the proper use of junction tables to maintain data integrity and avoid redundancy.

How to eliminate wrong answers

Option A is wrong because it violates database normalization principles by combining all data into a single table, leading to massive data redundancy and update anomalies. Option C is wrong because storing a JSON list of product IDs in a single column breaks first normal form (1NF) by storing multiple values in one column, making it impossible to enforce referential integrity or efficiently query individual products. Option D is wrong because adding fixed columns (Product1, Product2, Product3) cannot handle a variable number of products per order and violates the principle of atomicity, as it imposes an arbitrary limit and wastes space.

47
MCQmedium

A company's database administrator notices that queries against a large customer table are running slowly. The table has millions of rows and is frequently filtered by the 'last_name' column. Which of the following is the BEST way to improve query performance without changing the application code?

A.Partition the table by row count.
B.Increase the database server's RAM.
C.Create an index on the 'last_name' column.
D.Denormalize the table to reduce joins.
AnswerC

An index on the filtered column enables rapid row retrieval, significantly speeding up queries.

Why this answer

Creating an index on the 'last_name' column allows the database to locate rows matching filter conditions without scanning the entire table. This dramatically reduces I/O and CPU overhead for queries that filter by last_name, directly addressing the performance bottleneck without requiring any changes to application code.

Exam trap

The trap here is that candidates often choose 'Increase the database server's RAM' because they think more memory will speed up all queries, but without an index the database still must read every row from disk or memory, and RAM alone cannot eliminate the need for a full table scan.

How to eliminate wrong answers

Option A is wrong because partitioning by row count does not inherently speed up queries filtered by a specific column; it only splits data into smaller physical segments, which can even increase overhead if the partition key does not align with the filter column. Option B is wrong because increasing RAM may help caching but does not change the fundamental need for a full table scan when no index exists; it is a hardware band-aid that does not optimize query execution paths. Option D is wrong because denormalization reduces joins but does not address the core issue of slow filtering on last_name; it introduces data redundancy and maintenance complexity without improving lookup speed on that column.

48
Multi-Selecthard

A systems administrator is configuring a new server and needs to ensure high availability and reliability. Which THREE of the following are characteristics of cloud computing that support high availability? (Select THREE.)

Select 3 answers
A.Fixed capacity
B.Resource pooling
C.On-demand self-service
D.Broad network access
E.Local installation required
AnswersB, C, D

Multiple customers share resources, allowing redundancy across data centers.

Why this answer

Cloud computing provides on-demand self-service, resource pooling, rapid elasticity, measured service, and broad network access. These enable redundancy and automatic scaling for high availability.

49
MCQhard

A security policy grants the following permissions: Read and List. Based on the policy, what actions are permitted by this policy?

A.Read and List
B.Read only
C.Read and Delete
D.Write and Read
AnswerA

Correct. The policy grants Read and List actions.

Why this answer

The policy explicitly grants both the Read and List actions, as is common in many policy configurations. The trap is that candidates may assume Read alone is granted, but List is a separate permission that must be explicitly included.

Exam trap

The trap is that candidates may assume Read implies List, but in many security policies List is a separate action that must be explicitly granted.

How to eliminate wrong answers

Option A is wrong because ListObjects is not included in the policy's Action list; only GetObject is allowed. Option C is wrong because DeleteObject is not listed in the policy's Action list; the policy only grants GetObject. Option D is wrong because PutObject is not listed in the policy's Action list; the policy only grants GetObject.

50
MCQhard

A database has a table 'Orders' with columns OrderID (primary key), CustomerID, OrderDate, and TotalAmount. Which SQL statement will delete all orders placed before January 1, 2023?

A.DROP FROM Orders WHERE OrderDate < '2023-01-01'
B.DELETE FROM Orders WHERE OrderDate < '2023-01-01'
C.DELETE OrderDate < '2023-01-01' FROM Orders
D.REMOVE FROM Orders WHERE OrderDate < '2023-01-01'
AnswerB

Correct; deletes rows with OrderDate before the specified date.

Why this answer

DELETE FROM table WHERE condition removes rows that satisfy the condition.

51
MCQmedium

A user receives an email from their bank asking them to click a link and verify their account information. The email contains spelling errors and the sender's address looks suspicious. Which type of social engineering attack is this?

A.Spear phishing
B.Pretexting
C.Vishing
D.Phishing
AnswerD

The email is a typical phishing attempt trying to steal credentials.

Why this answer

Phishing is a social engineering attack where attackers send deceptive emails to trick recipients into revealing sensitive information.

52
MCQeasy

A developer wants to represent the logic of a program before writing code. The diagram should show decisions with diamond shapes and processes with rectangles. Which representation is the developer creating?

A.Algorithm
B.Data structure
C.Pseudocode
D.Flowchart
AnswerD

Flowcharts use shapes like diamonds for decisions and rectangles for processes.

Why this answer

A flowchart uses standard symbols to visually represent program logic, including decision diamonds and process rectangles.

53
Matchingmedium

Match each troubleshooting step to its order in the CompTIA A+ methodology.

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

Concepts
Matches

Step 1

Step 2

Step 3

Step 5

Why these pairings

The CompTIA A+ troubleshooting methodology has 7 steps: 1. Identify the problem, 2. Establish a theory of probable cause, 3.

Test the theory, 4. Establish a plan of action, 5. Implement the solution, 6.

Verify full system functionality, 7. Document findings. Common mistakes include swapping the order of the first three steps.

54
MCQhard

During a code review, a team notices that a function modifies a global variable instead of returning a value. Which software development principle is being violated?

A.Encapsulation
B.Polymorphism
C.Modularity
D.Inheritance
AnswerC

Modularity emphasizes that functions should be independent and avoid global side effects.

Why this answer

Modularity is the principle that a function should perform a single, well-defined task and communicate with the rest of the program through its inputs and outputs, not by altering shared state. By modifying a global variable instead of returning a value, the function creates hidden dependencies and side effects, which breaks the modular design that keeps components independent and testable.

Exam trap

CompTIA often tests the distinction between encapsulation and modularity, where candidates mistakenly choose encapsulation because they associate 'hiding data' with 'not modifying globals,' but encapsulation specifically relates to object-oriented access control, not the functional principle of avoiding side effects.

How to eliminate wrong answers

Option A is wrong because encapsulation is about hiding internal data and implementation details within a class or object, not about whether a function returns a value versus modifying a global variable. Option B is wrong because polymorphism refers to the ability of different objects to respond to the same method call in their own way, which is unrelated to the side effect of modifying global state. Option D is wrong because inheritance is a mechanism for a class to derive properties and behaviors from a parent class, and it does not address the issue of functions altering global variables instead of returning values.

55
MCQmedium

A technician needs to convert a decimal IP address octet value of 192 to binary. Which of the following is the correct binary representation?

A.10101010
B.11000000
C.11110000
D.10000001
AnswerB

11000000 is 128 + 64 = 192 in decimal.

Why this answer

192 in binary is 11000000. This can be calculated by subtracting powers of 2: 192 = 128 + 64, so bits 7 and 6 are 1, bits 5-0 are 0.

56
MCQmedium

A user reports that their computer has been displaying unwanted pop-up advertisements frequently. Which type of malware is most likely responsible?

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

Adware is specifically designed to display advertisements.

Why this answer

Adware displays unwanted advertisements, often in pop-ups or banners.

57
MCQeasy

A user reports that their computer cannot access the internet, but it can reach other devices on the local network. Which of the following is the MOST likely cause?

A.Incorrect DNS server address
B.Faulty network cable
C.Misconfigured default gateway
D.Local firewall blocking all outbound traffic
AnswerC

Default gateway routes traffic outside the local subnet; a misconfiguration blocks internet access.

Why this answer

The default gateway is the router interface that connects the local network to external networks, such as the internet. If the default gateway is misconfigured (e.g., wrong IP address or subnet mask), the computer can still communicate with devices on the same subnet using ARP and Layer 2 switching, but it cannot route packets to external destinations because it has no valid next-hop address. This directly explains why local access works but internet access fails.

Exam trap

The trap here is that candidates often confuse DNS issues with routing issues, assuming that 'cannot access the internet' automatically means DNS is broken, but the key clue is that local network access still works, which isolates the problem to Layer 3 routing (default gateway) rather than Layer 2 or application-layer issues.

How to eliminate wrong answers

Option A is wrong because an incorrect DNS server address would prevent domain name resolution (e.g., cannot browse by name), but the user could still access the internet by IP address; the question states 'cannot access the internet' generally, not just by name. Option B is wrong because a faulty network cable would cause a complete loss of connectivity, including to other local devices, not just internet access. Option D is wrong because a local firewall blocking all outbound traffic would prevent all outbound connections, including to local devices, unless specifically configured to allow local traffic, which is atypical for a blanket block rule.

58
MCQhard

Refer to the exhibit. A database contains tables Customers and Orders. Based on the query, what is the purpose of the INNER JOIN clause?

A.To return only customers who have at least one order in New York
B.To create a Cartesian product of customers and orders
C.To combine all rows from both tables regardless of match
D.To include all customers even if they have no orders
AnswerA

The INNER JOIN ensures only matching CustomerIDs are returned, filtered by New York.

Why this answer

INNER JOIN returns only rows where the CustomerID value matches in both tables. Combined with the WHERE clause filtering orders in New York, the query returns only customers who have placed at least one order in New York. Option B describes a CROSS JOIN.

Option C describes a FULL OUTER JOIN. Option D describes a LEFT JOIN.

59
Multi-Selecthard

A small business needs to manage customer contacts, sales leads, and communication history. Which THREE types of software could be used? (Choose THREE.)

Select 3 answers
A.Accounting software.
B.Word processing software.
C.Customer relationship management (CRM) software.
D.Database software.
E.Spreadsheet software.
AnswersC, D, E

CRM is specifically designed for managing customer interactions and sales.

Why this answer

Customer relationship management (CRM) software is specifically designed to manage customer contacts, sales leads, and communication history. It centralizes customer data, tracks interactions, and automates sales workflows, making it the ideal choice for this business need.

Exam trap

The trap here is that candidates may confuse general-purpose tools like spreadsheets or databases with specialized CRM software, not realizing that while spreadsheets can store data, they lack the automated workflow and relationship tracking features of a dedicated CRM.

60
MCQmedium

A developer needs to represent the logic of a program that decides whether a user is eligible for a discount. The process includes conditions (e.g., 'is member?') and actions (e.g., 'apply 10% discount'). Which tool would best visually represent this logic using standardized symbols like diamonds for decisions and rectangles for processes?

A.Pseudocode
B.Data flow diagram
C.Flowchart
D.UML class diagram
AnswerC

Flowcharts use symbols for decisions and processes.

Why this answer

Flowcharts use decision diamonds and process rectangles to visually represent logic.

61
MCQeasy

A user reports that their laptop cannot connect to the office Wi-Fi. Other devices connect fine. The technician checks the wireless adapter status in Device Manager and sees a yellow exclamation mark. The technician attempts to update the driver but receives an error that the best driver is already installed. What should the technician do next?

A.Run the Windows Network Troubleshooter
B.Roll back the driver to a previous version
C.Replace the wireless adapter
D.Disable and re-enable the wireless adapter
AnswerB

Rolling back can revert a problematic driver update and restore functionality.

Why this answer

The yellow exclamation mark in Device Manager indicates a driver problem. Since updating the driver fails with 'best driver already installed,' the issue is likely a faulty or incompatible driver version. Rolling back the driver restores the previous working version, which is the correct next step before considering hardware replacement.

Exam trap

The trap here is that candidates assume 'best driver already installed' means the driver is fine, but the yellow exclamation mark explicitly contradicts that, and they overlook the rollback option in favor of generic troubleshooting or hardware replacement.

How to eliminate wrong answers

Option A is wrong because the Windows Network Troubleshooter is a generic tool that cannot resolve driver-level issues indicated by a yellow exclamation mark; it only checks basic connectivity and configuration. Option C is wrong because replacing the wireless adapter is premature; a driver rollback or reinstall should be attempted first, as the adapter may be functional with the correct driver. Option D is wrong because disabling and re-enabling the adapter only resets the software state, not the driver itself, and will not fix a corrupted or incompatible driver.

62
MCQmedium

Which of the following file attributes on a Windows system would prevent a user from accidentally modifying a document when set?

A.Hidden
B.Read-only
C.System
D.Archive
AnswerB

Read-only prevents the file from being modified or deleted.

Why this answer

The read-only attribute in Windows prevents a file from being modified or deleted (though it can be overridden by the user). Hidden hides the file, system marks it as a system file, and archive is used for backup.

63
Multi-Selecteasy

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

Select 2 answers
A.Printer
B.Speaker
C.Monitor
D.Mouse
E.Keyboard
AnswersD, E

Mice are pointing input devices.

Why this answer

The mouse and keyboard are classic examples of input devices because they allow users to send data and commands to a computer. A mouse translates physical movement and button clicks into cursor control signals, while a keyboard converts key presses into electrical signals that the system interprets as characters or commands. Both operate by sending input to the computer for processing, not by receiving or outputting data.

Exam trap

The trap here is that candidates may confuse the direction of data flow, mistakenly thinking that devices like printers or monitors can also accept user input (e.g., via touchscreens or control panels), but in their standard definition as peripherals, they are classified strictly as output devices unless specified otherwise.

64
MCQhard

A company's server room is experiencing intermittent overheating. The administrator notices that the perforated floor tiles are blocked by equipment. What is the most likely consequence of this obstruction?

A.Reduced cooling efficiency and hot spots
B.Increased electrical load on the UPS
C.Increased humidity levels
D.Reduced battery backup time
AnswerA

Perforated tiles deliver cold air; blocking them creates hot spots and reduces cooling.

Why this answer

Blocking perforated floor tiles restricts the flow of cold air from the raised-floor plenum into the server room. This reduces the overall cooling efficiency of the HVAC system and creates localized hot spots around the obstructed tiles, which can lead to equipment overheating and failure.

Exam trap

The trap here is that candidates may confuse airflow obstruction with electrical or power-related issues, but the direct consequence is always thermal—reduced cooling and hot spots—not changes to the UPS or battery system.

How to eliminate wrong answers

Option B is wrong because an increased electrical load on the UPS would result from adding more equipment or increasing power draw, not from obstructing airflow. Option C is wrong because blocked floor tiles reduce airflow, which typically lowers humidity levels (as cold air carries less moisture) or has no direct effect on humidity; increased humidity is more often caused by poor sealing or HVAC malfunction. Option D is wrong because reduced battery backup time is a function of battery age, load, or capacity, not of airflow obstruction in the server room.

65
MCQeasy

Refer to the exhibit. A user cannot access the internet. What is the most likely issue based on the configuration shown?

A.The default gateway is missing
B.The DNS server is not configured
C.The IP address is invalid
D.The subnet mask is incorrect
AnswerA

Without a default gateway, the device cannot communicate outside its subnet.

Why this answer

The exhibit shows an IP address of 192.168.1.10 with a subnet mask of 255.255.255.0, but no default gateway is configured. Without a default gateway, the device can communicate within its local subnet (192.168.1.0/24) but cannot route traffic to any external network, including the internet. The default gateway is the router's IP address that provides the next-hop path for all off-subnet traffic.

Exam trap

CompTIA often tests the misconception that a missing DNS server prevents internet access entirely, but the real issue is the lack of a default gateway for routing traffic beyond the local subnet.

How to eliminate wrong answers

Option B is wrong because DNS is used for name resolution, not for routing; even without DNS, the user could access the internet by IP address. Option C is wrong because 192.168.1.10 is a valid private IP address within the 192.168.0.0/16 range. Option D is wrong because 255.255.255.0 is the correct subnet mask for a /24 network, matching the IP address 192.168.1.10.

66
MCQhard

A technician notices that a switch interface is showing many CRC errors. What is the most likely cause?

A.Duplex mismatch
B.Faulty cable
C.Incorrect IP configuration
D.MAC address flooding
AnswerB

CRC errors are often due to damaged cables, poor connections, or electromagnetic interference.

Why this answer

CRC errors indicate that frames received on the interface have failed the cyclic redundancy check, meaning the data has been corrupted during transmission. A faulty cable is the most common cause of such corruption because it can introduce electrical interference, signal degradation, or physical breaks that alter the bits in the frame. While duplex mismatch can cause CRC errors in some cases, a faulty cable is the primary suspect when CRC errors are present.

Exam trap

The trap here is that candidates often associate CRC errors with duplex mismatch because both can appear under high-traffic conditions, but The FC0-U61 exam specifically tests that CRC errors point to physical-layer issues like cabling, while duplex mismatch manifests as late collisions and runts.

How to eliminate wrong answers

Option A is wrong because a duplex mismatch typically causes late collisions and FCS errors, not CRC errors; CRC errors are more directly linked to physical-layer issues like cable faults. Option C is wrong because incorrect IP configuration affects network-layer communication (e.g., routing, addressing) and does not cause physical-layer frame corruption that results in CRC errors. Option D is wrong because MAC address flooding is a security attack that fills the switch's MAC address table, causing frames to be flooded out all ports, but it does not corrupt the frame's data integrity and thus does not produce CRC errors.

67
MCQmedium

Which DBMS is an example of a proprietary relational database system?

A.MySQL
B.PostgreSQL
C.SQLite
D.Oracle Database
AnswerD

Oracle is a proprietary commercial RDBMS.

Why this answer

Oracle Database is proprietary (commercial). MySQL, PostgreSQL, and SQLite are open-source.

68
MCQhard

A database administrator needs to ensure that only authorized users can access sensitive data. Which of the following concepts describes this requirement?

A.Availability
B.Non-repudiation
C.Integrity
D.Confidentiality
AnswerD

Confidentiality restricts access to authorized personnel.

Why this answer

Confidentiality ensures that sensitive data is accessible only to authorized users, typically enforced through access controls, encryption, and authentication mechanisms. In database administration, this is implemented via permissions, roles, and encryption at rest (e.g., AES-256) to prevent unauthorized disclosure.

Exam trap

The trap here is that candidates often confuse confidentiality with integrity, mistakenly thinking that preventing unauthorized changes (integrity) is the same as preventing unauthorized viewing (confidentiality), but the CIA triad separates these clearly.

How to eliminate wrong answers

Option A is wrong because availability refers to ensuring systems and data are accessible when needed (e.g., via redundancy or failover), not restricting access to authorized users. Option B is wrong because non-repudiation provides proof of origin or delivery (e.g., digital signatures), preventing denial of actions, but does not control who can view data. Option C is wrong because integrity ensures data is accurate and unaltered (e.g., via checksums or hashing), not that access is limited to authorized users.

69
MCQhard

A large retail chain operates a data warehouse that combines sales data from multiple source databases. The warehouse is designed using a highly normalized snowflake schema. Analysts frequently run complex queries that aggregate sales across many dimensions (e.g., time, product, store). Recently, the queries have become very slow, often taking hours to complete. The data warehouse team suspects the normalization is causing many joins, degrading performance. The business users need faster reporting. The team must decide on a course of action that balances query performance with maintainability. Which technique is most likely to improve reporting speed without significantly compromising data integrity?

A.Denormalize some tables by merging fact and dimension tables
B.Increase the server's CPU and memory resources
C.Replace the relational warehouse with a NoSQL document store
D.Add more indexes on all foreign key columns
AnswerA

Reduces joins, improving read performance for aggregations.

Why this answer

Denormalizing some tables by merging fact and dimension tables reduces the number of joins required for complex analytical queries, directly addressing the performance bottleneck caused by the highly normalized snowflake schema. This technique improves query speed by storing redundant data in a star-like schema, which is a common optimization for data warehouses where read performance is prioritized over write efficiency, while still maintaining data integrity through careful design and ETL processes.

Exam trap

CompTIA often tests the misconception that adding more indexes always improves query performance, but in a highly normalized schema with many joins, the overhead of maintaining and scanning multiple indexes can actually slow down complex aggregations.

How to eliminate wrong answers

Option B is wrong because increasing CPU and memory resources (vertical scaling) only provides a temporary performance boost and does not address the root cause of excessive joins from normalization; it is a costly band-aid that may not scale with growing data volumes. Option C is wrong because replacing the relational warehouse with a NoSQL document store would require a complete architectural overhaul, likely breaking existing BI tools and SQL-based reporting, and NoSQL systems typically lack the ACID guarantees and join capabilities needed for consistent aggregated reporting across dimensions. Option D is wrong because adding more indexes on all foreign key columns can speed up individual join operations but increases write overhead and storage costs, and in a highly normalized snowflake schema with many joins, the cumulative index overhead can actually degrade query performance due to index maintenance and lookup costs.

70
MCQhard

After a network upgrade, a user reports that their computer intermittently loses network connectivity. The link light remains on, but the activity light flashes rapidly and irregularly. What is the most likely cause?

A.IP address conflict
B.Bad Ethernet cable
C.Driver corruption
D.Faulty NIC
AnswerB

A bad cable can cause intermittent connectivity and rapid error flashes.

Why this answer

The intermittent connectivity with the link light on but the activity light flashing rapidly and irregularly is a classic symptom of a faulty or marginal Ethernet cable. A bad cable can cause excessive collisions or frame errors, leading to retransmissions that manifest as rapid, irregular activity light flashing while the physical link (link light) remains established. This is distinct from issues like IP conflicts or driver corruption, which typically do not produce this specific link/activity light behavior.

Exam trap

The trap here is that candidates often confuse physical layer symptoms (bad cable) with Layer 2 or Layer 3 issues (IP conflict, driver corruption), assuming that intermittent connectivity must be a software or configuration problem rather than a hardware fault.

How to eliminate wrong answers

Option A is wrong because an IP address conflict would cause complete loss of network access or intermittent connectivity, but it would not cause the activity light to flash rapidly and irregularly while the link light remains on; IP conflicts are a Layer 3 issue and do not affect physical layer indicators. Option C is wrong because driver corruption typically results in the NIC not being recognized or failing to establish a link at all, often with the link light off or flickering erratically, not with a steady link light and rapid activity flashing. Option D is wrong because a faulty NIC usually causes the link light to be off or unstable, or the NIC may fail to initialize entirely; a faulty NIC would not maintain a steady link light while producing rapid, irregular activity flashes.

71
MCQhard

A technician is troubleshooting a network issue where a client cannot reach a server on a different subnet. The client's IP is 192.168.1.10/24, and the server's IP is 10.0.0.50/24. The client can ping its default gateway. Which device is most likely misconfigured?

A.The client's DNS settings
B.The router between subnets
C.The server's firewall
D.The switch
AnswerB

The router must have a route to the server's subnet; without it, traffic cannot be forwarded.

Why this answer

The client can ping its default gateway, indicating that its local subnet (192.168.1.0/24) connectivity and the gateway's interface are working. However, the client cannot reach a server on a different subnet (10.0.0.0/24). This points to a routing issue: the router between the subnets is likely misconfigured—either missing a route to the 10.0.0.0/24 network or not performing inter-VLAN routing correctly.

Without proper routing, the router drops or fails to forward packets destined for the server's subnet.

Exam trap

CompTIA often tests the misconception that a client's inability to reach a different subnet is due to DNS or the server's firewall, but the key clue is that the client can ping its default gateway, isolating the problem to Layer 3 routing between subnets.

How to eliminate wrong answers

Option A is wrong because DNS settings resolve hostnames to IP addresses, but the client already knows the server's IP (10.0.0.50) and can ping the gateway, so DNS is irrelevant to the subnet reachability issue. Option C is wrong because the server's firewall would only block traffic if packets reached the server; the client cannot even get past the router, so the firewall is not the first point of failure. Option D is wrong because a switch operates at Layer 2 and forwards frames within the same subnet; the client can ping its gateway, proving the switch is correctly forwarding traffic on the local VLAN.

72
MCQmedium

A user wants to prevent unauthorized access to their laptop if stolen. Which is the best method?

A.Antivirus
B.Use a strong password
C.Firewall
D.Enable BitLocker
AnswerD

BitLocker encrypts the entire drive, protecting data even if the laptop is stolen.

Why this answer

BitLocker is a full-disk encryption feature built into Windows that encrypts the entire drive, making data inaccessible without the decryption key. If the laptop is stolen, the thief cannot read any files even if they remove the hard drive and connect it to another system. This directly prevents unauthorized access to data, unlike other options that only protect against network or software threats.

Exam trap

The trap here is that candidates confuse authentication (password) with encryption (BitLocker), assuming a strong password alone protects data against physical theft, but it only protects against casual login attempts, not direct disk access.

How to eliminate wrong answers

Option A is wrong because antivirus software detects and removes malware but does not protect data if the laptop is physically stolen and the drive is accessed offline. Option B is wrong because a strong password only protects the OS login screen; a thief can bypass it by booting from a live USB or removing the hard drive to read data directly. Option C is wrong because a firewall controls network traffic but offers no protection against physical theft or offline access to the storage device.

73
MCQhard

A table has columns: EmployeeID (PK), DepartmentID, DepartmentName, Salary. Which normal form violation exists?

A.No violation
B.Second Normal Form
C.First Normal Form
D.Third Normal Form
AnswerD

Transitive dependency: DepartmentName depends on DepartmentID, not on EmployeeID.

Why this answer

The table violates Third Normal Form (3NF) because DepartmentName depends on DepartmentID, which is not a candidate key. In 3NF, every non-key column must depend solely on the primary key (EmployeeID), not on another non-key column. This transitive dependency (EmployeeID → DepartmentID → DepartmentName) requires splitting the table into Employees and Departments to achieve 3NF.

Exam trap

The trap here is that candidates often confuse transitive dependencies with partial dependencies, leading them to incorrectly select Second Normal Form (2NF) instead of Third Normal Form (3NF).

How to eliminate wrong answers

Option A is wrong because the table clearly has a transitive dependency, so a normal form violation exists. Option B is wrong because Second Normal Form (2NF) is satisfied: there is no partial dependency since the primary key is a single column (EmployeeID), and all non-key columns are fully functionally dependent on it. Option C is wrong because First Normal Form (1NF) is satisfied: all columns contain atomic values, and there are no repeating groups or arrays.

74
MCQhard

A network technician is troubleshooting a slow wireless connection in a crowded office. The office uses many Wi-Fi networks and devices. Which Wi-Fi standard would be best to minimize interference and provide faster speeds?

A.802.11g
B.802.11n (Wi-Fi 4)
C.802.11ax (Wi-Fi 6)
D.802.11ac (Wi-Fi 5)
AnswerC

Wi-Fi 6 offers better performance in dense deployments.

Why this answer

802.11ax (Wi-Fi 6) is the latest standard, designed to handle dense environments with less interference and higher throughput compared to older standards like 802.11ac.

75
MCQmedium

A user wants to connect an external storage drive to a laptop for fast file transfers. The laptop has USB-A, USB-C, and Thunderbolt 3 ports. Which connection provides the fastest theoretical data transfer speed?

A.USB-A 2.0
B.USB-A 3.0
C.USB-C 3.1
D.Thunderbolt 3
AnswerD

40 Gbps max.

Why this answer

Thunderbolt 3 offers up to 40 Gbps, significantly faster than USB 3.0 (5 Gbps) or USB 3.1 (10 Gbps).

Page 1 of 14

Page 2