CompTIA Tech+ (FC0-U71) (FC0-U71) — Questions 76–150

A cloud-based productivity suite (e.g., Microsoft 365, Google Workspace) stores documents on remote servers and uses WebDAV or proprietary sync protocols (like Google Drive API) to enable multiple users to edit the same file simultaneously. This real-time collaboration relies on operational transformation or conflict-free replicated data types (CRDTs) to merge edits without conflicts. Local or offline tools lack the network infrastructure to synchronize changes across users in real time.

The SQL INSERT statement is the standard Data Manipulation Language (DML) command used to add new rows to a table. The syntax INSERT INTO Products VALUES ('Widget', 10.99) inserts a new row with the specified values into the Products table, assuming the column order matches the table definition. This is the correct and ANSI-standard way to add data.

A single customer can place many orders, but each order belongs to exactly one customer, which is the definition of a one-to-many relationship. The CustomerID foreign key in the Orders table references the primary key in Customers, enforcing that each order is tied to one customer while allowing a customer to have multiple orders.

When an operation can fail for a predictable reason such as a missing file, structured exception handling allows the program to recover gracefully. The try block contains the risky read, and the catch block intercepts the specific error and presents a friendly message. Comments, constants, and unbounded retries do not intercept the failure, so they cannot prevent the abrupt termination.

Available RAM is total RAM minus RAM in use: 8 GB − 3.2 GB = 4.8 GB. This is a straightforward subtraction problem testing basic memory capacity arithmetic.

A laser printer uses a laser beam and toner to produce fast, high-volume black-and-white text documents at a low cost per page, making it the best fit for an office with frequent jams and poor color output that needs faster, more cost-effective monochrome printing.

The POST method is designed to submit data to be processed to a specified resource, such as creating a new user registration record on a server. Unlike GET, which appends data to the URL, POST sends the registration data in the request body, making it suitable for non-idempotent operations where each submission creates a new resource or triggers server-side processing.

An API (Application Programming Interface) is a set of rules and protocols that allows different software applications to communicate with each other. In this scenario, the mobile app uses HTTP requests to interact with the weather service's API, which defines the endpoints, request formats, and JSON response structures. The API abstracts the underlying service implementation, enabling standardized data exchange.

A long passphrase that includes symbols and numbers is considered a best practice because it increases both length and complexity, making it significantly harder for attackers to crack using brute-force or dictionary attacks. Length is the most critical factor in password strength, and adding symbols and numbers further expands the search space. This approach aligns with guidance from NIST and other security organizations, which recommend passphrases over short, complex passwords.

Integrity ensures that data has not been altered or tampered with in an unauthorized manner. Since the file was modified without authorization, the integrity of the data has been compromised, which is the definition of an integrity violation in the CIA triad.

The PRIMARY KEY constraint uniquely identifies each row and enforces both uniqueness and non-null values. This meets the need to prevent duplicate employee identification numbers and to disallow empty values. UNIQUE allows nulls, FOREIGN KEY enforces referential integrity, and CHECK validates conditions but does not enforce uniqueness across rows.

Fiber-optic internet (often referred to as Fiber-to-the-Home or FTTH) uses light pulses transmitted through glass strands to deliver data. Unlike DSL or cable, fiber connections are inherently symmetric, meaning they provide identical upload and download speeds because the technology does not rely on asymmetric frequency division or shared coaxial infrastructure. This makes fiber the correct answer for symmetric speeds.

Public Wi-Fi is often unencrypted, allowing attackers to intercept data transmitted over the network. A VPN encrypts traffic, protecting data in transit.

Checking the IP address configuration is a fundamental first step in troubleshooting network connectivity. A misconfigured IP address, such as an Automatic Private IP Addressing (APIPA) address in the 169.254.x.x range, indicates that the device failed to obtain a valid IP from a DHCP server, which would prevent internet access. Verifying the IP configuration with commands like `ipconfig` (Windows) or `ifconfig` (Linux/macOS) helps identify if the device has a proper IP, subnet mask, and default gateway.

The variable must hold a whole-number age and support arithmetic such as adding five years. An integer satisfies both requirements directly, providing numeric storage and calculation. A Boolean cannot represent numbers, a string treats the value as text and concatenates instead of adding, and an array is meant for collections rather than a single scalar value.

An address in the 169.254.0.0/16 range is self-assigned by the operating system when DHCP attempts fail. Because no lease is obtained, no default gateway or DNS servers are provided either, which explains why the workstation cannot reach the file server. Link lights confirm the cable and switch port are working, so the next step is to investigate the DHCP server, scope, or relay.

