troubleshooting

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

A software developer is using an integrated development environment (IDE) to write a Python script that processes a CSV file containing customer data. The script uses a for loop to iterate over rows and calculates a total purchase amount. When the developer runs the script, it throws an error: "IndexError: list index out of range". The developer suspects the error occurs when the script tries to access a column that doesn't exist in some rows. Which debugging strategy should the developer use first to isolate the issue?

Which two of the following are types of malware? (Choose two.)

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

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

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

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?

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?

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?

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

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

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

A small office uses a single ISP-provided modem/router combination device. Employees need to connect their desktops and printers to the network. Which of the following devices would allow them to connect multiple wired devices and also extend wireless coverage?

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

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

Refer to the exhibit. This JSON policy is associated with a user. Which of the following actions is the user permitted to perform?

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

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?

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

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?

Which of the following is the best practice for creating strong passwords?

Refer to the exhibit. A user runs the query but gets no results, even though there are employees in the Sales department. Which of the following is the most likely cause?

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

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

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?

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?

A network technician needs to perform a bitwise AND operation on two binary numbers: 10110110 and 11001101. What is the result in decimal?

A user wants to remove a program that is no longer needed from a Windows computer. Which of the following is the correct method?

A report requires data from two tables: Customers and Orders. Which SQL clause is used to combine rows from both tables based on a related column?

What is the primary purpose of a password manager?

Based on the exhibit, which commit introduced the password validation fix?

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

A small business is experiencing intermittent network connectivity issues. Employees report that every few hours, the internet connection drops for about five minutes and then returns. The network uses a cable modem connected to a wireless router. The router logs show that the WAN interface renegotiates its connection around the same times. Which of the following is the MOST likely cause?

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

Which of the following best describes normalization in a relational database?

What is the output of the pseudocode in the exhibit?

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?

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

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?

A company is deploying a virtualization server to run multiple application servers. Which THREE resources are typically allocated to a virtual machine?

You are the IT administrator for a small accounting firm with 25 employees. The firm uses a Windows Server 2019 domain controller, a file server, and an email server running Microsoft Exchange. Each employee has a company-issued laptop running Windows 10. The firm recently experienced a ransomware attack that encrypted all files on the file server. The attacker demanded a ransom in Bitcoin. The firm restored the files from a backup that was taken the previous night. However, the CEO is concerned about future attacks and wants to implement additional security measures. The firm has a limited budget and cannot afford a full security suite. Which of the following is the BEST course of action to reduce the risk of another ransomware infection?

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?

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?

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

A technician is configuring a new computer for a graphic designer who needs to process large images. Which hardware component should be upgraded to improve performance?

You are the IT security administrator for a mid-sized law firm that handles sensitive client data. The firm has a mix of Windows 10 workstations, a Windows Server 2019 domain controller, and a network printer. All users have standard user accounts. The senior partner recently received a phishing email that appeared to be from a known client, requesting that he click a link to review a document. He clicked the link and entered his domain credentials on a fake login page. Shortly after, the firm's file server began encrypting files and displaying a ransom note. The incident response team isolated the infected server and restored files from backup. However, the senior partner now reports that he cannot access the file server from his workstation. He receives an 'Access Denied' message. You check his account in Active Directory and find that his account is not locked out and the password is correct. The file server is back online and accessible by other users. You verify that the senior partner's workstation has network connectivity and can ping the file server. Which of the following is the MOST likely cause of the access issue?

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?

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

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

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

Drag and drop the steps to shut down a Windows 10 computer properly into the correct order.

Which of the following is an example of system software?

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

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

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

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

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

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?

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

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

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?

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?

Which file extension typically indicates a compressed archive in Windows?

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?

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

Match each cable type to its typical use.

A hospital uses a legacy application that runs on a Windows 7 workstation. The application stores patient data in a local database. The IT department is migrating all workstations to Windows 10. The legacy application is not compatible with Windows 10. The hospital needs to continue using the application and ensure patient data is accessible from the new workstations. The application requires a dedicated workstation due to licensing. Which solution should the IT department implement?

