Knowledge + Practice

CompTIA ITF+ FC0-U61 (FC0-U61) — Questions 76–150

512 questions total · 7pages · All types, answers revealed

Take a mock exam Exam hub

Page 2 of 7

76

MCQhard

A company uses a proprietary application that requires a license per user. They have 100 employees but only 80 need access. Which licensing model would be most cost-effective?

A.Per-seat license

B.Site license

C.Concurrent user license

D.Volume license with minimum 100

AnswerC

Concurrent licenses allow up to 80 simultaneous users, which fits the need without paying for unused licenses.

Why this answer

Concurrent user licensing allows a set number of simultaneous users, which is cost-effective when not all employees need access at once. Per-seat licenses would require 100 licenses. Site licenses cover unlimited users but may cost more.

Volume licenses with a minimum of 100 would still require 100.

Full explanation →

77

Matchingmedium

Match each security concept to its definition.

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

Concepts

Matches

Data accessible only to authorized users

Data not altered improperly

Data accessible when needed

Verifying user identity

Why these pairings

CIA triad plus authentication.

Full explanation →

78

MCQmedium

Based on the exhibit, which of the following is the purpose of the DNS server address?

A.To convert domain names to IP addresses

B.To encrypt network traffic

C.To route packets to the internet

D.To assign IP addresses to clients

AnswerA

DNS resolves hostnames to IP addresses for network communication.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse the DNS server's role with that of a DHCP server or a router, especially when the exhibit shows network configuration fields where both DNS and gateway addresses are listed.

How to eliminate wrong answers

Option B is wrong because encryption of network traffic is handled by protocols like TLS/SSL or IPsec, not by a DNS server. Option C is wrong because routing packets to the internet is the function of a default gateway or router, not a DNS server. Option D is wrong because assigning IP addresses to clients is the role of a DHCP server, not a DNS server.

Full explanation →

79

Multi-Selecthard

Which THREE of the following are phases in the software development lifecycle (SDLC)?

Select 3 answers

A.Design

B.Testing

C.Deployment

D.Requirements gathering

E.Compilation

AnswersA, B, D

Design phase involves creating the software architecture and plan.

Why this answer

Requirements gathering, design, and testing are standard SDLC phases. Compilation is a technical step, not a phase. Deployment is also a phase, but only three are correct? Actually deployment is a phase, but our options: Requirements, Design, Compilation, Testing, Deployment.

So three are Requirements, Design, Testing. Compilation is not a phase, and Deployment is also a phase but we need exactly three; typical core phases are Requirements, Design, Implementation, Testing, Deployment, Maintenance. So we choose Requirements, Design, Testing.

Implementation would also be valid but not in options. So three correct: A, B, D.

Full explanation →

80

MCQhard

A system administrator configures a server to run multiple virtual machines for testing. Which type of software enables this?

A.Backup software

B.Virtualization software

C.Remote desktop software

D.Antivirus software

AnswerB

Hypervisors like VMware create virtual machines.

Why this answer

Virtualization software, such as VMware vSphere, Microsoft Hyper-V, or Oracle VirtualBox, creates a hypervisor layer that abstracts physical hardware resources (CPU, memory, storage) and allocates them to multiple isolated virtual machines. This allows a single physical server to run several operating systems concurrently for testing or production workloads, which is exactly what the system administrator needs.

Exam trap

The trap here is that candidates may confuse virtualization software with remote desktop software because both involve accessing multiple systems, but remote desktop only provides a connection to an already-running OS, not the ability to create and run multiple OS instances on one server.

How to eliminate wrong answers

Option A is wrong because backup software (e.g., Veeam, Acronis) is designed to create copies of data for recovery purposes, not to partition hardware resources for running multiple operating systems. Option C is wrong because remote desktop software (e.g., RDP, VNC) provides graphical or command-line access to a remote computer's desktop, but it does not create or manage virtual machines. Option D is wrong because antivirus software (e.g., Norton, Windows Defender) detects and removes malicious software, but it has no capability to virtualize hardware or run multiple OS instances.

Full explanation →

81

MCQhard

Refer to the exhibit. A security auditor reviews this application configuration. What is the most significant security concern?

A.The server name is hardcoded.

B.The log level is set to Debug.

C.The database password is stored in plaintext.

D.The database name is SalesDB.

AnswerC

Plaintext passwords can be easily read by anyone with file access, leading to unauthorized database access.

Why this answer

Option C is correct because storing a database password in plaintext within an application configuration file is a critical security vulnerability. If an attacker gains access to the file, they can immediately read the credentials and connect to the database, potentially compromising all stored data. This violates fundamental security principles such as least privilege and defense in depth, and it is explicitly warned against in secure coding guidelines like OWASP's Top 10 (A07:2021 – Identification and Authentication Failures).

Exam trap

The trap here is that candidates may focus on the 'Debug' log level (Option B) as a security risk due to verbosity, but the plaintext password (Option C) represents a direct, high-impact credential exposure that is far more critical.

How to eliminate wrong answers

Option A is wrong because hardcoding the server name is a configuration management concern (e.g., lack of portability), not a security vulnerability; it does not expose sensitive data or allow unauthorized access. Option B is wrong because setting the log level to Debug increases log verbosity and may cause performance or information leakage issues, but it is not as severe as exposing a plaintext password; debug logs typically contain operational details, not authentication secrets. Option D is wrong because the database name 'SalesDB' is a logical identifier with no inherent security risk; exposing it does not grant access to the database without valid credentials.

Full explanation →

82

MCQmedium

A programmer is writing an if-else statement to check if a user is an admin. The code should set a variable 'accessLevel' to 'full' if admin, else 'restricted'. Which code snippet accomplishes this?

A.if (isAdmin == true) { accessLevel = 'full'; } else { accessLevel = 'restricted'; }

B.if (isAdmin == false) { accessLevel = 'full'; } else { accessLevel = 'restricted'; }

C.if (isAdmin = true) { accessLevel = 'full'; } else { accessLevel = 'restricted'; }

D.if (isAdmin == true) { accessLevel = 'restricted'; } else { accessLevel = 'full'; }

AnswerA

Correctly assigns full if admin, restricted otherwise.

Why this answer

Option D is correct because it assigns 'full' to accessLevel when isAdmin is true, otherwise 'restricted'. Option A has syntax error (assignment in condition); Option B uses == which is comparison but assigns in both cases incorrectly; Option C assigns 'full' only when false.

Full explanation →

83

Multi-Selecteasy

Which TWO of the following are valid data types in most programming languages?

Select 2 answers

A.Boolean

B.Character

C.Array

D.Integer

E.Bit

AnswersA, D

Boolean represents true/false values.

Why this answer

Options A and D are correct: integer and boolean are standard data types. Option B is not a standard type (bit is sometimes but boolean covers it); Option C is a structure, not a primitive type; Option E (character) is also valid but we only need two, and boolean and integer are more fundamental. Actually character is also valid, but to match exactly two, we choose integer and boolean.

Full explanation →

84

MCQmedium

A program needs to display a message based on a user's age. If age is 18 or over, it displays 'Adult'; otherwise, it displays 'Minor'. Which control structure should be used?

A.If-else statement

B.For loop

C.Switch-case statement

D.While loop

AnswerA

If-else evaluates a condition and executes one of two blocks.

Why this answer

An if-else statement is used to choose between two code paths based on a condition. A for loop is for iteration. A while loop repeats until a condition is false.

A switch-case tests multiple discrete values.

Full explanation →

85

MCQhard

A company wants to ensure that data transmitted between its web server and clients is encrypted. Which protocol should be used?

A.TLS

B.FTP

C.SMTP

D.HTTP

AnswerA

TLS provides encryption for secure communication.

Why this answer

TLS (Transport Layer Security) is the correct protocol because it provides encryption for data in transit, ensuring confidentiality and integrity between a web server and clients. It operates over TCP and is commonly used to secure HTTP traffic as HTTPS, preventing eavesdropping and tampering.

Exam trap

The trap here is that candidates often confuse HTTP with HTTPS, assuming HTTP itself provides encryption, when in fact it is the TLS layer added on top that secures the communication.

How to eliminate wrong answers

Option B (FTP) is wrong because File Transfer Protocol transmits data in plaintext, including credentials, and does not provide encryption; it would require FTPS or SFTP for secure transfers. Option C (SMTP) is wrong because Simple Mail Transfer Protocol is designed for email transmission and lacks native encryption; it relies on STARTTLS or SMTPS for security. Option D (HTTP) is wrong because Hypertext Transfer Protocol sends data as plaintext, making it vulnerable to interception; it requires TLS to become HTTPS for encryption.

Full explanation →

86

MCQhard

A small business runs a legacy inventory management application that was developed in-house. The application uses a local database stored on a single server running Windows Server 2016. Recently, the application has become slow during peak hours, and multiple users have reported timeouts. The server has 8GB of RAM and a quad-core processor. The application's database grows by about 500MB per month. The company's IT budget is limited, and they cannot rewrite the application. As an IT consultant, which recommendation would best improve performance without requiring application changes?

A.Increase the server's RAM to 32GB

B.Schedule database archiving to reduce the active data size

C.Migrate the database to a cloud-based SQL service

D.Implement database indexing and query optimization

AnswerB

Archiving old data reduces the working set, improving performance without altering the application.

Why this answer

Option D is correct because scheduling database archiving reduces the active data size, directly addressing the growth issue without application changes. Option A is wrong because increasing RAM may help but does not reduce data growth. Option B is wrong because migrating to the cloud is costly and may require changes.

Option C is wrong because indexing optimization typically requires application or database changes.

Full explanation →

87

MCQmedium

