FC0-U71 · domain
troubleshooting
Practise CompTIA Tech+ (FC0-U71) troubleshooting practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.
Focused practice
Practice troubleshooting questions
Scored sessions drawing only from this domain — pick a length below.
Start 20-question practice test →What this domain covers
What to know about troubleshooting
troubleshooting questions test whether you can apply the concept in context, not just recognise a definition.
How the topic appears in realistic exam-style scenarios.
Which detail in the question changes the correct answer.
How to eliminate plausible but wrong options.
How to connect the question back to the wider exam objective.
Watch out for
Common troubleshooting exam traps
- ▸Answering from memory before reading the full scenario.
- ▸Missing a constraint such as cost, availability, security, scope or command context.
- ▸Choosing a broad answer when the question asks for the most specific fix.
- ▸Ignoring why the wrong options are tempting.
Question index
All troubleshooting questions (988)
Click any question to see the full explanation, or start a practice session above.
During the SDLC, testing is performed at different levels. Which TWO of the following are recognized levels of testing? (Select TWO.)
Easy2A small e-commerce website uses a relational database to manage its products and orders. The most common query is retrieving a product by its unique product ID. This query is executed thousands of times per minute. The database currently has no indexes, and the query is slow, causing user-facing delays. The database administrator wants to improve performance with minimal downtime and cost. Which action should be taken first?
Medium3A technician is selecting a storage solution for a home server that requires fast access speeds and redundancy against a single drive failure. Which TWO technologies should be considered?
Medium4Which component of a computer stores data permanently even when the power is turned off?
Easy5A company is planning to deploy tablets for field sales representatives. Which TWO mobile device features would be most useful for navigation and contactless payments?
Medium6A web developer wants to identify why a web page is loading slowly. Which built-in browser tool is most appropriate to analyze network requests?
Medium7A network technician observes that a DHCP server is not issuing IP addresses to clients. The DHCP server is running on a Windows Server with a static IP of 192.168.1.10. Clients are on the same subnet. Which of the following should the technician check FIRST?
Hard8A company is setting up a new branch office. The network administrator needs to choose a wireless standard and a frequency band. Which TWO of the following options would provide the fastest speeds and least interference? (Select TWO.)
Medium9A company requires all employees to use a smart card and a PIN to access the building. This is an example of which concept?
Medium10A user saves a document as 'report.docx'. Based on the file extension, what type of file is it?
Medium11Which of the following is the primary function of a router in a home network?
Easy12A web application is not responding to user input. The developer checks the code and finds an infinite loop. Which change will fix the infinite loop?
Medium13A software developer writes code that interacts with the operating system to access hardware. Which layer of software is being used?
Hard14A technician is documenting a hospital system where each patient can have many appointments, but every appointment belongs to exactly one patient and one doctor. The technician must describe how the Appointment table relates to the Patient table. Which term correctly describes this relationship?
Medium15A technician is setting up a new laptop for a traveling salesperson. The laptop must have a built-in cellular modem so the user can access the internet without relying on Wi-Fi hotspots or tethering to a phone. Which internal expansion slot is specifically designed to accept a cellular modem module in a modern laptop?
Easy16A small e-commerce company uses a monolithic web application hosted on a single server. During peak shopping hours, the server becomes overloaded, causing slow page loads and occasional timeouts. The development team wants to improve scalability and maintainability. They are considering breaking the application into smaller, independent services that can be developed, deployed, and scaled separately. Which approach should the team adopt?
Easy17A junior database administrator is reviewing the structure of a relational database used by a library. The database contains a Books table, a Members table, and a Loans table that records which member borrowed which book and the loan date. Which TWO of the following statements accurately describe the role of the Loans table in this database? (Choose two.)
Medium18A user notices their computer is running slowly and has many applications open. Which TWO hardware components are most likely to impact the speed at which multiple applications can run simultaneously? (Select TWO).
Medium19A user downloads a freeware application that displays occasional ads and offers paid upgrade options. This distribution model is best described as:
Hard20Which type of malware is designed to replicate itself and spread to other computers without needing to attach to a host file?
Medium21A user is trying to connect a laptop to a high-definition monitor that supports 4K resolution at 60Hz. Which of the following ports on the laptop will support this video output?
Medium22A developer is trying to find why a program is producing incorrect output. The developer runs the program with a debugging tool, sets a breakpoint at a specific line, and examines the values of variables at that point. Which debugging technique is being used?
Medium23A system administrator needs to deploy a software update to 500 computers without user interaction. Which installation method should be used?
Hard24A graphic designer needs to choose a software for vector illustration. Which of the following is best suited?
Medium25A small office has five desktop computers that need to be connected to share files and a printer. Which network device should be used to create a local area network?
Easy26A user wants to permanently delete files from a USB flash drive without any possibility of recovery. Which of the following techniques should be used?
Easy27An attacker gains physical access to a secure area by following an authorized employee through a door that requires a badge. This social engineering technique is known as:
Medium28A logistics analyst needs to record which driver delivered each shipment. A driver can deliver many shipments, and each shipment is delivered by exactly one driver. Which relationship type exists between drivers and shipments?
Medium29A small business owner wants to protect customer data stored on laptops in case the devices are stolen. Which encryption method provides the best protection for the entire hard drive?
Hard30A user wants to connect a high-resolution 4K monitor to their desktop computer for gaming at 144Hz. Which port should they use to ensure the best performance?
Medium31A company wants to run multiple operating systems on a single physical server to maximize resource utilization. Which technology should they use?
Hard32A technician is evaluating the CPU specifications of two computers. Which THREE factors directly affect the CPU's performance? (Select THREE.)
Hard33An employee allows a delivery person to enter a secure office building by holding the door open. The delivery person does not have an access badge. Which social engineering attack is this?
Medium34Which TWO of the following are effective measures to protect against ransomware attacks? (Select two.)
Medium35A user asks a technician why their computer can run multiple applications at once, such as a web browser, email client, and word processor, without them interfering with each other. Which of the following concepts should the technician use to explain this?
Easy36Which TWO of the following are common characteristics of compiled programming languages?
Medium37Which network topology connects all devices to a single central cable?
Medium38Which of the following is a characteristic of a relational database table?
Easy39A graphic designer is working with a large image file in a proprietary software format. The designer needs to send the image to a client who uses a different operating system and does not have the same software. Which of the following is the BEST method to ensure the client can open the file?
Medium40A security analyst is evaluating risks to the company's network. According to the risk formula (Risk = Likelihood × Impact), which THREE of the following are considered vulnerabilities?
Hard41A user is working on a presentation for a client meeting. The user has been using Microsoft PowerPoint and has completed the slides. The user now needs to create handouts for the audience so they can follow along. The handouts should show the slides with space for notes. Which of the following is the BEST way to create these handouts?
Medium42An IT specialist is explaining ASCII and Unicode to a trainee. Which statement accurately describes a difference between ASCII and Unicode?
Hard43An analyst runs a query against a sales database and wants to return only the rows where the Region column equals 'West' and the SaleAmount column is greater than 1000. The analyst also wants the results sorted from highest SaleAmount to lowest. Which clause combination should the analyst use?
Medium44Which type of memory is volatile and loses its data when the computer is turned off?
Easy45A developer is designing a program that stores a customer's mailing address, which consists of a street, city, state, and postal code. The developer wants to keep these related values grouped together and access them by name rather than by numeric position. Which data structure is the best fit?
Medium46A REST API is used by a mobile app to retrieve data. The API returns responses in a specific format. Which THREE of the following are typical characteristics of a REST API?
Medium47A database table contains repeating groups of fields for multiple phone numbers per customer. Which normal form is being violated?
Easy48Which of the following best describes the function of a hypervisor?
Medium49A company's database administrator notices that queries against a large customer table are running slowly. The table has millions of rows and is frequently filtered by the 'last_name' column. Which of the following is the BEST way to improve query performance without changing the application code?
Medium50A security policy grants the following permissions: Read and List. Based on the policy, what actions are permitted by this policy?
Hard51A database has a table 'Orders' with columns OrderID (primary key), CustomerID, OrderDate, and TotalAmount. Which SQL statement will delete all orders placed before January 1, 2023?
Hard52A user receives an email from their bank asking them to click a link and verify their account information. The email contains spelling errors and the sender's address looks suspicious. Which type of social engineering attack is this?
Medium53A user complains that their laptop's built-in display is very dim and difficult to read, even when the brightness is set to maximum. The laptop is five years old and has never had any hardware replaced. Which component is most likely failing?
Easy54A developer wants to represent the logic of a program before writing code. The diagram should show decisions with diamond shapes and processes with rectangles. Which representation is the developer creating?
Easy55A developer writes a function that calculates the average of a list of numbers. The function works correctly when the list contains values, but crashes when the list is empty. Which programming concept should the developer apply to handle the empty list case gracefully?
Hard56A technician needs to convert a decimal IP address octet value of 192 to binary. Which of the following is the correct binary representation?
Medium57A user reports that their computer has been displaying unwanted pop-up advertisements frequently. Which type of malware is most likely responsible?
Medium58A small business needs to manage customer contacts, sales leads, and communication history. Which THREE types of software could be used? (Choose THREE.)
Hard59A developer needs to represent the logic of a program that decides whether a user is eligible for a discount. The process includes conditions (e.g., 'is member?') and actions (e.g., 'apply 10% discount'). Which tool would best visually represent this logic using standardized symbols like diamonds for decisions and rectangles for processes?
Medium60A technician is cleaning up a Windows workstation that has accumulated many installed programs. The technician wants to remove applications that were installed as part of a bundled package and also wants to free disk space consumed by leftover installation files. Which TWO actions should the technician perform? (Choose two.)
Hard61Which of the following file attributes on a Windows system would prevent a user from accidentally modifying a document when set?
Medium62Which TWO of the following are examples of input devices? (Select TWO).
Easy63A company's server room is experiencing intermittent overheating. The administrator notices that the perforated floor tiles are blocked by equipment. What is the most likely consequence of this obstruction?
Hard64Refer to the exhibit. A user cannot access the internet. What is the most likely issue based on the configuration shown?
Easy65Which DBMS is an example of a proprietary relational database system?
Medium66A database administrator needs to ensure that only authorized users can access sensitive data. Which of the following concepts describes this requirement?
Hard67After a network upgrade, a user reports that their computer intermittently loses network connectivity. The link light remains on, but the activity light flashes rapidly and irregularly. What is the most likely cause?
Hard68A technician is troubleshooting a network issue where a client cannot reach a server on a different subnet. The client's IP is 192.168.1.10/24, and the server's IP is 10.0.0.50/24. The client can ping its default gateway. Which device is most likely misconfigured?
Hard69A user wants to prevent unauthorized access to their laptop if stolen. Which is the best method?
Medium70A technician is setting up a brand-new all-in-one desktop for a home user. The user wants to connect to the internet using the existing home router without running any cables. Which built-in capability should the technician verify is working?
Easy71A table has columns: EmployeeID (PK), DepartmentID, DepartmentName, Salary. Which normal form violation exists?
Hard72A network technician is troubleshooting a slow wireless connection in a crowded office. The office uses many Wi-Fi networks and devices. Which Wi-Fi standard would be best to minimize interference and provide faster speeds?
Hard73A user wants to connect an external storage drive to a laptop for fast file transfers. The laptop has USB-A, USB-C, and Thunderbolt 3 ports. Which connection provides the fastest theoretical data transfer speed?
Medium74A user wants to store a file with lossless compression. Which TWO of the following file formats support lossless compression? (Select TWO.)
Medium75A software engineer is debugging a program and needs to identify potential issues. Which THREE tools or techniques are commonly used in debugging? (Select THREE.)
Hard76A user needs to collaborate on a document with colleagues in real-time. Which type of application should they use?
Medium77Which of the following SQL statements will add a new row to the 'Products' table?
Medium78A sales database has a Customers table with CustomerID as the primary key and an Orders table that includes CustomerID. Which type of relationship is typically established between Customers and Orders?
Medium79A developer writes a function that opens a file, reads its contents, and then returns the data. If the file does not exist, the program should display a friendly message instead of terminating abruptly. Which approach best handles this situation?
Hard80A computer has 8 GB of RAM. If the operating system and applications are using 3.2 GB, how much RAM is available for other processes?
Medium81An office printer frequently jams and produces poor-quality color prints. The office manager decides to replace it with a printer that is faster and more cost-effective for high-volume black-and-white text documents. Which type of printer is most appropriate?
Medium82A web application needs to send user registration data to a server. Which HTTP method should be used?
Hard83A technician is explaining how data is represented and processed in a computer. Which TWO of the following statements accurately describe the relationship between bits, bytes, and storage capacities? (Choose two.)
Hard84A mobile app needs to display weather data from an online service. The app sends HTTP requests and receives responses in JSON format. This communication is made possible by a set of rules and protocols that allow the app and the service to interact. This set of rules is called a(n):
Easy85Which of the following is a best practice for creating a strong password?
Easy86A security analyst discovers that a file on a server has been modified without authorization. Which element of the CIA triad has been compromised?
Hard87A database administrator is designing a new table to store employee records. The administrator wants to ensure that no two employees can have the same employee identification number, and that the employee identification number cannot be left empty. Which constraint should be applied to the EmployeeID column to meet both requirements?
Hard88Which internet connection type provides symmetric upload and download speeds over a fiber-optic cable?
Hard89What is the primary risk of using public Wi-Fi without a VPN?
Medium90Which TWO of the following are appropriate steps when troubleshooting a user's inability to access the internet? (Select TWO.)
Medium91A junior developer writes a program that stores a customer's age in a variable. The program must later perform arithmetic, such as adding five years to that age. Which data type is MOST appropriate for this variable?
Easy92A technician is troubleshooting a workstation that randomly loses its connection to a file server. The workstation's IP address is 169.254.10.25, and it cannot reach the default gateway. The switch port shows link and activity lights. Which of the following is the MOST likely cause?
Hard93You are a desktop support technician for a small accounting firm. The firm uses a legacy accounting application that only runs on Windows 7. The application stores data in a local SQL Server Express database. A user reports that since the IT department applied a mandatory security update last night, the accounting application fails to start and displays an error: 'Cannot connect to database server. Check that the SQL Server (MSSQLSERVER) service is running.' You verify that the SQL Server service is set to Automatic but is not running. When you attempt to start it manually, it fails with error 1069: 'The service did not start due to a logon failure.' Which of the following is the MOST likely cause and solution?
Hard94A technician is installing RAM in a desktop computer. The motherboard supports dual-channel memory. Which memory configuration will provide the BEST performance?
Medium95A developer is testing a piece of code that calculates discounts. The code should give 10% off for orders over $100, and 5% off for orders between $50 and $100. Which test input set would best verify boundary conditions?
Hard96Which TWO of the following are characteristics of a solid-state drive (SSD) compared to a hard disk drive (HDD)?
Medium97A user downloads a software installer from the internet. On Windows, which file extension is most likely to be used for the installer?
Medium98An IT administrator is setting up a virtualization server to run multiple operating systems. The server will host critical business applications and requires maximum performance and reliability. Which type of hypervisor should the administrator choose?
Hard99A developer writes a script to calculate the average of a list of numbers. The script uses a loop to sum the numbers and then divides by the count. Which programming concept does this represent?
Easy100A network administrator is documenting the physical topology of a new office. The design uses a central switch with a dedicated cable to every desk, and the administrator wants to describe the strengths of this layout. Which TWO characteristics accurately describe this topology? (Choose two.)
Medium101What is the primary purpose of a password manager?
Easy102A small business wants employees to use a cloud-based office suite so that multiple people can edit the same document at the same time and see each other's changes immediately. Which characteristic of the cloud-based suite makes this possible?
Medium103A developer needs to store several related values for one record, such as a product's name, price, and quantity, and pass them around as a single unit. The values have different data types. Which data structure is MOST appropriate?
Medium104Which component of the CIA triad ensures that data cannot be modified by unauthorized users?
Easy105A programmer needs to store a customer's name in a variable. Which data type is most appropriate?
Easy106A technician is setting up a new wireless router for a home office. The user wants to ensure that devices can connect using the latest standard for better speed and reduced interference. Which wireless standard should the technician configure the router to use?
Easy107A user's web browser warns that the connection to an online store is not private because the site's certificate cannot be validated. The user ignores the warning and enters payment card details anyway. Which type of attack is the user MOST at risk of in this situation?
Hard108A company issues smartphones to employees and needs to enforce security policies such as remote wipe and mandatory encryption. Which technology should the IT department implement?
Medium109A user is concerned about connecting to a public Wi-Fi network at a coffee shop. Which security measure can best protect their data?
Medium110A technician is installing a legacy application on Windows 10 and receives an error log indicating 'Access Denied'. Which of the following should the technician do FIRST?
Hard111A home user reports that a web page loads slowly and intermittently fails to open, but other users on the same network reach the same site without trouble, and the site is reachable from a mobile phone on cellular data. The technician suspects the browser is holding outdated cached data for that site. Which action should the technician take first?
Medium112A user is setting up a new wireless router for a home office and wants to secure the wireless network. Which TWO of the following should the user configure to help prevent unauthorized access? (Choose two.)
Medium113A user reports that a desktop application crashes every time it tries to save a file to a network drive. Other applications work fine. Which is the MOST likely cause?
Hard114A small business wants to use a CRM system. They need to access it from mobile devices and desktops without installing software. Which deployment model fits?
Hard115Which of the following is the primary purpose of hashing a password before storing it in a database?
Medium116A gaming enthusiast is building a new PC. They want to install a dedicated graphics card, a network interface card, and a sound card. Which type of expansion slot on the motherboard should these cards be inserted into?
Hard117Which of the following is a characteristic of open-source software?
Easy118A user is editing a document in a word processor and wants to save a copy in a format that preserves the exact layout and is universally viewable without requiring the original editing software. Which file format should the user choose?
Easy119A developer is writing a program that processes whole numbers only. Which data type should be used?
Hard120In a relational database, which constraint ensures that a foreign key value matches an existing primary key value in the referenced table?
Medium121Which of the following is an example of system software?
Easy122Which of the following best describes the role of an operating system?
Easy123An IT technician is configuring a new employee's laptop. The employee will handle payroll data and must access the payroll application from home. The company requires that the connection be encrypted and that the employee's device prove its identity before access is granted. Which technology BEST meets these requirements?
Medium124A software developer needs to track changes to source code over time. Which type of software should they use?
Easy125A user wants to upgrade their computer's RAM for better performance. Which of the following are characteristics of DDR4 and DDR5 RAM? (Select THREE).
Medium126Which TWO of the following are types of system software? (Select two.)
Medium127A database administrator is designing a normalized database. Which TWO are benefits of normalization?
Medium128A technician is comparing storage technologies for a new workstation that will run a database with frequent random reads and writes. The technician needs a storage device with no moving parts, low latency, and high durability. Which of the following should the technician choose?
Medium129An administrator reviews a server's audit log and finds a long series of failed login attempts against many different usernames, all originating from a single external address within a few minutes. No attempt succeeded. Which term BEST describes this activity?
Hard130A small office wants to prevent unauthorized individuals from connecting to its wireless network. The office manager enables WPA3-Personal and configures a pre-shared key. Which additional step BEST reduces the risk of unauthorized access?
Easy131A company's backup strategy requires three copies of data, on two different media types, with one copy offsite. Which backup rule does this follow?
Hard132Which TWO of the following are valid SQL functions used to aggregate data?
Medium133A company is developing a security policy. Which THREE of the following are examples of physical security controls?
Hard134A software company uses a development model where work is divided into 2-week sprints. Each sprint begins with a planning meeting, includes daily standups, and ends with a review and retrospective. A product owner prioritizes features, and a scrum master facilitates the process. Which methodology is being used?
Medium135A database administrator is designing a table to store employee records. She needs to ensure that no two employees can have the same employee number, and that the employee number is never left blank. Which combination of constraints should she apply to the employee number column?
Medium136A user reports that when they try to open a PDF file attached to an email, nothing happens. Which of the following is the most likely cause?
Easy137Which file extension typically indicates a compressed archive in Windows?
Easy138A user is selecting a software license for a new application. The user wants to use the software for any purpose, modify it, and redistribute modified versions, but also wants to ensure that any redistributed modified versions remain under the same license. Which type of license best fits these requirements?
Medium139A developer is troubleshooting an issue where a user can list the files in a shared folder but cannot download any of them. Based on the exhibit, what is the most likely cause?
Hard140Which of the following BEST describes the primary function of an operating system?
Medium141A user reports that their desktop computer takes a long time to start up and frequently freezes. A technician suspects the storage drive is failing. Which of the following steps should the technician take FIRST to diagnose the issue?
Easy142A user's workstation has become slow and shows unexpected pop-up windows even when no browser is open. A technician suspects malware and wants to reduce the risk of further compromise while investigating. Which TWO actions should the technician take FIRST? (Choose two.)
Medium143A developer writes a Python script that processes user input. During execution, the script prompts for an age and stores it in a variable. Which data type is most appropriate for the variable that stores the age?
Hard144A mobile app developer wants to integrate weather data into an app. The developer uses an HTTP request to a web service that returns JSON data. The web service requires an API key in the request header for authentication. What is this web service an example of?
Medium145What is the primary purpose of a network firewall?
Easy146Which of the following software categories includes applications like Microsoft Teams and Slack?
Easy147Based on the exhibit, which of the following is the purpose of the DNS server address?
Medium148A technician is reviewing how a computer processes a single machine instruction. The instruction cycle begins when the CPU fetches an instruction from memory whose address is held in a specific register. The technician must identify the register that stores the memory address of the next instruction to be executed. Which of the following is that register?
Medium149A user wants to upgrade their desktop's storage from a traditional hard drive to a faster drive that connects directly to the motherboard without cables. Which storage interface should they choose?
Medium150A developer is debugging a program that unexpectedly crashes. Which TWO tools or techniques are commonly used to identify the cause of the crash? (Select the two correct answers.)
Medium151Which of the following are phases in the software development lifecycle (SDLC)?
Hard152A small office has five computers that need to share files and a printer. Which type of network should be set up?
Easy153A system administrator configures a server to run multiple virtual machines for testing. Which type of software enables this?
Hard154Refer to the exhibit. A security auditor reviews this application configuration. What is the most significant security concern?
Hard155Which TWO of the following are key characteristics of a NoSQL database compared to a traditional relational database?
Easy156Which TWO of the following are examples of multi-factor authentication?
Easy157A small business office has a network where each device is connected to a central switch. If the switch fails, all devices lose connectivity. Which network topology does this describe?
Hard158A 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?
Medium159A company wants to ensure that data transmitted between its web server and clients is encrypted. Which protocol should be used?
Hard160A memory address is displayed as 0x1A3F. What is the correct base of this representation?
Hard161Which of the following is the strongest password?
Easy162A small design studio needs a central device so five wired workstations and two networked printers can exchange data with each other on the same local network. The studio does not need any routing between separate networks. Which device is the best choice?
Medium163A 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?
Medium164An organization requires employees to use a password and a one-time code sent to their mobile phone when logging into the network. Which security principle is being implemented?
Medium165Which coding best practice improves code readability and maintainability?
Medium166A company stores customer data in a flat file. Which of the following is a disadvantage of using a flat file compared to a relational database?
Medium167A user is compiling a report and needs to combine text, a chart, and a table from three separate files into one document while preserving the original formatting of each element. Which productivity application feature is designed for this task?
Medium168An IT professional is explaining to a client the difference between an HDD and an SSD. Which statement best describes a key advantage of an SSD over an HDD?
Medium169A technician is upgrading a desktop computer's memory. Which component would the technician most likely replace to improve system performance using dual-channel architecture?
Easy170A user's home wireless network is experiencing interference. Which frequency band is more prone to interference from devices like microwaves and cordless phones?
Medium171Based on the exhibit, which device is the default gateway?
Easy172A technician is configuring a Windows workstation for a finance employee. The employee needs to read and update customer records but should not be able to change the folder's permissions or take ownership. Which NTFS permission should the technician assign?
Medium173A company is virtualizing several physical servers onto one host. The administrator wants to isolate each virtual machine so that a crash or resource spike in one does not affect the others, while still sharing the physical CPU and memory. Which technology should the administrator rely on?
Hard174A user is setting up a new smartphone and wants to protect the data on it in case the device is lost or stolen. The user wants to ensure that if the phone falls into the wrong hands, the data cannot be easily accessed. Which of the following should the user enable FIRST?
Easy175A technician must install a critical security update on 150 Windows 11 computers overnight without visiting each desk. The update is distributed as an .msi package, and the organization already uses Active Directory Domain Services. Which method should the technician use?
Hard176A database administrator needs to perform CRUD operations on a table. Which TWO SQL statements are used for the 'Create' and 'Read' operations? (Select TWO.)
Medium177A user is trying to print but receives the error shown in the exhibit. Which of the following is the MOST likely cause?
Easy178A developer needs to store a list of employee names. Which data structure is most appropriate?
Easy179Which of the following Wi-Fi standards operates on the 5 GHz band and provides the fastest theoretical speeds?
Medium180A developer is creating a program that must respond to user actions such as button clicks and mouse movements. Which programming paradigm is most suitable?
Easy181Which of the following storage interfaces provides the fastest data transfer speeds?
Easy182A user wants to store 100 high-resolution photos. Which unit of measurement is MOST appropriate for the total file size?
Medium183A user wants to securely access company resources from a remote location over the internet. Which technology should be used?
Easy184Which of the following correctly declares a variable to store a person's age in Python?
Easy185A software development team is adopting an Agile methodology. Which of the following are characteristics of Agile? (Choose three.)
Medium186A 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?
Hard187A company is considering moving its email system to the cloud and wants to avoid managing the underlying servers and software. Which cloud service model would best suit this need?
Medium188A network engineer is configuring a device and needs to enter a MAC address. Which notational system is typically used for MAC addresses?
Hard189A 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?
Medium190A user receives an error message 'Insufficient memory' when trying to open a large file. Which of the following is the MOST likely cause?
Hard191Which of the following best describes the purpose of a REST API?
Easy192A developer writes an UPDATE statement to change the price of a product but accidentally omits the WHERE clause. What is the most likely outcome?
Hard193A system administrator is reviewing a configuration for a scalable application. The configuration specifies a policy that triggers when the average CPU utilization exceeds 80% for a sustained period. Currently, there are 3 servers and the CPU usage is 85%. What should happen next?
Hard194Which TWO of the following are characteristics of object-oriented programming (OOP)?
Hard195Which TWO of the following are examples of security software? (Choose TWO.)
Easy196A user receives an email that appears to be from their bank, asking them to click a link and verify their account details. The email contains urgent language and threats of account closure. What type of attack is this?
Medium197A development team is adopting Scrum. Which TWO roles are defined in the Scrum framework? (Select the two correct answers.)
Medium198A user reports that their smartphone battery drains quickly and the device feels warm. The user recently installed several apps. Which built-in smartphone feature can help identify the cause?
Medium199A user wants to synchronize contacts, calendars, and photos between their Android smartphone and tablet. Which of the following methods would best accomplish this?
Medium200Which TWO of the following are commonly considered business productivity software? (Select TWO.)
Medium201A database transaction that updates two accounts fails halfway due to a power outage. Which ACID property ensures that partial changes are undone?
Hard202A user installs an open-source image editor on a personal laptop. The software is distributed with source code, and the user is allowed to modify and redistribute it under the same license terms. Which licensing characteristic best describes this software?
Medium203A software company is using version control for a project. A developer has completed work on a new feature in a separate branch and wants to merge it into the main branch. What TWO steps should typically occur before the merge is accepted?
Hard204A ticket system logs a row for every check-in scan at an event gate, capturing the timestamp, gate identifier, and badge number. Staff want a quick daily count of scans per gate. Which statement about this data is most accurate?
Hard205A database administrator notices that queries on a large table are taking too long to execute. Which action would most likely improve performance?
Medium206An organization issues smartphones to employees and needs to enforce security policies such as remote wipe and mandatory encryption. Which technology should be used to manage these devices centrally?
Medium207A user reports that their laptop battery drains quickly even when the device is plugged into a wall outlet. The technician notices the charging LED is off and the battery percentage slowly decreases. Which component is most likely faulty?
Easy208Which of the following is a characteristic of a NoSQL database compared to a relational database?
Medium209A software development team is adopting agile practices. Which TWO of the following are common characteristics of agile methodologies? (Select TWO.)
Medium210Which THREE of the following are characteristics of a solid-state drive (SSD) compared to a traditional hard disk drive (HDD)?
Hard211A 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?
Hard212A user receives an email that appears to be from their bank, asking them to click a link and verify their account. The email contains urgent language and a generic greeting. Which type of security threat is this?
Medium213A developer is planning a new project that has very clear and fixed requirements. The project must be completed in a linear fashion with each phase finished before moving to the next. Which development methodology should be used?
Easy214A company is setting up a new office and needs to connect multiple computers within the same building to share files and printers. Which type of network should they implement?
Medium215Which element of the CIA triad is primarily concerned with ensuring that data is not accessed by unauthorized individuals?
Easy216Which of the following is a characteristic of a worm in the context of malware?
Easy217Which THREE of the following are common types of network topologies? (Choose three.)
Hard218A company is choosing a storage solution for archival data that is rarely accessed. Which TWO characteristics are typically true of HDDs compared to SSDs? (Choose two.)
Medium219Which of the following best describes a NoSQL database?
Easy220A user wants to upgrade their desktop computer's storage for faster boot times. Which of the following storage interfaces would provide the fastest performance?
Easy221A 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?
Easy222A help desk technician must remove a program from a Windows 11 workstation because the user no longer has a license for it. The technician wants to use the graphical interface rather than command-line tools. Where should the technician go to uninstall the application?
Medium223A network administrator is designing a new office network. Which THREE factors should be considered when choosing between 2.4 GHz and 5 GHz Wi-Fi bands?
Hard224A developer writes code in Python and runs it without compiling. This is an example of which type of language?
Medium225A technician is helping a small office set up basic physical security for its server closet. Which TWO of the following are physical security controls that would protect the equipment in the closet? (Choose two.)
Medium226An IT administrator is configuring a virtualized environment on a single server. The administrator needs to allocate resources to multiple virtual machines. Which THREE of the following are resources that can be allocated to a VM? (Select THREE.)
Hard227An IT administrator needs to deploy a new application to 50 company-owned smartphones. The devices are managed by a central console that can enforce policies, install apps, and wipe data remotely. Which technology is being used?
Hard228Which TWO of the following are examples of system software?
Medium229A user reports that their desktop computer powers on, the fans spin, but the monitor shows no signal and there are no beep codes. A technician notices the monitor's cable is connected to a port on the motherboard, but the computer has a dedicated graphics card installed. Which of the following is the MOST likely explanation?
Easy230A company wants to prevent unauthorized physical access to its server room. Which control is best?
Easy231A user wants to connect a laptop to a corporate wireless network. What internal component must be present in the laptop?
Easy232A small office wants to prevent unauthorized people from connecting to its wireless network while still allowing visitors to use Wi-Fi. The office manager enables WPA3-Personal on the access point. Which requirement does this configuration satisfy?
Easy233An IT technician is setting up a virtualized server environment. The server will host multiple virtual machines for different departments. Which type of hypervisor should the technician install directly on the server hardware to maximize performance and resource efficiency?
Hard234Refer to the exhibit. Which of the following components would be used to physically connect the desktop computer to the network?
Easy235A programmer writes code to run a block of instructions repeatedly until a condition is met. Which programming concept is being used?
Medium236A 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?
Medium237An IT administrator needs to deploy a virtual machine (VM) on a server that will host multiple operating systems. The administrator wants the VM to have dedicated resources and minimal overhead. Which type of hypervisor should be installed on the server?
Hard238Which TWO of the following are core phases of the Software Development Life Cycle (SDLC)?
Easy239A company stores product data in a MongoDB database. Each product document contains fields like 'name', 'price', and 'tags' (an array). What type of NoSQL database is MongoDB?
Hard240An organization uses a security model where users are granted the minimum permissions necessary to perform their job functions. This model is known as:
Hard241A programmer writes a recursive function to compute the factorial of a number. When the function is called with a large positive integer, the program terminates unexpectedly with an error indicating that the maximum call depth was exceeded. The base case is correct and the recursion does eventually reach it for small inputs. Which statement best explains the failure?
Hard242A 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?
Easy243Which TWO of the following are best practices for creating and managing passwords?
Easy244An 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?
Hard245A user is creating a new password for an online banking account. The bank requires a minimum of 12 characters and recommends using a passphrase. Which of the following passwords BEST follows current security best practices?
Easy246A company decides to deploy a new accounting application. The vendor offers a subscription model where users pay monthly. This is an example of:
Medium247Which of the following describes a nibble?
Easy248A technician is configuring a new workstation for video editing. Which of the following expansion cards would be MOST beneficial for improving video rendering performance?
Medium249Refer to the exhibit. A technician is investigating a computer that randomly restarts. Based on the log, what should the technician check?
Medium250A technician is troubleshooting a network issue and needs to view the MAC address of a device. Which notational system is the MAC address most likely represented in?
Medium251A new employee at a software company receives a laptop and must follow the organization's security policy when choosing credentials and handling them day to day. Which TWO of the following practices align with standard authentication security guidance? (Choose two.)
Medium252A programmer writes a script that automates the backup of files every night. Which type of programming paradigm is this script likely using?
Medium253A user cannot connect to the internet. The network uses DHCP. Based on the exhibit, what is the most likely cause?
Medium254A database administrator needs to ensure that a transaction either completes fully or not at all. Which property of database transactions is this?
Medium255An employee at a marketing agency connects a personal smartphone to the corporate guest Wi-Fi to check social media. The phone has no screen lock and runs an outdated operating system. The IT administrator is concerned this device could serve as an entry point into the corporate network. Which term BEST describes the risk introduced by this device?
Medium256A quality assurance team is executing system testing on a new banking application. They need to verify that the entire application works correctly from start to finish. Which THREE of the following testing types would be included in system testing?
Hard257During debugging, a developer sets a breakpoint and steps through the code line by line. Which debugging tool feature is being used to execute one line of code at a time?
Hard258Which of the following is the decimal equivalent of the binary number 1101?
Easy259A user's laptop has a SATA SSD, and they want to upgrade to a faster storage solution. Which interface technology would provide the most significant performance improvement?
Medium260A home user wants to add a second monitor to a desktop PC that already uses its HDMI port for the primary display. The PC has a free DisplayPort connector on the graphics card. Which cable should the user connect from the new monitor to the PC?
Easy261A project has frequent requirement changes and the team needs to deliver working software in short cycles. Which software development methodology is most appropriate?
Hard262Which TWO of the following are benefits of using virtual machines? (Choose two.)
Medium263A user wants to install a free text editor on their Windows computer. Which file extension is most likely used for the installer?
Easy264A company uses a software license that allows anyone to view, modify, and distribute the source code, provided that any distributed modifications are also made available under the same license. Which type of license is this?
Medium265A company wants to run a Linux virtual machine on a Windows host without dual-booting. Which type of software is needed to create and manage the virtual machine?
Hard266A user reports that a database-backed inventory application is extremely slow when generating monthly reports, but normal data entry remains responsive. The technician observes that the report queries scan entire tables and that adding an index on the date column dramatically reduces report time. Which software concept explains why the index improved performance?
Hard267A developer creates a new branch in a version control system to work on a new feature. After completing the feature, the developer wants to combine the changes from the feature branch back into the main branch. What is this process called?
Easy268Which of the following is an example of an absolute file path?
Medium269Which of the following devices is used to connect multiple computers in a local area network and forwards data based on MAC addresses?
Easy270A development team is building a new mobile app. The project has a fixed budget and scope, and the requirements are well-understood from the start. Which software development methodology would be most appropriate for this project?
Easy271A user is setting up a new smartphone for work and wants to reduce the risk of unauthorized access if the device is lost. Which two measures should the user implement? (Choose two.)
Medium272A help desk technician is creating a spreadsheet to track support tickets. They want each ticket to have a unique identifier that is automatically generated when a new row is added, and they want the value to never repeat even if rows are deleted. Which spreadsheet feature should they use?
Easy273Which tool is commonly used for automated testing in software development?
Easy274Which TWO of the following are characteristics of ransomware?
Medium275Which THREE of the following are effective methods to protect against malware infections? (Select THREE.)
Hard276A 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?
Hard277An employee calls the help desk claiming to be a manager from another department and requests a password reset. This is an example of which social engineering technique?
Hard278Match each operating system to its common environment.
Medium279A company uses a relational database with a 'Customers' table and an 'Orders' table. Each order must be linked to exactly one customer. Which type of relationship exists between Customers and Orders?
Medium280Which THREE of the following are components typically found inside a CPU?
Hard281Which THREE of the following are best practices for password security?
Medium282A database administrator needs to perform CRUD operations on a database. Which THREE SQL commands correspond to the 'Create', 'Read', and 'Update' operations?
Hard283A user is experiencing slow Wi-Fi performance at home. The router supports both 2.4GHz and 5GHz bands. Which frequency band would provide faster speeds but shorter range?
Medium284A 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?
Easy285Which of the following best describes the difference between a compiler and an interpreter?
Easy286A 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?
Easy287A software team is choosing a version control workflow. They want developers to work on features without disturbing the stable main branch, and they want a clear mechanism to propose and review changes before those changes become part of the main codebase. Which version control concept best fits this need?
Medium288Which TWO of the following are common causes of errors when executing a SELECT query? (Choose two.)
Hard289A user is setting up a new Windows 11 laptop and wants to ensure that files in the Documents folder are regularly backed up to the cloud automatically. Which built-in Windows feature should the user configure?
Easy290Which software license allows a user to install the software on multiple computers for personal use?
Easy291Refer to the exhibit. A user executes: SELECT AVG(Salary) FROM Employees; What is the result?
Easy292A database must be restored to the exact state at 11:00 AM. The last full backup was at 10:00 PM previous day, and transaction log backups were taken every hour. What is the minimum to restore?
Medium293Which of the following is an example of an output device?
Easy294Which THREE of the following are valid SQL statements?
Hard295Which of the following best describes the 'Confidentiality' component of the CIA triad?
Easy296A company uses a web-based application that runs in a browser and stores data on a remote server. Which of the following best describes this type of application?
Medium297A company wants to deploy a new wireless standard that offers higher throughput and better performance in dense environments. Which Wi-Fi standard should they choose?
Medium298A technician is setting up a virtualized environment on a laptop to run multiple operating systems for testing. Which type of hypervisor is most appropriate?
Hard299A developer is working on a new feature and creates a copy of the main codebase to work in isolation. Later, this copy is merged back into the main branch. Which version control concept describes this copy?
Medium300Which of the following best describes the principle of least privilege?
Easy301A company is evaluating different software licenses for a new project. Which THREE of the following are characteristics of open-source licenses such as the MIT License or Apache License? (Select THREE.)
Hard302A home user has a laptop with an integrated webcam that no longer works after a recent driver update. The user needs a quick, low-cost replacement for video calls. Which of the following should the technician recommend?
Easy303A database designer is creating a table to store employee information. To ensure that each employee can be uniquely identified, which constraint should be applied?
Medium304Which type of malware is disguised as legitimate software but performs malicious actions?
Medium305A database administrator adds an index on the 'Email' column of a 'Users' table. What is a likely consequence?
Medium306A team is choosing a version control workflow for a project with multiple developers. They want changes to be tracked, reviewed, and integrated safely. Which TWO practices are characteristic of using a distributed version control system such as Git? (Choose two.)
Medium307A user notices that their computer runs slowly when multiple applications are open simultaneously. Which hardware component is most likely insufficient for the current workload?
Medium308Which programming data type would be used to store a value of 'True' or 'False'?
Medium309A query uses a LEFT JOIN between Customers and Orders. The result set includes customers with no orders. What does the Orders columns show for those customers?
Hard310A user is creating a report that includes several photographs. After saving, the file size is larger than expected. Which data type is primarily responsible?
Easy311A small business uses a single Linux server to host a custom inventory management application written in Python. The application reads from a CSV file on the server to display current stock levels. Recently, users have reported that the inventory numbers are incorrect and sometimes the application crashes with a 'Permission denied' error when trying to save updates. The server has two user accounts: 'admin' (with sudo privileges) and 'app_user' (a standard user under which the application runs). The CSV file is located at /var/data/inventory.csv and currently has permissions -rw-rw---- and owner root:root. The application code uses the open() function to read and write the file. Which of the following actions should be taken to resolve the issue?
Easy312Refer to the exhibit. A user reports that a recent Windows update failed to install. Which action should the technician take FIRST?
Hard313A user complains that their smartphone photos take up too much space and that image quality is critical for printing. A technician explains that a particular image format uses lossy compression, which reduces file size by permanently discarding some image data. Which of the following formats is the technician describing?
Easy314Based on the exhibit, which of the following best describes the file type?
Easy315Which TWO of the following are examples of social engineering attacks?
Medium316A user reports that their computer is unable to access the internet, but can access local network resources. Which of the following is the most likely cause?
Medium317Which of the following is the binary representation of the decimal number 10?
Easy318A user reports that their desktop computer will not power on at all. No lights appear, and no fans spin. The power cable is securely connected to the wall outlet and the power supply. Which component should the technician check first?
Easy319A user is setting up a new wireless router at home. During configuration, they see options for Wi-Fi 5 (802.11ac) and Wi-Fi 6 (802.11ax). Which standard offers faster speeds and better performance in congested environments?
Easy320Consider the following algorithm: SET x = 5 SET y = 2 SET result = x ^ y OUTPUT result Assuming '^' is the exponentiation operator, what is the output?
Hard321Drag and drop the steps to connect a Bluetooth device to a Windows 10 computer into the correct order.
Medium322A user wants to purchase a new monitor for gaming. Which THREE specifications are most important for a smooth gaming experience?
Hard323A technician is recommending a device to protect a server from data loss during a power outage. Which device should the technician recommend?
Hard324A small business keeps its customer list in a single spreadsheet where the customer's city and state are typed into every invoice row. The owner wants a structure that stores each customer's address once and references it from many invoices without duplicating the address text. Which database concept should the owner apply?
Easy325A small business wants to store customer contact information and order history. The data is structured and relationships between customers and orders must be enforced. Which type of database is most appropriate?
Easy326A user reports that their printer is not working. The printer is connected via USB to a workstation, and other users can print to the same printer over the network. Which of the following should the technician check FIRST?
Medium327A user wants to synchronize files across multiple devices, including an iPhone, a Windows laptop, and an Android tablet. Which TWO cloud services would be most effective for this cross-platform syncing?
Easy328An employee is working from a coffee shop and needs to access company files. Which of the following is the most secure method?
Medium329A database administrator needs to choose a database for an e-commerce application that requires high availability and automatic scaling. Which TWO options are cloud database services?
Medium330Which of the following best describes the function of a web API?
Hard331A security analyst is reviewing access logs and notices that an employee in the marketing department was able to read files in the human resources shared folder. The employee's account should only have access to marketing resources. Which security principle was violated?
Hard332A bookstore owner wants to list all book titles stored in a table named Inventory, sorted alphabetically by title. Which SQL statement should be used?
Easy333A junior developer needs to create a simple program that adds two numbers and displays the result. Which programming paradigm is most suitable for this task?
Easy334What is the difference between a threat and a vulnerability?
Easy335A technician needs to set up a small office network with 15 computers. The computers should be able to communicate with each other and share a single internet connection. Which device is required to enable internet sharing?
Easy336A development team is using an agile methodology. Which TWO of the following are typical practices in agile development?
Medium337A junior developer is writing a program that must repeatedly ask the user for a password until the correct password is entered. The developer needs a programming construct that will keep running the same block of code while a condition remains true. Which programming concept should the developer use?
Easy338Which type of malware replicates itself across a network without user interaction?
Hard339A small business has a single server running Windows Server 2019 that acts as a domain controller, file server, and DHCP server. The server has a single network interface with IP address 192.168.1.10/24. The office has 30 client computers running Windows 10. All clients obtain IP addresses automatically. The network uses a single unmanaged switch. The internet connection is provided by a cable modem with IP 192.168.1.1. The server is configured with a static IP of 192.168.1.10, and the DHCP scope is 192.168.1.100-192.168.1.200. Recently, users have reported that they cannot access the internet. The technician checks that the cable modem is online and that the server can ping the modem. The technician runs 'ipconfig /all' on a client and sees: IP: 192.168.1.101, Subnet: 255.255.255.0, Default Gateway: 192.168.1.10, DNS: 192.168.1.10. The client can ping the server (192.168.1.10) but cannot ping the modem (192.168.1.1). What is the most likely cause?
Hard340A user reports that their laptop cannot connect to the corporate Wi-Fi network. Other users in the same area are connected without issues. The laptop shows it is connected to the Wi-Fi but has no internet access. Which of the following is the MOST likely cause?
Medium341A technician is troubleshooting a computer that fails to boot. The technician suspects corrupted firmware. Which component stores the firmware that initializes hardware during boot?
Hard342A user is choosing a backup strategy for a laptop that contains important documents. The user wants copies of files stored in a second location and wants to be able to restore an earlier version of a file that was accidentally modified. Which TWO actions should the user perform? (Choose two.)
Medium343A user is creating an account on a shopping website and is asked to choose a password. Which of the following passwords BEST follows current security guidance for resisting brute-force and dictionary attacks?
Medium344Which TWO of the following are advantages of server virtualization? (Select TWO.)
Easy345A user complains that their laptop battery drains quickly even when the laptop is idle. A technician suspects that a background process is consuming resources. Which of the following Windows tools should the technician use to identify the process consuming the most CPU or disk resources?
Medium346Which device converts the signal from an ISP into a digital signal that a computer can use?
Medium347A small business owner installs a wireless access point in a coffee shop for customers. The owner wants to prevent strangers outside the building from reading the wireless traffic of paying customers. Which security feature should be enabled on the access point?
Easy348A junior programmer is reviewing a piece of pseudocode written by a teammate. The pseudocode contains the line: total = total + item. The programmer wants to know what type of operation this line performs in the algorithm. Which of the following best describes this line?
Medium349What is the binary representation of the decimal number 10?
Easy350A small business owner wants to let visitors use the office Wi-Fi without giving them access to the company's file server or networked printers. Which of the following is the BEST way to accomplish this?
Easy351Which TWO of the following are types of optical disc storage? (Select exactly two.)
Easy352A programmer writes a loop that performs a bitwise AND operation between the byte 0b11001100 and the mask 0b00001111. What is the result in decimal?
Hard353A technician is explaining data representation to a trainee. Which TWO of the following are character encoding standards used in computing? (Select TWO).
Medium354A software development team is using Scrum. During a sprint, the product owner introduces a new high-priority requirement that was not in the sprint backlog. The team has already committed to the current sprint's goals. According to Scrum principles, what should the team do?
Hard355Which of the following is a benefit of using a database instead of a flat file?
Easy356A technician is configuring a small office network with 15 computers. The computers need to share files and a printer. The technician decides to use a topology where each computer is connected to a central device. Which physical topology is being implemented?
Hard357A user's web browser displays a warning that the connection to an online store is not private because the site's certificate cannot be validated. The user asks a technician what the warning means. Which explanation is MOST accurate?
Medium358Refer to the exhibit. A user can ping 192.168.1.1 but cannot ping 8.8.8.8. What is most likely the issue?
Easy359A company is planning to adopt cloud computing. Which THREE of the following are benefits of using cloud services compared to on-premises infrastructure? (Select THREE).
Hard360Based on the exhibit, which device is directly responsible for separating traffic into VLAN10 and VLAN20?
Hard361A user wants to create a presentation with slides, animations, and speaker notes. Which application type should they use?
Easy362A digital image is stored in a file that retains all original data without any loss. Later, the file is compressed using a technique that discards some data to reduce file size, but the image quality is lower. Which type of compression was applied?
Medium363Which of the following best describes the function of an operating system?
Medium364A developer wants to install a Linux application on a system that uses the Debian package manager. Which package format should the developer look for?
Hard365A user is concerned about losing edits to a document if the power fails. Which type of memory is the document most likely stored in while being edited?
Medium366Which of the following is an example of a PAN (Personal Area Network) technology?
Easy367Which TWO of the following are best practices for password security?
Easy368Which TWO of the following are common types of network cables used in wired Ethernet networks?
Easy369A company needs to store customer orders and ensure that each order is uniquely identified. Which database concept should be used?
Easy370A company uses a cloud database service where the provider automatically handles backups, patching, and scaling. This deployment model is known as:
Hard371Which of the following is an example of a NoSQL database that stores data as JSON-like documents?
Medium372Which TWO concerns are most critical when selecting a backup method? (Select exactly two.)
Medium373A technician is troubleshooting a computer that fails to boot. The technician checks the system's low-level software stored on a chip on the motherboard. Which type of software is being inspected?
Medium374A technician is setting up a new computer on a network. The computer receives an IP address of 169.254.1.5. Which of the following is the most likely issue?
Hard375Which of the following is an example of a strong password?
Easy376A development team is building a web application and wants to adopt a version control system to manage code changes across multiple contributors. Which TWO of the following are primary benefits of using a version control system in this scenario? (Choose two.)
Medium377Which TWO of the following are characteristics of a relational database? (Select TWO.)
Medium378A company is deciding between two software delivery models. Model X requires a formal sign-off after each phase before the next begins, while Model Y delivers working software in short iterations with continuous customer feedback. Which model is Model Y?
Medium379A help desk technician is reviewing security practices with a new employee who works remotely. Which TWO of the following actions BEST reduce the risk of a malware infection on the employee's workstation? (Choose two.)
Hard380Drag and drop the steps to check for Windows Updates in Windows 10 into the correct order.
Medium381A database designer wants to ensure that no two employees have the same email address. Which constraint should be applied to the Email column?
Easy382A company wants to deploy a custom internal application to all employees' Windows computers. The application requires administrative privileges to install and must be updated frequently. Which deployment method should the IT team use to ensure consistent installation and easy updates?
Medium383Which principle ensures that data is not modified by unauthorized users?
Easy384In a relational database, which type of relationship is typically implemented by creating a third table (junction table) that contains foreign keys from both related tables?
Medium385A technician is asked to dispose of several old hard drives that contain sensitive company data. The technician wants to ensure that the data cannot be recovered by anyone who obtains the drives. Which of the following methods is the MOST secure?
Easy386A company wants to ensure that data is not lost if a hard drive fails. Which of the following best practices should be implemented?
Easy387A user receives a file with the extension .exe from an unknown sender. Before running it, the user wants to verify whether the file is safe. Which action best helps the user evaluate the risk?
Medium388A small real estate office with 12 employees has been using the same network setup for five years. Employees use both company-issued laptops and personal smartphones to access email and client listings. Last week, an employee clicked a link in a phishing email, which led to a ransomware infection on the company file server. The server was encrypted, and the attackers demanded a ransom. The office had no backups; all client data and contracts were lost. The office manager wants to prevent such incidents in the future. Which of the following should be the FIRST security measure implemented, considering the root cause of the breach?
Hard389Which THREE are common steps in troubleshooting software issues?
Hard390A company wants to use a cloud service where they can deploy their own applications on virtual machines without managing the underlying hardware. Which cloud service model best fits this requirement?
Medium391A hospital stores patient records in a relational database. Administrators need to record that a patient can have multiple allergies, and each allergy may affect multiple patients. Which type of relationship exists between patients and allergies, and how is it implemented?
Hard392Which TWO of the following are advantages of using a relational database over a NoSQL database? (Choose two.)
Easy393A small business uses a legacy desktop application for inventory management. The application was designed for Windows 7 and has not been updated. The company recently upgraded its workstations to Windows 10. Now, when employees try to run the inventory application, it either crashes immediately or displays errors about missing components. The company relies on this application daily and cannot afford downtime. The IT administrator has tried running the application in compatibility mode for Windows 7, but the crashes persist. There is no alternative application available, and the vendor is out of business. Which of the following is the BEST course of action to allow the business to continue using this application?
Hard394A technician needs to verify that a twisted-pair Ethernet cable is wired correctly and has no breaks. Which tool should be used?
Easy395A user reports that the company's customer relationship management (CRM) application is slow after a recent network upgrade. What could be the cause?
Medium396A software developer is building an application that needs to store user profiles with varying attributes, such as some users having multiple phone numbers and others having none. The developer wants a flexible schema that allows different users to have different sets of fields without altering the database structure. Which type of database is best suited for this requirement?
Medium397A user is shopping for a laptop and wants to know how much data the machine can hold for documents, photos, and applications. Which specification should the user check to determine the total storage capacity of the system?
Easy398A user wants to upgrade their desktop computer's RAM for better performance. The motherboard supports dual-channel memory. Which configuration will provide the best performance?
Medium399A user asks a technician why their spreadsheet file opens much faster after being saved in a different format. The technician explains that the new format stores data in a structured, compressed way. Which of the following best describes the primary purpose of a file format?
Easy400A user needs to run a Windows application on a Mac. Which approach uses a hypervisor to create a separate environment?
Medium401A software developer writes code that stores sensitive user data. To comply with data protection regulations, which application-level security measure should be implemented?
Hard402A company wants to implement the principle of least privilege for its employees. Which TWO of the following actions align with this principle? (Choose TWO.)
Medium403A university database includes a table named 'Students' and a table named 'Enrollments'. The 'Enrollments' table has a foreign key column 'StudentID' that references the 'StudentID' primary key in the 'Students' table. The university policy requires that when a student withdraws (i.e., their record is deleted from the 'Students' table), all of their associated enrollment records must be automatically removed to maintain data consistency. The database administrator wants to enforce this rule at the database level. Which referential action should be applied when creating the foreign key constraint on the 'Enrollments' table?
Hard404What is the decimal equivalent of the binary number 1101?
Easy405A technician is comparing two internal storage devices for a workstation that must boot quickly and survive being dropped during transport. One candidate uses flash memory with no moving parts, while the other uses spinning magnetic platters. Which statement correctly describes the trade-off the technician should consider?
Hard406A user is troubleshooting an issue with a web application that is only accessible through a browser. The user notes that the application runs slowly. Which component is most likely responsible for processing the application's server-side logic?
Medium407A small business is expanding and needs to ensure their network infrastructure supports growth. Which THREE practices should they implement?
Hard408A spreadsheet user needs to display the text from cell A2 in all uppercase letters in cell B2, without altering the original value in A2. Which function should be entered in B2?
Medium409A technician is troubleshooting a computer that does not start. They suspect the BIOS may be corrupted. Which type of software is the BIOS?
Hard410A user needs to retrieve only the 'ProductName' and 'Price' columns from a table named 'Products' where the 'Category' is 'Electronics'. Which SQL statement should the user execute?
Easy411A software application is experiencing performance degradation. The team suspects a memory leak. Which development practice should be used to identify the source of the leak?
Hard412A database analyst is designing a schema for a library system. Each book can have multiple authors, and each author can write multiple books. Which relationship type should be used?
Hard413Which of the following is an example of lossy compression?
Medium414A company wants to deploy a custom application to 500 employees. The IT team needs to ensure each workstation has the same version and configuration. Which deployment method should be used?
Hard415Which of the following is an example of application software?
Easy416Two developers have edited the same file and created different versions. To integrate their changes, which Git operation should they perform?
Hard417A company is implementing a backup strategy. Which of the following best adheres to the 3-2-1 backup rule?
Hard418A team of developers is working on a large project with multiple features. They use a version control system. One developer creates a new branch to develop a feature, while other developers continue working on the main branch. After completing the feature, the developer wants to combine the changes from the feature branch back into the main branch. What version control operation should be performed?
Hard419A student is learning to write programs and asks why a programming language uses variables. The instructor explains that a variable lets the program store a value under a name and refer to it later. Which statement best describes the role of a variable in a program?
Easy420Based on the exhibit, what will be the last value output?
Easy421A developer is designing a program to calculate an employee's weekly pay. The program must store the hourly rate, the number of hours worked, and the computed gross pay so these values can be used and updated as the calculation proceeds. Which programming concept describes these named storage locations?
Medium422Which cloud service model provides the customer with the ability to run and manage applications on a cloud infrastructure but does NOT give control over the underlying operating system?
Hard423A user receives a text message claiming to be from a package delivery service, saying a package could not be delivered and asking the user to click a link to reschedule. The user is unsure if the message is legitimate. Which TWO of the following actions should the user take to verify the message and avoid becoming a victim? (Choose two.)
Medium424Which THREE of the following are common methods for securing a wireless network?
Hard425Given the following pseudocode that calculates the average of a list of numbers, which error will occur? SET total = 0 SET count = 0 FOR EACH number IN list total = total + number count = count + 1 ENDFOR SET average = total / count OUTPUT average
Medium426A programmer needs to store a collection of key-value pairs where each key is unique and maps to a value. Which data structure is best suited for this purpose?
Medium427Which of the following is an example of an input device?
Easy428A technician needs to install a new graphics card in a desktop computer. Through which type of slot is the graphics card typically connected to the motherboard?
Medium429A developer is debugging a program that crashes with an error. Which THREE of the following are common debugging techniques?
Medium430A SELECT statement combines rows from two tables based on a related column. Which SQL clause is used to accomplish this?
Medium431A user wants to install a software package on a Linux system using a package that ends in .deb. Which Linux distribution family is most likely being used?
Easy432A user wants to connect a modern monitor to their laptop using a single cable that can carry both video and audio signals. Which port on the laptop should they use?
Easy433A company implements a policy where employees must lock their computer screen when leaving their desk. Which security principle does this practice support?
Medium434Which SQL statement is used to retrieve all columns from a table named 'Customers' where the city is 'London'?
Easy435A small business wants to set up a wireless network. Which of the following is the BEST security method to use?
Easy436Drag and drop the steps to connect a laptop to a Wi-Fi network in Windows 10 into the correct order.
Medium437In a Scrum team, who is responsible for prioritizing the product backlog and ensuring that the team works on the most valuable features first?
Medium438A company needs to ensure that all employees can collaborate on documents in real time. Which type of software should the company choose?
Medium439A network administrator is configuring a small office network with 20 computers. The network must be easy to troubleshoot and resilient to a single cable failure. Which topology should the administrator implement?
Hard440A developer is writing a script in Python that processes user input. The script needs to execute a block of code repeatedly while a condition is true. Which programming construct should the developer use?
Hard441A developer writes a query: SELECT * FROM Employees WHERE Department = 'Sales'. Which statement about this query is true?
Medium442A junior technician is documenting the internal components of a desktop workstation for an inventory audit. The supervisor asks the technician to identify components that are installed inside the system unit and connect directly to the motherboard or its expansion slots. Which TWO of the following are internal hardware components? (Choose two.)
Medium443A team is choosing a version control workflow. They want developers to work on features in isolation without affecting the stable main codebase, and then integrate changes after review. Which version control concept directly supports this isolation?
Medium444Which of the following is the best practice for backing up data according to the 3-2-1 rule?
Easy445A student is comparing storage technologies for a project. The student needs a system that stores data as key-value pairs and is designed to scale horizontally across many servers for very high read and write throughput. Which category of database best fits this requirement?
Easy446Based on the exhibit, which type of attack is most likely occurring?
Hard447A software development team follows a methodology where work is divided into fixed sequential phases: requirements, design, implementation, testing, deployment, and maintenance. Changes to requirements are difficult once a phase is completed. Which development methodology is being used?
Easy448A company is developing a mobile app and wants to ensure it works on both iOS and Android without writing separate codebases. Which approach should be used?
Medium449A technician needs to install a wireless network in a large warehouse. The goal is to minimize interference and support many devices. Which frequency band is best for this scenario?
Medium450During the software development life cycle, which phase directly follows the coding phase?
Medium451A user complains that their laptop battery drains rapidly even while plugged into a docking station that supports USB Power Delivery. The dock is connected with a cable that fits the USB-C port. Which of the following is the MOST likely cause?
Easy452A developer needs to store a collection of student names and their corresponding grades. The data should be accessed quickly by student name. Which data structure is most appropriate?
Easy453Which of the following character encodings can represent characters from virtually all written languages?
Medium454A developer is learning version control. Which THREE of the following are core Git concepts? (Select 3)
Hard455An e-commerce application experiences a data anomaly where an order is partially recorded: the order header is saved but some order line items are missing due to a system crash. Which property of database transactions is violated?
Hard456A student is converting the hexadecimal number 2F to decimal. What is the correct decimal value?
Medium457A company has a server that hosts a critical database. The server uses RAID 5 with three disks. One disk fails. What is the immediate impact on data availability?
Hard458A user needs to install a new application on a Windows 10 computer but does not have administrative privileges. The application requires writing to the Program Files directory and modifying system registry keys. What will happen when the user attempts to install the application?
Medium459Which backup strategy involves keeping three copies of data on two different media types with one copy offsite?
Medium460Which of the following is a key difference between a vulnerability and a threat in cybersecurity?
Medium461A startup is choosing a data store for a product catalog where each item may have a different set of attributes, such as a camera with lens mount and sensor size versus a book with ISBN and page count. The catalog is read far more often than it is written, and the schema is expected to change frequently. Which TWO characteristics make a document-oriented NoSQL store a suitable fit? (Choose two.)
Hard462A user is trying to access a file located at 'C:\Users\John\Documents\report.docx'. This is an example of which type of file path?
Medium463A user is selecting a web browser for everyday use. Which of the following is NOT a web browser?
Medium464Which cloud service model provides users with access to software applications over the internet without managing the underlying infrastructure?
Medium465Which of the following malware types is characterized by self-replication without needing to attach to a host file?
Medium466A software tester is verifying that individual functions within a module work correctly in isolation. Which type of testing is being performed?
Medium467A data center administrator is considering virtualization to consolidate multiple physical servers. Which of the following is the PRIMARY benefit of using virtual machines in this environment?
Hard468A user needs to retrieve all product names and prices from a table named 'Products' where the price is greater than 50. Which SQL statement should be used?
Medium469A user wants to install software on a macOS computer. Which TWO file types are commonly used as installer packages on macOS? (Select TWO.)
Medium470A technician runs the ipconfig command and observes the following output: IPv4 Address. . . . . . . . . . . : 192.168.1.10 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . : 192.168.1.1 Based on the output, which of the following can the technician conclude?
Easy471A software development team is in the process of gathering requirements from stakeholders, identifying project scope, and creating a project plan. After this phase, they will move to analyzing requirements in detail. In which phase of the SDLC is the team currently working?
Medium472Which THREE of the following are common file formats for images?
Hard473A user is unable to insert a new record into a database table because a required field is missing. Which database concept enforces that a field must have a value?
Easy474A security analyst is explaining the difference between a threat and a vulnerability. Which statement accurately describes this difference?
Hard475A developer needs to visually represent the logic of a program, including decisions (yes/no branches) and processes. Which tool should the developer use?
Easy476A company wants to ensure that sensitive documents are not readable if a laptop is stolen. Which of the following provides the best protection?
Medium477Which TWO data types are considered unstructured? (Select exactly two.)
Easy478A user needs to connect a wireless keyboard and mouse to a desktop computer. Which of the following technologies is most commonly used for this purpose?
Easy479A user is unable to open a .docx file. The user has the correct application installed. Which of the following is the MOST likely cause?
Easy480Which TWO of the following are recommended practices for physical security in an office environment? (Select two.)
Easy481A user wants to connect a Bluetooth keyboard to a tablet. What is the first step the user must perform to establish the connection?
Medium482A company wants to ensure that if one hard drive fails, no data is lost. Which RAID level should be implemented?
Medium483A junior developer is tasked with fixing a bug where a variable is unexpectedly undefined. The developer suspects the variable is not within scope. Which programming concept describes where a variable can be accessed?
Easy484Refer to the exhibit. PC1 (192.168.1.10) cannot communicate with PC2 (192.168.2.10). What is the most likely cause?
Hard485Which of the following best describes the function of a DNS server?
Easy486A user installs a productivity suite on a Windows 11 laptop. The license agreement states the software may be installed on only one computer and cannot be copied or modified. Which type of software license does this describe?
Easy487A software engineer is working on a collaborative project and needs to track changes to the source code. Which of the following tools is specifically designed for version control?
Hard488Which TWO of the following are characteristics of a client-server network?
Easy489A software development team is using a version control system to manage their codebase. They want to create an isolated copy of the main codebase to develop a new feature without affecting the main line of development. Which Git operation should they use?
Hard490Based on the exhibit, what is the most likely cause of the error?
Medium491A user installed a new photo editing application. After opening it, the user receives an error that the application cannot find a required DLL file. Which of the following is the MOST likely cause?
Easy492A user reports that their laptop's Wi-Fi connection is slow and frequently drops when they are in the living room, but works fine in the office near the router. The router supports both 2.4GHz and 5GHz bands. Which band should the user connect to for better performance in the living room?
Medium493A developer is creating a cloud-based application that needs to authenticate third-party services before allowing access to its API. The developer decides to use a method where each third-party service receives a unique key that must be included in each API request. This method is known as:
Hard494A technician needs to identify a network interface on a device. Which notational system is most commonly associated with MAC addresses?
Easy495An organization implements a security control that requires users to swipe a smart card and then enter a PIN to access a secure facility. Which combination of authentication factors does this represent?
Hard496An employee receives a phone call from someone claiming to be from the IT department. The caller states there is a security issue and requests the employee's login credentials to 'fix the problem'. What should the employee do?
Hard497Which THREE of the following are examples of multi-factor authentication? (Select three.)
Hard498A user needs to store customer information including name, address, and order history. Which database type is most appropriate?
Easy499Refer to the exhibit. The user is unable to browse the internet using domain names but can access websites by IP address. Which configuration is most likely incorrect?
Medium500Which TWO of the following are examples of popular relational database management systems (RDBMS)? (Select TWO.)
Medium501Which of the following units represents the largest amount of data?
Easy502A server has four hard drives configured in RAID 5. One drive fails. What must the technician do to restore full redundancy?
Hard503A user wants to ensure data confidentiality. Which action is most appropriate?
Easy504A help desk technician is coaching a new employee on how to recognize social engineering attempts that arrive by phone and text message rather than email. Which TWO characteristics should the technician tell the employee to treat as warning signs? (Choose two.)
Hard505Refer to the exhibit. What is the purpose of the 'no shutdown' command in this router configuration?
Medium506A web application uses a JavaScript function to validate user input on a registration form. The function checks that the password is at least 8 characters long and contains a number. When a user submits the form with a password "abc123", the validation passes even though the password has only 6 characters. The developer examines the code and finds that the function uses the condition: if (password.length >= 8 || /\d/.test(password)). Which logical error is causing this bug?
Hard507A company is choosing between public, private, and hybrid cloud deployments. Which TWO statements correctly describe characteristics of these cloud models? (Select TWO.)
Medium508An application is displaying an error message: "Cannot write to file. The file may be read-only or in use by another application." Which of the following is the LEAST likely cause?
Medium509Which TWO of the following are examples of NoSQL database types?
Medium510A small business wants to replace its on-premises email server with a service where the provider manages the servers, patching, and uptime. Employees will access email through a web browser and mobile apps. Which cloud service model is the business adopting?
Medium511During a sprint retrospective, the team identifies that too many bugs are being discovered late in the development cycle. They decide to introduce a practice where developers write tests for individual functions before coding the functions themselves. This approach is an example of:
Hard512A user wants to install a program on their Ubuntu Linux system. Which TWO file extensions are commonly used for Linux installer packages? (Select TWO.)
Medium513A technician is preparing a Windows workstation for a user who needs to run a legacy line-of-business program that requires specific runtime libraries and direct access to a hardware security key. The technician must choose installation and configuration steps that support these requirements. Which TWO actions are appropriate? (Choose two.)
Hard514A programmer writes a step-by-step description of a solution in plain English without using any specific programming language syntax. What is this description called?
Easy515Which device is used to connect multiple devices within the same network segment and forward data based on MAC addresses?
Easy516A home user wants to connect a desktop computer to the internet using a wireless connection. The computer does not have built-in Wi-Fi. What is the simplest and most cost-effective solution? The user has a wireless router already installed and working.
Easy517Which network device converts the signal from an Internet Service Provider (ISP) into a digital signal that a home network can use?
Easy518A user needs to edit a video file for a presentation. Which type of application is most suitable?
Easy519A user wants to sync their contacts and calendar between their Android phone and tablet. Which method is most commonly used?
Hard520A developer writes code in C++ and must convert it to machine code before execution. This process is called:
Hard521Which TWO of the following are examples of operating systems?
Easy522A developer is working on a collaborative software project and uses Git for version control. The developer creates a new feature on a separate branch. After completing the feature, what is the typical next step to integrate the changes into the main branch?
Hard523A company is choosing collaboration software. Which TWO of the following are examples of collaboration applications? (Select 2)
Medium524An employee working from a coffee shop connects a laptop to an open wireless network to check webmail. The employee wants to prevent other patrons on that same network from capturing the login credentials in transit. Which technology BEST provides this protection?
Easy525A small accounting firm stores client tax records on a shared network folder. The owner wants to ensure that only the three staff members who prepare taxes can open those files, while other employees can still access the general office folder. Which security concept should the owner apply to the tax records folder?
Easy526A team is testing a software application after a bug fix. They want to ensure that the fix did not introduce new bugs in previously working functionality. Which type of testing should they perform?
Medium527An IT administrator is hardening a server. Which three of the following actions should be taken to improve security? (Select THREE.)
Hard528A database administrator is normalizing a table that currently stores order details. The table has columns OrderID, ProductID, ProductName, Quantity, and UnitPrice. The administrator notices that ProductName and UnitPrice depend on ProductID, not on the combination of OrderID and ProductID. Which normal form is the table violating?
Hard529A company wants to protect against data loss if a single hard drive fails. They have three identical drives. Which RAID configuration provides fault tolerance while maximizing storage capacity?
Hard530An organization adopts the 3-2-1 backup rule. Which of the following practices aligns with this rule?
Medium531Which TWO of the following are features of productivity software?
Easy532A developer writes the following pseudocode for a process that finds the largest number in a list: SET max = first element FOR each number in list IF number > max THEN SET max = number END IF ENDFOR OUTPUT max What programming concept does this pseudocode represent?
Medium533A network administrator wants to automatically assign IP addresses to all devices on the network. Which service should be configured on the server?
Medium534An IT manager is evaluating a cloud storage service for backup of critical company data. The manager is concerned about data security and availability. The service offers encryption at rest and in transit, 99.9% uptime SLA, and geo-redundancy. However, the service uses multi-tenancy. Which of the following is a potential concern the manager should address?
Hard535A user reports that a spreadsheet application crashes whenever they try to use a specific macro. The technician needs to identify the cause. Which of the following should the technician check first?
Medium536A technician is troubleshooting a desktop computer that powers on but does not display any video. The monitor works when connected to another computer. Which TWO of the following are the most likely causes to check first? (Choose two.)
Medium537Which TWO of the following are examples of database management systems (DBMS)?
Easy538A developer is writing a program that reads a list of numbers and must repeatedly divide a running total by each number in the list. Some list entries may be zero. Which approach BEST prevents the program from crashing while still producing correct results for the non-zero entries?
Hard539A security analyst notices that a user's computer is running slowly and displaying many pop-up ads. Which type of malware is most likely causing this?
Hard540Which of the following is a characteristic of a strong password?
Easy541Refer to the exhibit. A technician sees an established connection to an external IP on port 443 from PID 3400. What is the most likely purpose of this connection?
Hard542A database administrator needs to retrieve, update, and delete records from a customer table. Which THREE SQL commands are required? (Select THREE.)
Hard543A junior developer is asked to fix a bug in a program. The senior developer explains that the bug is a logic error: the program runs without crashing but produces an incorrect total. Which characteristic best distinguishes a logic error from a syntax error in this scenario?
Medium544A database includes a table called 'Products' with columns: ProductID, ProductName, Price, and Quantity. Which TWO of the following SQL statements correctly insert a new product into the table? (Select TWO.)
Easy545Which THREE of the following are common types of computer networks? (Select three.)
Medium546A technician is troubleshooting a computer that fails to boot. Which of the following types of firmware is responsible for initializing hardware and loading the operating system?
Hard547A development team is using a stack data structure to manage function calls. Which of the following correctly describes the order in which items are removed from a stack?
Hard548A user needs to transfer a large collection of documents to a colleague. The documents must retain their exact formatting and be readable without needing the original software used to create them. Which of the following file formats is best suited for this requirement?
Easy549Which THREE of the following are common features of word processing applications?
Hard550A user receives an error message indicating 'insufficient memory' when opening several applications. Which action will most likely resolve the issue?
Medium551Which of the following is a primary advantage of using a database instead of a flat file system?
Easy552A technician is connecting a desktop PC directly to a cable modem to provide internet access. The PC needs to receive a public IP address automatically from the ISP. Which protocol should the technician ensure is enabled on the PC's network adapter?
Easy553A user reports that a spreadsheet application crashes every time they try to open a specific file. The file was created in a newer version of the software. What is the most likely cause?
Easy554A technician needs to connect a new desktop computer to a wired network in an office where the wall jack is active and the network uses DHCP. The computer has an integrated RJ45 port. Which of the following should the technician do to enable network connectivity?
Hard555Which TWO of the following are benefits of using a cloud database service (DBaaS) over an on-premises database?
Medium556A small office has a network with all devices connected to a central switch. If one device fails, only that device is affected and the rest of the network continues to function. Which network topology does this describe?
Easy557Which THREE of the following are examples of social engineering attacks?
Easy558Which TWO of the following are examples of open-source software licenses?
Medium559A small accounting office uses three desktop computers running Windows 10. One computer has become extremely slow over the past week. The user reports that the computer takes a long time to start up and applications are unresponsive. The technician checks Task Manager and sees that physical memory usage is at 95% and the page file is heavily used. The hard drive activity light is solid. The computer has 4GB of RAM and a 1TB HDD with 200GB free. Which course of action should the technician take first to most directly address the performance issue?
Hard560A technician is configuring a new Windows workstation and needs to assign a static IPv4 address that allows the computer to communicate with other devices on the same local network segment. The network uses a 255.255.255.0 subnet mask. Which of the following addresses should the technician assign to the workstation?
Medium561Which TWO of the following are types of cloud computing service models?
Medium562Which THREE of the following are advantages of using a cloud database service (DBaaS) over an on-premises database? (Select THREE.)
Hard563Which TWO of the following are examples of physical security controls?
Easy564Drag and drop the steps to boot a computer into Safe Mode in Windows 10 into the correct order.
Medium565Which TWO of the following are examples of output devices?
Easy566A user wants to connect an external monitor to their laptop. The monitor supports a resolution of 3840x2160 at 60Hz. Which of the following ports on the laptop would be BEST suited for this display?
Medium567A technician is converting the decimal number 255 to binary. Which binary value is correct?
Medium568A developer writes code in a high-level language and then uses a tool to translate the entire source code into machine code before execution. This process is known as:
Hard569A company has two office buildings 1.5 km apart and needs to connect their networks with a high-speed, reliable link. Which cabling type is most appropriate?
Medium570A user subscribes to a cloud productivity suite and wants to ensure that documents remain available for editing even when the internet connection is temporarily lost. Which feature should the user enable?
Hard571A user wants to save a photo with the highest quality but does not care about file size. Which file format should they use?
Medium572Which of the following types of networks covers the largest geographical area?
Easy573A small business owner wants to print multi-part carbon-copy invoices on continuous form paper in a warehouse environment where dust is common. Which printer type is most appropriate?
Easy574A developer accidentally committed a bug that broke the build. The team wants to undo the commit without losing the commit history. Which Git command should be used?
Hard575A technician is troubleshooting a computer that will not power on. Which of the following should be checked FIRST?
Medium576A user reports that a web application fails to load in a browser. The IT technician suspects a compatibility issue. Which TWO actions should the technician take to diagnose the problem?
Hard577In Git, which action creates a snapshot of changes in the repository?
Hard578Which SQL statement is used to retrieve all columns from a table named 'Employees'?
Easy579A small business wants to connect its office to a fiber internet service. The ISP provides an optical network terminal (ONT) that converts the fiber signal to Ethernet. The business needs a device that will route traffic between the internal LAN and the ISP, perform NAT, and provide DHCP to internal clients. Which device should the technician install between the ONT and the LAN switch?
Medium580Which THREE of the following are best practices for database security?
Hard581Which THREE are common types of network cables? (Select exactly three.)
Easy582A security administrator is reviewing authentication logs and notices hundreds of failed login attempts against many user accounts from a single external IP address within a few minutes. No accounts were successfully accessed. Which type of attack is occurring?
Hard583A technician is troubleshooting a network issue and needs to identify the IP address of a device. Which of the following are private IPv4 addresses? (Select TWO).
Medium584A programmer needs to store a true/false value. Which data type is most appropriate?
Medium585A developer is writing a program that stores a collection of unique student IDs. The program needs to quickly look up a student by ID and does not require the IDs to be stored in any particular order. Which data structure is most appropriate for this task?
Medium586A network administrator is setting up a small office network with 20 computers. The network must be easy to troubleshoot and resilient to a single cable failure affecting only one device. Which topology is most appropriate?
Hard587A user downloads a trial version of a photo editing application that is fully functional for 30 days. After the trial period, the user must purchase a license. This type of software distribution model is known as:
Medium588A user reports that their computer is running slowly. Which of the following is the MOST likely cause?
Easy589A technician is configuring a laptop for a user who frequently travels and needs to connect to both wired and wireless networks. The laptop has an RJ45 port and supports Wi-Fi 6. Which statement accurately describes the role of the network interface card (NIC) in this scenario?
Hard590A small business wants to connect its office computers to a network that provides centralized authentication, file sharing, and printer sharing without relying on a cloud service. The owner wants to minimize recurring costs and keep data on-site. Which of the following should the technician implement?
Medium591A hospital's IT team manages a virtualized server hosting a patient records database. The server has one physical processor with 6 cores, 32 GB of RAM, and a RAID 5 array of three 1 TB HDDs. The virtual machine (VM) running the database is configured with 2 vCPUs, 8 GB RAM, and a 500 GB virtual disk stored on the RAID array. Users report that database queries are taking much longer than usual. The host server shows CPU utilization at 20%, memory at 60%, and the disk queue length frequently stays above 5. Which of the following is the most likely cause of the performance issue?
Hard592A developer is writing a program that must handle multiple tasks simultaneously, such as downloading files while updating a user interface. Which programming concept allows the program to execute multiple sequences of instructions concurrently?
Hard593A system administrator needs to automatically assign IP addresses to devices on the network. Which protocol should be configured on the server?
Hard594Which TWO of the following are advantages of using a relational database management system (RDBMS) over a file-based system?
Medium595A small business needs to share files among employees within the same building. Which network topology is most efficient for this scenario?
Medium596Refer to the exhibit. A technician notices high CPU usage from a process called 'svchost.exe'. What is the most appropriate action?
Medium597Refer to the exhibit. A technician is troubleshooting why a user cannot run a custom application installed in D:\Apps. Based on the exhibit, what is the MOST likely reason?
Medium598A user wants to ensure software is legitimate and free from malware before installation. Which THREE of the following are recommended practices?
Hard599Which of the following is an input device?
Easy600Which TWO of the following are advantages of using a virtual private network (VPN) for remote employees?
Medium601Which device converts the signal from an ISP (e.g., cable or fiber) into a digital signal that a home network can use?
Medium602A technician is diagnosing performance issues in a wireless network. Users report intermittent slowdowns. Which of the following is the MOST likely cause?
Hard603A programmer is using a version control system. Which THREE are core Git concepts?
Hard604A developer needs to track changes to source code over time, collaborate with other developers, and maintain a history of all modifications. Which tool is specifically designed for these tasks?
Hard605A company wants to ensure that its corporate data is secure if a mobile device is lost. The IT department needs to remotely wipe the device and enforce a passcode policy. Which technology should be implemented?
Hard606A team is building an application where several unrelated objects must all respond to the same command, such as "start" and "stop", even though each object performs those actions differently. Which software development concept allows different object types to be treated uniformly through a shared interface?
Medium607A database manager is designing a new table to store customer information for a retail company. The table needs to store a unique identifier for each customer, the customer's first and last name, email address, phone number, and date of birth. The manager also wants to ensure that the email address is always provided and that no two customers have the same email. Which of the following SQL constraints should be applied to the email column?
Hard608Which THREE are valid primitive data types in most programming languages? (Choose three.)
Hard609A development team is selecting a programming language for a new project that must run directly on many different operating systems with minimal changes to the source code. The team also wants strong built-in support for object-oriented programming. Which TWO characteristics should the team prioritize when evaluating languages? (Choose two.)
Hard610A junior developer is tasked with creating a function that checks whether a number is even or odd. The developer writes the following pseudocode: FUNCTION isEven(number) IF number % 2 == 0 THEN RETURN true ELSE RETURN false. The developer then realizes they need to handle non-integer input. Which of the following should the developer add to improve the robustness of this function?
Easy611Which programming concept allows a program to make decisions based on conditions, such as checking if a user is logged in?
Medium612Which type of software provides an interface for users to interact with the computer's hardware?
Easy613A user is trying to access a website but receives a 'DNS server not responding' error. Which of the following is the MOST likely cause?
Medium614A company implements a policy requiring employees to use a password and a one-time code sent to their mobile phone when logging into the corporate network. Which security concept is being employed?
Medium615Which TWO of the following are common file formats for images?
Medium616A technician is deploying a new desktop PC that must run several virtual machines for software testing. The PC has 32 GB of RAM and a processor with virtualization extensions. Which of the following must be enabled in the system firmware to allow the hypervisor to function?
Medium617A small office wants wireless devices to connect to the corporate network without running cables to each desk. The administrator must choose a technology that provides wireless local area network connectivity using radio frequencies. Which technology should be selected?
Medium618A small business uses a single external IP address from their ISP and has a network of 10 computers. They want to host a web server that must be accessible from the internet, but they also need to protect their internal network. They have a firewall/router that supports port forwarding. Which configuration should they implement?
Hard619A technician is troubleshooting a computer that randomly reboots during use. The technician suspects a hardware issue. Which of the following tools would be MOST appropriate to monitor the system's temperature and voltage readings in real time?
Hard620A user receives an email that appears to be from their bank, asking them to click a link and verify their account details. The user notices the email address is slightly misspelled (e.g., 'support@bankk.com' instead of 'support@bank.com'). Which type of attack is this?
Medium621In a relational database, a foreign key in the 'Enrollments' table references the primary key of the 'Students' table. What does this relationship primarily enforce?
Medium622A help desk technician receives an alert from the security monitoring system showing multiple events like the one in the exhibit. The technician is investigating a possible brute-force attack. Based on the exhibit, which of the following is the primary attack vector being used?
Easy623A support technician is explaining file compression to a user. Which THREE of the following are examples of lossless compression formats? (Select THREE).
Hard624A network technician is troubleshooting a connectivity issue and needs to identify the destination MAC address of a frame. Which TWO of the following are true about MAC addresses? (Select TWO.)
Medium625A technician is preparing a desktop workstation for a user who needs to run several virtual machines locally for software testing. The host must have enough resources to keep the virtual machines responsive while the desktop remains usable. Which TWO hardware upgrades would most directly support this workload? (Choose two.)
Medium626A developer is writing a program in C++. The source code needs to be translated into machine code before execution. Which process is required?
Hard627A technician is asked to dispose of several old hard drives that contained customer records. The drives still function and the company wants to reuse them in a different department. Which action BEST protects the data while allowing reuse?
Medium628A user has a desktop computer with a SATA SSD and wants to upgrade to an NVMe M.2 SSD. The motherboard has an M.2 slot. What must the user verify before purchasing the NVMe drive?
Hard629Which of the following file extensions indicates a document created with Microsoft Word?
Easy630Refer to the exhibit. What does this event log entry indicate?
Easy631A product manager creates a list of user stories for a new feature. The development team estimates effort for each story and selects a set to complete in a two-week iteration. Daily standup meetings are held to discuss progress. At the end of the iteration, the team demonstrates working software to stakeholders. Which development framework is being used?
Medium632A user wants to install a locally compiled C program on a Linux system so that it becomes available system-wide to all users. Which command should the user run from the source directory after compilation?
Easy633A user notices that a file saved as a JPEG is smaller than the original BMP file. Which type of compression does JPEG typically use?
Medium634A company's IT department is deploying a new payroll system. Before the system goes live, a group of employees from the accounting department test the system to ensure it meets their requirements and is usable. This type of testing is known as:
Medium635Which TWO of the following are types of malware?
Easy636Which TWO of the following are primitive data types commonly used in programming?
Easy637An employee receives an email from 'IT Support' asking for his password due to 'system maintenance'. This is an example of:
Medium638A user needs to create a presentation for a sales meeting. Which type of software should they use?
Easy639A small business purchases a cable modem from the ISP. They need to obtain a public IP address to access the internet. Which method does the cable modem typically use?
Hard640A user is trying to install a new application but receives an error that the system does not meet the minimum requirements. Which TWO hardware components should the user check first to ensure compatibility?
Easy641Which THREE of the following are characteristics of object-oriented programming (OOP)? (Select THREE).
Hard642A user has just installed a new word-processing application on their laptop. When the user tries to open the application for the first time, a window appears asking for a product key. The user purchased the software online and received an email with the product key. Where should the user enter the product key to activate the software?
Easy643A user wants to upgrade their workstation's storage without losing existing data. Which of the following is the BEST method?
Medium644A developer writes a set of instructions to sort an array of numbers in ascending order. The instructions include steps like 'compare first two numbers, swap if out of order, move to next pair, repeat until no swaps are needed.' This step-by-step procedure is known as a(n):
Hard645A database contains two tables: 'Authors' (AuthorID, Name) and 'Books' (BookID, Title, AuthorID). A query needs to return all authors and any books they have written, including authors with no books. Which type of JOIN should be used?
Hard646Which of the following is the best practice for creating a strong password?
Easy647Which TWO of the following are examples of social engineering attacks? (Select TWO.)
Medium648A user connects to a website using its domain name. Which server translates that domain name into an IP address?
Hard649A developer is using Git and wants to integrate changes from a feature branch into the main branch. Which Git operation should be performed?
Hard650After a ransomware attack, which step should be taken FIRST in the incident response process?
Hard651Which of the following is a key difference between a web application and a desktop application?
Medium652A database designer wants to avoid duplicate data across tables and ensure each table stores information about a single entity. Which process should the designer apply?
Easy653An attacker sets up a fake wireless access point named "Cafe_Free_WiFi" in a coffee shop and uses it to capture the traffic of customers who connect. Which type of attack is this?
Hard654A small accounting firm's wireless network currently uses WPA2-Personal with a shared passphrase that all 20 employees know. The office manager reports that a former contractor who was given the passphrase can still connect to the Wi-Fi from the parking lot. The firm wants each user to authenticate with their own unique credentials and wants to be able to revoke access for one person without disrupting everyone else. Which wireless security method should the firm implement?
Medium655A programmer is writing code that needs to repeat a block of instructions 10 times. Which programming construct is best suited for this task?
Medium656A graphic designer needs a component to accelerate rendering of 3D models. Which of the following computer hardware components is specifically designed for this purpose?
Medium657An IT administrator needs to install software on multiple company computers without user interaction. Which installation method should the administrator use?
Medium658Which THREE of the following are types of data integrity enforced in relational databases?
Medium659A database designer is modeling a system where each book can have multiple authors and each author can write multiple books. Which type of relationship should be used between the Book and Author entities?
Hard660A user wants to ensure data is not lost in the event of a drive failure. Which storage configuration provides redundancy?
Medium661Which of the following is an example of something you are in multi-factor authentication?
Medium662Which of the following is a valid reason to use a database instead of a spreadsheet?
Easy663Which of the following best describes the principle of confidentiality in the CIA triad?
Easy664A user's laptop battery no longer holds a charge and the laptop only works when plugged in. Which component should be replaced?
Easy665Which of the following license types allows users to view, modify, and distribute the source code, as long as they include the original copyright notice and any modifications are also open source?
Easy666You are an IT support specialist for a mid-sized company. A user in the accounting department, Jane, reports that her accounting software (QuickBooks 2021) crashes every time she tries to export a report to PDF. The crash occurs immediately after clicking 'Export to PDF' and displays the error: 'The application has stopped working.' Jane's workstation runs Windows 10 Pro with 8GB RAM and an SSD. She has sufficient disk space. Other users in the same department using the same software version do not experience this issue. Jane recently installed a free PDF printer driver for personal use. What is the most likely cause and the best course of action?
Hard667A developer writes the following pseudocode: for i = 1 to 5, sum = sum + i. What does this code do?
Easy668A database administrator needs to ensure that a transaction either fully completes or is fully rolled back. Which database property guarantees this?
Medium669A company wants to manage and secure employee smartphones used for work. Which technology should they implement?
Medium670A user wants to connect a new external monitor to a laptop that has only USB-C ports. The monitor supports HDMI and DisplayPort inputs. The user needs to drive the monitor at its native resolution and also charge the laptop through the same connection. Which of the following should the technician recommend?
Medium671Which THREE of the following are productivity software suites?
Medium672A technician is assembling a desktop PC for a video editor. The editor frequently transfers large project files to and from external drives and wants the fastest currently available consumer interface. Which interface should the technician prioritize on the motherboard?
Medium673Which of the following best describes the function of a CPU cache?
Medium674A company is developing a mobile app and wants to release a minimal set of features quickly, then add more features based on user feedback. Which methodology best supports this approach?
Medium675A testing team is verifying a new version of an e-commerce website. They run a set of pre-existing test cases to ensure that recent changes have not broken any previously working functionality. What type of testing is this?
Medium676A user reports that their desktop computer will not power on. The technician notices that the power supply fan does not spin and no lights appear on the motherboard. The technician has already verified that the wall outlet is working and the power cable is securely connected. Which of the following should the technician check NEXT?
Medium677A help desk technician receives a call from someone claiming to be a company vice president who is traveling and urgently needs their password reset over the phone. The caller's number matches an internal extension. Which action should the technician take FIRST?
Medium678A programmer declares a variable 'price' and assigns it the value 19.99. In most programming languages, what is the data type of this variable?
Hard679Which TWO of the following are types of software licenses? (Select TWO).
Medium680A user is working from a coffee shop and needs to access the corporate file server. The user connects to the coffee shop's open Wi-Fi network and wants to ensure that the data transmitted between the laptop and the corporate network cannot be read by others on the same network. Which of the following should the user implement?
Medium681You are the IT administrator for a small company with 50 employees. The company uses a shared network drive for project files. Employees have read/write access to all folders on the drive. Recently, a ransomware attack encrypted many files on the network drive after an employee's workstation became infected. The employee had mapped the drive as a local letter. Backups are available but restoring takes several hours. Management wants to reduce the risk of future ransomware damage to the network drive. You are considering implementing one of the following controls. Which control would be most effective in limiting the spread of ransomware to the network drive?
Medium682A user needs to edit a PDF file that was received as an attachment. What type of application is required?
Easy683A database administrator notices that a transaction that updates two tables is failing halfway, leaving data inconsistent. Which property of ACID ensures that the database returns to its original state if the transaction fails?
Hard684A technician is explaining the difference between volatile and non-volatile memory. Which of the following is an example of volatile memory?
Easy685An IT administrator applies the software restriction policy shown in the exhibit. What is the intended effect of this policy?
Hard686A user is browsing the web on a public Wi-Fi network at a coffee shop and needs to check a personal bank account. The bank's website address begins with https. Which statement BEST describes how the user's connection is protected?
Medium687A help desk technician receives a ticket that a user cannot access a shared folder. The technician verifies the network cable is connected and the user can ping the server. What should the technician check next?
Easy688A company requires employees to use a one-time code from a smartphone app in addition to their password to log into the corporate VPN. This is an example of:
Hard689A technician is setting up a small office network. Which device should be used to connect multiple computers and allow them to communicate with each other?
Easy690Which THREE of the following are characteristics of a strong password? (Select THREE)
Hard691A small business wants to set up a network where employees can share files and a printer without a dedicated server. The budget is limited, and the network should be easy to set up. Which type of network model is most appropriate?
Medium692A network administrator wants to restrict access to the wireless network to only approved devices. Which security feature should be enabled on the access point?
Hard693A user wants to install software on a Linux system. Which file types are most commonly used for installing applications?
Easy694A user is troubleshooting a slow internet connection and has verified that the modem is working. The user suspects that the router is causing the issue. Which TWO of the following functions are typically performed by a home router? (Select TWO.)
Medium695A company wants to protect its network from unauthorized external access. Which of the following devices should be configured to filter traffic based on port and protocol?
Medium696Drag and drop the steps to create a new folder on the desktop in Windows 10 into the correct order.
Medium697Which file system is commonly used on external USB drives for compatibility between Windows and macOS?
Easy698A user wants to open a PDF file but receives an error that no application is associated. Which action should the user take?
Easy699A user cannot connect to the internet. Which step is most appropriate to start troubleshooting?
Easy700A database table contains redundant employee data, leading to update anomalies. Which database design process should be applied to resolve this?
Medium701Which of the following is a characteristic of a worm compared to a virus?
Hard702A data analyst is working with a large dataset stored in a columnar database. She needs to retrieve only the customer name and total order amount for orders placed in the last 30 days. Which two actions are most appropriate for optimizing this query? (Choose two.)
Hard703A small business is setting up a database to track its customers and their orders. The owner wants to ensure that every order is linked to an existing customer and that the customer ID in the Order table cannot refer to a non-existent customer. Which database concept should be implemented?
Medium704Which of the following cloud service models is correctly paired with its description?
Medium705A web developer is creating a weather application that retrieves data from a third-party service. The service requires an identifier to track usage and authenticate requests. The developer includes this identifier in the HTTP header of each request. What is this identifier called?
Hard706Which THREE are phases of the software development life cycle? (Choose three.)
Easy707A finance team member must share a spreadsheet containing customer account numbers with an external auditor. The team member wants to ensure that only the intended recipient can read the file contents. Which action BEST accomplishes this?
Medium708Which TWO of the following are characteristics of the Agile software development methodology?
Medium709A company needs to connect two separate local area networks (LANs) in different buildings. Which device is required to route traffic between the networks?
Hard710A user reports that their laptop cannot connect to the corporate Wi-Fi. Other devices are working fine. Which TWO troubleshooting steps should the technician take first? (Choose TWO.)
Medium711A developer is using Git for version control. Which THREE actions are core Git operations? (Select THREE.)
Hard712Which TWO of the following are types of desktop applications?
Easy713A network technician is troubleshooting intermittent Wi-Fi dropouts in a crowded office building. The office uses 2.4 GHz and 5 GHz dual-band access points. Users report better range but more interference on one band. Which frequency band is likely experiencing more interference?
Hard714A small business needs to share documents among employees and allow real-time collaboration. Which type of application is best suited?
Medium715A programmer needs to represent the logic of a program that includes decisions and loops. Which tool is most suitable for visually representing this logic?
Medium716A warehouse supervisor reports that an unknown person wearing a delivery uniform walked through the open loading dock, entered the server room, and left with a backup drive. The company wants to prevent unauthorized entry into the server room without rebuilding the entire facility. Which control should be implemented FIRST?
Medium717A technician is preparing a workstation for a user who needs to work with several document types. The technician wants to confirm which file extensions are commonly associated with word-processing documents and which are commonly associated with spreadsheets. Which TWO file extensions are typically used for spreadsheet files? (Choose two.)
Medium718A banking transaction transfers money from savings to checking. The system updates the savings balance, then the power fails before the checking balance is updated. Which ACID property is violated?
Medium719A development team is using version control for their project. They need to isolate a new feature from the main codebase until it is complete. Which version control operation should they perform?
Medium720A company wants to store product catalogs that vary in structure (different attributes per product). Which type of database is best suited?
Easy721A small business has a single server that hosts a customer database. The owner wants to ensure the database remains available if the server's primary power supply fails. Which component should the technician install to meet this need?
Easy722A developer writes code to store a collection of employee names in a structure that allows adding names at the end and removing names from the front, following a first-in-first-out (FIFO) order. Which data structure is the developer implementing?
Medium723A project team is in the phase where they gather business requirements, define project scope, and create a project plan. This phase occurs before any design or coding begins. Which SDLC phase is being described?
Medium724Which TWO of the following are input devices? (Select two.)
Easy725A user needs to create a document that includes complex mathematical equations, automatic table of contents, and collaborative editing with change tracking. Which type of application is most appropriate?
Easy726A help desk technician is setting up a new laptop for a remote employee. The employee needs to copy a 6 GB video file onto the laptop, which has a 256 GB solid-state drive. Which of the following storage interfaces would provide the fastest transfer speed for an external drive connected to this laptop?
Easy727A technician is troubleshooting a network connectivity issue on a laptop. The laptop connects to the company's wireless network but cannot access the internet. The technician checks the IP configuration and sees an IP address of 169.254.1.5. What is the most likely cause?
Hard728In a database, which SQL statement is used to add new records to a table?
Medium729A database has a 'Students' table and an 'Enrollments' table. Which type of relationship exists if a student can enroll in multiple courses and each course can have multiple students?
Hard730A developer needs to repeat a set of instructions exactly 10 times. Which programming construct should be used?
Easy731A software team is developing a mobile payment application using the waterfall model. They have completed the requirements, design, and implementation phases. During system testing, testers discover that the app crashes when processing transactions over $10,000. Further investigation reveals that the design specification for the transaction module did not account for large amounts, causing an overflow error. The project manager holds a meeting to decide the next steps. The team estimates that fixing the issue will require redesigning the transaction module, updating the code, and retesting, which will add two weeks to the schedule. The client's contract includes a penalty for late delivery but also a clause requiring the software to be free of critical defects. The team has already used most of the contingency time. What is the BEST course of action?
Medium732A junior developer writes a program that stores a customer's age in a variable. The value should be a whole number between 0 and 120. Which data type is most appropriate for this variable?
Easy733A user reports that a program does not start when double-clicking. The technician checks that the computer meets the minimum requirements. Which concept is being applied?
Easy734Which of the following is the binary representation of the decimal number 5?
Easy735A security analyst discovers that a file on a server has been modified without authorization. However, the system logs show that the modification was made by an authenticated user who had legitimate access to the file. Which aspect of the CIA triad has been violated?
Hard736Which file extension is typically associated with a compressed archive?
Easy737A user wants to remove a record from a database table. Which SQL command should be used?
Medium738A technician is building a virtualization host that will run multiple virtual machines simultaneously. The host needs to support hardware-assisted virtualization and provide the best performance for VMs that require direct access to peripheral devices. Which of the following CPU features should the technician verify is enabled in the BIOS/UEFI?
Hard739Which THREE of the following are examples of Infrastructure as a Service (IaaS) offerings? (Select THREE.)
Hard740A small business wants to connect its computers to share files and printers. Which of the following network devices would BEST facilitate this?
Medium741A small business wants to deploy a new customer relationship management (CRM) application. The company has no in-house IT staff and wants to minimize upfront infrastructure costs. They also need to access the CRM from any device with a browser. Which of the following deployment models best fits these requirements?
Medium742A software tester writes tests to verify that individual functions in a module return correct results when given specific inputs. These tests are isolated from other parts of the system. Which type of testing is being performed?
Medium743A security administrator wants to protect data at rest on a laptop that may be lost or stolen. Which of the following is the BEST solution?
Hard744A user reports that their laptop display looks extremely dim even though the image is visible and the operating system is running normally. The screen becomes readable when a flashlight is aimed at it. Which component has most likely failed?
Medium745A company is deploying software to multiple workstations without user interaction. Which TWO installation methods are considered silent installations?
Medium746A company is deploying a custom application to 500 employees. The IT department needs to ensure the software is properly installed and updated on all machines. Which deployment method is most efficient?
Medium747A team maintains a program that calculates employee payroll. A new tax rule takes effect next quarter, and the team expects more rule changes in the future. They want to isolate the tax calculation so it can be modified without rewriting the rest of the payroll code. Which software development principle best supports this goal?
Medium748A network technician is setting up a wireless network. To minimize interference from neighboring networks, which wireless frequency band is typically less congested?
Medium749A technician is troubleshooting a user's inability to access the internet. The user can ping the default gateway but cannot ping external websites. What is the most likely issue?
Medium750Which of the following storage technologies uses spinning platters and a mechanical arm to read and write data?
Easy751Which of the following cable types is MOST commonly used for Ethernet networks in an office?
Easy752A technician needs to install software on 50 company computers without user interaction. Which installation method should be used?
Medium753Which of the following storage types uses spinning platters to read and write data?
Easy754A technician is setting up a virtual machine on a laptop running Windows 10. The technician installs VirtualBox and creates a Linux VM. Which type of hypervisor is VirtualBox?
Medium755A junior developer is learning about data structures. The developer needs to choose a data structure for the following scenarios: - Storing a list of items where order matters and items can be accessed by index. - Storing key-value pairs for fast lookups. Which TWO data structures should the developer consider?
Medium756A data analyst runs a query that joins the Customers and Orders tables. The result includes only customers who have placed at least one order, and customers with no orders are excluded. Which type of join produced this result?
Medium757A technician is troubleshooting a workstation that cannot connect to a server at 192.168.1.100. The workstation's IP configuration shows: IP: 192.168.2.50, Subnet: 255.255.255.0, Gateway: 192.168.2.1. Which of the following is the MOST likely cause of the connectivity issue?
Hard758Which of the following best describes a web application?
Medium759Refer to the exhibit. A user on this computer can browse the internet but cannot ping another computer at 192.168.1.20. What is the most likely cause?
Medium760Which type of computer memory loses its data when the power is turned off?
Easy761A user reports that their computer is slow when running multiple applications simultaneously. Which component upgrade would best improve performance?
Easy762An IT instructor is teaching about binary arithmetic operations. Which TWO of the following are correct results of a logical XOR operation on the binary inputs 1 and 0? (Select TWO.)
Medium763A small business is setting up a LAN. Which TWO of the following are characteristics of a LAN?
Medium764Which printer technology is most suitable for printing high-volume black-and-white text documents in an office environment due to its lower cost per page?
Easy765Which of the following is an example of a physical security control?
Easy766A small business needs a printer that can produce high-quality color documents quickly and at a low cost per page. Which type of printer is most suitable?
Medium767A user reports that a laptop battery no longer holds a charge and the laptop shuts down immediately when unplugged. The laptop is several years old and the user wants to keep using it. Which of the following is the most appropriate replacement component?
Easy768Refer to the exhibit. The query returns two rows. If the database had an index on the Department column only, how would the query execution be affected?
Medium769A user attempts to run a legacy application and receives the error message shown in the exhibit. What is the most likely cause of this error?
Easy770A junior administrator is learning about database fundamentals and needs to identify characteristics that apply to a relational database management system (RDBMS). (Choose two.)
Medium771A company wants to use a cloud service where they provide their own operating system and applications, but the provider manages the physical hardware and virtualization layer. Which cloud service model does this describe?
Easy772An attacker gains physical access to a building by following an employee through a secured door without using a badge. This is an example of which social engineering technique?
Hard773A user is trying to choose a web browser. Which TWO features are considered advantages of using a browser with built-in developer tools? (Select TWO).
Hard774A small business owner needs to connect three desktop computers, a network laser printer, and a broadband router in a single office. The budget is tight, and the owner wants the simplest possible wired setup that allows all devices to communicate on the same local network. Which of the following should the owner install?
Medium775What is the primary purpose of a firewall?
Medium776Which component on the motherboard is responsible for temporarily storing frequently accessed data to speed up processing?
Easy777A cloud database service is being considered for a startup to avoid hardware maintenance and allow automatic scaling. Which type of service is this?
Hard778A user wants to install software on a Windows computer using the application's official installer. Which of the following file extensions is most likely associated with a Windows executable installer?
Easy779A technician is troubleshooting a network slowdown. The technician suspects a loop in the network. Which of the following protocols would prevent such a loop?
Medium780Which type of malware attaches to legitimate files and spreads when those files are executed?
Medium781A technician is explaining database concepts to a new employee. The employee asks what a record represents in a relational database table. Which statement best describes a record?
Easy782A database designer wants to reduce data redundancy and avoid update anomalies. Which process should be applied?
Medium783A user is preparing a budget spreadsheet and wants to apply the same currency format, bold header row, and column widths to twelve monthly sheets inside one workbook. The user wants each sheet to update automatically if the header text changes. Which feature should the user apply?
Easy784An administrative assistant is using a spreadsheet application to create a budget report. The assistant needs to add a column that calculates the total of the previous three columns for each row. The assistant is not very experienced with formulas and is unsure how to proceed. The assistant wants to use a built-in function that will automatically sum the values. Which of the following should the assistant do to achieve this?
Easy785A software development team is working on a project with fixed requirements and a strict deadline. The project manager decides to use a methodology where each phase must be completed before moving to the next. Which development methodology is being used?
Easy786A developer modifies a database and wants to ensure that every value in a column meets a specific condition, such as age must be between 0 and 120. Which type of integrity constraint should be used?
Hard787A network technician is configuring a device and needs to enter a MAC address. Which of the following is a valid MAC address in hexadecimal notation?
Hard788A database designer wants to ensure that every value in a column called 'Status' is either 'Active', 'Inactive', or 'Pending'. Which type of constraint should be applied?
Hard789A company is deploying mobile devices for its sales team. The devices need to access corporate email and calendars securely. Which THREE features are most important for managing these devices centrally?
Medium790A technician is selecting a storage interface for a new solid-state drive that offers the fastest data transfer speeds. Which interface should they choose?
Easy791Which wireless standard is commonly known as Wi-Fi 5 and operates on the 5 GHz band?
Medium792A user wants to edit a plain text configuration file on a Linux system. Which type of application is most appropriate?
Medium793A junior developer is creating a script to generate reports for each of 10 departments. The script should run the report generation code exactly 10 times. Which control structure should be used?
Easy794A team is preparing to release a software product and wants to automate checks that run whenever code is committed. They are selecting practices that belong to continuous integration. Which two of the following are core continuous integration practices? (Choose two.)
Medium795An administrator reviews the following access control policy: { "Rule": { "Effect": "Deny", "Action": "delete", "Resource": "file-server", "Condition": { "IpAddress": { "SourceIp": "192.0.2.0/24" } } } } What does it do?
Medium796An office has a single shared printer connected via USB to a Windows 10 desktop. Other users in the office need to print to this printer from their own computers, which are connected to the same local network. What is the simplest way to share the printer without additional hardware?
Medium797Refer to the exhibit. A technician runs ipconfig /all on a user's computer. The user can access the internet but cannot browse to any websites by domain name. What is the most likely cause?
Hard798A database administrator is designing a normalized database for an e-commerce site. Which TWO actions represent best practices for normalization?
Medium799Which of the following is used to translate human-readable domain names (like www.example.com) into IP addresses that computers use to identify each other on the network?
Easy800A technician is setting up a new desktop computer and needs to install an operating system from a bootable USB flash drive. The computer powers on but boots directly into the existing hard drive instead of the USB drive. Which of the following should the technician configure to allow the computer to boot from the USB drive?
Medium801A technician is troubleshooting a network connectivity issue. The user can access local network resources but cannot browse the internet. The technician suspects a DNS problem. Which of the following is the primary function of DNS?
Hard802A small office needs a centralized storage solution that all employees can access over the network to share files. Which type of storage should they implement?
Medium803A user needs to create a document that includes a table of contents, footnotes, and a bibliography. Which TWO application types are suitable for this task? (Choose TWO.)
Medium804Which of the following are advantages of using a cloud database service (DBaaS) compared to an on-premises database? (Select TWO.)
Easy805A user receives an 'Insufficient memory' error when opening a large spreadsheet. Which hardware component is most likely insufficient?
Medium806Which TWO of the following are common Ethernet cable categories used in local area networks?
Easy807A user is trying to install software on a macOS computer and has downloaded a file with a .dmg extension. What should the user do with this file to install the software?
Medium808A database administrator is setting up user permissions. Which THREE actions follow the principle of least privilege?
Hard809An organization is implementing a new payroll system. Before final deployment, a group of actual payroll employees test the system to ensure it meets their business needs and processes payroll correctly. Which testing phase is this?
Medium810A small business wants to set up a local network with internet access. They have a modem from the ISP and need to share the connection among five computers. Which device should they use to connect all computers to the modem and manage traffic?
Medium811A small business wants to centralize data storage so that employees on both Windows and macOS systems can access shared files with permissions. The company has a limited budget and wants to avoid recurring cloud subscription fees. Which of the following should the technician implement?
Medium812A database administrator wants to enforce that every record in the 'Orders' table must have a non-null unique value in the 'OrderID' column. Which database concept ensures this?
Medium813A user is configuring backup software on a workstation. The user wants the backup job to run automatically every night, capture only files that changed since the last run, and avoid re-copying files that have not been modified. The backup destination is a local external drive. Which backup type should the user select?
Hard814An employee receives an email from an unknown sender that includes an attachment labeled 'Invoice.pdf'. The employee does not recall ordering anything. What is the most secure action for the employee to take?
Easy815A small business owner wants to secure the wireless network at a retail store. The owner wants customers to have internet access without needing a password, but also wants to keep the internal point-of-sale (POS) network separate and protected. Which of the following should the owner configure?
Medium816Which TWO of the following are characteristics of a strong password? (Select TWO.)
Easy817A small retail company stores customer orders in a relational database. The IT administrator wants each order record to automatically receive a unique number without manual entry when a new order is inserted. Which database feature should be configured to meet this requirement?
Easy818A user receives a suspicious email with an attachment claiming to be an invoice. Which three practices should the user follow? (Select THREE.)
Hard819Which of the following file extensions is associated with a compressed archive file?
Easy820A company's email server is experiencing slow performance. The IT administrator notices high disk I/O wait times. Which component is most likely bottlenecked?
Hard821A team is using version control for a software project. A developer accidentally committed a buggy change to the main branch. Which action should the team take to fix this while preserving the commit history?
Medium822A user reports that they can access websites by IP address but not by domain name. Based on the exhibit, which of the following is the MOST likely cause?
Medium823Which SQL command is used to add a new row to a table?
Easy824Which TWO are characteristics of object-oriented programming? (Choose two.)
Medium825A small office has five computers connected to a switch, which is connected to a router that provides internet access. The office uses a single printer connected to one computer and shared over the network. The router has built-in DHCP and assigns IP addresses in the 192.168.0.0/24 range. Recently, the office manager added a wireless access point (WAP) to allow guests to access the internet. The WAP is connected to the switch and configured with its own DHCP server handing out addresses in the 192.168.1.0/24 range. The manager notices that some office computers are unable to access the shared printer, while others can. The computers that cannot access the printer have IP addresses in the 192.168.1.0/24 range. The printer's IP address is 192.168.0.50. What is the most likely cause of the issue?
Easy826A small business owner wants to protect sensitive customer data stored on a laptop that is frequently used on public Wi-Fi networks. The owner is considering implementing a security control that ensures data remains confidential even if the laptop is stolen. Which of the following is the BEST control for this scenario?
Medium827A user wants to ensure that a document cannot be edited by others. Which file property should be set?
Easy828Which TWO of the following are examples of high-level programming languages? (Select TWO).
Medium829Refer to the exhibit. A user is unable to access the internet but can ping the default gateway. Based on the exhibit, what is the most likely cause?
Hard830A company implements a policy where employees must swipe their ID card and then enter a PIN to access the server room. Which two authentication factors are being used?
Hard831A database administrator needs to add a new customer record to the 'customers' table. Which SQL statement should they use?
Medium832A user is selecting a software license for a new application that will be used by 50 employees. The company wants to pay a single upfront fee and avoid recurring costs. Which type of license should they choose?
Medium833A user wants to upgrade their laptop's storage to improve boot times and file transfer speeds. The laptop has an available M.2 slot. Which type of drive should the user choose?
Medium834A user receives a document created in a word processor that the user does not own. The sender wants the user to be able to read the text and view the layout, but the user does not need to edit or save changes. Which action allows the user to view the document content most reliably?
Medium835A user is selecting a new computer and sees that the CPU has a clock speed of 3.6 GHz and four cores. What does the clock speed of 3.6 GHz indicate?
Medium836Refer to the exhibit. A user is able to browse the internet using the Ethernet connection but not the Wi-Fi. What is the most likely cause?
Medium837A help desk technician is comparing storage capacity specifications for two laptops. One specification lists the SSD as 512 GB and the other lists it as 512 GiB. The technician needs to explain to a customer why the operating system reports a lower usable capacity than the advertised number. Which of the following best explains this difference?
Easy838A database administrator wants to enforce that a column only accepts whole numbers. Which data type should be used?
Easy839A software team uses version control and one developer commits a change that breaks the build. Which practice should be enforced to prevent this in the future?
Hard840A technician is explaining data representation to a trainee. The trainee asks which of the following statements correctly describe how bits and bytes are used in computing. (Choose two.)
Hard841An organization wants to ensure that employees only have access to the data necessary to perform their job functions. Which principle should be applied?
Medium842A developer is writing the first version of a program that calculates an employee's weekly pay. Before writing any code, the developer writes a numbered list of steps in plain English: get hours worked, get hourly rate, multiply hours by rate, display the result. Which software development concept does this numbered list represent?
Easy843A company is designing a disaster recovery plan. They need to restore operations within 4 hours and can tolerate up to 1 hour of data loss. Which combination of Recovery Time Objective (RTO) and Recovery Point Objective (RPO) should they set?
Hard844A technician is explaining the concept of cloud computing to a new employee. Which TWO of the following are characteristics of cloud computing as defined by NIST? (Choose two.)
Medium845A small business wants to set up a wireless network for employees and guests. The owners are concerned about unauthorized access. Which of the following security measures would be MOST effective to prevent outsiders from connecting?
Medium846A developer is debugging a program that is producing incorrect output. Which of the following are common debugging techniques? (Choose three.)
Hard847A user is trying to install software from an .msi file on a Windows computer. What is the most likely purpose of an .msi file?
Medium848A help desk technician needs to retrieve the names and email addresses of all customers who live in 'Chicago'. Which SQL statement should the technician use?
Easy849A small business stores customer orders in a relational database. The Orders table has a foreign key column named CustomerID that references the Customers table. A developer needs to prevent any order from being inserted if the CustomerID does not already exist in the Customers table. Which database feature should be used?
Medium850A small retail store keeps its sales records in a spreadsheet file. The owner complains that customer addresses are typed slightly differently in different rows, and that correcting one address requires editing many rows. Which data concept best describes the root problem the owner is experiencing?
Easy851A developer is writing a program that needs to handle text in multiple languages, including Chinese and Arabic. Which TWO character encoding systems should they consider? (Choose two.)
Hard852A technician installs a new network printer. It can communicate with other computers on the same network but no one outside the network can access it. What is the MOST likely cause?
Easy853A junior administrator is reviewing a database schema and must identify which statements about primary keys and foreign keys are accurate. (Choose two.)
Hard854A graphic designer needs to create vector logos that can be scaled without losing quality. Which software category is most appropriate?
Medium855Which of the following is an example of a lossy compression format?
Medium856A user needs to open a document that was created in a proprietary format by a legacy application. The user does not have that application installed. Which of the following is the BEST solution to view the document's content without installing additional software?
Medium857A medium-sized business has a policy that requires all employees to use two-factor authentication (2FA) when accessing the corporate email system. The authentication method uses a time-based one-time password (TOTP) app on employees' smartphones. Several employees have reported that they cannot log in because they recently changed phones and did not transfer the TOTP seed. The help desk has been resetting 2FA for these users, but management is concerned about the security of the reset process. Which of the following procedures should the help desk follow to securely reset 2FA for a user?
Hard858A technician must install an internal storage drive in a desktop that will hold the operating system and needs the fastest practical boot performance. The motherboard supports NVMe and has an available M.2 slot wired for PCIe. Which drive should the technician select?
Hard859Which TWO of the following are examples of multi-factor authentication? (Choose TWO.)
Medium860A technician is troubleshooting a laptop that randomly shuts down during use and feels very hot near the vents. The technician suspects a thermal issue. Which TWO of the following actions are MOST appropriate to resolve the problem? (Choose two.)
Hard861A user receives an email that appears to be from their bank, asking them to click a link and verify their account details. The user notices the sender's email address is slightly misspelled. Which type of threat is this?
Medium862Which THREE of the following are characteristics of a relational database?
Hard863A database designer wants to split a table into two to reduce data redundancy and avoid update anomalies. This process is known as:
Medium864A small office has 15 computers that need to be connected to share files and a printer. Which type of network is most appropriate for this local setup?
Easy865A user wants to retrieve all records from a table named 'Products' where the price is greater than 100. Which TWO SQL statements will work?
Easy866Which TWO of the following are effective methods to help secure a wireless network from unauthorized access?
Hard867A computer has 8 GB of RAM installed, but the operating system reports only 7.9 GB usable. What is the most likely reason for this discrepancy?
Hard868A company is setting up a new branch office. The network administrator needs to connect 20 computers and 2 network printers to the local network. The branch also needs a connection to the internet via a cable modem. The administrator has a 24-port switch and a wireless router. The cable modem is already provided by the ISP. Which configuration should the administrator use?
Medium869A technician is configuring a wireless access point for a small office. The office has several older laptops that only support the 2.4 GHz frequency band, as well as newer devices that support both 2.4 GHz and 5 GHz. The technician wants to ensure all devices can connect while minimizing interference. Which of the following should the technician do?
Medium870Which of the following software licenses allows users to modify and redistribute the source code, provided they keep the same license terms?
Easy871Which TWO of the following are types of malware? (Select TWO)
Easy872A user wants to install a 32-bit application on a 64-bit version of Windows 10. The application's installer runs but displays an error message stating that the application requires a 32-bit operating system. Which of the following is the most likely cause?
Hard873Drag and drop the steps to change the desktop background in Windows 10 into the correct order.
Medium874A user is evaluating database concepts while building a small inventory system. Which TWO statements accurately describe a relational database? (Choose two.)
Medium875Drag and drop the steps to open the Task Manager in Windows 10 into the correct order.
Medium876Which SQL statement would you use to retrieve the names of all products with a price greater than $50 from a table named 'Products'?
Hard877A company wants to implement a private network for devices within a single building. Which type of network should they use?
Hard878An organization's security policy requires that users prove their identity with something they know and something they have when accessing the payroll system from outside the office. A user enters a password and then a code generated by a mobile app. Which security concept does this scenario illustrate?
Hard879An employee wants to add a new customer record to the 'Customers' table with columns 'ID', 'Name', and 'Email'. Which SQL statement should be used?
Medium880A system administrator is evaluating antivirus software for company computers. Which TWO features are most important for protecting against malware? (Select TWO.)
Medium881A school's computer lab has 25 computers, each running a specific educational software suite. The IT department needs to update the software on all machines to the latest version. The update is a large file, and downloading it separately on each machine would consume too much bandwidth and time. The network has a server that can host the installation files locally. Which of the following is the MOST efficient method to update the software on all computers?
Medium882A user wants to edit a document collaboratively with multiple team members in real-time. Which type of application should they use?
Easy883A user reports that they cannot print to a network printer. Other users can print to the same printer. Which of the following should the technician check FIRST?
Medium884A retail company wants to build an online store where the source code is freely available for anyone to inspect, modify, and redistribute, provided that any derivative work is released under the same license. Which licensing model should the company adopt?
Medium885In which phase of the Software Development Life Cycle (SDLC) are the system requirements gathered and analyzed?
Easy886Match each network protocol to its well-known port number.
Medium887A user inserts a software CD into their computer to install a new application. Which of the following is the most likely next step after the CD is inserted?
Easy888A technician is troubleshooting a network where users in one department cannot reach a web server in another subnet. The technician confirms the server is running and the switch ports are up. Which of the following should be checked NEXT?
Hard889A user reports that their desktop computer will not power on. The technician confirms the wall outlet works, the power supply switch is set to the correct voltage, and the power button cable is connected to the motherboard. When the technician presses the power button, no fans spin and no lights illuminate. Which component should the technician test next to determine whether the power supply is functioning?
Medium890A database administrator needs to remove all rows from the 'Log' table but keep the table structure for future use. The administrator also wants the operation to be irreversible (cannot be rolled back). Which SQL statement should be used?
Hard891A user wants to open a spreadsheet file, edit some cells, and then save the changes in a format that preserves formulas and formatting. Which type of application should the user open?
Easy892A database administrator needs to retrieve all customer names from a table named 'Customers' where the city is 'New York'. Which SQL statement should be used?
Medium893A small independent bookstore has been operating for several years using a single Microsoft Excel spreadsheet to manage its inventory, sales, and customer data. The spreadsheet contains over 10,000 rows and is shared among five employees. Recently, employees have noticed recurring data quality issues: the same book appears multiple times in the inventory list with different prices, some sales records reference book titles that do not exist in the inventory, and customer contact information is duplicated across rows. Because there are no constraints, employees can enter any value into any cell. The owner wants to implement a more robust system to eliminate data redundancy and ensure data integrity. The bookstore has a budget for new software and some technical support. The owner is not very technical but is willing to hire a consultant. Which action should be taken to best address these problems?
Easy894A technician is explaining the difference between lossy and lossless compression to a colleague. Which of the following file formats uses lossy compression?
Medium895A medium-sized company uses a customer relationship management (CRM) application that is accessed by 50 employees. The application is installed on a local server and uses a shared database. Recently, employees have reported that the application is becoming slow and sometimes times out. The IT staff has verified that there is no network congestion and the server has adequate resources. The application logs show that the database file has grown significantly over the past year. Which of the following is the MOST likely cause of the performance issue and the BEST solution?
Hard896A user wants to protect their laptop in case it is stolen. Which TWO of the following measures would help protect the confidentiality of the data?
Medium897A hospital's scheduling system must answer questions such as 'which appointments belong to patient 4471, and which physician is assigned to each?' Records change frequently, and staff need immediate, consistent answers. Which data structure characteristic is most important for this requirement?
Medium898Which of the following is the correct file extension for a macOS installer package?
Easy899A company wants to deploy a new wireless network in its office. The network must support high device density and minimize interference from neighboring networks. Which Wi-Fi standard and frequency band combination is most suitable?
Medium900A user wants to upgrade their desktop computer to faster storage. Which of the following storage interfaces provides the highest data transfer speeds?
Easy901A technician is reviewing network security concepts with a junior colleague. The colleague asks which of the following are characteristics of a virtual private network (VPN) used for remote access. (Choose two.)
Hard902You are a support technician for a small company. An employee reports that their desktop computer will not turn on. You have verified that the power cable is securely connected to both the computer and the wall outlet. When you press the power button, you hear a faint clicking sound but the computer does not start. The power supply fan does not spin, and there are no lights on the motherboard. You have tested the wall outlet with a known working device and it provides power. What is the most likely cause of the issue?
Easy903A technician is deploying a software update to 200 computers in a domain. To avoid user interaction, which installation method should be used?
Medium904A network administrator is setting up a small office network for a new startup. The office has five computers, two printers, and one server. The administrator wants to ensure that all devices can communicate with each other and access the internet. The administrator has decided to use a switch and a router. Which of the following configurations is the MOST appropriate?
Medium905Refer to the exhibit. A developer wrote this BASIC program. What will happen if the user presses Enter without typing a name?
Medium906A technician must install an operating system on a workstation that will run a virtual machine with direct access to a graphics card for CAD rendering. The physical CPU and motherboard support the required feature. Which setting must be enabled in the UEFI/BIOS for the virtual machine to use the GPU directly?
Hard907A small office's wireless router still ships with the administrator username and default password printed in its manual. A technician is asked to harden the device before it goes into production. Which action BEST addresses this specific risk?
Medium908A company wants to ensure that data on lost laptops cannot be accessed. Which technology should be used?
Medium909A database designer wants to enforce that a 'CustomerID' value in an 'Orders' table must exist in the 'Customers' table. Which TWO methods can achieve this?
Medium910A university database includes tables: 'Professors' (ProfessorID, Name, Department) and 'Courses' (CourseID, Title, ProfessorID). Which THREE statements about this design are correct?
Hard911A small business is replacing its aging wired network with a wireless solution for 25 employees. The owner wants to reduce cabling costs while still supporting file sharing and printing. Which TWO of the following are benefits of implementing a wireless network in this scenario? (Choose two.)
Medium912A developer runs a SQL query against a database and receives the error shown. Which of the following actions should the developer take first to resolve the issue?
Hard913A technician is setting up a small office network and needs to assign a logical address to each workstation so devices can communicate across the local network and the internet. Which of the following best describes the role of an IP address?
Medium914An employee at a marketing firm plugs an unknown USB flash drive found in the parking lot into a workstation to identify its owner. Within minutes, files on a shared network folder begin to be renamed with a .locked extension and a ransom note appears. Which type of malware most likely caused this behavior?
Medium915A small business owner wants to keep a record of the software installed on each employee laptop and receive an alert if unauthorized software is installed later. The owner asks a technician for the BEST tool to accomplish this. Which of the following should the technician recommend?
Easy916Match each storage type to its description.
Medium917During a Scrum sprint review, stakeholders request a new feature that was not in the product backlog. The product owner wants to add it to the next sprint. What is the correct action according to Scrum?
Hard918A web application constructs SQL queries by concatenating user input directly. What is the primary security risk?
Easy919Which TWO factors should be considered when choosing a software license?
Medium920A software license allows users to use the software for a limited time before purchasing. This is an example of which license type?
Hard921Which TWO of the following are characteristics of a client-server network? (Choose two.)
Medium922A database administrator needs to ensure that every record in the 'Orders' table can be uniquely identified. Which constraint should be applied to the 'OrderID' column?
Medium923An IT technician is configuring a new server and needs to allocate virtual resources to a VM. Which THREE of the following are virtual resources that can be allocated to a VM? (Choose THREE.)
Medium924Which TWO of the following are examples of interpreted programming languages?
Easy925A user reports that their computer is slow. Which of the following is the BEST first step to troubleshoot?
Easy926A program crashes with a 'division by zero' error. Which of the following is the most likely cause?
Medium927A user needs to install a new graphics editing application on a Windows computer. Which file extension is most likely associated with the installer?
Easy928A security analyst is reviewing user permissions and discovers that several users have been granted more privileges than necessary to perform their job functions. The analyst wants to apply the principle of least privilege. Which TWO actions should the analyst take? (Choose TWO.)
Hard929A software developer is writing a script that needs to run a set of instructions repeatedly until a condition is met. Which programming construct should be used?
Hard930Which TWO of the following are best practices for creating strong passwords?
Medium931A junior developer is asked to write a program that reads a user's age and determines whether the user is eligible to vote. The program must compare the age to 18 and display one of two messages. Which programming construct is the most appropriate to use for this decision-making step?
Easy932A programmer is writing a function that must decide whether a customer qualifies for a discount. The function checks if the customer's total purchases are greater than 500. If true, it returns a discount rate; otherwise, it returns zero. Which programming construct is most appropriate for making this decision?
Easy933A user needs to print a large number of color brochures with high-quality images. Which type of printer would produce the best color output for this task?
Medium934Which THREE of the following are valid database integrity constraints?
Hard935A user downloads a free game from an untrusted website. After installation, the user's computer begins displaying pop-up advertisements frequently. Which type of malware is most likely installed?
Medium936A user is selecting a storage device for a new computer and wants fast boot times and durability. Which TWO storage technologies should the user consider? (Select TWO.)
Easy937An office manager needs to replace a printer that will primarily print text documents and has a high monthly page volume. Which type of printer would be MOST cost-effective?
Medium938A developer is writing pseudocode for a program that calculates the average of a list of numbers. Which THREE of the following are valid components that would likely appear in the pseudocode? (Select THREE.)
Hard939An organization needs to run multiple operating systems on a single physical server to isolate development environments. Which virtualization technology should they use?
Hard940A small office needs a network that is easy to set up and allows devices to connect without wires. The office has a single internet connection and about 15 devices. Which of the following is the BEST choice?
Medium941A technician is documenting the physical networking hardware in a small office wiring closet and needs to distinguish devices that forward data between network segments from devices that only regenerate signals. Which TWO of the following devices actively forward frames or packets between network segments? (Choose two.)
Medium942A network technician is explaining to a client why a file transfer over the network is slower than expected. Which factor MOST likely affects transfer speed?
Medium943A hospital's pharmacy system requires that every time a pharmacist adjusts a medication order, the system records who made the change, the exact time, and the previous value. Auditors later need to prove that no record was altered after the fact. Which security principle is the hospital primarily implementing?
Hard944An employee is tailgated into a secure office building by someone without a badge. Which type of security threat does this represent?
Medium945A user wants to access a file located in a subdirectory relative to the current working directory. Which type of path is being used?
Medium946A development team is choosing a version control workflow for a project with multiple contributors. They want to keep the main branch stable and allow each developer to work independently before changes are reviewed and integrated. Which THREE of the following are characteristics of a typical branch-based version control workflow? (Choose three.)
Hard947Which TWO of the following are examples of application software? (Select TWO).
Easy948A software developer is working on a team project and uses Git for version control. The developer has made changes to the code and wants to save a snapshot of the current state of the project locally. Which Git command should they use?
Hard949Which THREE of the following are common troubleshooting steps? (Select THREE).
Hard950Which of the following is the result of the binary operation 1101 AND 1011?
Hard951A developer notices that an application runs slowly when processing large files. Which optimization technique is most likely to improve performance?
Medium952A company needs to store an organizational chart showing reporting relationships. Which database model is most appropriate?
Easy953A development team is comparing compiled languages and interpreted languages as they choose a technology for a new project. Which TWO of the following statements accurately describe differences between these two categories? (Choose two.)
Hard954Which of the following is an example of a NoSQL database?
Medium955A user runs a query on a database table and notices that the results contain duplicate rows. Which SQL keyword would eliminate these duplicates?
Easy956A technician is troubleshooting a desktop PC that powers on but produces no video and emits a repeating beep pattern. The motherboard has an integrated speaker and no POST card is available. Which component should the technician check first?
Medium957An organization implements a security policy where users must provide a password and a one-time code generated by a mobile app to log in. Which type of authentication is being used?
Hard958Which of the following is the binary result of the AND operation on 1010 and 1110?
Easy959A company's customer database contains a table named 'Orders' with columns: OrderID, CustomerID, ProductID, Quantity, OrderDate. The company wants to enforce that every CustomerID in 'Orders' must exist in the 'Customers' table. Which database constraint should be added to the 'Orders' table?
Medium960Refer to the exhibit. What is the most likely cause of the application crash?
Easy961A company's IT policy requires that all corporate smartphones be remotely wiped if lost. Which technology enables this capability?
Hard962A small business wants its staff to create documents, spreadsheets, and presentations without installing any software on their laptops. Staff must be able to open the files from any company device and see edits made by coworkers within seconds. Which software delivery model best meets this requirement?
Easy963Which TWO of the following are open-source licenses? (Select 2)
Medium964A company needs to manage and secure a fleet of employee smartphones used for work. Which technology should they implement?
Medium965Refer to the exhibit. A user attempts to insert a row into Orders with a CustomerID that does not exist in the Customers table. What is the expected outcome?
Medium966A technician is explaining the concept of software licensing to a client. The client wants to install a single copy of an application on multiple computers within their small business. Which type of license should the technician recommend?
Medium967A company is deploying new laptops for employees. The IT department requires that the laptops have fast storage, support for external 4K monitors, and the ability to connect to a wireless network. Which THREE of the following should be included?
Hard968A company wants to secure its wireless network. Which of the following is the BEST practice?
Medium969A user wants to install an application on an Android smartphone. Which app store should they use?
Medium970An employee needs to create a chart showing quarterly sales data for a presentation. Which of the following types of applications should the employee use?
Medium971A technician is installing a new graphics card and needs to connect it to the motherboard. Which type of slot is typically used for a dedicated GPU?
Medium972Which of the following character encoding standards supports characters from most of the world's languages and uses a variable number of bytes per character?
Medium973Which of the following RAM types is the fastest and most recent?
Easy974A technician is setting up a server that will host multiple virtual machines. Which type of hypervisor runs directly on the physical hardware without an underlying operating system?
Hard975Which of the following is a primary advantage of using a database over a flat file system for storing customer records?
Easy976A user reports that their laptop cannot connect to the corporate Wi-Fi. Other devices in the same area work fine. The network technician checks the laptop and sees that the wireless adapter is enabled and shows available networks, but the connection attempt to the corporate SSID fails with an authentication error. Which of the following is the MOST likely cause?
Medium977A small business owner wants to create a simple website to display business hours and contact information. The owner has no programming experience and needs to quickly update the content without learning code. A family member suggests using a content management system (CMS) like WordPress. Another suggests using a plain HTML file and editing it manually. The owner is concerned about both ease of use and security. Which solution best addresses the owner's needs while minimizing technical complexity?
Easy978Which of the following is a valid SQL statement to retrieve all records from a table named 'Employees'?
Easy979A technician is setting up a small office network and needs to connect devices using a physical topology where each device connects to a central device, and a failure of one cable does not affect the others. Which topology should the technician implement?
Medium980A security analyst is explaining the CIA triad to new employees. Which scenario best illustrates a breach of integrity?
Hard981A server in a data center is running a critical application. The server is connected to a managed switch via two network cables for redundancy (link aggregation). Recently, the server experienced intermittent connectivity issues. The network logs show that every few hours, one of the links goes down and then comes back up within a minute. The other link remains up. The server's team reports no errors in the server logs. What is the most likely cause of this issue?
Hard982A technician is explaining the difference between volatile and non-volatile memory to a trainee. Which TWO of the following are examples of volatile memory? (Select TWO.)
Hard983A technician is explaining data storage to a customer. Which of the following best describes the difference between a bit and a byte?
Medium984Which data structure is best for storing a collection of key-value pairs?
Medium985Which of the following is an example of open-source software license?
Easy986After deploying a new version of a web application, the QA team runs a set of test cases that were previously executed on the old version to ensure that existing functionality still works correctly. This testing is performed to detect any unintended side effects of the changes. What type of testing is this?
Hard987A user wants to create a backup of important files stored on a hard drive. Which type of application is most appropriate for this task?
Easy988A user wants to synchronize contacts and calendar events between their Android smartphone and tablet. Which service is MOST likely used for this synchronization?
MediumOther domains
All FC0-U71 exam domains
Frequently asked questions
- What does the troubleshooting domain cover on the FC0-U71 exam?
- troubleshooting questions test whether you can apply the concept in context, not just recognise a definition.
- How many questions are in this domain?
- This page lists all 988 troubleshooting questions in the FC0-U71 question bank. The actual exam draws from this domain proportionally to its weighting in the official exam blueprint.
- What is the best way to practise this domain?
- Start with a short focused session (10 questions) to identify gaps, then work through explanations. Repeat with a longer session once the weak areas feel solid.
- Can I practise only troubleshooting questions?
- Yes — the session launcher on this page filters questions to this domain only. Choose any session length for inline explanations and scoring.