A user can access the internet and other computers on the network but cannot print to a network printer that is on the same subnet. The printer's IP is 192.168.1.100. What is the most likely cause?

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

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

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?

Match each security concept to its definition.

What is the primary purpose of a network firewall?

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

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

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?

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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 suspects it is a phishing attempt. Which type of phishing attack is this most likely to be?

A software testing team is planning to verify a new e-commerce application. Which THREE testing types should be performed to ensure comprehensive quality? (Select the three correct answers.)

Which of the following is the strongest password?

A software team is adopting agile practices. They want to ensure they incorporate feedback early and often. Which TWO of the following are key events in the Scrum framework that provide opportunities for feedback and inspection?

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?

Which coding best practice improves code readability and maintainability?

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?

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?

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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?

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

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?

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

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

Which of the following port types is commonly used to connect a modern external hard drive to a computer and supports data transfer speeds up to 10 Gbps?

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

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

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

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

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

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?

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

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

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

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

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

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?

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

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?

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

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

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

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

Which of the following best describes a NoSQL database?

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?

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

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

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

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

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?

Which TWO of the following are examples of system software?

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

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

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

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

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

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?

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

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

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?

An online store uses a relational database with tables: Customers, Orders, and Products. Which of the following are valid ways to query the database structure? (Select THREE.)

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?

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

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?

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

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

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?

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

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

A user wants to transfer files from a smartphone to a laptop. The smartphone supports USB-C with USB 3.0, and the laptop has both USB-A and USB-C ports. Which cable type is most appropriate for maximum transfer speed?

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

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

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

Which of the following describes a nibble?

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?

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

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?

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

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

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

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?

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?

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

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?

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

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

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

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?

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

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

A user is looking for a cloud-based suite of applications that includes word processing, spreadsheets, and email, and allows real-time collaboration with colleagues. Which of the following best meets these requirements?

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?

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

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

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

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?

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

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

Which TWO of the following are characteristics of ransomware?

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

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

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

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?

Match each operating system to its common environment.

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?

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

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

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

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

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?

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?

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

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

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?

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

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

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

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

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?

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

Which THREE of the following are valid SQL statements?

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

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?

A company needs to store customer orders, where each order can contain multiple items. Which database design is most appropriate?

A user wants to share a large video file with colleagues. Which THREE methods are appropriate? (Choose THREE.)

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?

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?

Which TWO are characteristics of a network switch? (Select exactly two.)

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?

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

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

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?

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

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

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?

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

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?

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?

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?

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

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

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

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?

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

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

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?

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?

Refer to the exhibit. A technician is troubleshooting a connectivity issue. The user can access local resources but cannot reach the internet. Based on the output, what is the most likely cause?

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

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

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

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?

A database contains a table 'Orders' with columns OrderID, CustomerID, OrderDate, and TotalAmount. Which THREE SQL statements will correctly insert a new row into the table? (Choose THREE.)

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?

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?

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

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?

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

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?

What is the difference between a threat and a vulnerability?

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?

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

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

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?

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?

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?

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

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

What is the binary representation of the decimal number 10?

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

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?

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

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?

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

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?

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?

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

A technician is building a new desktop computer for a user who needs to edit large video files. Which type of RAM should the technician recommend for dual-channel performance?

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

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

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?

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

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?

Refer to the exhibit. A security analyst reviews the NTFS permissions on the C:\Shared folder. Which user or group has the ability to delete files created by other users?

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?

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

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

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

Which security threat is indicated in the exhibit?

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

Refer to the exhibit. Which type of license does Acme Corp hold?

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

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

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

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?

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?

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

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

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

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

A technician is setting up a small office network with five workstations and a file server. Which TWO of the following are essential hardware components for this network to function? (Select TWO).

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

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?

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