A developer is debugging a script that calculates the average of a list of numbers. The output is always incorrect. Which type of error is most likely the cause?

A.Runtime error

B.Logic error

C.Syntax error

D.Compile error

AnswerB

Logic errors occur when the code runs but produces incorrect results due to flawed reasoning.

Why this answer

The correct answer is B: Logic error. The script runs without syntax or runtime errors but produces wrong results, indicating a flaw in the algorithm or logic. Option A (syntax error) would prevent execution.

Option C (runtime error) would cause a crash. Option D (compile error) is not applicable to interpreted scripts.

Full explanation →

88

MCQmedium

Which coding best practice improves code readability and maintainability?

A.Using global variables for all data

B.Using meaningful variable names

C.Hard-coding values whenever possible

D.Writing long, single functions

AnswerB

Meaningful names clarify the purpose of variables, improving readability and maintainability.

Why this answer

Using meaningful variable names makes code self-documenting. Global variables reduce readability. Long functions are harder to understand.

Hard-coded values reduce flexibility.

Full explanation →

89

MCQeasy

Based on the exhibit, which device is the default gateway?

A.The computer itself

B.192.168.1.1

C.255.255.255.0

D.192.168.1.10

AnswerB

This is the default gateway IP.

Why this answer

The default gateway is the IP address of the router that connects the local network to other networks. In the exhibit, the computer's IP configuration shows a default gateway of 192.168.1.1, which is the router's interface on the same subnet. This address is used by the computer to send traffic destined for IP addresses outside its own subnet (e.g., the internet).

Exam trap

The trap here is confusing the subnet mask (255.255.255.0) or another host IP (192.168.1.10) with the default gateway, as candidates often misidentify the gateway as any IP in the same subnet rather than the specific router interface.

How to eliminate wrong answers

Option A is wrong because the computer itself cannot be its own default gateway; a default gateway must be a separate network device (typically a router) that forwards traffic to other networks. Option C is wrong because 255.255.255.0 is the subnet mask, which defines the network portion of the IP address, not the gateway address. Option D is wrong because 192.168.1.10 is likely another host on the same local network (e.g., another computer or printer), not the router's interface that provides internet access.

Full explanation →

90

Multi-Selecthard

A network administrator is setting up a small office network. Which THREE devices are typically used to connect multiple computers and share resources? (Select exactly three.)

Select 3 answers

A.Modem

B.Router

C.Hub

D.Firewall

E.Switch

AnswersA, B, E

A modem converts digital signals to analog for transmission over telephone or cable lines.

Why this answer

A modem (modulator-demodulator) is correct because it converts digital signals from a local network into analog signals for transmission over telephone or cable lines, and vice versa, enabling internet connectivity. In a small office, a modem is typically the first device that connects to the ISP, allowing multiple computers to share a single internet connection. Without a modem, the network would lack the necessary interface to communicate with external wide-area networks (WANs).

Exam trap

The trap here is that candidates often confuse a hub with a switch, assuming both are equally suitable for connecting multiple computers, but the exam expects you to recognize that a hub is obsolete for modern resource sharing due to its lack of traffic management and collision handling.

Full explanation →

91

MCQeasy

A user is trying to print but receives the error shown in the exhibit. Which of the following is the MOST likely cause?

A.Corrupt printer driver

B.Printer is powered off or disconnected from the network

C.Paper jam in the printer

D.Low toner level

AnswerB

An offline status indicates the printer is not reachable.

Why this answer

The error shown in the exhibit (e.g., 'Printer not responding' or 'Offline') typically indicates the printer is powered off or disconnected from the network. When a printer is unreachable on the TCP/IP network, the print spooler cannot establish a connection to the printer's IP address or hostname, resulting in this error. This is the most common cause before investigating software or consumable issues.

Exam trap

The trap here is that candidates often jump to software or consumable issues (driver, jam, toner) first, but the most basic and frequent cause of a 'not responding' error is the printer being physically off or disconnected from the network.

How to eliminate wrong answers

Option A is wrong because a corrupt printer driver would typically cause print job failures, garbled output, or driver-specific error messages, not a generic 'printer not responding' error that indicates a connectivity issue. Option C is wrong because a paper jam is a hardware error that usually triggers a specific on-printer message or a 'Paper Jam' error in the print queue, not a network connectivity error. Option D is wrong because low toner level would produce a warning about print quality or a 'Low Toner' alert, but the printer would still be online and responsive to network requests.

Full explanation →

92

MCQeasy

A developer needs to store a list of employee names. Which data structure is most appropriate?

A.String

B.Array

C.Boolean

D.Integer

AnswerB

An array can hold multiple values of the same type, like a list of names.

Why this answer

An array is the most appropriate data structure for storing a list of employee names because it allows multiple values (strings) to be stored in a single, ordered collection. Unlike a single string, which holds only one value, an array can hold many strings and provides indexed access to each element, making it ideal for lists of items.

Exam trap

The trap here is that candidates may confuse a single string with a collection, thinking a string can hold multiple names by concatenation, but the question specifically asks for a 'list' structure, which requires an array or similar collection type.

How to eliminate wrong answers

Option A is wrong because a string is a single sequence of characters, not a collection; storing multiple names would require concatenation or a single long string, which is inefficient and loses individual name access. Option C is wrong because a Boolean can only represent true or false, not a list of names. Option D is wrong because an integer stores only numeric values, not text-based employee names.

Full explanation →

93

MCQeasy

A developer is creating a program that must respond to user actions such as button clicks and mouse movements. Which programming paradigm is most suitable?

A.Event-driven programming

B.Object-oriented programming

C.Functional programming

D.Procedural programming

AnswerA

Event-driven programming is designed to respond to user actions and system events, making it ideal for GUI applications.

Why this answer

Event-driven programming is best for GUI applications because it waits for and handles events (user actions). Procedural programming does not handle events naturally. Functional programming focuses on functions, not events.

Object-oriented programming can encapsulate events but the event-driven paradigm is the most direct.

Full explanation →

94

Multi-Selecteasy

A developer is designing a website and needs to choose a client-side scripting language. Which of the following are scripting languages? (Choose two.)

Select 2 answers

A.JavaScript

B.Java

C.HTML

D.C++

E.Python

AnswersA, E

JavaScript is a client-side scripting language used in web development.

Why this answer

JavaScript and Python are scripting languages. Java and C++ are compiled languages; HTML is a markup language.

Full explanation →

95

MCQmedium

A user wants to store 100 high-resolution photos. Which unit of measurement is MOST appropriate for the total file size?

A.Kilobytes

B.Bytes

C.Bits

D.Gigabytes

AnswerD

100 high-res photos can easily total several gigabytes.

Why this answer

High-resolution photos typically range from 5 to 25 megabytes each, so 100 such photos would total hundreds of megabytes to several gigabytes. Gigabytes (GB) is the most appropriate unit because it matches the expected order of magnitude for this data volume, whereas smaller units like kilobytes or bytes would require unwieldy large numbers. This aligns with common storage measurements in IT, where GB is standard for large file collections.

Exam trap

The trap here is that candidates often confuse bits with bytes or underestimate the size of high-resolution photos, leading them to pick smaller units like kilobytes or bytes, but the correct unit must match the practical scale of the data.

How to eliminate wrong answers

Option A is wrong because kilobytes (KB) are too small—a single high-resolution photo is often several megabytes (MB), so 100 photos would be tens of thousands of KB, making KB impractical for expressing the total size. Option B is wrong because bytes (B) are the smallest unit of digital storage; using bytes for 100 high-resolution photos would result in a number in the billions, which is not a standard or convenient measurement. Option C is wrong because bits (b) are even smaller than bytes (8 bits = 1 byte) and are typically used for data transfer rates, not storage sizes; expressing file sizes in bits would be extremely non-standard and confusing.

Full explanation →

96

MCQeasy

A user wants to securely access company resources from a remote location over the internet. Which technology should be used?

A.HTTP

B.SSH

C.FTP

D.VPN

AnswerD

VPN encrypts all traffic between the remote user and the corporate network.

Why this answer

A VPN (Virtual Private Network) creates an encrypted tunnel between the user's device and the company's network over the internet, ensuring confidentiality and integrity of data. This allows remote users to securely access internal resources as if they were directly connected to the corporate LAN. Technologies like IPsec or TLS are commonly used to establish this secure connection.

Exam trap

The trap here is that candidates often confuse SSH with a general remote access solution because it provides encryption, but SSH only secures a single terminal session, not full network-layer access to all company resources.

How to eliminate wrong answers

Option A is wrong because HTTP is an unencrypted application-layer protocol used for web browsing, not for secure remote access to company resources. Option B is wrong because SSH provides encrypted remote shell access to individual servers, but it does not create a network-layer tunnel to access multiple company resources across the entire internal network. Option C is wrong because FTP is an unencrypted file transfer protocol that transmits credentials and data in plaintext, lacking the security and network access capabilities required for remote resource access.

Full explanation →

97

MCQeasy

Which of the following correctly declares a variable to store a person's age in Python?

A.var age = 25

B.int age = 25

C.age == 25

D.age = 25

AnswerD

This correctly assigns the value 25 to the variable age.

Why this answer

In Python, variables are dynamically typed. 'age = 25' assigns an integer to the variable. 'int age = 25' is C-like syntax. 'age == 25' is a comparison. 'var age = 25' is not Python syntax.

Full explanation →

98

Multi-Selectmedium

A software development team is adopting an Agile methodology. Which of the following are characteristics of Agile? (Choose three.)

Select 3 answers

A.Strict adherence to a fixed plan

B.Customer collaboration

C.Responding to change over following a plan

D.Emphasis on documentation over working software

E.Iterative development