Error 1069 specifically indicates a logon failure for the service account. When a mandatory security update is applied, it may enforce password expiration policies or reset the service account password, causing the SQL Server service to fail to start. Updating the service logon credentials in the Services console resolves the issue.

Dual-channel memory requires two identical memory modules installed in matching slots to double the memory bandwidth.

It tests the exact boundary values for the discount tiers: $49.99 (just below $50, no discount), $50.00 (5% threshold), $99.99 (still 5%), $100.00 (boundary between 5% and 10%), and $100.01 (10% threshold). This set validates both the lower and upper edges of each range, ensuring the code handles floating-point comparisons correctly.

SSDs have no moving parts; they use NAND flash memory to store data, which eliminates the mechanical noise produced by spinning platters and moving actuator arms in HDDs. This makes SSDs completely silent during operation, a key advantage in noise-sensitive environments like recording studios or quiet office spaces.

On Windows, the standard file extension for executable programs and software installers is .exe (executable). When a user downloads an installer for Windows, it is typically an .exe file that can be run to install the application. The other extensions are associated with different operating systems: .pkg and .dmg are used on macOS, and .deb is used on Debian-based Linux distributions.

A Type 1 (bare-metal) hypervisor like VMware ESXi runs directly on the host hardware without an underlying OS, giving it direct access to CPU, memory, and I/O resources. This architecture delivers the lowest virtualization overhead, highest performance, and best reliability — critical for hosting business-critical applications. Type 1 hypervisors also offer advanced features like vMotion, HA, and resource pools that enterprises rely on.

The script uses a loop to repeatedly access each number in the list and add it to a running total. This repeated execution of a block of code (the loop body) is the defining characteristic of iteration. Iteration is the correct programming concept because the average calculation depends on cycling through a sequence of elements, which is exactly what a loop provides.

A password manager's core function is to create high-entropy, unique passwords for every account and store them in an encrypted vault, eliminating password reuse and weak credentials. It uses a master password and strong encryption (e.g., AES-256) to protect the vault, and can auto-fill credentials, reducing human error. While some managers offer cloud sync or sharing, those are secondary features, not the primary purpose.

Real-time collaboration in a cloud-based office suite depends on central document storage plus continuous synchronization between participants. That combination lets several employees edit one shared document and see each other's changes as they happen. Local installation, email handoffs, and manual saving do not provide that simultaneous shared editing experience.

The product record combines a text name, a numeric price, and a numeric quantity that belong together. A record or struct with named fields stores these related, differently typed values as one unit and keeps each field's type intact. A delimited string loses typing, a Boolean is too limited, and an integer array cannot hold the text name or provide meaningful field names.

Integrity, the 'I' in the CIA triad, specifically ensures that data remains accurate, complete, and unaltered unless modified by authorized parties. It protects against unauthorized modification, deletion, or corruption, whether the data is at rest, in transit, or in use. Authentication verifies identity, availability ensures access, and confidentiality prevents unauthorized disclosure—none of these directly address modification prevention.

A customer's name is a sequence of characters (letters, spaces, possibly punctuation), which is best represented as a String data type. In most programming languages, strings are used to store text and are enclosed in quotes (e.g., "John Doe"). This aligns with the fundamental concept that names are not numeric or logical values.

802.11ax, or Wi-Fi 6, is the latest mainstream wireless standard, offering improved speed, efficiency, and reduced interference compared to older standards. It is designed for environments with many devices and provides better performance. Configuring the router to use 802.11ax ensures the home office benefits from current wireless technology.

When a browser cannot validate a site's certificate, the identity of the server is in doubt, which is the hallmark of an on-path attack redirecting traffic to an imposter endpoint. Entering payment details in that state can hand them directly to the attacker. The other listed attacks target availability or server-side application flaws and are not signaled by a certificate validation warning.

Mobile Device Management (MDM) is the correct technology because it provides centralized policy enforcement for smartphones, including remote wipe, mandatory encryption, passcode requirements, and app management. MDM agents on the device check in with the MDM server (e.g., Intune, Jamf, Workspace ONE) and apply configuration profiles that enforce these controls. This directly matches the stated requirements.

A VPN encrypts traffic between the user's device and the VPN server, protecting data on public networks.

Legacy applications often require elevated privileges to install on Windows 10 because they may attempt to write to system directories or registry keys that are protected by User Account Control (UAC). Running the installer as Administrator is the simplest and most common first troubleshooting step to resolve permission-related issues before considering other solutions like missing dependencies or application upgrades.