A user downloads a free application from the internet that offers full functionality for a 30-day period. After 30 days, the user must pay to continue using it. Which license type does this describe?

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?

A user is experiencing slow performance and wants to upgrade their computer's RAM. Which TWO factors should they consider when purchasing new RAM? (Choose two.)

Which THREE are common steps in troubleshooting software issues?

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?

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

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?

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

Match each network type to its description.

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

A user reports that a SELECT query on a large table with millions of records is very slow. The table has no indexes. Which index type would most likely improve the performance of equality searches (e.g., WHERE id = 100)?

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?

Refer to the exhibit. A computer displays this error during startup. Which component is most likely the cause of the issue?

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

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

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

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?

What is the decimal equivalent of the binary number 1101?

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?

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

Which TWO of the following are common characteristics of object-oriented programming languages?

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

A technician is setting up a small office network with 10 computers and one printer. The network should allow devices to communicate with each other and share the printer. Which TWO of the following components are essential?

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?

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?

A developer is troubleshooting a program that produces unexpected results. The code includes a loop that repeats 10 times but the output shows only 9 values. Which debugging step should be taken first?

Which of the following is an example of lossy compression?

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?

Which of the following is an example of application software?

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

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

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?

A company's IT department is developing a new internal tool to track employee leave requests. The development team is using a waterfall model. After the requirements phase, they create a detailed design document. During implementation, a key stakeholder requests a new feature that requires a change to the database schema. The team is reluctant to accommodate the change because they have already started coding. Which approach should the team take to best handle this situation while adhering to the waterfall model?

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

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?

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

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

A user reports that a previously working word-processing application now crashes immediately after launch. The user has not installed any new software recently. Which of the following should the user try first?

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?

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

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?

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

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

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?

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?

Which security principle is being applied?

A database administrator needs to modify the 'Phone' column in the 'Employees' table to allow up to 15 characters. Which SQL statement should the administrator use?

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

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

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

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

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

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

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?

A team of developers is collaborating on a mobile app using Git. One developer, Alice, is working on a new feature in a branch called "new-feature". Bob, another developer, has pushed several bug fixes to the main branch. Alice now wants to incorporate Bob's bug fixes into her feature branch. Which sequence of Git commands should Alice use to achieve this with minimal disruption?

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

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

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

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?

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?

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?

Which TWO of the following are examples of volatile memory?

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?

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

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

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?

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

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?

A system administrator is configuring a server to provide email services for a small business. The business wants to avoid managing the underlying infrastructure. Which cloud service model best fits this need?

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

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

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

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?

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

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

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

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

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?

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?

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

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?

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?

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

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?

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

Which THREE of the following are common file extensions for image files?

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

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

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

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?

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?

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

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

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

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?

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

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

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?

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

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

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?

Which of the following encryption methods is used to protect data in transit over a public network, such as the internet?

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?

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:

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

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?

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?

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

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

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?

A user reports that their computer is running slowly. Which of the following is the FIRST troubleshooting step the technician should perform?

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

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

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

Which of the following is an example of multi-factor authentication?

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

A technician is choosing a printer for a home office that needs high-quality color photo prints. Which TWO printer types are most suitable?

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

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?

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

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?

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

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:

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

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?

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

A company requires all employees to use strong passwords. Which of the following password policies best aligns with security best practices?

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.

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

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

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

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

A developer sees the above error message. What type of error is this?

Which TWO of the following are examples of operating systems?

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?

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

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?

A technician is selecting a monitor for a graphic designer. The designer needs accurate color representation and smooth motion. Which THREE specifications are most important to consider?

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

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?

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

Which TWO of the following are features of productivity software?

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?

A user reports that their computer is unable to connect to the internet, but other devices on the same network work fine. Which of the following is the MOST likely cause?

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

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?

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?

A user is printing a large document at home. The printer is an inkjet model. Which TWO consumables will need to be replaced periodically?

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

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?

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

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?