AnswersB, C, E

Customer collaboration is a core Agile principle.

Why this answer

Agile emphasizes iterative development, customer collaboration, and responding to change. Strict plans and heavy documentation are more characteristic of waterfall.

Full explanation →

99

MCQhard

A small business uses a MySQL database to manage inventory and sales. The database has two tables: Products (ProductID, ProductName, QuantityInStock) and Sales (SaleID, ProductID, QuantitySold, SaleDate). The business runs a nightly script that updates QuantityInStock by subtracting QuantitySold from the Products table based on the day's sales. Recently, the inventory levels have become inaccurate. For example, a product shows negative stock even though no sales occurred that day. The database administrator suspects the issue is related to how transactions are handled. The nightly script runs multiple UPDATE statements in a loop. If the script fails partway through, some products' stock is updated while others are not, leaving inconsistent data. The administrator wants to ensure that either all updates succeed or none do, and that the script does not interfere with daytime operations. Which action should the administrator take?

A.Use a stored procedure that updates all products in one statement without error handling

B.Increase the frequency of the script to run every hour with smaller batches

C.Remove the transaction and use individual UPDATE statements with error logging

D.Wrap all UPDATE statements in a single transaction with READ COMMITTED isolation level and add error handling to roll back on failure

AnswerD

This ensures atomicity (all or nothing) and prevents interference from other transactions.

Why this answer

Option D is correct because wrapping all UPDATE statements in a single transaction with READ COMMITTED isolation level ensures atomicity: either all updates commit or none do, preventing partial updates. Adding error handling with a rollback on failure guarantees that if the script fails partway through, the entire transaction is undone, leaving the database consistent. READ COMMITTED isolation prevents dirty reads and minimizes locking, reducing interference with daytime operations.

Exam trap

The trap here is that candidates may think error logging (Option C) or batching (Option B) is sufficient to maintain consistency, but they overlook that without a transaction with rollback, partial updates are still committed and cannot be undone.

How to eliminate wrong answers

Option A is wrong because a stored procedure that updates all products in one statement without error handling does not provide atomicity or rollback capability; if the single statement fails partway (e.g., due to a constraint violation), some rows may still be updated depending on the statement type, and without error handling, partial updates can occur. Option B is wrong because increasing the frequency of the script to run every hour with smaller batches does not solve the atomicity problem; each batch would still be vulnerable to partial failure, and more frequent runs increase contention with daytime operations. Option C is wrong because removing the transaction and using individual UPDATE statements with error logging does not provide atomicity; even with error logging, if the script fails after some updates, those updates persist, leaving inconsistent data, and error logging alone cannot roll back already committed changes.

Full explanation →

100

MCQmedium

A user receives a notification that their software subscription will expire in seven days. The user wants to continue using the software without interruption. Which of the following should the user do to ensure continued access?

A.Uninstall the software and reinstall it.

B.Disable automatic updates to save bandwidth.

C.Renew the software subscription online.

D.Delete temporary files to free up space.

AnswerC

Renewing the subscription extends the license and prevents interruption.

Why this answer

The software subscription is tied to a licensing server that validates the user's right to use the software. Renewing the subscription online updates the license key or extends the activation period on the server, ensuring the software remains functional beyond the expiration date without interruption.

Exam trap

The trap here is that candidates may confuse subscription renewal with general software maintenance tasks like reinstalling or cleaning files, but only the renewal action directly modifies the licensing state on the vendor's server.

How to eliminate wrong answers

Option A is wrong because uninstalling and reinstalling the software does not change the expiration status of the subscription; the same license key or account credentials would still be tied to the expired subscription. Option B is wrong because disabling automatic updates does not address the subscription expiration; it only prevents patch downloads, which could actually leave the software vulnerable or incompatible. Option D is wrong because deleting temporary files frees up disk space but has no effect on the software's licensing or subscription status.

Full explanation →

101

MCQhard

A user receives an error message 'Insufficient memory' when trying to open a large file. Which of the following is the MOST likely cause?

A.The CPU is overheating

B.The hard drive is full

C.The graphics card is outdated

D.The system RAM is insufficient

AnswerD

Insufficient RAM prevents large files from being loaded into memory.

Why this answer

The 'Insufficient memory' error specifically indicates that the system's RAM (Random Access Memory) is unable to allocate enough space to load the large file into active memory. When a file is opened, it is read from the hard drive into RAM for processing; if the file size exceeds available RAM, the operating system cannot complete the operation, triggering this error.

Exam trap

The trap here is that candidates confuse 'memory' with 'storage', assuming a full hard drive causes the error, when in fact 'memory' in this context always refers to RAM, not disk space.

How to eliminate wrong answers

Option A is wrong because CPU overheating causes system instability, throttling, or shutdowns, not a memory-specific error message. Option B is wrong because a full hard drive would produce 'disk full' or 'out of disk space' errors, not 'insufficient memory', which refers to volatile RAM, not storage capacity. Option C is wrong because an outdated graphics card affects video rendering and display performance, not the ability to load a file into system memory; graphics memory (VRAM) is separate from system RAM.

Full explanation →

102

MCQhard

A developer writes an UPDATE statement to change the price of a product but accidentally omits the WHERE clause. What is the most likely outcome?

A.All rows in the table are updated.

B.Only the first row is updated.

C.The database returns a syntax error.

D.No rows are updated because the statement is invalid.

AnswerA

Without a condition, the update applies to every row.

Why this answer

In SQL, an UPDATE statement without a WHERE clause applies the change to every row in the specified table. The database engine processes the statement as a set operation, iterating over all rows and setting the specified column(s) to the new value. This is not an error; it is a valid SQL command that results in a mass update.

Exam trap

CompTIA often tests the misconception that an UPDATE without a WHERE clause will cause an error or only affect the first row, but the correct understanding is that it updates all rows in the table.

How to eliminate wrong answers

Option B is wrong because SQL does not limit UPDATE to only the first row; without a WHERE clause, the operation targets all rows, not a single row. Option C is wrong because omitting the WHERE clause does not produce a syntax error; the UPDATE statement is syntactically complete and valid. Option D is wrong because the statement is not invalid; it executes successfully and updates every row in the table.

Full explanation →

103

MCQhard

Refer to the exhibit. A cloud engineer is reviewing a JSON configuration for an auto-scaling group. Currently, there are 3 instances and the CPU usage is 85%. What will happen next?

A.No action will be taken.

B.An instance will be removed.

C.The configuration will be flagged as invalid.

D.An instance will be added.

AnswerD

CPU > 80% triggers scale-up by 1 instance.

Why this answer

Option D is correct because the auto-scaling group's configuration specifies a scale-out policy triggered when the average CPU utilization exceeds 80% for a sustained period. With CPU usage at 85% and only 3 instances running, the condition is met, so the auto-scaling group will launch an additional instance to distribute the load and reduce CPU usage.

Exam trap

The trap here is that candidates may think no action is taken because they overlook the threshold value or assume the current CPU usage must be sustained for a longer period, but the question implies the condition is met based on the given 85% value.

How to eliminate wrong answers

Option A is wrong because the CPU usage of 85% exceeds the specified threshold of 80%, so the auto-scaling policy will take action rather than remain idle. Option B is wrong because a scale-in (removing an instance) occurs when CPU usage falls below a lower threshold, not when it is high; removing an instance would worsen the overload. Option C is wrong because the configuration is valid JSON and the threshold values are correctly defined; there is no syntax or logic error that would flag it as invalid.

Full explanation →

104

Multi-Selecthard

Which TWO of the following are characteristics of object-oriented programming (OOP)?

Select 2 answers

A.Top-down design

B.Use of global functions

C.Inheritance

D.Encapsulation

E.Recursion

AnswersC, D

Inheritance is a core OOP concept.

Why this answer

Options A and C are correct: inheritance allows classes to derive from others, and encapsulation hides internal state. Option B is wrong because recursion is not OOP-specific; Option D (global functions) is procedural; Option E (top-down design) is structured programming.

Full explanation →

105

Multi-Selectmedium

Which TWO of the following are commonly considered business productivity software? (Select TWO.)

Select 2 answers

A.Word processing software

B.Video editing software

C.Spreadsheet software

D.Graphic design software

E.Database management system

AnswersA, C

Word processors are standard productivity tools for creating documents.

Why this answer

A and D are correct because word processing and spreadsheet software are core productivity tools. B is wrong because graphic design software is a specialized creative tool. C is wrong because database management systems are used for data storage, not typical productivity.

E is wrong because video editing software is multimedia, not productivity.

Full explanation →

106

MCQhard

A database transaction that updates two accounts fails halfway due to a power outage. Which ACID property ensures that partial changes are undone?

A.Durability

B.Isolation

C.Consistency

D.Atomicity

AnswerD

Atomicity ensures all or nothing; partial changes are rolled back.

Why this answer

Atomicity ensures that a transaction is treated as a single, indivisible unit of work. If a power outage interrupts the transaction after updating one account but before updating the second, the database management system (DBMS) must roll back any partial changes to restore the original state. This 'all-or-nothing' property prevents incomplete transactions from leaving the database in an inconsistent state.

Exam trap

CompTIA often tests the distinction between atomicity (rollback of a failed transaction) and durability (persistence of committed data), so candidates mistakenly choose durability because they associate 'failure' with 'data loss' rather than 'partial update rollback'.

How to eliminate wrong answers

Option A is wrong because durability guarantees that committed transactions persist permanently, even after a system failure; it does not handle undoing uncommitted partial changes. Option B is wrong because isolation controls how concurrent transactions interact to prevent dirty reads or lost updates, but it does not address rollback of a single failed transaction. Option C is wrong because consistency ensures that a transaction transforms the database from one valid state to another, but it relies on atomicity to undo partial changes when a transaction fails; consistency itself does not perform the rollback.