The symptom is isolated to one browser on one machine while other devices reach the same site, which points to locally stored browser data rather than network hardware, the shared internet link, or DNS. Clearing the cache and cookies forces a fresh fetch from the server and directly resolves stale or corrupt cached content.

To secure a home wireless network, the user should enable strong encryption such as WPA3 and change the router's default administrator password. WPA3 protects data in transit and controls who can join, while changing the default admin password prevents unauthorized reconfiguration. The other options either provide minimal protection, are unrelated to security, or can increase exposure.

The most likely cause is insufficient permissions on the network share (D). When a desktop application crashes specifically during a save operation to a network drive, but other applications work fine, it often indicates that the application lacks the necessary write permissions to the target folder or file. This can trigger an unhandled exception in the application's save routine, leading to a crash, whereas other applications may handle the permission denial gracefully or use different access methods.

Software as a Service (SaaS) delivers the CRM application over the internet, allowing users to access it from any device with a web browser without installing software. This model matches the requirement for mobile and desktop access with zero local installation, as the provider hosts and manages the entire application stack.

Hashing is a one-way function that converts a password into a fixed-length string. It is used to securely store passwords so that even if the database is breached, the actual passwords are not easily recoverable.

PCIe (Peripheral Component Interconnect Express) is the modern standard expansion slot for high-performance add-in cards like graphics cards, network interface cards, and sound cards. It provides high bandwidth and is backward compatible with PCI. Thus, D is correct.

Open-source software is defined by its license, which grants users the right to view, modify, and distribute the source code. This characteristic is the core principle of open-source, as codified by the Open Source Initiative (OSI). The ability to modify the source code allows for customization, auditing, and community-driven improvements.

PDF is designed to preserve the visual appearance of a document exactly as created, including fonts, images, and layout, and it can be opened on virtually any platform with a free reader. This makes it ideal for sharing final versions where the layout must remain intact and the recipient may not have the original editing software.

(Integer) because the program processes whole numbers only, and the integer data type is specifically designed to store non-fractional numeric values without decimal points. In most programming languages, integers are stored as 32-bit or 64-bit binary values, making them efficient for arithmetic operations on whole numbers.

A foreign key constraint enforces referential integrity by requiring that any value in the foreign key column(s) must either match a primary key or unique key value in the referenced table, or be NULL. This ensures that relationships between tables remain consistent and prevents orphaned records. The constraint is defined on the child table and references the parent table's primary key (or a unique key).

System software includes the operating system and utilities that manage hardware. Linux is an operating system, hence system software. Word processor, web browser, and spreadsheet are application software.

The operating system (OS) is the core software layer that sits between hardware and applications. It allocates CPU time, memory, storage, and I/O devices to processes, and exposes system calls and APIs that applications use to run without directly manipulating hardware. This resource management and abstraction role is the defining function of an OS, making option A the correct description.

The scenario requires two things: encryption of the connection and proof of the device's identity. A VPN with IPsec or TLS supplies the encrypted tunnel, while certificate-based authentication forces the laptop to present a valid digital certificate before the tunnel is established. Remote desktop, password-only web portals, and cloud sync either lack device authentication or fail to provide a private encrypted path to the payroll application.

Version control software (e.g., Git) is specifically designed to track changes to source code over time, allowing developers to manage revisions, collaborate, and revert to previous states. Graphic design software, project management tools, and database management systems do not provide the necessary functionality for source code versioning.

The operating system (B) is the core system software that manages hardware resources, provides services for application programs, and acts as an intermediary between the user and the computer hardware. Device drivers (D) are system software that allow the operating system to communicate with and control specific hardware devices, such as a graphics card or network adapter.

An SSD meets all the stated requirements: it has no moving parts, provides low latency, and is durable against shock. It is specifically designed for fast random access, making it ideal for database workloads. The other options involve mechanical components and are better suited for bulk storage or backup rather than performance-critical random I/O.

The distinguishing feature in the log is breadth: many different usernames targeted from one source in a short window. That pattern matches password spraying, where an attacker tests a few common passwords across a large user list to stay under per-account lockout thresholds. Brute force would hammer one account, a denial-of-service attack would aim at availability, and a man-in-the-middle attack would involve interception rather than direct login attempts.

WPA3-Personal protects the wireless traffic, but the access point's management interface remains a separate attack surface. If default administrator credentials are left in place, an attacker on the local network or with physical access could log in and change settings, create a backdoor, or disable security. Replacing those defaults with a unique strong passphrase closes that path while preserving the encryption already configured.

The 3-2-1 backup rule: three copies, two different media types, one offsite.

