Courseiva

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.

988 questions282 easy434 medium272 hard

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.

1

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

Easy
2

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

Medium
3

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

Medium
4

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

Easy
5

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

Medium
6

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

Medium
7

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

Hard
8

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

Medium
9

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

Medium
10

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

Medium
11

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

Easy
12

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

Medium
13

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

Hard
14

A 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?

Medium
15

A 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?

Easy
16

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

Easy
17

A 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.)

Medium
18

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

Medium
19

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

Hard
20

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

Medium
21

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

Medium
22

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

Medium
23

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

Hard
24

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

Medium
25

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

Easy
26

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

Easy
27

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

Medium
28

A 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?

Medium
29

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

Hard
30

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

Medium
31

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

Hard
32

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

Hard
33

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

Medium
34

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

Medium
35

A 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?

Easy
36

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

Medium
37

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

Medium
38

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

Easy
39

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

Medium
40

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

Hard
41

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

Medium
42

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

Hard
43

An 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?

Medium
44

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

Easy
45

A 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?

Medium
46

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

Medium
47

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

Easy
48

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

Medium
49

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

Medium
50

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

Hard
51

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

Hard
52

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

Medium
53

A 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?

Easy
54

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

Easy
55

A 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?

Hard
56

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

Medium
57

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

Medium
58

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

Hard
59

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

Medium
60

A 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.)

Hard
61

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

Medium
62

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

Easy
63

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

Hard
64

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

Easy
65

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

Medium
66

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

Hard
67

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

Hard
68

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

Hard
69

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

Medium
70

A 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?

Easy
71

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

Hard
72

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

Hard
73

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

Medium
74

A user wants to store a file with lossless compression. Which TWO of the following file formats support lossless compression? (Select TWO.)

Medium
75

A software engineer is debugging a program and needs to identify potential issues. Which THREE tools or techniques are commonly used in debugging? (Select THREE.)

Hard
76

A user needs to collaborate on a document with colleagues in real-time. Which type of application should they use?

Medium
77

Which of the following SQL statements will add a new row to the 'Products' table?

Medium
78

A 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?

Medium
79

A 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?

Hard
80

A 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?

Medium
81

An 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?

Medium
82

A web application needs to send user registration data to a server. Which HTTP method should be used?

Hard
83

A 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.)

Hard
84

A 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):

Easy
85

Which of the following is a best practice for creating a strong password?

Easy
86

A security analyst discovers that a file on a server has been modified without authorization. Which element of the CIA triad has been compromised?

Hard
87

A 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?

Hard
88

Which internet connection type provides symmetric upload and download speeds over a fiber-optic cable?

Hard
89

What is the primary risk of using public Wi-Fi without a VPN?

Medium
90

Which TWO of the following are appropriate steps when troubleshooting a user's inability to access the internet? (Select TWO.)

Medium
91

A 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?

Easy
92

A 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?

Hard
93

You 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?

Hard
94

A technician is installing RAM in a desktop computer. The motherboard supports dual-channel memory. Which memory configuration will provide the BEST performance?

Medium
95

A 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?

Hard
96

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

Medium
97

A user downloads a software installer from the internet. On Windows, which file extension is most likely to be used for the installer?

Medium
98

An 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?

Hard
99

A 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?

Easy
100

A 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.)

Medium
101

What is the primary purpose of a password manager?

Easy
102

A 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?

Medium
103

A 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?

Medium
104

Which component of the CIA triad ensures that data cannot be modified by unauthorized users?

Easy
105

A programmer needs to store a customer's name in a variable. Which data type is most appropriate?

Easy
106

A 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?

Easy
107

A 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?

Hard
108

A 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?

Medium
109

A user is concerned about connecting to a public Wi-Fi network at a coffee shop. Which security measure can best protect their data?

Medium
110

A 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?

Hard
111

A 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?

Medium
112

A 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.)

Medium
113

A 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?

Hard
114

A 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?

Hard
115

Which of the following is the primary purpose of hashing a password before storing it in a database?

Medium
116

A 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?

Hard
117

Which of the following is a characteristic of open-source software?

Easy
118

A 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?

Easy
119

A developer is writing a program that processes whole numbers only. Which data type should be used?

Hard
120

In a relational database, which constraint ensures that a foreign key value matches an existing primary key value in the referenced table?

Medium
121

Which of the following is an example of system software?

Easy
122

Which of the following best describes the role of an operating system?

Easy
123

An 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?

Medium
124

A software developer needs to track changes to source code over time. Which type of software should they use?

Easy
125

A user wants to upgrade their computer's RAM for better performance. Which of the following are characteristics of DDR4 and DDR5 RAM? (Select THREE).

Medium
126

Which TWO of the following are types of system software? (Select two.)

Medium
127

A database administrator is designing a normalized database. Which TWO are benefits of normalization?

Medium
128

A 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?

Medium
129

An 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?

Hard
130

A 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?

Easy
131

A company's backup strategy requires three copies of data, on two different media types, with one copy offsite. Which backup rule does this follow?

Hard
132

Which TWO of the following are valid SQL functions used to aggregate data?

Medium
133

A company is developing a security policy. Which THREE of the following are examples of physical security controls?

Hard
134

A 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?

Medium
135

A 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?

Medium
136

A 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?

Easy
137

Which file extension typically indicates a compressed archive in Windows?

Easy
138

A 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?

Medium
139

A 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?

Hard
140

Which of the following BEST describes the primary function of an operating system?

Medium
141

A 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?

Easy
142

A 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.)

Medium
143

A 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?

Hard
144

A 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?

Medium
145

What is the primary purpose of a network firewall?

Easy
146

Which of the following software categories includes applications like Microsoft Teams and Slack?

Easy
147

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

Medium
148

A 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?

Medium
149

A 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?

Medium
150

A 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.)

Medium
151

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

Hard
152

A small office has five computers that need to share files and a printer. Which type of network should be set up?

Easy
153

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

Hard
154

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

Hard
155

Which TWO of the following are key characteristics of a NoSQL database compared to a traditional relational database?

Easy
156

Which TWO of the following are examples of multi-factor authentication?

Easy
157

A 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?

Hard
158

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

Medium
159

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

Hard
160

A memory address is displayed as 0x1A3F. What is the correct base of this representation?

Hard
161

Which of the following is the strongest password?

Easy
162

A 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?

Medium
163

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

Medium
164