Which THREE of the following are common methods to acquire software? (Select THREE).

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

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

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

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?

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?

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

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

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

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?

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

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?

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

A technician is troubleshooting a desktop that does not power on. The power supply fan spins, but there is no display and no beep codes. Which component should the technician check first?

A user reports that their computer is running slowly and the hard drive activity light is constantly on. The technician checks Task Manager and sees that disk usage is at 100%. What is the most likely cause?

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

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?

Refer to the exhibit. A user reports that an application is running slowly. Based on the exhibit, which process is using the most memory?

A file is compressed using a lossless algorithm. Which of the following file types is most likely the result?

A user reports that their laptop battery drains quickly even when plugged in. What is the most likely cause?

A technician is troubleshooting a computer that cannot connect to the network. Which THREE steps should the technician perform first in the troubleshooting process?

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

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

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

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

Which TWO of the following are examples of output devices?

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?

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

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:

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?

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

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

A company is implementing physical security measures. Which two of the following are examples of physical security controls? (Select TWO.)

An IT technician is setting up a home office network. The technician needs to connect multiple devices to the internet and ensure they can communicate with each other. Which THREE devices are essential for this setup?

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?

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

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?

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

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

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

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

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

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

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?

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?

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:

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

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?

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

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

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

Refer to the exhibit. A database administrator executes the following query: SELECT COUNT(*) FROM employees WHERE department_id = 10; What is the result?

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

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?

A database has a 'Students' table with columns: StudentID (primary key), Name, Major. Another table 'Enrollments' has columns: EnrollmentID (primary key), StudentID (foreign key), CourseID. Which SQL query correctly lists each student's name and their enrolled courses by joining the tables?

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

Which of the following is an input device?

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

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

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

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

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?

A user receives an error 'This application cannot run on your PC' when trying to install a legacy program on Windows 10. What is the most likely cause?

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?

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?

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

A small business wants to secure its wireless network. Which configuration provides the strongest encryption?

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?

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

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

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?

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?

Refer to the exhibit. The database administrator sees this error in the log. Which action should the administrator take to resolve the deadlock?

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

Which TWO of the following are examples of physical security measures? (Select TWO)

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?

An administrator is configuring access to a cloud storage bucket. The policy is applied to a user. Which of the following actions will the user be allowed to perform?

A developer sees the above output. After a recent commit, the application crashed due to a null pointer. Which commit likely introduced the null pointer issue?

A company is setting up a home office for a remote employee. The employee will use a desktop computer, a VoIP phone, and a printer. The office has only one Ethernet wall jack. Which of the following devices would allow all three devices to connect to the network? (Select TWO).

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?

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?

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?

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

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

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

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?

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

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

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?

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?

A user wants to upgrade a desktop computer for better gaming performance. Which TWO components should the user consider upgrading to improve graphics processing? (Select TWO).

A graphic designer needs to save an image with high quality and no data loss. Which THREE file formats should the designer consider for lossless compression? (Select THREE.)

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:

Which TWO of the following are types of malware?

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

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

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

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?

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?

Which of the following is an example of a relative file path?

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

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?

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

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

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?

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

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

Drag and drop the steps to uninstall a program in Windows 10 into the correct order.

Refer to the exhibit. A system administrator notices that the computer occasionally freezes and data read errors occur. What should the administrator do?

A network printer should always receive the same IP address to ensure reliable access. Which configuration method guarantees this?

A company has two departments on separate floors and wants to connect them into a single local area network (LAN). Which device should be used to interconnect the switches on each floor?

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

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

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

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

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?

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

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?

A company is migrating its email and document collaboration from an on-premises server to a cloud-based solution. The IT manager wants to ensure that employees can access their files and emails from any device with a web browser. Which software category should the company implement?

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

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

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?

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

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

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

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

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

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?

A company wants to implement a solution that allows employees to access internal applications from home without installing software on their personal devices. Which technology should be used?

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?

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

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

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

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

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