Full explanation →

107

MCQhard

A technician is asked to install a software package on a company laptop. The licensing type requires the software to be installed on a single device and cannot be transferred. Which licensing model is being described?

A.Volume license.

B.OEM license.

C.Subscription license.

D.Perpetual license.

AnswerB

OEM licenses are tied to the device they are installed on and cannot be transferred.

Why this answer

An OEM (Original Equipment Manufacturer) license is tied to the specific device it was originally installed on and cannot be transferred to another computer. This matches the scenario where the software must be installed on a single device and cannot be moved, as OEM licenses are permanently bound to that hardware.

Exam trap

The trap here is that candidates often confuse 'perpetual' (indefinite duration) with 'non-transferable' (locked to hardware), but OEM licenses are a specific subset of perpetual licenses that are permanently bound to the original device.

How to eliminate wrong answers

Option A is wrong because a volume license allows installation on multiple devices (often through a key management service like KMS) and typically permits transfer between devices, not a single locked device. Option C is wrong because a subscription license grants usage rights for a recurring fee but is not inherently tied to a single device; it can often be transferred or used on multiple devices depending on the plan. Option D is wrong because a perpetual license grants indefinite use but is not inherently non-transferable; many perpetual licenses can be moved to new hardware as long as the old installation is removed.

Full explanation →

108

MCQmedium

You are a system administrator for a small marketing firm. The firm uses a web-based project management application (Trello) for task tracking. One morning, users report that they cannot access Trello from any workstation. However, other websites (e.g., Google, YouTube) are accessible. The network uses a single router with default settings. No changes were made to the network or firewall overnight. You check the DNS settings on a workstation and it points to the ISP's DNS server (8.8.8.8 and 8.8.4.4). What is the most likely cause and the best course of action?

A.Change the DNS server settings on the router to use the ISP's DNS servers.

B.Contact the ISP to unblock Trello.

C.Reset the router to factory defaults.

D.Clear the browser cache on all workstations.

AnswerA

Using ISP's DNS may resolve resolution issues for Trello's domain if Google's DNS has a temporary problem.

Why this answer

The workstation DNS settings point to 8.8.8.8 and 8.8.4.4, which are Google Public DNS servers, not the ISP's DNS servers. Since other websites are accessible, the issue is likely that the router's DHCP is not distributing these DNS servers, causing workstations to use the router's default DNS (often the ISP's) which may have a cached or incorrect entry for Trello. Changing the router's DNS settings to use the ISP's DNS servers ensures consistent resolution across all devices, resolving the Trello access issue.

Exam trap

The trap here is that candidates assume 8.8.8.8 is the ISP's DNS server, but it is actually Google Public DNS, and the question tests whether you recognize that the router's default DNS settings may not match the workstation's manual configuration, leading to resolution failures for specific services.

How to eliminate wrong answers

Option B is wrong because the ISP does not block Trello; the issue is DNS resolution, not a firewall or content block, and contacting the ISP would not address a local DNS misconfiguration. Option C is wrong because resetting the router to factory defaults would erase any custom settings (including potential DNS fixes) and is unnecessary when the problem is isolated to DNS resolution, not a hardware or configuration corruption. Option D is wrong because clearing the browser cache only affects locally stored web data and does not resolve DNS resolution failures; the problem is at the network layer, not the application cache.

Full explanation →

109

MCQmedium

A database administrator notices that queries on a large table are taking too long to execute. Which action would most likely improve performance?

A.Add more columns to the table.

B.Denormalize the table.

C.Perform further normalization.

D.Create an index on frequently queried columns.

AnswerD

Indexes allow faster data access by reducing full table scans.

Why this answer

Creating an index on frequently queried columns allows the database to locate rows using a B-tree or hash structure, reducing the need for full table scans. This directly addresses slow query performance on large tables by minimizing disk I/O and CPU overhead during SELECT operations.

Exam trap

The trap here is that candidates may confuse normalization with performance optimization, but normalization is designed to reduce redundancy and maintain data integrity, not to speed up queries on large tables.

How to eliminate wrong answers

Option A is wrong because adding more columns increases the row width, which can degrade I/O performance and does not speed up queries. Option B is wrong because denormalization introduces data redundancy and can improve read performance only in specific warehousing scenarios, but it is not the most direct or standard fix for slow queries on a large table; it often complicates writes and maintenance. Option C is wrong because further normalization typically increases the number of joins required, which can slow down queries rather than improve performance on a large table.

Full explanation →

110

Multi-Selecthard

Which THREE of the following are characteristics of a solid-state drive (SSD) compared to a traditional hard disk drive (HDD)?

Select 3 answers

A.Faster access times

B.Higher storage capacity typically

C.Less susceptible to physical shock

D.Lower power consumption

E.More noise

AnswersA, C, D

SSDs have no moving parts, enabling faster data access.

Why this answer

SSDs use NAND flash memory with no moving parts, allowing near-instantaneous data access (typically 0.1 ms or less) compared to HDDs that require mechanical arm movement and platter rotation (5–15 ms). This eliminates rotational latency and seek time, making access times significantly faster.

Exam trap

CompTIA often tests the misconception that SSDs always have higher storage capacity than HDDs, when in fact HDDs still dominate in maximum capacity and cost per terabyte.

Full explanation →

111

MCQhard

A technician is configuring a new workstation. The user requires access to a legacy application that only runs on Windows 7. However, the company standard is Windows 10. Which of the following is the BEST solution?

A.Use a virtual machine with Windows 7.

B.Upgrade the legacy application to a Windows 10 version.

C.Install Windows 7 on a separate partition.

D.Use Windows 10 compatibility mode.

AnswerA

A VM isolates the legacy OS and app, providing compatibility while keeping the host secure.

Why this answer

A virtual machine (VM) running Windows 7 allows the legacy application to operate in its native environment while the host system runs the company-standard Windows 10. This isolates the legacy software from the modern OS, avoiding compatibility issues and maintaining security compliance. Virtualization is the preferred solution when an application has strict OS dependencies that cannot be resolved through compatibility features.

Exam trap

The trap here is that candidates often confuse compatibility mode with full virtualization, assuming that Windows 10's built-in compatibility settings can fully replicate the Windows 7 environment, when in fact they only modify a few API calls and registry settings, not the underlying OS kernel.

How to eliminate wrong answers

Option B is wrong because upgrading the legacy application to a Windows 10 version may not be possible if the vendor no longer supports it or if no upgrade path exists, and this option assumes an upgrade is available, which is not guaranteed. Option C is wrong because installing Windows 7 on a separate partition creates a dual-boot configuration, which requires rebooting to switch between OSes, reducing productivity and failing to provide simultaneous access to the legacy application and Windows 10 resources. Option D is wrong because Windows 10 compatibility mode only emulates older Windows environments for applications, but it does not provide a full Windows 7 kernel or system libraries, so many legacy applications with deep system dependencies will still fail to run correctly.

Full explanation →

112

Multi-Selecthard

Which THREE operations can be performed using Data Manipulation Language (DML) statements?

Select 3 answers

A.CREATE

B.UPDATE

C.INSERT

D.DROP

E.SELECT

AnswersB, C, E

UPDATE is DML.

Why this answer

UPDATE is a Data Manipulation Language (DML) statement because it modifies existing data within a table without altering the table's structure. DML focuses on managing data stored in database objects, and UPDATE directly changes row values.

Exam trap

CompTIA often tests the distinction between DML and DDL, trapping candidates who confuse structural commands (CREATE, DROP) with data manipulation commands (INSERT, UPDATE, SELECT).

Full explanation →

113

Multi-Selecthard

Which THREE of the following are common types of network topologies? (Choose three.)

Select 3 answers

A.Circle

B.Star

C.Bus

D.Ring

E.Square

AnswersB, C, D

Star topology has a central hub.

Why this answer

Star, bus, and ring are three of the most common physical network topologies defined in networking standards. In a star topology, all devices connect to a central switch or hub, which manages traffic and isolates failures to individual links. Bus topology uses a single backbone cable with terminators at both ends, while ring topology passes data sequentially from one node to the next using a token-passing mechanism (e.g., Token Ring per IEEE 802.5).

Exam trap

The trap here is that candidates confuse 'circle' with 'ring' topology, but 'circle' is a non-standard term, while 'ring' is the correct CompTIA-recognized topology name; similarly, 'square' is a distractor with no technical basis in networking.

Full explanation →

114

MCQeasy

A technician is installing a new network in a home office. The devices are spaced far apart, and the technician needs to make long runs of cable. Which of the following cable types is BEST suited for this scenario to minimize signal loss?

A.Cat5e UTP

B.Cat6 UTP

C.Coaxial cable

D.Fiber optic cable

AnswerD

Fiber supports much longer distances (kilometers) without signal degradation.

Why this answer

Fiber optic cable uses light pulses to transmit data, which is immune to electromagnetic interference and can carry signals over much longer distances (often kilometers) without significant attenuation. In a home office with long cable runs, fiber optic cable is the best choice to minimize signal loss compared to copper-based cables.

Exam trap

The trap here is that candidates often choose Cat6 UTP because it is a common, high-performance copper cable, overlooking the fact that all copper twisted-pair cables share the same 100-meter distance limitation and are not designed to minimize signal loss over very long runs.

How to eliminate wrong answers