An 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?

Medium
165

Which coding best practice improves code readability and maintainability?

Medium
166

A 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?

Medium
167

A 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?

Medium
168

An 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?

Medium
169

A technician is upgrading a desktop computer's memory. Which component would the technician most likely replace to improve system performance using dual-channel architecture?

Easy
170

A user's home wireless network is experiencing interference. Which frequency band is more prone to interference from devices like microwaves and cordless phones?

Medium
171

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

Easy
172

A 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?

Medium
173

A 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?

Hard
174

A 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?

Easy
175

A 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?

Hard
176

A database administrator needs to perform CRUD operations on a table. Which TWO SQL statements are used for the 'Create' and 'Read' operations? (Select TWO.)

Medium
177

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

Easy
178

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

Easy
179

Which of the following Wi-Fi standards operates on the 5 GHz band and provides the fastest theoretical speeds?

Medium
180

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

Easy
181

Which of the following storage interfaces provides the fastest data transfer speeds?

Easy
182

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

Medium
183

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

Easy
184

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

Easy
185

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

Medium
186

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

Hard
187

A 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?

Medium
188

A network engineer is configuring a device and needs to enter a MAC address. Which notational system is typically used for MAC addresses?

Hard
189

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

Medium
190

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

Hard
191

Which of the following best describes the purpose of a REST API?

Easy
192

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

Hard
193

A 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?

Hard
194

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

Hard
195

Which TWO of the following are examples of security software? (Choose TWO.)

Easy
196

A 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?

Medium
197

A development team is adopting Scrum. Which TWO roles are defined in the Scrum framework? (Select the two correct answers.)

Medium
198

A 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?

Medium
199

A user wants to synchronize contacts, calendars, and photos between their Android smartphone and tablet. Which of the following methods would best accomplish this?

Medium
200

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

Medium
201

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

Hard
202

A 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?

Medium
203

A 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?

Hard
204

A 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?

Hard
205

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

Medium
206

An 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?

Medium
207

A 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?

Easy
208

Which of the following is a characteristic of a NoSQL database compared to a relational database?

Medium
209

A software development team is adopting agile practices. Which TWO of the following are common characteristics of agile methodologies? (Select TWO.)

Medium
210

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

Hard
211

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

Hard
212

A 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?

Medium
213

A 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?

Easy
214

A 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?

Medium
215

Which element of the CIA triad is primarily concerned with ensuring that data is not accessed by unauthorized individuals?

Easy
216

Which of the following is a characteristic of a worm in the context of malware?

Easy
217

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

Hard
218

A 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.)

Medium
219

Which of the following best describes a NoSQL database?

Easy
220

A user wants to upgrade their desktop computer's storage for faster boot times. Which of the following storage interfaces would provide the fastest performance?

Easy
221

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

Easy
222

A 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?

Medium
223

A 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?

Hard
224

A developer writes code in Python and runs it without compiling. This is an example of which type of language?

Medium
225

A 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.)

Medium
226

An 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.)

Hard
227

An 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?

Hard
228

Which TWO of the following are examples of system software?

Medium
229

A 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?

Easy
230

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

Easy
231

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

Easy
232

A 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?

Easy
233

An 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?

Hard
234

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

Easy
235

A programmer writes code to run a block of instructions repeatedly until a condition is met. Which programming concept is being used?

Medium
236

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

Medium
237

An 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?

Hard
238

Which TWO of the following are core phases of the Software Development Life Cycle (SDLC)?

Easy
239

A 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?

Hard
240

An organization uses a security model where users are granted the minimum permissions necessary to perform their job functions. This model is known as:

Hard
241

A 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?

Hard
242

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

Easy
243

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

Easy
244

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

Hard
245

A 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?

Easy
246

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

Medium
247

Which of the following describes a nibble?

Easy
248

A technician is configuring a new workstation for video editing. Which of the following expansion cards would be MOST beneficial for improving video rendering performance?

Medium
249

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

Medium
250

A 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?

Medium
251

A 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.)

Medium
252

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

Medium
253

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

Medium
254

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

Medium
255

An 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?

Medium
256

A 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?

Hard
257

During 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?

Hard
258

Which of the following is the decimal equivalent of the binary number 1101?

Easy
259

A 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?

Medium
260

A 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?

Easy
261

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

Hard
262

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

Medium
263

A user wants to install a free text editor on their Windows computer. Which file extension is most likely used for the installer?

Easy
264

A 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?

Medium
265

A 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?

Hard
266

A 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?

Hard
267

A 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?

Easy
268

Which of the following is an example of an absolute file path?

Medium
269

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

Easy
270

A 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?

Easy
271

A 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.)

Medium
272

A 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?

Easy
273

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

Easy
274

Which TWO of the following are characteristics of ransomware?

Medium
275

Which THREE of the following are effective methods to protect against malware infections? (Select THREE.)

Hard
276

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

Hard
277

An 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?

Hard
278

Match each operating system to its common environment.

Medium
279

A 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?

Medium
280

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

Hard
281

Which THREE of the following are best practices for password security?

Medium
282

A database administrator needs to perform CRUD operations on a database. Which THREE SQL commands correspond to the 'Create', 'Read', and 'Update' operations?

Hard
283

A 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?

Medium
284

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

Easy
285

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

Easy
286

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

Easy
287

A 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?

Medium
288

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

Hard
289

A 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?

Easy
290

Which software license allows a user to install the software on multiple computers for personal use?

Easy
291

Refer to the exhibit. A user executes: SELECT AVG(Salary) FROM Employees; What is the result?

Easy
292

A 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?

Medium
293

Which of the following is an example of an output device?

Easy
294

Which THREE of the following are valid SQL statements?

Hard
295

Which of the following best describes the 'Confidentiality' component of the CIA triad?

Easy
296

A 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?

Medium
297

A 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?

Medium
298

A technician is setting up a virtualized environment on a laptop to run multiple operating systems for testing. Which type of hypervisor is most appropriate?

Hard
299

A 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?

Medium
300

Which of the following best describes the principle of least privilege?

Easy
301

A 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.)

Hard
302

A 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?

Easy
303

A database designer is creating a table to store employee information. To ensure that each employee can be uniquely identified, which constraint should be applied?

Medium
304

Which type of malware is disguised as legitimate software but performs malicious actions?

Medium
305

A database administrator adds an index on the 'Email' column of a 'Users' table. What is a likely consequence?