Which THREE of the following are productivity software suites?

Refer to the exhibit. What is the output of the SELECT statement?

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

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

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?

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?

A technician is choosing expansion cards for a new workstation. The workstation will be used for high-end gaming and video editing. Which TWO cards are most essential for these tasks?

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?

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

A user reports that their computer is running slowly and the network activity light is constantly on. The technician runs the command shown in the exhibit. Based on the output, what is the most likely cause?

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?

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

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?

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

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

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?

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:

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?

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

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?

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

Which THREE of the following are types of network topologies?

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

A database administrator is configuring a virtual machine (VM) to run a high-performance database. The hypervisor is VMware ESXi. Which THREE resources should the administrator allocate to the VM to ensure optimal performance?

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?

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

A company uses a legacy application that only runs on Windows 7. The IT department plans to upgrade to Windows 10. What is the best approach to ensure compatibility?

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

A team is developing a new feature using an Agile methodology. The product owner wants to see a working version of the feature after each iteration. Which practice best supports this request?

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

A network technician is troubleshooting a server that is not reachable from the LAN. The server has a static IP address of 192.168.1.100/24 and a default gateway of 192.168.1.1. The technician pings the gateway successfully but cannot ping the server from another workstation on the same subnet. Which TWO steps should the technician take to resolve the issue?

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

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

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

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

A user wants to synchronize files, contacts, and calendar between their smartphone and tablet. Which THREE of the following methods can accomplish this?

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?

A user reports that their computer is not turning on. Which TWO hardware components should be checked first?

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

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

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

An inventory database contains Products (ProductID int PK, ProductName varchar(50), Quantity int, Price decimal) and Sales (SaleID int PK, ProductID int FK, SaleDate date, QuantitySold int). A report is needed: for each product, show product ID, name, current quantity, and total quantity sold. An employee writes: SELECT p.ProductID, p.ProductName, p.Quantity, SUM(s.QuantitySold) AS TotalSold FROM Products p LEFT JOIN Sales s ON p.ProductID = s.ProductID ORDER BY p.ProductID; The query executes without error but the results are incorrect. For products with no sales, TotalSold displays the same value as p.Quantity. For products with sales, TotalSold shows the correct sum. Which action should the employee take to fix the query?

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

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

Which TWO of the following are types of desktop applications?

Refer to the exhibit. A user can successfully ping the local default gateway but cannot ping an external IP address. What is the most likely cause?

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?

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

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?

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?

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?

A developer needs to store a list of student grades (integers) and be able to add and remove grades easily. Which data structure is most appropriate?

A network technician is analyzing a hexadecimal IP address representation. Which TWO of the following are common uses of hexadecimal notation? (Select TWO).

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

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?

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

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?

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

Which THREE of the following are best practices for creating secure passwords?

Match each software license type to its description.

A company is moving its email system to a cloud provider. The provider offers the software, platform, and infrastructure. Which TWO cloud service models are being used? (Select TWO.)

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?

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

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?

Which wireless standard operates on both 2.4 GHz and 5 GHz bands, providing faster speeds and better performance in crowded environments compared to its predecessor?

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

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?

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?

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

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?

Which file extension is typically associated with a compressed archive?

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

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

Refer to the exhibit. What is the most likely cause of this installation error?

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

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?

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?

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

A developer is debugging a program that produces incorrect output. The developer sets a breakpoint on a specific line of code and runs the program in a debugger. When execution stops at the breakpoint, the developer examines the values of variables at that point. What debugging technique is being used?

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?

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

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?

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

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

A user runs the query: SELECT * FROM Employees WHERE Department = 'Sales' AND Salary > 50000; but no rows are returned. The Department column contains 'Sales ' with a trailing space. What is the most likely cause?

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

A network administrator is redesigning a small office network with 20 computers, two servers, and three printers. The network must be reliable and easy to troubleshoot. Which TWO network topologies should the administrator consider?

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

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?

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?

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?