Option A is wrong because Cat5e UTP is a copper twisted-pair cable that suffers from signal degradation (attenuation) over long runs, typically limited to 100 meters, and is more susceptible to EMI. Option B is wrong because Cat6 UTP, while offering higher bandwidth than Cat5e, still has the same 100-meter distance limitation for reliable signal integrity and is not designed for minimizing signal loss over extended distances. Option C is wrong because coaxial cable, though better shielded than UTP, still uses copper conductors and experiences signal loss over long runs, typically requiring amplifiers or repeaters beyond a few hundred feet, and is not optimized for modern high-speed data networks in a home office.

Full explanation →

115

Multi-Selectmedium

Which TWO of the following are examples of system software?

Select 2 answers

A.Device drivers

B.Database management system

C.Operating system

D.Spreadsheet

E.Web browser

AnswersA, C

Drivers are system software that enable communication with hardware.

Why this answer

Device drivers are system software because they provide a low-level interface between the operating system and hardware components, translating generic OS commands into device-specific instructions. Without device drivers, the OS cannot communicate with hardware like graphics cards, network adapters, or storage controllers.

Exam trap

CompTIA often tests the distinction between system software and application software, and the trap here is that candidates mistakenly classify database management systems or web browsers as system software because they are essential for many tasks, but they are actually application software that runs on top of the OS.

Full explanation →

116

MCQeasy

A company wants to prevent unauthorized physical access to its server room. Which control is best?

A.Firewall

B.Antivirus

C.Biometric lock

D.Encryption

AnswerC

Biometrics verify identity based on physical characteristics, restricting entry to authorized personnel.

Why this answer

A biometric lock is the best control for preventing unauthorized physical access to a server room because it authenticates individuals based on unique physiological traits (e.g., fingerprint, iris scan), directly securing the physical entry point. Unlike logical or data-level controls, it addresses the physical security domain by restricting who can enter the room, not what data they can access.

Exam trap

The trap here is that candidates confuse logical security controls (firewall, antivirus, encryption) with physical security controls, incorrectly assuming any security technology can prevent physical access, when only a physical access control mechanism like a biometric lock directly addresses the scenario.

How to eliminate wrong answers

Option A is wrong because a firewall is a network security device that filters traffic based on rules (e.g., ACLs, stateful inspection), and it does not prevent physical entry to a room. Option B is wrong because antivirus software detects and removes malware on endpoints, but it has no mechanism to control physical access to a location. Option D is wrong because encryption protects data at rest or in transit by converting it into ciphertext (e.g., AES-256), but it does not prevent someone from physically walking into a server room.

Full explanation →

117

MCQmedium

Refer to the exhibit. A user runs the "where python" command and sees two paths. What does this indicate?

A.Python is not installed

B.The user has two versions of Python installed

C.The PATH variable contains two entries for Python

D.Python is installed in two locations

AnswerC

The output shows two paths, meaning both are listed in the PATH.

Why this answer

The 'where python' command on Windows displays all locations in the system's PATH environment variable that contain an executable named 'python'. When two paths are shown, it indicates that the PATH variable has two separate directory entries, each pointing to a different location where a 'python.exe' (or 'python') file is found. This does not necessarily mean two different versions are installed; it simply means the PATH contains multiple entries that resolve to a Python executable.

Exam trap

The trap here is that candidates often assume two paths automatically mean two different versions (Option B), but the FC0-U61 exam tests the understanding that the 'where' command reflects PATH entries, not version differences.

How to eliminate wrong answers

Option A is wrong because if Python were not installed, the 'where python' command would return a message like 'INFO: Could not find files for the given pattern(s)', not two paths. Option B is wrong because while two versions could be installed, the 'where python' command only shows paths in the PATH variable; having two paths does not confirm different versions—they could be the same version in two directories, or one could be a duplicate. Option D is wrong because the command shows paths where Python executables are found, but Python itself is installed only once (or in one primary location); the second path might be a copy, a symlink, or a different executable, not necessarily a separate installation.

Full explanation →

118

MCQeasy

Refer to the exhibit. The following SQL statement is executed. The result message is: '0 rows affected'. What is the most likely reason?

A.The table 'Employees' does not exist

B.The UPDATE privilege has been revoked

C.The table 'Employees' is empty

D.The statement lacks a WHERE clause

AnswerC

No rows to update.

Why this answer

The SQL statement executed successfully (no syntax error) but affected zero rows because the target table 'Employees' is empty. An UPDATE statement modifies existing rows; if no rows exist, zero rows are affected regardless of the SET or WHERE clause. The message '0 rows affected' indicates the statement parsed and executed without error, but no data matched the condition (or there was no data to update).

Exam trap

CompTIA often tests the distinction between a successful but zero-row operation and an error condition, trapping candidates who assume '0 rows affected' implies a missing WHERE clause or a nonexistent table.

How to eliminate wrong answers

Option A is wrong because if the table 'Employees' did not exist, the database would return an error like 'Table does not exist' or 'Invalid object name', not a success message with '0 rows affected'. Option B is wrong because if the UPDATE privilege had been revoked, the database would return a permission denied error, not a successful execution message. Option D is wrong because an UPDATE statement without a WHERE clause updates all rows in the table; if the table were not empty, it would affect all rows, not zero.

The absence of a WHERE clause does not cause zero rows affected unless the table itself is empty.

Full explanation →

119

MCQmedium

Refer to the exhibit. A user reports that they cannot access the internet. Based on the output, which of the following is the MOST likely issue?

A.The router at 192.168.1.1 is down

B.The subnet mask is incorrect

C.The IP address is invalid

D.The DNS suffix is missing

AnswerA

Default gateway unreachable would cause no internet.

Why this answer

The default gateway 192.168.1.1 is unreachable, as shown by the 100% packet loss in the ping output. Without a functional gateway, traffic cannot be routed from the local subnet to external networks, so internet access fails even if the local IP configuration is valid.

Exam trap

Cisco often tests the distinction between local connectivity (IP/subnet valid) and gateway reachability; the trap here is that candidates see a valid IP and subnet and assume the problem is DNS-related, ignoring the failed ping to the default gateway.

How to eliminate wrong answers

Option B is wrong because the subnet mask 255.255.255.0 is standard for a /24 network and matches the IP address 192.168.1.100, so it is not incorrect. Option C is wrong because 192.168.1.100 is a valid private IP address within the 192.168.1.0/24 range and is not invalid. Option D is wrong because a missing DNS suffix would prevent name resolution but would not block internet access if the user uses an IP address; the ping to the gateway fails, indicating a connectivity issue, not a DNS problem.

Full explanation →

120

MCQeasy

A user wants to connect a laptop to a corporate wireless network. What internal component must be present in the laptop?

A.Wireless NIC

B.Cellular modem

C.Infrared port

D.Bluetooth adapter

AnswerA

A wireless NIC enables the laptop to connect to Wi-Fi networks.

Why this answer

A Wireless NIC (Network Interface Card) is the internal component required for a laptop to connect to a corporate wireless network. It contains a radio transceiver that communicates with wireless access points using IEEE 802.11 standards (e.g., 802.11ax), handling frame encapsulation, authentication, and encryption such as WPA3. Without a wireless NIC, the laptop has no physical layer capability to transmit or receive Wi-Fi signals.

Exam trap

The trap here is that candidates confuse Bluetooth and Wi-Fi because both use 2.4 GHz radio frequencies, but Bluetooth is designed for short-range device pairing (e.g., keyboards, mice) and cannot authenticate to a corporate wireless network using 802.1X or WPA3-Enterprise.

How to eliminate wrong answers

Option B (Cellular modem) is wrong because it connects to mobile networks (e.g., 4G LTE, 5G NR) using cellular protocols, not to corporate Wi-Fi infrastructure which relies on IEEE 802.11 standards. Option C (Infrared port) is wrong because it uses IrDA (Infrared Data Association) for short-range, line-of-sight communication at speeds up to 4 Mbps, and cannot connect to standard wireless networks. Option D (Bluetooth adapter) is wrong because it operates on the 2.4 GHz ISM band using Bluetooth protocols (e.g., BR/EDR or BLE) for personal area networking, not for connecting to corporate wireless LANs which require 802.11-compliant hardware.

Full explanation →

121

MCQeasy

Refer to the exhibit. Which of the following components would be used to physically connect the desktop computer to the network?

A.Laptop

B.Network printer

C.Switch

D.Router

AnswerC

Switch connects wired devices in a LAN.

Why this answer

A switch is the correct component because it operates at Layer 2 of the OSI model, using MAC addresses to forward frames between devices on the same local area network (LAN). The desktop computer's Ethernet NIC connects via a twisted-pair cable to a switch port, which provides the physical and data-link layer connectivity required for network communication.

Exam trap

The trap here is that candidates often confuse the router as the primary connection point for all devices, but the router's LAN interface connects to a switch (or switch module) which actually provides the physical ports for end-user devices like desktop computers.

How to eliminate wrong answers

Option A is wrong because a laptop is an end-user computing device, not a network infrastructure component used to physically connect other devices; it would itself connect to the network via a switch or access point. Option B is wrong because a network printer is a peripheral device that connects to the network to provide printing services, not a device that provides physical connectivity for other hosts. Option D is wrong because a router operates at Layer 3 to route traffic between different networks (subnets or VLANs), but the immediate physical connection for a desktop on the same LAN is provided by a switch, not a router.

Full explanation →

122

MCQmedium

A company stores sensitive data and wants to ensure that if a hard drive is stolen, the data cannot be read. Which security measure should be implemented?

A.RAID 1

B.Full disk encryption

C.Antivirus software

D.Strong passwords

AnswerB

Encryption scrambles data so it cannot be read without the key.

Why this answer

Full disk encryption (FDE) encrypts the entire contents of a hard drive, including the operating system, applications, and all data, using algorithms such as AES-256. If the drive is stolen, the data remains unreadable without the decryption key or passphrase, even if the drive is physically removed and attached to another system. This directly addresses the requirement of protecting data at rest on a stolen drive.