Medium
306

A 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.)

Medium
307

A user notices that their computer runs slowly when multiple applications are open simultaneously. Which hardware component is most likely insufficient for the current workload?

Medium
308

Which programming data type would be used to store a value of 'True' or 'False'?

Medium
309

A 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?

Hard
310

A user is creating a report that includes several photographs. After saving, the file size is larger than expected. Which data type is primarily responsible?

Easy
311

A 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?

Easy
312

Refer to the exhibit. A user reports that a recent Windows update failed to install. Which action should the technician take FIRST?

Hard
313

A 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?

Easy
314

Based on the exhibit, which of the following best describes the file type?

Easy
315

Which TWO of the following are examples of social engineering attacks?

Medium
316

A 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?

Medium
317

Which of the following is the binary representation of the decimal number 10?

Easy
318

A 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?

Easy
319

A 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?

Easy
320

Consider the following algorithm: SET x = 5 SET y = 2 SET result = x ^ y OUTPUT result Assuming '^' is the exponentiation operator, what is the output?

Hard
321

Drag and drop the steps to connect a Bluetooth device to a Windows 10 computer into the correct order.

Medium
322

A user wants to purchase a new monitor for gaming. Which THREE specifications are most important for a smooth gaming experience?

Hard
323

A technician is recommending a device to protect a server from data loss during a power outage. Which device should the technician recommend?

Hard
324

A 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?

Easy
325

A 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?

Easy
326

A 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?

Medium
327

A 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?

Easy
328

An employee is working from a coffee shop and needs to access company files. Which of the following is the most secure method?

Medium
329

A 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?

Medium
330

Which of the following best describes the function of a web API?

Hard
331

A 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?

Hard
332

A bookstore owner wants to list all book titles stored in a table named Inventory, sorted alphabetically by title. Which SQL statement should be used?

Easy
333

A 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?

Easy
334

What is the difference between a threat and a vulnerability?

Easy
335

A 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?

Easy
336

A development team is using an agile methodology. Which TWO of the following are typical practices in agile development?

Medium
337

A 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?

Easy
338

Which type of malware replicates itself across a network without user interaction?

Hard
339

A 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?

Hard
340

A 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?

Medium
341

A technician is troubleshooting a computer that fails to boot. The technician suspects corrupted firmware. Which component stores the firmware that initializes hardware during boot?

Hard
342

A 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.)

Medium
343

A 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?

Medium
344

Which TWO of the following are advantages of server virtualization? (Select TWO.)

Easy
345

A 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?

Medium
346

Which device converts the signal from an ISP into a digital signal that a computer can use?

Medium
347

A 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?

Easy
348

A 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?

Medium
349

What is the binary representation of the decimal number 10?

Easy
350

A 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?

Easy
351

Which TWO of the following are types of optical disc storage? (Select exactly two.)

Easy
352

A programmer writes a loop that performs a bitwise AND operation between the byte 0b11001100 and the mask 0b00001111. What is the result in decimal?

Hard
353

A technician is explaining data representation to a trainee. Which TWO of the following are character encoding standards used in computing? (Select TWO).

Medium
354

A 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?

Hard
355

Which of the following is a benefit of using a database instead of a flat file?

Easy
356

A 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?

Hard
357

A 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?

Medium
358

Refer to the exhibit. A user can ping 192.168.1.1 but cannot ping 8.8.8.8. What is most likely the issue?

Easy
359

A 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).

Hard
360

Based on the exhibit, which device is directly responsible for separating traffic into VLAN10 and VLAN20?

Hard
361

A user wants to create a presentation with slides, animations, and speaker notes. Which application type should they use?

Easy
362

A 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?

Medium
363

Which of the following best describes the function of an operating system?

Medium
364

A developer wants to install a Linux application on a system that uses the Debian package manager. Which package format should the developer look for?

Hard
365

A 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?

Medium
366

Which of the following is an example of a PAN (Personal Area Network) technology?

Easy
367

Which TWO of the following are best practices for password security?

Easy
368

Which TWO of the following are common types of network cables used in wired Ethernet networks?

Easy
369

A company needs to store customer orders and ensure that each order is uniquely identified. Which database concept should be used?

Easy
370

A company uses a cloud database service where the provider automatically handles backups, patching, and scaling. This deployment model is known as:

Hard
371

Which of the following is an example of a NoSQL database that stores data as JSON-like documents?

Medium
372

Which TWO concerns are most critical when selecting a backup method? (Select exactly two.)

Medium
373

A 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?

Medium
374

A 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?

Hard
375

Which of the following is an example of a strong password?

Easy
376

A 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.)

Medium
377

Which TWO of the following are characteristics of a relational database? (Select TWO.)

Medium
378

A 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?

Medium
379

A 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.)

Hard
380

Drag and drop the steps to check for Windows Updates in Windows 10 into the correct order.

Medium
381

A database designer wants to ensure that no two employees have the same email address. Which constraint should be applied to the Email column?

Easy
382

A 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?

Medium
383

Which principle ensures that data is not modified by unauthorized users?

Easy
384

In 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?

Medium
385

A 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?

Easy
386

A company wants to ensure that data is not lost if a hard drive fails. Which of the following best practices should be implemented?

Easy
387

A 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?

Medium
388

A 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?

Hard
389

Which THREE are common steps in troubleshooting software issues?

Hard
390

A 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?

Medium
391

A 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?

Hard
392

Which TWO of the following are advantages of using a relational database over a NoSQL database? (Choose two.)

Easy
393

A 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?

Hard
394

A technician needs to verify that a twisted-pair Ethernet cable is wired correctly and has no breaks. Which tool should be used?

Easy
395

A user reports that the company's customer relationship management (CRM) application is slow after a recent network upgrade. What could be the cause?

Medium
396

A 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?

Medium
397

A 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?

Easy
398

A 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?

Medium
399

A 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?

Easy
400

A user needs to run a Windows application on a Mac. Which approach uses a hypervisor to create a separate environment?

Medium
401

A software developer writes code that stores sensitive user data. To comply with data protection regulations, which application-level security measure should be implemented?

Hard
402

A company wants to implement the principle of least privilege for its employees. Which TWO of the following actions align with this principle? (Choose TWO.)

Medium
403

A 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?

Hard
404

What is the decimal equivalent of the binary number 1101?

Easy
405

A 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?

Hard
406

A 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?