Which of the following best describes a web application?

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?

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

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

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

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

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?

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

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?

A developer is writing code and uses a variable to store a user's age. Which TWO data types are appropriate for storing a whole number age?

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?

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?

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?

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?

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

What is the primary purpose of a firewall?

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

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

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?

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?

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

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

A technician is troubleshooting a computer that won't boot. The system emits a series of beeps. What is the best resource to interpret the beep codes?

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?

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?

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?

A support technician is explaining binary operations to a junior technician. Which TWO of the following are valid binary arithmetic operations? (Select TWO.)

Refer to the exhibit. A database administrator runs the command shown, but user1 still cannot select data from the Customers table. What is the most likely reason?

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?

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?

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?

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?

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

A user is trying to install a new printer driver on a Windows 10 workstation but receives an error stating the driver is not signed. Which security concept is most directly involved?

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

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?

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?

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?

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?

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

Refer to the exhibit. A technician runs two ping commands. Based on the output, which of the following is the MOST likely cause?

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?

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?

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?

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

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

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

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

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?

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

Refer to the exhibit. A user sees this error when using an application. What is the most likely cause?

A company's IT policy requires that all employees use a specific word-processing application for creating official documents. An employee, who prefers a different application, uses that application to create a document and then saves it in the required application's native format. The employee gives the file to a coworker, who cannot open it. Which of the following is the MOST likely reason the coworker cannot open the file?

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?

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?

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?

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?

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

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

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

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?

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?

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?

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

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

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?

You are the IT support technician for a small office with 5 computers, a shared printer, and a router providing internet access. Users report that the network has been slow and intermittent for the past two days. Additionally, print jobs from multiple users are frequently stuck or fail halfway. You have already verified that all network cables are securely connected, restarted the router and printer, and updated the printer drivers. The issue persists. One user mentions that their computer sometimes shows a 'Windows has detected an IP address conflict' notification. Based on this scenario, which course of action should you take next to resolve the most likely root cause?

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?

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

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

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?

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?

A database administrator needs to add a new customer record to the 'customers' table. Which SQL statement should they use?

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?

A small business owner wants to purchase a software application for accounting. The application is available under two licenses: a single-user commercial license for $500, and a GNU General Public License (GPL) version for free. The owner is concerned about support and future updates. Which of the following is a key consideration for the owner?

A company's IT policy mandates data backups following the 3-2-1 rule. Which TWO of the following practices align with this rule?

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?

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?

What is the primary purpose of a password manager?

A database administrator wants to enforce that a column only accepts whole numbers. Which data type should be used?

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?

You are a junior developer at a small company that uses a monolithic web application written in Python. The application runs on a single server and uses a MySQL database. Recently, the application has become slow during peak hours. The operations team reports high CPU usage on the server. You suspect that the database queries are not optimized. You propose to refactor the application to use a caching layer. However, your manager is concerned about adding complexity and suggests that you first optimize the most frequently executed queries. You review the code and find that the most frequent query selects all columns from a large table without a WHERE clause. The table has over 1 million rows. Which course of action should you take?

An organization wants to ensure that employees only have access to the data necessary to perform their job functions. Which principle should be applied?

Which TWO of the following are benefits of virtualization in a data center?

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?

Refer to the exhibit. A database administrator executes the DELETE statement, and it reports success. However, a subsequent SELECT still shows the row. Which is the most likely explanation?

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?

A developer is debugging a program that is producing incorrect output. Which of the following are common debugging techniques? (Choose three.)

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?

A company is experiencing frequent application crashes. Which TWO troubleshooting steps should be performed first? (Choose TWO.)

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?

An employee receives an email that appears to be from the CEO, urgently requesting a wire transfer to an external vendor. The email address looks slightly off. Which type of social engineering attack is this?

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

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?

A graphic designer needs to create vector logos that can be scaled without losing quality. Which software category is most appropriate?