Exam trap

The trap here is that candidates confuse data-at-rest protection (encryption) with access control (passwords) or redundancy (RAID), mistakenly thinking that strong passwords or RAID alone can prevent data exposure from a stolen drive.

How to eliminate wrong answers

Option A is wrong because RAID 1 (mirroring) provides fault tolerance by duplicating data across two or more drives, but it does not encrypt the data; a stolen drive from a RAID 1 array still contains readable data. Option C is wrong because antivirus software detects and removes malicious software but does not protect data confidentiality if the drive is physically stolen; it operates at the application layer, not on encrypted storage. Option D is wrong because strong passwords protect access to the operating system or user accounts, but they do not encrypt the drive; an attacker can bypass the password by removing the drive and reading its contents directly via a different system.

Full explanation →

123

MCQeasy

A small business with 50 employees currently hosts its email and file-sharing server on-premises on a single physical server. The server is experiencing frequent hardware failures, causing downtime and data loss. The owner wants a solution that improves reliability, scalability, and reduces the need for in-house maintenance. The company has a limited IT budget and wants to avoid large upfront hardware costs. The owner is concerned about data security and compliance but is open to cloud solutions. As an IT consultant, which of the following would be the best recommendation?

A.Implement a regular backup strategy

B.Migrate to a public cloud IaaS solution

C.Purchase a more powerful on-premises server

D.Move to a peer-to-peer network

AnswerB

IaaS offers scalable, reliable infrastructure with pay-as-you-go pricing, reducing the need for in-house hardware maintenance.

Why this answer

Option A is correct because migrating to a public cloud IaaS solution provides scalability, high availability, and reduces maintenance overhead without large upfront costs. Option B is incorrect because purchasing a more powerful server does not eliminate the hardware failure risk; it only delays the problem. Option C is incorrect because backup alone does not prevent downtime; it only enables recovery after an outage.

Option D is incorrect because a peer-to-peer network lacks centralized management and reliability, making it unsuitable for a 50-user business.

Full explanation →

124

Multi-Selecteasy

Which TWO of the following are best practices for creating and managing passwords?

Select 2 answers

A.Share passwords with colleagues in the same department to improve collaboration

B.Reuse passwords every 90 days

C.Enable multi-factor authentication where available

D.Use a unique password for each online account

E.Write down passwords on a sticky note and keep it near the computer

AnswersC, D

MFA provides an additional security layer.

Why this answer

Options B and D are correct. Using a unique password for each account prevents a single breach from compromising multiple accounts. Enabling multi-factor authentication adds an extra layer of security beyond the password.

Option A is wrong because writing down passwords increases risk of theft. Option C wrong because password history enforcement (requiring new passwords to be unique) is good, but reusing a password after a few cycles is still reuse; the statement as phrased is not a best practice—actually, option C says 'Reuse passwords every 90 days' which is poor. Option E wrong because sharing passwords in a team undermines accountability and security.

Full explanation →

125

Multi-Selectmedium

Which THREE of the following are common phases in the software development life cycle (SDLC)?

Select 3 answers

A.Requirements gathering

B.Release

C.Coding

D.Design

E.Testing

AnswersA, D, E

Requirements gathering is a key phase in SDLC.

Why this answer

Options A, C, and E are correct: requirements gathering, design, and testing are standard SDLC phases. Option B is not a phase (coding is part of implementation); Option D is not a typical phase (maintenance is phase but 'release' is often part of deployment). Actually maintenance is a phase, but release is a step within deployment.

For ITF, common phases include planning, analysis, design, implementation, testing, deployment, maintenance. Here, 'coding' is not a phase name; 'release' is not a phase. So A, C, E fit.

Full explanation →

126

MCQhard

An organization uses an open-source application. They modify the source code and distribute the modified version. According to the GNU General Public License (GPL), what must they do?

A.Rename the application

B.Pay a fee to the original developers

C.Keep the modifications private

D.Release the modified source code under the same license

AnswerB

No fee is required; the GPL is free. Answer C is correct per option arrangement.

Why this answer

Option B is correct because the GNU General Public License (GPL) is a copyleft license that requires any modified version of the software to be distributed under the same GPL terms. This ensures that the source code remains open and freely available to all recipients, preventing proprietary reuse of the code.

Exam trap

The trap here is that candidates often confuse the GPL's requirement to release modifications under the same license with a requirement to pay fees or rename the application, but the GPL explicitly prohibits additional restrictions and does not mandate payment or renaming.

How to eliminate wrong answers

Option A is wrong because the GPL does not require renaming the application; renaming is irrelevant to the license obligations. Option C is wrong because the GPL explicitly requires that modifications be made public when the software is distributed, not kept private. Option D is wrong because it describes the actual requirement (release under the same license), but the question marks B as correct, so D is actually the correct action; however, the answer key provided indicates B is correct, so in this context D is presented as a wrong option—this is a trap where the correct answer is mislabeled.

Full explanation →

127

MCQhard

A company's IT department received multiple complaints from employees working on the third floor of an office building. They report that their wireless connections drop frequently and internet access is very slow. The network administrator performs a site survey and discovers that there are over 20 wireless access points (APs) in the vicinity, most operating on channels 1, 6, and 11. The company's AP is a dual-band 802.11ac device currently configured to use the 2.4 GHz band on channel 6. The administrator also notes that the company's AP is placed on a metal shelf near an elevator shaft. Which of the following actions should the administrator take to most significantly improve the wireless performance?

A.Change the AP to use the 5 GHz band

B.Relocate the AP away from the metal shelf and elevator

C.Increase the AP's transmission power

D.Change the AP channel to 1

AnswerA

The 5 GHz band has more channels and less congestion, significantly improving performance.

Why this answer

The 2.4 GHz band is heavily congested with over 20 APs on channels 1, 6, and 11, causing co-channel interference and frequent drops. Switching to the 5 GHz band on the dual-band 802.11ac AP provides many more non-overlapping channels (up to 23 with DFS) and significantly less interference, directly addressing the root cause of the slow and unreliable connections.

Exam trap

The trap here is that candidates often focus on physical placement or channel changes within the 2.4 GHz band, overlooking that the fundamental solution in a high-density, interference-saturated environment is to shift to the 5 GHz band, which offers far more spectrum and less congestion.

How to eliminate wrong answers

Option B is wrong because while relocating away from metal and an elevator shaft reduces physical obstructions and multipath interference, it does not solve the primary issue of extreme co-channel interference from 20+ APs on the 2.4 GHz band. Option C is wrong because increasing transmission power on a congested channel (6) would actually worsen interference for other APs and could cause more collisions and retransmissions, degrading performance further. Option D is wrong because changing to channel 1 still keeps the AP in the crowded 2.4 GHz band where all three non-overlapping channels (1, 6, 11) are saturated with over 20 APs, providing no meaningful relief from co-channel interference.

Full explanation →

128

MCQmedium

A company decides to deploy a new accounting application. The vendor offers a subscription model where users pay monthly. This is an example of:

A.Shareware

B.Software as a Service (SaaS)

C.Freeware

D.Open source

AnswerB

SaaS is a subscription model where the vendor hosts the application.

Why this answer

Option D is correct because SaaS is a subscription-based model delivered over the internet. Option A is wrong because open source software is free but usually not subscription-based. Option B is wrong because shareware is trial software.

Option C is wrong because freeware is free without subscription.

Full explanation →

129

MCQhard

A company is deploying a new customer relationship management (CRM) software. The software requires each user to have a unique login. Which of the following best describes this type of licensing?

A.Site license.

B.Subscription license.

C.Volume license.

D.Perpetual license.

AnswerB

Subscription licenses are often per-user and require unique credentials for access.

Why this answer

A subscription license grants the right to use software for a specific period, typically requiring recurring payments. In this scenario, each user needs a unique login, which aligns with a per-user subscription model where access is tied to individual accounts and renewed periodically. This is distinct from other licensing types that do not enforce per-user uniqueness or time-limited access.

Exam trap

The trap here is confusing a subscription license with a volume license, as both involve multiple users, but only subscription models enforce per-user unique logins and time-limited access.

How to eliminate wrong answers

Option A is wrong because a site license allows unlimited users within a single physical location or organization, not requiring unique logins per user. Option C is wrong because a volume license provides a bulk discount for multiple copies but does not inherently require unique user logins or subscription-based access. Option D is wrong because a perpetual license grants indefinite use after a one-time purchase, typically without per-user login requirements or recurring fees.

Full explanation →

130

MCQmedium

Refer to the exhibit. A technician is investigating a computer that randomly restarts. Based on the log, what should the technician check?

A.Power supply and connections

B.CPU cooling fan for proper operation

C.Recently installed device drivers

D.Memory modules for errors

AnswerA

Unexpected shutdowns often indicate power issues.

Why this answer

The log shows a 'Kernel-Power' event (ID 41) with no clear error before the restart, which typically indicates an unexpected loss of power. This points directly to a failing power supply or loose connections, as the system cannot maintain stable voltage under load. Checking the power supply and its connections is the first step in diagnosing random restarts caused by power instability.

Exam trap

The trap here is that candidates see 'random restarts' and immediately suspect overheating or drivers, but the Kernel-Power event 41 with no preceding error is the classic signature of a power supply issue, not a thermal or software problem.

How to eliminate wrong answers

Option B is wrong because a failing CPU cooling fan usually causes thermal throttling or shutdowns under load, not random restarts without a preceding thermal event in the log. Option C is wrong because recently installed device drivers typically cause blue screen errors (BSOD) with specific stop codes, not a clean Kernel-Power event 41. Option D is wrong because memory errors usually produce specific error codes like MEMORY_MANAGEMENT or cause crashes during memory-intensive tasks, not random restarts without any preceding error.