Medium
407

A small business is expanding and needs to ensure their network infrastructure supports growth. Which THREE practices should they implement?

Hard
408

A 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?

Medium
409

A technician is troubleshooting a computer that does not start. They suspect the BIOS may be corrupted. Which type of software is the BIOS?

Hard
410

A 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?

Easy
411

A 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?

Hard
412

A 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?

Hard
413

Which of the following is an example of lossy compression?

Medium
414

A 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?

Hard
415

Which of the following is an example of application software?

Easy
416

Two developers have edited the same file and created different versions. To integrate their changes, which Git operation should they perform?

Hard
417

A company is implementing a backup strategy. Which of the following best adheres to the 3-2-1 backup rule?

Hard
418

A 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?

Hard
419

A 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?

Easy
420

Based on the exhibit, what will be the last value output?

Easy
421

A 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?

Medium
422

Which 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?

Hard
423

A 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.)

Medium
424

Which THREE of the following are common methods for securing a wireless network?

Hard
425

Given 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

Medium
426

A 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?

Medium
427

Which of the following is an example of an input device?

Easy
428

A 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?

Medium
429

A developer is debugging a program that crashes with an error. Which THREE of the following are common debugging techniques?

Medium
430

A SELECT statement combines rows from two tables based on a related column. Which SQL clause is used to accomplish this?

Medium
431

A 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?

Easy
432

A 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?

Easy
433

A company implements a policy where employees must lock their computer screen when leaving their desk. Which security principle does this practice support?

Medium
434

Which SQL statement is used to retrieve all columns from a table named 'Customers' where the city is 'London'?

Easy
435

A small business wants to set up a wireless network. Which of the following is the BEST security method to use?

Easy
436

Drag and drop the steps to connect a laptop to a Wi-Fi network in Windows 10 into the correct order.

Medium
437

In a Scrum team, who is responsible for prioritizing the product backlog and ensuring that the team works on the most valuable features first?

Medium
438

A company needs to ensure that all employees can collaborate on documents in real time. Which type of software should the company choose?

Medium
439

A 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?

Hard
440

A 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?

Hard
441

A developer writes a query: SELECT * FROM Employees WHERE Department = 'Sales'. Which statement about this query is true?

Medium
442

A 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.)

Medium
443

A 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?

Medium
444

Which of the following is the best practice for backing up data according to the 3-2-1 rule?

Easy
445

A 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?

Easy
446

Based on the exhibit, which type of attack is most likely occurring?

Hard
447

A 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?

Easy
448

A 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?

Medium
449

A 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?

Medium
450

During the software development life cycle, which phase directly follows the coding phase?

Medium
451

A 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?

Easy
452

A 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?

Easy
453

Which of the following character encodings can represent characters from virtually all written languages?

Medium
454

A developer is learning version control. Which THREE of the following are core Git concepts? (Select 3)

Hard
455

An 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?

Hard
456

A student is converting the hexadecimal number 2F to decimal. What is the correct decimal value?

Medium
457

A 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?

Hard
458

A 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?

Medium
459

Which backup strategy involves keeping three copies of data on two different media types with one copy offsite?

Medium
460

Which of the following is a key difference between a vulnerability and a threat in cybersecurity?

Medium
461

A 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.)

Hard
462

A 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?

Medium
463

A user is selecting a web browser for everyday use. Which of the following is NOT a web browser?

Medium
464

Which cloud service model provides users with access to software applications over the internet without managing the underlying infrastructure?

Medium
465

Which of the following malware types is characterized by self-replication without needing to attach to a host file?

Medium
466

A software tester is verifying that individual functions within a module work correctly in isolation. Which type of testing is being performed?

Medium
467

A 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?

Hard
468

A 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?

Medium
469

A user wants to install software on a macOS computer. Which TWO file types are commonly used as installer packages on macOS? (Select TWO.)

Medium
470

A 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?

Easy
471

A 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?

Medium
472

Which THREE of the following are common file formats for images?

Hard
473

A 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?

Easy
474

A security analyst is explaining the difference between a threat and a vulnerability. Which statement accurately describes this difference?

Hard
475

A developer needs to visually represent the logic of a program, including decisions (yes/no branches) and processes. Which tool should the developer use?

Easy
476

A company wants to ensure that sensitive documents are not readable if a laptop is stolen. Which of the following provides the best protection?

Medium
477

Which TWO data types are considered unstructured? (Select exactly two.)

Easy
478

A 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?

Easy
479

A user is unable to open a .docx file. The user has the correct application installed. Which of the following is the MOST likely cause?

Easy
480

Which TWO of the following are recommended practices for physical security in an office environment? (Select two.)

Easy
481

A user wants to connect a Bluetooth keyboard to a tablet. What is the first step the user must perform to establish the connection?

Medium
482

A company wants to ensure that if one hard drive fails, no data is lost. Which RAID level should be implemented?

Medium
483

A 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?

Easy
484

Refer to the exhibit. PC1 (192.168.1.10) cannot communicate with PC2 (192.168.2.10). What is the most likely cause?

Hard
485

Which of the following best describes the function of a DNS server?

Easy
486

A 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?

Easy
487

A 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?

Hard
488

Which TWO of the following are characteristics of a client-server network?

Easy
489

A 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?

Hard
490

Based on the exhibit, what is the most likely cause of the error?

Medium
491

A 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?

Easy
492

A 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?

Medium
493

A 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:

Hard
494

A technician needs to identify a network interface on a device. Which notational system is most commonly associated with MAC addresses?

Easy
495

An 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?

Hard
496

An 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?

Hard
497

Which THREE of the following are examples of multi-factor authentication? (Select three.)

Hard
498

A user needs to store customer information including name, address, and order history. Which database type is most appropriate?

Easy
499

Refer 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?

Medium
500

Which TWO of the following are examples of popular relational database management systems (RDBMS)? (Select TWO.)

Medium
501

Which of the following units represents the largest amount of data?

Easy
502

A server has four hard drives configured in RAID 5. One drive fails. What must the technician do to restore full redundancy?

Hard
503

A user wants to ensure data confidentiality. Which action is most appropriate?

Easy
504

A 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.)

Hard
505

Refer to the exhibit. What is the purpose of the 'no shutdown' command in this router configuration?

Medium
506

A 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?

Hard
507

A company is choosing between public, private, and hybrid cloud deployments. Which TWO statements correctly describe characteristics of these cloud models? (Select TWO.)