COUNT (option A) is a valid SQL aggregate function that returns the number of rows or non-NULL values in a column, commonly used with GROUP BY to summarize data. SUM (option C) is also a valid SQL aggregate function that returns the total sum of a numeric column, making it a standard tool for data aggregation. The other options are not aggregate functions: SORT (option B) is not a SQL function (ordering is done with ORDER BY), LENGTH (option D) is a scalar string function that returns the character length of a value, and APPEND (option E) is not a standard SQL function at all.

Scrum is an agile framework that uses sprints, daily standups, sprint reviews, and specific roles (product owner, scrum master, development team).

To require that every employee has a unique employee number, the column needs both a uniqueness rule and a non-null rule. UNIQUE prevents duplicates, and NOT NULL prevents blanks. A primary key would also work, but the question asks for a combination of constraints; UNIQUE and NOT NULL are the specific constraints that meet both conditions.

If no software is installed that can handle PDF files, the operating system has no default handler to open the file. When a user clicks on a PDF attachment in an email client, the system attempts to launch the associated application (e.g., Adobe Acrobat Reader, a web browser with PDF support). If no such application is present, nothing happens—the file simply does not open, and no error message may appear depending on the email client's configuration.

.zip is the standard compressed archive format on Windows, bundling one or more files into a single compressed container. Windows Explorer natively supports creating and extracting .zip files without third-party tools, making it the default archive extension.

The user wants freedom to use, modify, and redistribute, plus a requirement that modified versions stay under the same license. That reciprocal condition is the defining feature of a copyleft license such as the GNU GPL. Permissive licenses and public domain allow modification and redistribution but do not enforce the same-license requirement, while proprietary licenses forbid these freedoms altogether.

The exhibit shows an explicit Deny statement for read access, which overrides any Allow statements due to access control evaluation logic. Even if the user has list permission, the Deny on read prevents downloading files. This is the most likely cause because Deny statements are absolute and cannot be overridden by Allow statements.

The primary function of an operating system is to manage hardware resources, including the CPU, memory, storage, and input/output devices, by abstracting them into a usable interface for applications. Without an OS, software cannot directly coordinate hardware access, as the OS handles scheduling, memory allocation, and device drivers. This resource management is fundamental to all other OS roles, such as file system management and process control.

Running the manufacturer's diagnostic utility is the correct first step because it directly tests the suspected failing component without making changes. It provides actionable data about the drive's health, allowing the technician to make an informed decision. Other options either skip diagnosis or address different components, which could lead to unnecessary work.

Containment and evidence preservation come before remediation. Disconnecting the workstation stops active communication with external infrastructure and prevents lateral spread, while documenting symptoms and timestamps preserves information needed for analysis. Scanning, reimaging, or sharing credentials either allows the threat to continue operating or destroys evidence, so those actions belong later in the response process.

An age is a whole number of years, so the Integer type is the natural fit. Python's int type stores whole numbers without a fractional component and supports arithmetic operations directly. Using Integer avoids unnecessary type conversions and preserves numeric semantics for comparisons and calculations.

This web service is a REST API because it uses HTTP requests to access and manipulate resources, returns data in JSON format, and requires an API key in the request header for authentication. REST APIs are stateless and rely on standard HTTP methods (GET, POST, etc.), making them ideal for integrating external data like weather information into mobile apps.

A network firewall's primary purpose is to control incoming and outgoing network traffic by comparing packets against a set of predefined security rules. It acts as a barrier between trusted internal networks and untrusted external networks (like the internet), allowing or denying traffic based on criteria such as IP addresses, ports, and protocols. This rule-based filtering is the core function that distinguishes a firewall from other security tools.

Microsoft Teams and Slack are team communication and collaboration platforms, so they fall under Collaboration software. These tools provide chat, video conferencing, file sharing, and integration with other work apps. Collaboration software is specifically designed to help groups work together, which matches the described applications.

The DNS server address is used to resolve human-readable domain names (like www.example.com) into machine-readable IP addresses. This is the fundamental purpose of the Domain Name System, which translates names to IPs so that network devices can locate and communicate with each other.

The program counter stores the address of the next instruction to be fetched, making it the register that drives sequential execution. Each cycle, its value is used to access memory, then advanced or redirected by branches. Other registers such as the accumulator, memory address register, and instruction register serve different roles in processing data or the current instruction.

NVMe M.2 drives plug directly into an M.2 slot on the motherboard, requiring no data or power cables, and use the PCIe bus for far higher throughput than SATA. This matches the user's requirement of a fast drive that connects directly to the motherboard without cables. M.2 NVMe is the standard choice for modern desktop storage upgrades where cable-free installation and maximum speed are priorities.