Which of the following is an example of a lossy compression format?

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?

What is the most likely reason PC1 cannot ping PC2?

A small business needs to allow multiple employees to use the same application on their individual computers while ensuring each user has their own settings. Which type of software license is best?

Which TWO of the following are examples of multi-factor authentication? (Choose TWO.)

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?

Which THREE of the following are characteristics of a relational database?

A database designer wants to split a table into two to reduce data redundancy and avoid update anomalies. This process is known as:

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?

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?

Which TWO of the following are effective methods to help secure a wireless network from unauthorized access?

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?

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?

Which security best practice is being demonstrated?

Which of the following software licenses allows users to modify and redistribute the source code, provided they keep the same license terms?

Which TWO of the following are types of malware? (Select TWO)

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?

Drag and drop the steps to change the desktop background in Windows 10 into the correct order.

Drag and drop the steps to open the Task Manager in Windows 10 into the correct order.

Which SQL statement would you use to retrieve the names of all products with a price greater than $50 from a table named 'Products'?

A company wants to implement a private network for devices within a single building. Which type of network should they use?

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?

A system administrator is evaluating antivirus software for company computers. Which TWO features are most important for protecting against malware? (Select TWO.)

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?

A user wants to edit a document collaboratively with multiple team members in real-time. Which type of application should they use?

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?

Drag and drop the steps to install a printer on Windows 10 via USB into the correct order.

In which phase of the Software Development Life Cycle (SDLC) are the system requirements gathered and analyzed?

Match each network protocol to its well-known port number.

Which file attribute prevents a file from being modified or deleted accidentally?

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?

Which TWO of the following are examples of system software?

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?

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?

A project team is using Git for version control. Which TWO actions are typical Git operations? (Choose TWO.)

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?

A company wants to implement a backup solution that allows for quick restoration of individual files. Which backup type should be used?

A company wants to ensure data redundancy in case of a single hard drive failure. Which RAID level should they use?

An IT department is planning a new server deployment. They need to ensure that if one server fails, another can take over with minimal downtime. Which concept describes this requirement?

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?

A technician is explaining the difference between lossy and lossless compression to a colleague. Which of the following file formats uses lossy compression?

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?

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?

Which of the following is the correct file extension for a macOS installer package?

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?

A user wants to upgrade their desktop computer to faster storage. Which of the following storage interfaces provides the highest data transfer speeds?

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?

A technician is deploying a software update to 200 computers in a domain. To avoid user interaction, which installation method should be used?

Match each database concept to its description.

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?

A database designer is normalizing a table that contains repeating groups (multiple values in one column). Which of the following are goals of normalization? (Select THREE.)

Refer to the exhibit. A developer wrote this BASIC program. What will happen if the user presses Enter without typing a name?

A small business has 20 employees using a mix of wired and wireless devices. The network uses a single router with built-in 4-port switch and Wi-Fi. Recently, employees have reported intermittent connectivity drops, especially during peak hours. The technician notices that the router's CPU usage is consistently at 90% or higher. The business cannot afford to replace the router immediately. Which of the following actions would BEST improve the situation without purchasing new hardware?

A user notices that the computer is running slowly and opens Task Manager to check running processes. Based on the exhibit, which process is using the most memory?

A company wants to ensure that data on lost laptops cannot be accessed. Which technology should be used?

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?

A university database includes tables: 'Professors' (ProfessorID, Name, Department) and 'Courses' (CourseID, Title, ProfessorID). Which THREE statements about this design are correct?

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?

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

Match each storage type to its description.

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?

A web application constructs SQL queries by concatenating user input directly. What is the primary security risk?

Which TWO factors should be considered when choosing a software license?

A software license allows users to use the software for a limited time before purchasing. This is an example of which license type?

Which TWO of the following are characteristics of a client-server network? (Choose two.)

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?

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