Medium
508

An 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?

Medium
509

Which TWO of the following are examples of NoSQL database types?

Medium
510

A 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?

Medium
511

During 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:

Hard
512

A user wants to install a program on their Ubuntu Linux system. Which TWO file extensions are commonly used for Linux installer packages? (Select TWO.)

Medium
513

A 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.)

Hard
514

A 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?

Easy
515

Which device is used to connect multiple devices within the same network segment and forward data based on MAC addresses?

Easy
516

A 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.

Easy
517

Which network device converts the signal from an Internet Service Provider (ISP) into a digital signal that a home network can use?

Easy
518

A user needs to edit a video file for a presentation. Which type of application is most suitable?

Easy
519

A user wants to sync their contacts and calendar between their Android phone and tablet. Which method is most commonly used?

Hard
520

A developer writes code in C++ and must convert it to machine code before execution. This process is called:

Hard
521

Which TWO of the following are examples of operating systems?

Easy
522

A 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?

Hard
523

A company is choosing collaboration software. Which TWO of the following are examples of collaboration applications? (Select 2)

Medium
524

An 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?

Easy
525

A 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?

Easy
526

A 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?

Medium
527

An IT administrator is hardening a server. Which three of the following actions should be taken to improve security? (Select THREE.)

Hard
528

A 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?

Hard
529

A 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?

Hard
530

An organization adopts the 3-2-1 backup rule. Which of the following practices aligns with this rule?

Medium
531

Which TWO of the following are features of productivity software?

Easy
532

A 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?

Medium
533

A network administrator wants to automatically assign IP addresses to all devices on the network. Which service should be configured on the server?

Medium
534

An 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?

Hard
535

A 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?

Medium
536

A 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.)

Medium
537

Which TWO of the following are examples of database management systems (DBMS)?

Easy
538

A 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?

Hard
539

A 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?

Hard
540

Which of the following is a characteristic of a strong password?

Easy
541

Refer 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?

Hard
542

A database administrator needs to retrieve, update, and delete records from a customer table. Which THREE SQL commands are required? (Select THREE.)

Hard
543

A 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?

Medium
544

A 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.)

Easy
545

Which THREE of the following are common types of computer networks? (Select three.)

Medium
546

A 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?

Hard
547

A 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?

Hard
548

A 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?

Easy
549

Which THREE of the following are common features of word processing applications?

Hard
550

A user receives an error message indicating 'insufficient memory' when opening several applications. Which action will most likely resolve the issue?

Medium
551

Which of the following is a primary advantage of using a database instead of a flat file system?

Easy
552

A 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?

Easy
553

A 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?

Easy
554

A 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?

Hard
555

Which TWO of the following are benefits of using a cloud database service (DBaaS) over an on-premises database?

Medium
556

A 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?

Easy
557

Which THREE of the following are examples of social engineering attacks?

Easy
558

Which TWO of the following are examples of open-source software licenses?

Medium
559

A 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?

Hard
560

A 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?

Medium
561

Which TWO of the following are types of cloud computing service models?

Medium
562

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

Hard
563

Which TWO of the following are examples of physical security controls?

Easy
564

Drag and drop the steps to boot a computer into Safe Mode in Windows 10 into the correct order.

Medium
565

Which TWO of the following are examples of output devices?

Easy
566

A 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?

Medium
567

A technician is converting the decimal number 255 to binary. Which binary value is correct?

Medium
568

A 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:

Hard
569

A 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?

Medium
570

A 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?

Hard
571

A user wants to save a photo with the highest quality but does not care about file size. Which file format should they use?

Medium
572

Which of the following types of networks covers the largest geographical area?

Easy
573

A 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?

Easy
574

A 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?

Hard
575

A technician is troubleshooting a computer that will not power on. Which of the following should be checked FIRST?

Medium
576

A 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?

Hard
577

In Git, which action creates a snapshot of changes in the repository?

Hard
578

Which SQL statement is used to retrieve all columns from a table named 'Employees'?

Easy
579

A 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?

Medium
580

Which THREE of the following are best practices for database security?

Hard
581

Which THREE are common types of network cables? (Select exactly three.)

Easy
582

A 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?

Hard
583

A 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).

Medium
584

A programmer needs to store a true/false value. Which data type is most appropriate?

Medium
585

A 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?

Medium
586

A 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?

Hard
587

A 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:

Medium
588

A user reports that their computer is running slowly. Which of the following is the MOST likely cause?

Easy
589

A 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?

Hard
590

A 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?

Medium
591

A 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?

Hard
592

A 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?

Hard
593

A system administrator needs to automatically assign IP addresses to devices on the network. Which protocol should be configured on the server?

Hard
594

Which TWO of the following are advantages of using a relational database management system (RDBMS) over a file-based system?

Medium
595

A small business needs to share files among employees within the same building. Which network topology is most efficient for this scenario?

Medium
596

Refer to the exhibit. A technician notices high CPU usage from a process called 'svchost.exe'. What is the most appropriate action?

Medium
597

Refer 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?

Medium
598

A user wants to ensure software is legitimate and free from malware before installation. Which THREE of the following are recommended practices?

Hard
599

Which of the following is an input device?

Easy
600

Which TWO of the following are advantages of using a virtual private network (VPN) for remote employees?

Medium
601

Which device converts the signal from an ISP (e.g., cable or fiber) into a digital signal that a home network can use?

Medium
602

A technician is diagnosing performance issues in a wireless network. Users report intermittent slowdowns. Which of the following is the MOST likely cause?

Hard
603

A programmer is using a version control system. Which THREE are core Git concepts?

Hard
604

A 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?

Hard
605

A 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?

Hard
606

A 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?

Medium
607

A 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?

Hard
608

Which THREE are valid primitive data types in most programming languages? (Choose three.)

Hard
609

A 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.)

Hard
610

A 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?

Easy
611

Which programming concept allows a program to make decisions based on conditions, such as checking if a user is logged in?

Medium
612

Which type of software provides an interface for users to interact with the computer's hardware?

Easy
613

A user is trying to access a website but receives a 'DNS server not responding' error. Which of the following is the MOST likely cause?

Medium
614

A 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?

Medium
615

Which TWO of the following are common file formats for images?

Medium
616

A 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?

Medium
617

A 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?

Medium
618

A 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?

Hard
619

A 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?

Hard
620

