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?
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 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 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 small business owner wants to install a productivity suite on 25 Windows workstations without purchasing a physical disc for each machine and without paying a recurring subscription fee. The owner needs word processing, spreadsheets, and presentation software that will remain usable indefinitely after a single payment. Which type of software license and delivery method best fits this need?
A user is configuring a new email client on a Windows 11 laptop. The user wants to ensure that email messages are downloaded from the server and stored locally on the laptop, and that the mailbox remains synchronized across multiple devices. Which two protocols should the user consider? (Choose two.)
A user wants to run a virtual machine on a Windows 10 Pro desktop to test a different operating system. The user needs the VM to access the internet and share files with the host. Which two components must be installed and configured to meet these requirements?
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 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 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?
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 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 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?
An IT administrator needs to install software on multiple company computers without user interaction. Which installation method should the administrator use?
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 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 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 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 system administrator is evaluating antivirus software for company computers. Which TWO features are most important for protecting against malware? (Select 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 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 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?
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 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 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 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 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 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 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.)
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?
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 needs to create a document that includes complex mathematical equations, automatic table of contents, and collaborative editing with change tracking. Which type of application is most appropriate?
A user installs a productivity suite on a Windows 11 laptop. The license agreement states the software may be installed on only one computer and cannot be copied or modified. Which type of software license does this describe?
A company wants to deploy a custom internal application to all employees' Windows computers. The application requires administrative privileges to install and must be updated frequently. Which deployment method should the IT team use to ensure consistent installation and easy updates?
A small business wants to deploy a new customer relationship management (CRM) application. The company has no in-house IT staff and wants to minimize upfront infrastructure costs. They also need to access the CRM from any device with a browser. Which of the following deployment models best fits these requirements?
A small business wants its staff to create documents, spreadsheets, and presentations without installing any software on their laptops. Staff must be able to open the files from any company device and see edits made by coworkers within seconds. Which software delivery model best meets this requirement?
A small business wants to replace its on-premises email server with a service where the provider manages the servers, patching, and uptime. Employees will access email through a web browser and mobile apps. Which cloud service model is the business adopting?
A user is selecting a software license for a new application that will be used by 50 employees. The company wants to pay a single upfront fee and avoid recurring costs. Which type of license should they choose?
A user is setting up a new Windows 11 laptop and wants to ensure that files in the Documents folder are regularly backed up to the cloud automatically. Which built-in Windows feature should the user configure?
A help desk technician must remove a program from a Windows 11 workstation because the user no longer has a license for it. The technician wants to use the graphical interface rather than command-line tools. Where should the technician go to uninstall the application?
A user is editing a document in a word processor and wants to save a copy in a format that preserves the exact layout and is universally viewable without requiring the original editing software. Which file format should the user choose?
A user is compiling a report and needs to combine text, a chart, and a table from three separate files into one document while preserving the original formatting of each element. Which productivity application feature is designed for this task?
A user needs to open a document that was created in a proprietary format by a legacy application. The user does not have that application installed. Which of the following is the BEST solution to view the document's content without installing additional software?
A user needs to install a new application on a Windows 10 computer but does not have administrative privileges. The application requires writing to the Program Files directory and modifying system registry keys. What will happen when the user attempts to install the application?
A technician must install a critical security update on 150 Windows 11 computers overnight without visiting each desk. The update is distributed as an .msi package, and the organization already uses Active Directory Domain Services. Which method should the technician use?
A user wants to install a locally compiled C program on a Linux system so that it becomes available system-wide to all users. Which command should the user run from the source directory after compilation?
A technician is preparing a workstation for a user who needs to work with several document types. The technician wants to confirm which file extensions are commonly associated with word-processing documents and which are commonly associated with spreadsheets. Which TWO file extensions are typically used for spreadsheet files? (Choose two.)
A user wants to open a spreadsheet file, edit some cells, and then save the changes in a format that preserves formulas and formatting. Which type of application should the user open?
A software development team is using a version control system to manage their codebase. They want to create an isolated copy of the main codebase to develop a new feature without affecting the main line of development. Which Git operation should they use?
A technician is explaining the concept of software licensing to a client. The client wants to install a single copy of an application on multiple computers within their small business. Which type of license should the technician recommend?
A spreadsheet user needs to display the text from cell A2 in all uppercase letters in cell B2, without altering the original value in A2. Which function should be entered in B2?
A user is evaluating database concepts while building a small inventory system. Which TWO statements accurately describe a relational database? (Choose two.)
A user reports that a database-backed inventory application is extremely slow when generating monthly reports, but normal data entry remains responsive. The technician observes that the report queries scan entire tables and that adding an index on the date column dramatically reduces report time. Which software concept explains why the index improved performance?
A small business wants employees to use a cloud-based office suite so that multiple people can edit the same document at the same time and see each other's changes immediately. Which characteristic of the cloud-based suite makes this possible?
A developer is writing a program that must handle multiple tasks simultaneously, such as downloading files while updating a user interface. Which programming concept allows the program to execute multiple sequences of instructions concurrently?
A user installs an open-source image editor on a personal laptop. The software is distributed with source code, and the user is allowed to modify and redistribute it under the same license terms. Which licensing characteristic best describes this software?
A user is choosing a backup strategy for a laptop that contains important documents. The user wants copies of files stored in a second location and wants to be able to restore an earlier version of a file that was accidentally modified. Which TWO actions should the user perform? (Choose two.)
A user receives a file with the extension .exe from an unknown sender. Before running it, the user wants to verify whether the file is safe. Which action best helps the user evaluate the risk?
A user is preparing a budget spreadsheet and wants to apply the same currency format, bold header row, and column widths to twelve monthly sheets inside one workbook. The user wants each sheet to update automatically if the header text changes. Which feature should the user apply?
A technician is preparing a Windows workstation for a user who needs to run a legacy line-of-business program that requires specific runtime libraries and direct access to a hardware security key. The technician must choose installation and configuration steps that support these requirements. Which TWO actions are appropriate? (Choose two.)
A user subscribes to a cloud productivity suite and wants to ensure that documents remain available for editing even when the internet connection is temporarily lost. Which feature should the user enable?
A technician is cleaning up a Windows workstation that has accumulated many installed programs. The technician wants to remove applications that were installed as part of a bundled package and also wants to free disk space consumed by leftover installation files. Which TWO actions should the technician perform? (Choose two.)
A user is selecting a software license for a new application. The user wants to use the software for any purpose, modify it, and redistribute modified versions, but also wants to ensure that any redistributed modified versions remain under the same license. Which type of license best fits these requirements?
A user receives a document created in a word processor that the user does not own. The sender wants the user to be able to read the text and view the layout, but the user does not need to edit or save changes. Which action allows the user to view the document content most reliably?
A user is configuring backup software on a workstation. The user wants the backup job to run automatically every night, capture only files that changed since the last run, and avoid re-copying files that have not been modified. The backup destination is a local external drive. Which backup type should the user select?