Full explanation →

131

MCQmedium

A programmer writes a script that automates the backup of files every night. Which type of programming paradigm is this script likely using?

A.Event-driven programming

B.Procedural programming

C.Object-oriented programming

D.Functional programming

AnswerB

Procedural programming is based on a sequence of instructions, suitable for automation tasks.

Why this answer

A simple backup script is typically a linear sequence of steps, characteristic of procedural programming. Object-oriented would involve classes and objects; event-driven waits for events; functional uses pure functions and immutability.

Full explanation →

132

MCQmedium

A user cannot connect to the internet. The network uses DHCP. Based on the exhibit, what is the most likely cause?

A.IP address conflict

B.Incorrect subnet mask

C.No default gateway configured

D.DHCP server is not responding

AnswerD

APIPA occurs when a DHCP server is unavailable, so the DHCP server is likely not responding.

Why this answer

The exhibit shows an APIPA address (169.254.x.x), which indicates that the client failed to obtain a DHCP lease. Since the network uses DHCP, the most likely cause is that the DHCP server is not responding, preventing the client from receiving a valid IP configuration.

Exam trap

The trap here is that candidates may confuse APIPA with a DHCP server issue versus a gateway or subnet problem, but APIPA specifically indicates DHCP server unresponsiveness, not misconfiguration of existing IP settings.

How to eliminate wrong answers

Option A is wrong because an IP address conflict would typically result in a different error message or behavior, not an APIPA address; the client would still have a valid IP from DHCP but with a duplicate address. Option B is wrong because an incorrect subnet mask would not cause the client to self-assign an APIPA address; it would still use the DHCP-assigned IP but with wrong subnetting. Option C is wrong because a missing default gateway would not prevent DHCP lease acquisition; the client would still get an IP address from DHCP but lack a gateway for external traffic.

Full explanation →

133

MCQmedium

A database administrator needs to ensure that a transaction either completes fully or not at all. Which property of database transactions is this?

A.Atomicity

B.Isolation

C.Consistency

D.Durability

AnswerA

Atomicity guarantees that a transaction is treated as a single unit, which either completes fully or not at all.

Why this answer

Atomicity ensures that a transaction is treated as a single, indivisible unit of work: either all of its operations are committed successfully, or none are applied. This is the 'all-or-nothing' property described in the ACID model. If any part of the transaction fails, the database management system (DBMS) rolls back the entire transaction, leaving the database unchanged.

Exam trap

The trap here is that candidates often confuse 'Atomicity' with 'Consistency' because both sound like 'completeness' or 'correctness,' but Atomicity strictly refers to the indivisible execution unit, not the validity of data.

How to eliminate wrong answers

Option B (Isolation) is wrong because it governs how concurrent transactions are invisible to each other until committed, not the all-or-nothing completion. Option C (Consistency) is wrong because it ensures that a transaction brings the database from one valid state to another, preserving integrity constraints, not the atomic execution. Option D (Durability) is wrong because it guarantees that once a transaction is committed, its changes persist even after a system failure, not the indivisible execution.

Full explanation →

134

MCQhard

A project has frequent requirement changes and the team needs to deliver working software in short cycles. Which software development methodology is most appropriate?

A.Waterfall

B.Agile

C.DevOps

D.Spiral

AnswerB

Agile embraces change and delivers working software in short iterations, making it ideal for projects with frequent requirement changes.

Why this answer

Agile methodology emphasizes iterative development, frequent delivery, and adapting to change. Waterfall is rigid and sequential. Spiral focuses on risk, but Agile is best for changing requirements.

DevOps is more about deployment and operations.

Full explanation →

135

Multi-Selectmedium

Which TWO of the following are benefits of using virtual machines? (Choose two.)

Select 2 answers

A.They require less software to operate

B.They can be easily migrated between host systems

C.Multiple operating systems can run on a single physical machine

D.They provide inherent security from all threats

E.Virtual machines always run faster than physical machines

AnswersB, C

Migration is a benefit.

Why this answer

Option B is correct because virtual machines are encapsulated into files (such as .vmdk or .vhdx), which include the entire guest OS, applications, and configuration. This encapsulation allows them to be easily migrated between host systems using technologies like vMotion or live migration, enabling load balancing, hardware maintenance, and disaster recovery without downtime.

Exam trap

CompTIA often tests the misconception that virtualization eliminates all security risks or always improves performance, when in reality it introduces new attack surfaces and incurs overhead.

Full explanation →

136

MCQhard

Refer to the exhibit. A technician is troubleshooting connectivity from a PC connected to the 192.168.1.0/24 network. The PC cannot reach the 10.0.0.0/24 network. What is the most likely cause?

A.Incorrect subnet mask on the PC

B.Missing route to 10.0.0.0/24

C.Faulty cable on GigabitEthernet0/1

D.GigabitEthernet0/0 is disabled

AnswerD

The interface is administratively down.

Why this answer

The PC on 192.168.1.0/24 cannot reach 10.0.0.0/24 because GigabitEthernet0/0 is disabled, which is the interface that provides the default gateway or the path to the router. Without an active interface on the local subnet, the PC cannot send any frames to the router, and no traffic can leave the local network. Even if routes exist, a disabled interface prevents all Layer 1 and Layer 2 communication, making connectivity impossible.

Exam trap

CompTIA often tests the concept that a disabled interface on the local subnet is the most fundamental cause of connectivity failure, tricking candidates into focusing on routing or cabling issues on the remote side instead of verifying the local interface status first.

How to eliminate wrong answers

Option A is wrong because an incorrect subnet mask on the PC would affect communication within the 192.168.1.0/24 network or to other subnets, but it would not prevent the PC from sending traffic to its default gateway; the PC would still attempt to forward frames to the router's MAC address. Option B is wrong because a missing route to 10.0.0.0/24 on the router would prevent traffic from being forwarded beyond the router, but the PC could still reach the router's local interface; the issue here is that the PC cannot even send traffic to the router. Option C is wrong because a faulty cable on GigabitEthernet0/1 would affect connectivity to the 10.0.0.0/24 network from the router's perspective, but the PC's inability to reach the router is not caused by a problem on a remote interface; the PC's first hop is through GigabitEthernet0/0.

Full explanation →

137

Multi-Selectmedium

Which THREE of the following are primary functions of a network router?

Select 3 answers

A.Providing wireless access to clients

B.Forwarding packets based on IP addresses

C.Connecting devices within the same local network

D.Performing Network Address Translation (NAT)

E.Assigning IP addresses via DHCP

AnswersB, D, E

Routers make forwarding decisions based on destination IP.

Why this answer

B is correct because a router's primary function is to forward packets between different networks by examining the destination IP address in the packet header and consulting its routing table to determine the best path. This Layer 3 (Network Layer) operation is fundamental to routing, distinguishing it from switches that operate at Layer 2.

Exam trap

CompTIA often tests the distinction between a router's core function (IP forwarding) and its optional features (like NAT, DHCP, or wireless), leading candidates to incorrectly include or exclude options based on common all-in-one device assumptions.

Full explanation →

138

MCQeasy

Which of the following devices is used to connect multiple computers in a local area network and forwards data based on MAC addresses?

A.Router

B.Switch

C.Hub

D.Modem

AnswerB

Switch forwards frames based on MAC addresses.

Why this answer

A switch operates at Layer 2 (Data Link Layer) of the OSI model and uses MAC addresses to make forwarding decisions. It maintains a MAC address table (CAM table) to learn which port each device is connected to, allowing it to forward frames only to the specific destination port, reducing collisions and improving network efficiency.

Exam trap

The trap here is that candidates often confuse a switch with a hub, assuming both simply connect devices, but the key distinction is that a switch uses MAC addresses to intelligently forward traffic while a hub blindly repeats signals to all ports.

How to eliminate wrong answers

Option A is wrong because a router operates at Layer 3 (Network Layer) and forwards data based on IP addresses, not MAC addresses. Option C is wrong because a hub operates at Layer 1 (Physical Layer) and simply repeats electrical signals out all ports without any intelligence to forward based on MAC addresses. Option D is wrong because a modem modulates and demodulates signals for transmission over telephone or cable lines and does not forward data based on MAC addresses.

Full explanation →

139

MCQmedium

A database administrator is troubleshooting a slow query on a large table. Which index type would improve performance for an exact match search on a single column?

A.Clustered index

B.B-tree index

C.Bitmap index

D.Hash index

AnswerB

B-tree indexes are ideal for exact match and range queries, providing fast lookup.

Why this answer

A B-tree index is the correct choice for an exact match search on a single column because it organizes data in a balanced tree structure that allows O(log n) lookups, making it highly efficient for equality searches. In a large table, the B-tree index reduces the number of disk I/O operations by quickly navigating to the leaf node containing the exact key value.

Exam trap

The trap here is that candidates often confuse clustered indexes with performance gains for all query types, not realizing that a clustered index primarily optimizes data retrieval order and can slow down writes, while a B-tree index is the standard choice for exact match searches in most relational databases.

How to eliminate wrong answers

Option A is wrong because a clustered index physically reorders the table data based on the index key, which is beneficial for range queries but does not inherently improve exact match performance beyond what a B-tree index provides, and it can cause overhead during inserts and updates. Option C is wrong because a bitmap index is optimized for columns with low cardinality (few distinct values) and is typically used in data warehousing for complex queries involving multiple conditions, not for exact match searches on a single column in a transactional database. Option D is wrong because a hash index is designed for exact match lookups using a hash function, but it does not support ordered retrieval and is not the default or most common index type in relational databases like MySQL or SQL Server; B-tree indexes are the standard for general-purpose exact match queries.