A 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?

Medium
621

In a relational database, a foreign key in the 'Enrollments' table references the primary key of the 'Students' table. What does this relationship primarily enforce?

Medium
622

A 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?

Easy
623

A support technician is explaining file compression to a user. Which THREE of the following are examples of lossless compression formats? (Select THREE).

Hard
624

A 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.)

Medium
625

A 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.)

Medium
626

A developer is writing a program in C++. The source code needs to be translated into machine code before execution. Which process is required?

Hard
627

A 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?

Medium
628

A 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?

Hard
629

Which of the following file extensions indicates a document created with Microsoft Word?

Easy
630

Refer to the exhibit. What does this event log entry indicate?

Easy
631

A 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?

Medium
632

A 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?

Easy
633

A user notices that a file saved as a JPEG is smaller than the original BMP file. Which type of compression does JPEG typically use?

Medium
634

A 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:

Medium
635

Which TWO of the following are types of malware?

Easy
636

Which TWO of the following are primitive data types commonly used in programming?

Easy
637

An employee receives an email from 'IT Support' asking for his password due to 'system maintenance'. This is an example of:

Medium
638

A user needs to create a presentation for a sales meeting. Which type of software should they use?

Easy
639

A 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?

Hard
640

A 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?

Easy
641

Which THREE of the following are characteristics of object-oriented programming (OOP)? (Select THREE).

Hard
642

A 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?

Easy
643

A user wants to upgrade their workstation's storage without losing existing data. Which of the following is the BEST method?

Medium
644

A 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):

Hard
645

A 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?

Hard
646

Which of the following is the best practice for creating a strong password?

Easy
647

Which TWO of the following are examples of social engineering attacks? (Select TWO.)

Medium
648

A user connects to a website using its domain name. Which server translates that domain name into an IP address?

Hard
649

A developer is using Git and wants to integrate changes from a feature branch into the main branch. Which Git operation should be performed?

Hard
650

After a ransomware attack, which step should be taken FIRST in the incident response process?

Hard
651

Which of the following is a key difference between a web application and a desktop application?

Medium
652

A 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?

Easy
653

An 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?

Hard
654

A 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?

Medium
655

A programmer is writing code that needs to repeat a block of instructions 10 times. Which programming construct is best suited for this task?

Medium
656

A graphic designer needs a component to accelerate rendering of 3D models. Which of the following computer hardware components is specifically designed for this purpose?

Medium
657

An IT administrator needs to install software on multiple company computers without user interaction. Which installation method should the administrator use?

Medium
658

Which THREE of the following are types of data integrity enforced in relational databases?

Medium
659

A 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?

Hard
660

A user wants to ensure data is not lost in the event of a drive failure. Which storage configuration provides redundancy?

Medium
661

Which of the following is an example of something you are in multi-factor authentication?

Medium
662

Which of the following is a valid reason to use a database instead of a spreadsheet?

Easy
663

Which of the following best describes the principle of confidentiality in the CIA triad?

Easy
664

A user's laptop battery no longer holds a charge and the laptop only works when plugged in. Which component should be replaced?

Easy
665

Which 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?

Easy
666

You 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?

Hard
667

A developer writes the following pseudocode: for i = 1 to 5, sum = sum + i. What does this code do?

Easy
668

A database administrator needs to ensure that a transaction either fully completes or is fully rolled back. Which database property guarantees this?

Medium
669

A company wants to manage and secure employee smartphones used for work. Which technology should they implement?

Medium
670

A 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?

Medium
671

Which THREE of the following are productivity software suites?

Medium
672

A 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?

Medium
673

Which of the following best describes the function of a CPU cache?

Medium
674

A 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?

Medium
675

A 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?

Medium
676

A 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?

Medium
677

A 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?

Medium
678

A programmer declares a variable 'price' and assigns it the value 19.99. In most programming languages, what is the data type of this variable?

Hard
679

Which TWO of the following are types of software licenses? (Select TWO).

Medium
680

A 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?

Medium
681

You 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?

Medium
682

A user needs to edit a PDF file that was received as an attachment. What type of application is required?

Easy
683

A 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?

Hard
684

A technician is explaining the difference between volatile and non-volatile memory. Which of the following is an example of volatile memory?

Easy
685

An IT administrator applies the software restriction policy shown in the exhibit. What is the intended effect of this policy?

Hard
686

A 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?

Medium
687

A 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?

Easy
688

A 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:

Hard
689

A 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?

Easy
690

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

Hard
691

A 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?

Medium
692

A network administrator wants to restrict access to the wireless network to only approved devices. Which security feature should be enabled on the access point?

Hard
693

A user wants to install software on a Linux system. Which file types are most commonly used for installing applications?

Easy
694

A 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.)

Medium
695

A 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?

Medium
696

Drag and drop the steps to create a new folder on the desktop in Windows 10 into the correct order.

Medium
697

Which file system is commonly used on external USB drives for compatibility between Windows and macOS?

Easy
698

A user wants to open a PDF file but receives an error that no application is associated. Which action should the user take?

Easy
699

A user cannot connect to the internet. Which step is most appropriate to start troubleshooting?

Easy
700

A database table contains redundant employee data, leading to update anomalies. Which database design process should be applied to resolve this?

Medium
701

Which of the following is a characteristic of a worm compared to a virus?

Hard
702

A 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.)

Hard
703

A 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?

Medium
704

Which of the following cloud service models is correctly paired with its description?

Medium
705

A 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?

Hard
706

Which THREE are phases of the software development life cycle? (Choose three.)

Easy
707

A 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?

Medium
708

Which TWO of the following are characteristics of the Agile software development methodology?

Medium
709

A company needs to connect two separate local area networks (LANs) in different buildings. Which device is required to route traffic between the networks?

Hard
710

A 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.)

Medium
711

A developer is using Git for version control. Which THREE actions are core Git operations? (Select THREE.)

Hard
712

Which TWO of the following are types of desktop applications?

Easy
713

A 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?

Hard
714

A small business needs to share documents among employees and allow real-time collaboration. Which type of application is best suited?

Medium
715

A programmer needs to represent the logic of a program that includes decisions and loops. Which tool is most suitable for visually representing this logic?

Medium
716

A 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?

Medium
717

A 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.)

Medium
718

A 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?

Medium
719

A 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?

Medium
720

A company wants to store product catalogs that vary in structure (different attributes per product). Which type of database is best suited?