A help desk technician receives a call from a user who says their computer is showing a message that files are encrypted and a ransom is demanded. Which TWO types of malware are most likely involved?

Which TWO of the following are examples of interpreted programming languages?

A user reports that their computer is slow. Which of the following is the BEST first step to troubleshoot?

A program crashes with a 'division by zero' error. Which of the following is the most likely cause?

A user needs to install a new graphics editing application on a Windows computer. Which file extension is most likely associated with the installer?

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

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?

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

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?

Which THREE of the following are valid database integrity constraints?

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?

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

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?

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

An organization needs to run multiple operating systems on a single physical server to isolate development environments. Which virtualization technology should they use?

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?

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?

Refer to the exhibit. A user cannot connect to a network share on a remote server. Based on the firewall rule, what is the most likely cause?

An employee is tailgated into a secure office building by someone without a badge. Which type of security threat does this represent?

A user wants to access a file located in a subdirectory relative to the current working directory. Which type of path is being used?

Which TWO of the following are examples of application software? (Select TWO).

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?

Which THREE of the following are common troubleshooting steps? (Select THREE).

Which of the following is the result of the binary operation 1101 AND 1011?

Which of the following is an example of open-source software license?

A developer notices that an application runs slowly when processing large files. Which optimization technique is most likely to improve performance?

A company needs to store an organizational chart showing reporting relationships. Which database model is most appropriate?

What is the primary purpose of a password manager?

Refer to the exhibit. The Products table has been created and two rows have been inserted. What will be the result of the following query? SELECT ProductName FROM Products WHERE Price > 100;

A user needs to transfer photos from a digital camera to a laptop. The camera supports wired and wireless transfer. Which THREE of the following connection methods can be used? (Choose THREE.)

Which of the following is an example of a NoSQL database?

A user wants to access a website but types the wrong URL. Which technology resolves domain names to IP addresses?

A user runs a query on a database table and notices that the results contain duplicate rows. Which SQL keyword would eliminate these duplicates?

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?

Which of the following is the binary result of the AND operation on 1010 and 1110?

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?

Refer to the exhibit. What is the most likely cause of the application crash?

Which THREE of the following are best practices for database normalization? (Choose three.)

A company's IT policy requires that all corporate smartphones be remotely wiped if lost. Which technology enables this capability?

A company is choosing between HDD and SSD storage for new laptops. Which THREE of the following are advantages of SSDs over traditional HDDs? (Select THREE.)

Which TWO of the following are open-source licenses? (Select 2)

A company needs to manage and secure a fleet of employee smartphones used for work. Which technology should they implement?

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?

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?

A company wants to secure its wireless network. Which of the following is the BEST practice?

A user wants to install an application on an Android smartphone. Which app store should they use?

Which SQL statement is used to remove all rows from a table while keeping the table structure?

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?

A database designer wants to reduce data redundancy in a relational database. Which THREE of the following are normalization techniques or concepts?

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?

Which three of the following are recommended practices for securing a home wireless network? (Choose three.)

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?

Which of the following RAM types is the fastest and most recent?

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?

Which of the following is a primary advantage of using a database over a flat file system for storing customer records?

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?

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?

Which of the following is a valid SQL statement to retrieve all records from a table named 'Employees'?

A security analyst is explaining the CIA triad to new employees. Which scenario best illustrates a breach of integrity?

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?

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

A technician is explaining data storage to a customer. Which of the following best describes the difference between a bit and a byte?

Which data structure is best for storing a collection of key-value pairs?

Which of the following is an example of open-source software license?

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?

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?

A user wants to synchronize contacts and calendar events between their Android smartphone and tablet. Which service is MOST likely used for this synchronization?

A development team is working on a critical update to an e-commerce website. After deploying the update, they must ensure that existing features (like login and search) still work correctly. Additionally, they want to test the new checkout flow end-to-end. Which TWO types of testing should the team perform?

Refer to the exhibit. A user cannot access the internet. What does this output indicate?