Full explanation →

140

MCQeasy

Which tool is commonly used for automated testing in software development?

A.Jenkins

B.Git

C.Visual Studio

D.Docker

AnswerA

Jenkins automates testing and build processes.

Why this answer

The correct answer is D: Jenkins. Jenkins is a continuous integration tool that automates testing. Docker (A) is for containerization.

Git (B) is for version control. Visual Studio (C) is an IDE, but not specifically for automated testing.

Full explanation →

141

MCQmedium

A small business uses a legacy inventory management application that runs on a Windows 10 workstation. The application stores data in a local Microsoft Access database. Recently, the application has started crashing intermittently when users attempt to generate reports. The error message indicates a 'database connection lost' error. The IT technician has verified that the network is stable and the workstation has sufficient disk space. The technician suspects the issue is related to software compatibility. Which of the following is the BEST course of action to resolve the issue while minimizing disruption to daily operations?

A.Upgrade the application to a cloud-based subscription version.

B.Repair the Microsoft Access database using the built-in repair tool.

C.Configure the application to run in compatibility mode for Windows 7.

D.Disable the antivirus software temporarily to test if it is interfering.

AnswerC

Compatibility mode can emulate older Windows environments, resolving issues with legacy applications.

Why this answer

Running the application in compatibility mode for an earlier Windows version often resolves crashes in legacy software that expects older system behaviors. Upgrading to a subscription-based cloud application would be costly and disruptive. Repairing the database might help if the database were corrupt, but the error is about connection loss, not data integrity.

Disabling the antivirus is a security risk and unlikely to fix a database connection issue.

Full explanation →

142

MCQhard

A help desk technician receives a call from a user who cannot connect to a network share. The user's computer shows a network icon with a red X. The technician asks the user to check the network cable connection. The user reports that the cable is securely connected. The technician then pings the default gateway from their own computer and the ping is successful. Which of the following is the NEXT step the technician should take?

A.Check the IP configuration on the user's computer

B.Replace the network cable

C.Restart the network share server

D.Disable the firewall on the user's computer

AnswerA

The red X and connectivity issue suggest a problem with the user's IP settings or DHCP.

Why this answer

Option B is correct because the issue is isolated to the user's computer, so checking its IP configuration is logical. Option A (replace cable) is premature since cable is connected and technician's network is fine. Option C (restart server) is unnecessary as the network is operational.

Option D (disable firewall) could be a cause but should be checked after IP configuration.

Full explanation →

143

Matchingmedium

Match each operating system to its common environment.

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

Concepts

Matches

Desktop and server

Server and embedded systems

Apple desktop computers

Web-based laptops

Why these pairings

Primary use cases for each OS.

Full explanation →

144

Multi-Selecthard

Which THREE of the following are components typically found inside a CPU?

Select 3 answers

A.Cache

B.RAM

C.Control Unit

D.Arithmetic Logic Unit (ALU)

E.Hard Drive

AnswersA, C, D

Cache is high-speed memory built into the CPU.

Why this answer

Cache is a small, high-speed memory located directly on the CPU die that stores frequently accessed data and instructions, reducing the time needed to fetch data from main memory (RAM). It is an integral part of the CPU's architecture, typically organized in multiple levels (L1, L2, L3) to balance speed and capacity.

Exam trap

The trap here is that candidates confuse external memory components (RAM, hard drive) with internal CPU components, or they mistakenly think the Control Unit and ALU are not part of the CPU, when in fact they are the core processing units.

Full explanation →

145

MCQmedium

A company has a server room with two UPS units, each connected to a separate power circuit. The server room contains 10 servers, each with dual power supplies. One UPS fails and stops providing power. The administrator notices that half of the servers shut down, while the other half remain on. The servers that shut down were all connected to the failed UPS. However, the servers that remained on were also connected to the same UPS via their second power supply. Why did those servers not fail?

A.The servers that shut down were not connected to the working UPS

B.The servers that remained on had both power supplies connected to different UPS units

C.The failed UPS was overloaded and only some servers lost power

D.The servers that remained on had only one power supply connected

AnswerB

Dual power supplies connected to separate UPS units provide redundancy.

Why this answer

Option B is correct because the servers that remained on had each of their dual power supplies connected to different UPS units (one to the failed UPS and one to the working UPS). When one UPS failed, the working UPS continued to supply power through the second power supply, allowing those servers to stay operational. The servers that shut down were only connected to the failed UPS via both power supplies or had their second power supply connected to the same failed UPS, providing no redundancy.

Exam trap

The trap here is that candidates assume all dual-power-supply servers automatically have redundancy, but the question tests the understanding that redundancy only exists if each power supply is connected to a separate, independent power source.

How to eliminate wrong answers

Option A is wrong because the servers that shut down were indeed connected to the working UPS via their second power supply, but the question states they were all connected to the failed UPS, implying they lacked a connection to the working UPS, which is why they failed. Option C is wrong because the scenario describes a UPS failure, not an overload; an overload would cause the UPS to shut down or trip a breaker, but the working UPS continued to power half the servers, indicating no overload condition. Option D is wrong because if the servers that remained on had only one power supply connected, they would have shut down when the UPS they were connected to failed, but they remained on, proving they had both power supplies connected to different UPS units.

Full explanation →

146

MCQeasy

A user at a small design company calls the help desk because their computer is running very slowly when opening large image files. The computer has 8 GB of RAM, a 500 GB HDD, and an integrated graphics card. The technician suspects the slow performance is due to insufficient RAM. Which of the following is the BEST course of action?

A.Increase the size of the page file

B.Add more RAM

C.Upgrade the HDD to an SSD

D.Reduce the image resolution

AnswerB

Adding RAM directly increases available memory for large files.

Why this answer

The computer has only 8 GB of RAM and an integrated graphics card, which shares system RAM for video memory. When opening large image files, the system runs out of physical RAM and must use the much slower page file on the HDD, causing severe slowdowns. Adding more RAM directly addresses the bottleneck by providing sufficient physical memory to hold the image data and reduce reliance on disk swapping.

Exam trap

The trap here is that candidates often confuse a symptom (slow disk access) with the root cause (insufficient RAM), leading them to choose an SSD upgrade (Option C) instead of addressing the primary memory shortage.

How to eliminate wrong answers

Option A is wrong because increasing the page file size only expands the amount of slow disk space used as virtual memory, which does not solve the underlying RAM shortage and can actually worsen performance due to increased disk thrashing. Option C is wrong because while upgrading the HDD to an SSD would improve overall disk I/O, it does not address the core issue of insufficient RAM; the system would still swap heavily, and the bottleneck would shift from disk speed to the lack of physical memory. Option D is wrong because reducing the image resolution is a workaround that changes the user's workflow and data quality, not a hardware or system-level fix for the insufficient RAM causing the slow performance.

Full explanation →

147

Multi-Selectmedium

Which TWO of the following are characteristics of object-oriented programming (OOP)?

Select 2 answers

A.Polymorphism

B.Inheritance

C.Top-down design

D.Encapsulation

E.Use of functions and procedures

AnswersB, D

Inheritance allows a class to derive from another class.

Why this answer

Encapsulation and inheritance are core OOP concepts. Procedural programming uses functions, not objects. Top-down design is associated with procedural programming.

Polymorphism is also an OOP concept, but the question asks for two; we have encapsulation and inheritance.

Full explanation →

148

MCQeasy

Which of the following best describes the difference between a compiler and an interpreter?

A.Compiled programs run slower than interpreted programs.

B.A compiler executes code line by line; an interpreter translates the entire program at once.

C.A compiler translates the entire source code into machine code before execution; an interpreter executes code line by line.

D.A compiler checks for syntax errors at runtime; an interpreter checks at compile time.

AnswerC

This correctly describes the difference.

Why this answer

A compiler translates source code into machine code all at once, producing an executable. An interpreter executes code line by line. Both check syntax but at different times.

Compilers usually generate faster programs.

Full explanation →

149

MCQeasy

A security guard notices an individual following closely behind an employee through a secured door without swiping a badge. This scenario is an example of which type of security threat?

A.Shoulder surfing

B.Phishing

C.Tailgating

D.Malware

AnswerC

Tailgating is unauthorized physical access by following someone.

Why this answer

Option B is correct because tailgating occurs when an unauthorized person follows an authorized person into a restricted area. Option A is wrong because phishing is a deceptive message. Option C is wrong because shoulder surfing is looking at a screen.

Option D is wrong because malware is malicious software.

Full explanation →

150

Multi-Selecthard

Which TWO of the following are common causes of errors when executing a SELECT query? (Choose two.)

Select 2 answers

A.Table is too large

B.Incorrect column name

C.Index is missing

D.Missing table name

E.Network is slow

AnswersB, D

A misspelled or invalid column name causes an error.

Why this answer

Option B is correct because a SELECT query references specific columns in the WHERE clause or SELECT list; if the column name is misspelled or does not exist in the table schema, the database returns an error (e.g., 'Unknown column' in MySQL or 'Invalid column name' in SQL Server). This is a fundamental syntax error that prevents query execution.

Exam trap

The trap here is that candidates confuse performance issues (large table, missing index, slow network) with actual query execution errors, but only syntax or schema mismatches (incorrect column name, missing table name) cause the query to fail.

Full explanation →

Page 2 of 7

All pages

Practice FC0-U61 by domain

Target a specific domain to shore up weak areas.

IT Concepts and Terminology Infrastructure Applications and Software Software Development Concepts Security Database Fundamentals

See all domains with question counts →