Easy
721

A 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?

Easy
722

A 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?

Medium
723

A 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?

Medium
724

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

Easy
725

A 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?

Easy
726

A 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?

Easy
727

A 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?

Hard
728

In a database, which SQL statement is used to add new records to a table?

Medium
729

A 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?

Hard
730

A developer needs to repeat a set of instructions exactly 10 times. Which programming construct should be used?

Easy
731

A 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?

Medium
732

A 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?

Easy
733

A 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?

Easy
734

Which of the following is the binary representation of the decimal number 5?

Easy
735

A 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?

Hard
736

Which file extension is typically associated with a compressed archive?

Easy
737

A user wants to remove a record from a database table. Which SQL command should be used?

Medium
738

A 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?

Hard
739

Which THREE of the following are examples of Infrastructure as a Service (IaaS) offerings? (Select THREE.)

Hard
740

A small business wants to connect its computers to share files and printers. Which of the following network devices would BEST facilitate this?

Medium
741

A 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?

Medium
742

A 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?

Medium
743

A 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?

Hard
744

A 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?

Medium
745

A company is deploying software to multiple workstations without user interaction. Which TWO installation methods are considered silent installations?

Medium
746

A 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?

Medium
747

A 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?

Medium
748

A network technician is setting up a wireless network. To minimize interference from neighboring networks, which wireless frequency band is typically less congested?

Medium
749

A 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?

Medium
750

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

Easy
751

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

Easy
752

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

Medium
753

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

Easy
754

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

Medium
755

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

Medium
756

A 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?

Medium
757

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

Hard
758

Which of the following best describes a web application?

Medium
759

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

Medium
760

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

Easy
761

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

Easy
762

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

Medium
763

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

Medium
764

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

Easy
765

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

Easy
766

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

Medium
767

A 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?

Easy
768

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

Medium
769

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

Easy
770

A junior administrator is learning about database fundamentals and needs to identify characteristics that apply to a relational database management system (RDBMS). (Choose two.)

Medium
771

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

Easy
772

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

Hard
773

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

Hard
774

A 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?

Medium
775

What is the primary purpose of a firewall?

Medium
776

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

Easy
777

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

Hard
778

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

Easy
779

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

Medium
780

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

Medium
781

A 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?

Easy
782

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

Medium
783

A 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?

Easy
784

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

Easy
785

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

Easy
786

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

Hard
787

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

Hard
788

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

Hard
789

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

Medium
790

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

Easy
791

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

Medium
792

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

Medium
793

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

Easy
794

A 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.)

Medium
795

An 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?

Medium
796

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

Medium
797

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

Hard
798

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

Medium
799

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

Easy
800

A 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?

Medium
801

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

Hard
802

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

Medium
803

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

Medium
804

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

Easy
805

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

Medium
806

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

Easy
807

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

Medium
808

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

Hard
809

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

Medium
810

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

Medium
811

A 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?

Medium
812

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

Medium
813

A 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?

Hard
814

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

Easy
815

A 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?

Medium
816

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

Easy
817

A 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?

Easy
818

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

Hard
819

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

Easy
820

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

Hard
821

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

Medium
822

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

Medium
823

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

Easy
824

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

Medium
825

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

Easy
826

A 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?

Medium
827

A user wants to ensure that a document cannot be edited by others. Which file property should be set?

Easy
828

Which TWO of the following are examples of high-level programming languages? (Select TWO).

Medium
829

Refer 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?

Hard
830

A 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?

Hard
831

A database administrator needs to add a new customer record to the 'customers' table. Which SQL statement should they use?

Medium
832

A 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?

Medium
833

A 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?

Medium
834

A 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?

Medium
835

A 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?

Medium
836

Refer 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?

Medium
837

A 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?

Easy
838

A database administrator wants to enforce that a column only accepts whole numbers. Which data type should be used?

Easy
839

A 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?

Hard
840

A 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.)

Hard
841

An organization wants to ensure that employees only have access to the data necessary to perform their job functions. Which principle should be applied?

Medium
842

A 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?

Easy
843

A 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?

Hard
844

A 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.)

Medium
845

A 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?

Medium
846

A developer is debugging a program that is producing incorrect output. Which of the following are common debugging techniques? (Choose three.)

Hard
847

A user is trying to install software from an .msi file on a Windows computer. What is the most likely purpose of an .msi file?

Medium
848

A 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?

Easy
849

A 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?

Medium
850

A 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?

Easy
851

A 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.)

Hard
852

A 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?

Easy
853

A junior administrator is reviewing a database schema and must identify which statements about primary keys and foreign keys are accurate. (Choose two.)

Hard
854

A graphic designer needs to create vector logos that can be scaled without losing quality. Which software category is most appropriate?

Medium
855

Which of the following is an example of a lossy compression format?

Medium
856

A 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?

Medium
857

A 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?

Hard
858

A 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?

Hard
859

Which TWO of the following are examples of multi-factor authentication? (Choose TWO.)

Medium
860

A 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.)

Hard
861

A 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?

Medium
862

Which THREE of the following are characteristics of a relational database?

Hard
863

A database designer wants to split a table into two to reduce data redundancy and avoid update anomalies. This process is known as:

Medium
864

A 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?

Easy
865

A user wants to retrieve all records from a table named 'Products' where the price is greater than 100. Which TWO SQL statements will work?

Easy
866

Which TWO of the following are effective methods to help secure a wireless network from unauthorized access?

Hard
867

A 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?

Hard
868

A 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?

Medium
869

A 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?

Medium
870

Which of the following software licenses allows users to modify and redistribute the source code, provided they keep the same license terms?

Easy
871

Which TWO of the following are types of malware? (Select TWO)

Easy
872

A 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?

Hard
873

Drag and drop the steps to change the desktop background in Windows 10 into the correct order.

Medium
874

A user is evaluating database concepts while building a small inventory system. Which TWO statements accurately describe a relational database? (Choose two.)

Medium
875

Drag and drop the steps to open the Task Manager in Windows 10 into the correct order.

Medium
876

Which SQL statement would you use to retrieve the names of all products with a price greater than $50 from a table named 'Products'?

Hard
877

A company wants to implement a private network for devices within a single building. Which type of network should they use?

Hard
878

An 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?

Hard
879

An employee wants to add a new customer record to the 'Customers' table with columns 'ID', 'Name', and 'Email'. Which SQL statement should be used?

