Font size
WorksheetsIT Fundamentals practice exam II
Total questions: 77
Worksheet time: 39mins
Which of the following depicts a significant difference between proprietary software and open-source software?
Compatability Issues
single-Platform vs Cross-Platform
Licensing and sources code accessibility
advanced Installation options
Alice is experiencing slow browsing speed and frequent browser crashes. What could potentially fix this situation?
Removing Browser extensions
Clearing the cache
Switching the private browsing
Deactivating client-side Scripting
Jennifer, a financial analyst at Dion Training, decides to use Microsoft Excel to help analyze complex financial data. This software is an example of:
Database Software
Spreadsheet Software
Word processing Software
Visual Diagramming Software
Lara, a small business owner, wants to acquire new software for her employees. Her staff varies in size from season to season, so she needs a license that can cater for that. Which form of licensing should she consider?
Concurrent License
Open source Lincense
Single Use License
Group Use License
Patrick, a systems analyst at Dion Training, wants to install a small, lightweight software tool on his laptop, without the necessity of network access. Which application delivery method is most suitable for his needs?
Cloud Hosted
Local network Hosted
Locally installed
Software as a service (SaaS)
Which term refers to instances of running applications actively executing tasks in the operating system?
Drivers
Services
Task scheduling
Processes
What distinguishes an open-source license from a proprietary license?
One -Source Licenses require payment for usage , are as proprietary licenses can be used without cost
proprietary licenses prevent modifications of the source code, whereas One-Source Licenses allow it.
proprietary licenses encourage community development, whereas One-Source licenses discourage it.
Open-source licenses prevent anyone from modifying the source code, while proprietary licenses allow it.
What’s the difference between a concurrent license and a group/site license?
Concurrent license allow multiple installations, while group or site licenses allows single installations.
Concurrent license restricts simultaneous assuage, while a group is to restrict by devices numbers.
Concurrent license requires regular payments, while a group or site licenses is a one-time Purchase
Concurrent license requires access to source code, while group or site license doesn't
Steve, a network administrator at Dion Training, wants to stop an unresponsive application on a Windows PC. Which feature of the operating system will facilitate this?
process management
/scheduling
disk defragmentation
Memory management
device compatibility
Jane, a Project Manager at Dion Training, is experiencing slow browser performance due to a specific extension. What should Jane do to speed up her browser?
Clear her browser's cache
remove or disable the troublesome extension
Add new extensions
Enable Private browsing
Under which software category does an email client fall?
Collaboration software
Database Software
Programming Software
Operating system Software
Thomas, a Software Developer at Dion Training, needs to use an application that may not be compatible with all web browsers. He would greatly benefit from understanding which of the following?
Browser add-ons/extensions
Popup blockers
Script Blockers
compatible Browsers
What software provides an online environment that enables collaboration and sharing of files in an organization?
web browsers
Online Workspace
Productivity software
Database Software
Martha, a financial manager at Dion Training, wants to monitor transactions, control budgets, and generate financial reports. What type of software will help her the most?
Web browser
Business Specific Applications
Accounting Software
Email client
Which of the following interfaces is used to connect a monitor to a computer and supports high-definition video and audio?
HDMI
Bluetooth
USB
RJ-45
Linda is at a coffee shop and wants to purchase her drink using a contactless payment method. She takes out her smartphone and hovers it near the payment terminal, which instantly completes the transaction without the need for physical contact or inserting a card. Which wireless technology is commonly used for contactless payments and data transfer?
Thunderbolt
Bluetooth
NFC
USB
Which network connection types utilize wireless technology? (Select two).
DSL
Radio Frequency
Cable
Satellite
Fiberoptic
Which of the following devices is normally utilized by healthcare professionals for patient monitoring, sometimes remotely, and diagnostic purposes?
Steaming media devices
mobile phone
medical devices
workstations
When setting up a secure wireless network, which of the following encryption methods should be MOST avoided due to known vulnerabilities?
WPA
WPA2
WEP
open access/ captive portal
Which devices are the most integrated into our everyday life, offering features from making calls to browsing the internet to digital photography?
Mobile Phones
Home appliances
gaming consoles
Laptop
Jane is trying to visit a website in her browser by typing in a webpage's URL (www.example.com). Before the site can load, a conversion must take place. Which process BEST describes what is happening?
The webpage's URL is converting into a Mac address
The webpage's URL is converting into a IP address
The webpage's URL is converting into an hexadecimal code
The webpage's URL is converting into a binary code
Which of these storage types relies on movable mechanical parts to read and write data?
Flash Drive
Hard Drive
Ram
Solid Stae Drive
In terms of data accessibility, which of the following has the fastest retrieval time?
Cloud storage service
Optical
Nas
Hard drive
Which type of storage device uses non-volatile memory to store data?
RAM
GPU
Cooling System
SSD
What can be said about cloud storage services and local network storage types that make them similar?
Remote Accessibility
Local Accessibility
Optical Storage
Flash Drives
Which wireless network technology is commonly used for short-range communication between devices?
LTE
Bluetooth
Ethernet
Wi-Fi
Which of the following interfaces is used for digital video output and can support multiple monitors from a single connector?
HDMI
DisplayPort
USB
RJ-45
Which of the following protocols is the most secure?
WPA
WEP
OPEN
WPA2
What does NFC stand for in the context of wireless communication?
National fiber Consortium
Near field communication
New Frequency Channel
Network File connection
Which term below is used to denote a distinct identifier allocated to every device on a layer three network?
WAN
MAC address
DNS
IP address
Tom just bought a wireless mouse for his laptop. To use the mouse, which of the following does he most likely need to do?
Driver Installation
Plug-and Play
Web Based configuration
IP address configuration
What is the primary purpose of using password managers?
They store passwords in an encrypted format
They eliminate the need for password explanation.
They Generate random and complex passwords
They require the users to reuse passwords across multiple sites
Which term describes the act of manipulating individuals to reveal their passwords or sensitive information?
Social engineering
Wire tapping
Eavesdropping
Snooping
In a business continuity plan, what is a key consideration for deciding whether to store backups locally, in cloud storage, or off-site?
The cost of storage solutions.
The size of the data to be backed up.
The speed of the local network
The need to ensure data availability and quick recovery in case of a disruption.
Which of the following BEST describes the concept of RAID 1 in data redundancy?
Disk Mirroring
Disk Shadowing
Disk Stripping
Disk Stripping with parity
Which of the following specifically refers to a deliberate attack aimed at overwhelming a system or network, rendering it unavailable?
Service Outage
Power Outage
Denial of Service Attacks (Dos Attack).
Destruction
Which of the following are considered reputable software sources
Freeware websites with no user rating or reviews
Third-Party websites offering cracked software
peer-to-peer file sharing networks
official vendor websites and app stores
Which of the following is HTTPS used for the most?
Secure web communication
encryption of emails messages
secure file storage
encryption of mobile applications.
Emily, a security analyst at Dion Training, wants to prevent attackers from capturing and retransmitting legitimate data to deceive the system. Which of the following threats should she be particularly focused on?
Replay Attack
Man-in-the Middle
impersonation
Unauthorized information alteration
Which of the following is the primary purpose of authentication?
To assign permissions and access levels
To verify the identity of the users
to ensure the availability of the resources
To track the user activities and generates logs.
As a user of online communication platforms, what is one major privacy concern?
Understanding the type of computer used to access these platforms
knowing what information is made public and how service providers use provided data.
Being sure to use a high-speed internet connection.
Monitoring the amount of time spent on these platforms.
What is the primary benefit of implementing a password reset process?
It allows users to recover forgotten passwords
It prevents unauthorized access to user accounts .
It ensures passwords are changed regularly
It enforces password complexity requirements.
What encryption type is used where a single secret key is used to both encrypt and decrypt data?
Public Key infrastructure
Cyptographic Hashing
Asymmetric encryption
Symmetric encryption
Which term refers to the practice of gathering sensitive information by going through someone's trash or discarded materials?
Snooping
Dumpster Diving
Wiretapping
Eavesdropping
How does prioritization play a role in disaster recovery?
It determine the order in which data is restored.
It determine the frequency of backup operations.
It determine the level of redundancy needed for each system
It determine the order in which systems are backed up.
Emily, a security-conscious user, wants to implement preventive measures to protect her computer from advanced malware attacks. Which of the following practices should Emily adopt to enhance her defense against sophisticated malware? (Select TWO).
enabling automating software updates
disabling the User Account Control
disabling all browser extensions
using reputable antivirus /anti-malware software
downloading software from unverified sources.
In database management, what does the term "User Interface/Utility Access" primarily refer to?
The process of directly modifying data in a database via SQL commands.
Assigning roles and permissions to users.
the use of GUI-based tools or software to interact with and perform operations on a database.
The process of adjusting the server setting.
Nia is a database manager for a fitness application. A user has recently contacted customer service to correct their recorded weight in the app from 150 lbs to 140 lbs. Which SQL command should Nia use to make the necessary adjustment in the database?
Insert
Select
Update
Delete
What BEST describes the purpose of a record in a database?
to alter data in a table
to remove data from a database
to store related data in various fields.
to view the structure of a table.
What is the purpose of a query in a database?
To connect to the database
to add new records to the database.
to format the data for reporting.
To specify criteria to match values in fields and select information of interest.
When it comes to databases, which one of the following BEST defines a report?
a formatted and organized presentation of data
a set of SQL commands executed in sequence
a group of related database tables
a specific type of database query.
Kai is part of a team developing a content management system where the data structure is not fixed and can vary greatly among content pieces. Also, the system needs the ability to handle a large amount of unstructured and semi-structured data. Which type of database would be BEST suited for Kai to meet these requirements?
Key-Value database
Documented-oriented database
Relational Database
Graph database
Amanda is a junior database developer who has just started learning about relational databases. Her senior colleague mentioned the term "schema" during a discussion. What does the term "schema" refer to?
the security measures employed in a database.
the database software version.
The set of rules that specify data consistency in a database.
The structure of a database, including tables and relationships
Which SQL command is MOST suitable for removing existing data from an SQL database?
Update
delete
Insert
select
Which one of the following notational systems that is commonly used in the field of computing relies on the use of only 1s and 0s?
Unicode
Hexadecimal
Binary
ASCII
Which among the following units is commonly used to measure digital storage?
Gigabyetes
Bits per Second (BPS)
Hertz (HZ)
Pixel
Which data representation method is a character encoding standard that represents text and control characters in computers, communication equipment, and other devices, using 7 bits to define each character?
Hexadecimal
Binary
Unicode
ASCII Code
In normal computer operation, a monitor primarily serves which of the following functions?
Output
Storage
Processing
Input
Which of the following data types does NOT have the ability to represent multiple characters in a sequence?
Boolean
Numbers
Strings
Array
In normal computer operation, a keyboard primarily serves which of the following functions?
Input
Output
Storage
Processing
What is the equivalent speed of 1 Gigahertz (GHz) in Megahertz (MHz)?
1024 MHz
1000 Mhz
500 Mhz
1 Mhz
Given the value "Hello World," which data type is it most appropriately associated with?
Char
String
Number
Boolean
Which of the following is NOT a hexadecimal representation?
2G
1A
10
FF
Mike, a helpdesk technician, is troubleshooting a user's issue with a specific application that keeps crashing on launch. Mike has already identified the problem as a corrupted application file. He has also established a plan of action to reinstall the application. However, Mike doesn't have the administrative privileges necessary to uninstall or install applications. Which of the following is the BEST next step?
Simply restart the computer and try again
escalate the issue to a higher-level technician who has a technician who has the necessary privileges
use another employees account who has administrative privileges
ask the user to uninstall and reinstall the application.
Jamal is a software engineer who has confirmed the root cause of a bug in his application. Which of the following strategies would be the MOST effective for Jamal in resolving this problem?
Waiting for a colleagues to determine the next steps
Ignoring the confirmed root cause and trying different solutions
Trying random solutions until the problem is resolved
Developing a plan based on the confirmed root cause and implementing the necessarily changes to resolve the problem.
In normal computer operation, a Solid State Drive (SSD) primarily serves which of the following functions?
Output
Processing
Storage
Input
A modern e-commerce company collects a vast amount of data from its online sales, customer behaviors, and market trends. How is this data considered an asset to the company?
It generates physical Income directly
It eliminates the need for customer interactions
It increases the physical inventory of the company
It provides insightful information for decision making
What software maintains and manipulates datasets, often using structured query language (SQL)?
database software
conferencing software
web browser
accounting software
In his role as a senior software developer, Matthew is assigned to create a new component for Dion Training's enterprise software. This component will calculate the depreciation of company assets over time. The calculations will result in numbers that may include fractions. This value will be needed for complex financial computations in multiple parts of the software. Which data type is best suited for Matthew to store this computed value?
Char
Integer
Boolean
Float
Which of the following language categories is specifically designed to provide structure for content in web documents rather than focusing on programming-based functionality or logic?
Scripted Language
Interpreted language
Scripting Language
Mark Up Language
Which of the following languages is an example of a compiled language?
Python
C #
Java Script
CSS
In which of the following scenarios would a programmer prefer to use Assembly language rather than a higher-level language such as C++ or Java?
When developing applications that require direct hardware manipulation or access to specialized processor instructions.
When creating cross-platformed web applications
When working on large scale, complex software projects with many contributors
When they need to write code tat is easy to read, maintain and debug.
In which of the following scenarios would it be most beneficial to use pseudocode for the design and planning of your code?
When you want to design the logic of an algorithm clearly before implementing it in a specific programming language
When you want to perform a through debugging on your current code.
when you aim to execute functional code immediately
when you need to incorporate a new library or tool into your current codebase.
Which of the following BEST describes the fundamental use of Batch Files, Windows PowerShell, and VBScript?
Design Interactive websites
Create Scripts
Establishing secure network connections
Develop high-performance video games.
Why are variables important in programming?
They allow developers to store data for later use
They reduce the loading time of a program.
They increase the security of the codebase
They make programming language more difficult to learn.
What is sequencing in programming logic?
It refer to a specific order in which instructions or steps are executed in a program.
It refer to the random order in which instructions are executed in a program.
it refers to a process or organizing programs in alpahabetic order
it refers to looping mechanism where a set of instructions are repeated.
How does incorporating a loop MOST affect the sequence of a program's operations?
Looping can cause certain steps in the sequence to be repeated based on specific conditions.
a loop eliminates the need for sequencing in a program
a loop has no impact on the sequence of a program
Looping makes the sequence less readable and more complex.