Medium
880

A system administrator is evaluating antivirus software for company computers. Which TWO features are most important for protecting against malware? (Select TWO.)

Medium
881

A 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?

Medium
882

A user wants to edit a document collaboratively with multiple team members in real-time. Which type of application should they use?

Easy
883

A 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?

Medium
884

A 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?

Medium
885

In which phase of the Software Development Life Cycle (SDLC) are the system requirements gathered and analyzed?

Easy
886

Match each network protocol to its well-known port number.

Medium
887

A 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?

Easy
888

A 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?

Hard
889

A 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?

Medium
890

A 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?

Hard
891

A 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?

Easy
892

A 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?

Medium
893

A 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?

Easy
894

A technician is explaining the difference between lossy and lossless compression to a colleague. Which of the following file formats uses lossy compression?

Medium
895

A 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?

Hard
896

A 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?

Medium
897

A 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?

Medium
898

Which of the following is the correct file extension for a macOS installer package?

Easy
899

A 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?

Medium
900

A user wants to upgrade their desktop computer to faster storage. Which of the following storage interfaces provides the highest data transfer speeds?

Easy
901

A 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.)

Hard
902

You 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?

Easy
903

A technician is deploying a software update to 200 computers in a domain. To avoid user interaction, which installation method should be used?

Medium
904

A 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?

Medium
905

Refer to the exhibit. A developer wrote this BASIC program. What will happen if the user presses Enter without typing a name?

Medium
906

A 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?

Hard
907

A 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?

Medium
908

A company wants to ensure that data on lost laptops cannot be accessed. Which technology should be used?

Medium
909

A 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?

Medium
910

A university database includes tables: 'Professors' (ProfessorID, Name, Department) and 'Courses' (CourseID, Title, ProfessorID). Which THREE statements about this design are correct?

Hard
911

A 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.)

Medium
912

A 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?

Hard
913

A 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?

Medium
914

An 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?

Medium
915

A 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?

Easy
916

Match each storage type to its description.

Medium
917

During 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?

Hard
918

A web application constructs SQL queries by concatenating user input directly. What is the primary security risk?

Easy
919

Which TWO factors should be considered when choosing a software license?

Medium
920

A software license allows users to use the software for a limited time before purchasing. This is an example of which license type?

Hard
921

Which TWO of the following are characteristics of a client-server network? (Choose two.)

Medium
922

A 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?

Medium
923

An 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.)

Medium
924

Which TWO of the following are examples of interpreted programming languages?

Easy
925

A user reports that their computer is slow. Which of the following is the BEST first step to troubleshoot?

Easy
926

A program crashes with a 'division by zero' error. Which of the following is the most likely cause?

Medium
927

A user needs to install a new graphics editing application on a Windows computer. Which file extension is most likely associated with the installer?

Easy
928

A 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.)

Hard
929

A 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?

Hard
930

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

Medium
931

A 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?

Easy
932

A 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?

Easy
933

A 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?

Medium
934

Which THREE of the following are valid database integrity constraints?

Hard
935

A 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?

Medium
936

A 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.)

Easy
937

An 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?

Medium
938

A 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.)

Hard
939

An organization needs to run multiple operating systems on a single physical server to isolate development environments. Which virtualization technology should they use?

Hard
940

A 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?

Medium
941

A 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.)

Medium
942

A 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?

Medium
943

A 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?

Hard
944

An employee is tailgated into a secure office building by someone without a badge. Which type of security threat does this represent?

Medium
945

A user wants to access a file located in a subdirectory relative to the current working directory. Which type of path is being used?

Medium
946

A 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.)

Hard
947

Which TWO of the following are examples of application software? (Select TWO).

Easy
948

A 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?

Hard
949

Which THREE of the following are common troubleshooting steps? (Select THREE).

Hard
950

Which of the following is the result of the binary operation 1101 AND 1011?

Hard
951

A developer notices that an application runs slowly when processing large files. Which optimization technique is most likely to improve performance?

Medium
952

A company needs to store an organizational chart showing reporting relationships. Which database model is most appropriate?

Easy
953

A 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.)

Hard
954

Which of the following is an example of a NoSQL database?

Medium
955

A user runs a query on a database table and notices that the results contain duplicate rows. Which SQL keyword would eliminate these duplicates?

Easy
956

A 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?

Medium
957

An 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?

Hard
958

Which of the following is the binary result of the AND operation on 1010 and 1110?

Easy
959

A 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?

Medium
960

Refer to the exhibit. What is the most likely cause of the application crash?

Easy
961

A company's IT policy requires that all corporate smartphones be remotely wiped if lost. Which technology enables this capability?

Hard
962

A 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?

Easy
963

Which TWO of the following are open-source licenses? (Select 2)

Medium
964

A company needs to manage and secure a fleet of employee smartphones used for work. Which technology should they implement?

Medium
965

Refer 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?

Medium
966

A 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?

Medium
967

A 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?

Hard
968

A company wants to secure its wireless network. Which of the following is the BEST practice?

Medium
969

A user wants to install an application on an Android smartphone. Which app store should they use?

Medium
970

An employee needs to create a chart showing quarterly sales data for a presentation. Which of the following types of applications should the employee use?

Medium
971

A 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?

Medium
972

Which of the following character encoding standards supports characters from most of the world's languages and uses a variable number of bytes per character?

Medium
973

Which of the following RAM types is the fastest and most recent?

Easy
974

A 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?

Hard
975

Which of the following is a primary advantage of using a database over a flat file system for storing customer records?

Easy
976

A 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?

Medium
977

A 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?

Easy
978

Which of the following is a valid SQL statement to retrieve all records from a table named 'Employees'?

Easy
979

A 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?

Medium
980

A security analyst is explaining the CIA triad to new employees. Which scenario best illustrates a breach of integrity?

Hard
981

A 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?

Hard
982

A 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.)

Hard
983

A technician is explaining data storage to a customer. Which of the following best describes the difference between a bit and a byte?

Medium
984

Which data structure is best for storing a collection of key-value pairs?

Medium
985

Which of the following is an example of open-source software license?

Easy
986

After 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?

Hard
987

A user wants to create a backup of important files stored on a hard drive. Which type of application is most appropriate for this task?

Easy
988

A user wants to synchronize contacts and calendar events between their Android smartphone and tablet. Which service is MOST likely used for this synchronization?

Medium

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.