ISM3004 COMPREHENSIVE STUDY GUIDE
2026 FULL QUESTIONS AND SOLUTIONS
GRADED A+
◍ "FIND()".
Answer: returns the position of "tgt" inside of "maintext", case-sensitive,
returns #VALUE if target isn't found; optional parameter is "start"
◍ What factors lead to cloud computing being more energy efficient and
environmentally friendly?.
Answer: Greater Energy Efficient - sharing hardware. Using less space,
using only what you need.
◍ unmanaged PC.
Answer: -do it yourself-users can do whatever they want with their PC
◍ Are insiders a serious threat?.
Answer: Yes, because 70% of incidents involve insiders.
◍ Software is architected in layers"Layer Cake".
Answer: User Application OS Hardware
◍ What can you not copyright?.
Answer: an idea
◍ CODEC.
Answer: Coder DecoderVideo conference system unit using internet which
sends and receives audio and voice
◍ What vulnerabilities are exploited with compromised websites?.
Answer: Software; incredibly complex and therefore there are bugs -
vulnerable browsers and plug ins. This presents the opportunity for cyber
criminals to take advantage of the fact that we are out there on the internet.
,◍ PTZ (Type of camera).
Answer: Pan- adjust cameraTilt- up & downZoom- wider/narrow camera
frame
◍ Issues to consider with subscription type software licenses?.
Answer: What are the terms and renewal? Upgrade/Newer Version -
included or not? Bug FixesSupportExit ClausesLiability
◍ Are Robo Bosses unbiased?.
Answer: A human has bias based on personal opinion. We are human. A
computer doesn't have that.
◍ What steps can be taken to protect mobile devices?.
Answer: Make sure your mobile device is encrypted.By using a Mobile
Device Management.
◍ Consumerization of IT.
Answer: Consumer devices (iPhones, iPads, Android devices) are more
popular, faster, smaller, lighter, and easier than standard corporate
equipment (more powerful features) (increases productivity of employees in
corporate IT)
◍ Cloud computing is _____ more efficient than standalone servers.
Answer: 95%
◍ Be familiar with the three examples of big data provided in the lecture. How
do you see the Three V's in each?actions speak louder than words.
Answer: · improve therapy diagnoses· supporting US military to help
prevent suicide· 20 measurements per secondo facial expressionso vocal
inflectiono gestures· pattern recognitiono sign and types of distress· virtual
therapist was able to probe conversation and react
◍ What is the problem with using the public Internet to connect remote offices
and mobile users to an organization's private resources?.
Answer: risky and can lose functionality
◍ What can Robo Bosses do?.
, Answer: Machine Learning and can process routine tasks: Approve
TimeSchedule employeesResume ScreeningPerformance evaluation
◍ Risks of Cloud Computing.
Answer: Vendor stability Security RisksConsumerization
◍ Application Programming Interface (API).
Answer: simple means by which one layer can talk to the next
◍ "TRIM()".
Answer: removes excess spaces from text(no leading or trailing spaces, only
one space between each pair of words; reduces match/lookup errors, helps
with data from external sources; use with VLOOKUP if value cannot be
found because of extra spaces in name
◍ Ending balance (formula).
Answer: beginning balance - principal
◍ Niche Players.
Answer: Successfully focus on small market segment
◍ WANo What is it? Briefly, how is it constructed?.
Answer: wide area network; private service provider
◍ Cloud-First Strategy.
Answer: When developing a new app, they figure out how to put it in the
cloud first
◍ Is an anti-virus a systems or application software?.
Answer: Systems - makes the system productive so apps can run.
◍ Leaders.
Answer: Max ability, max vision
◍ Bimodal IT.
Answer: Two Different Modes:- Traditional IT (system used to create
paychecks)- Experimental IT (risks)
◍ Who can use fair us?.
2026 FULL QUESTIONS AND SOLUTIONS
GRADED A+
◍ "FIND()".
Answer: returns the position of "tgt" inside of "maintext", case-sensitive,
returns #VALUE if target isn't found; optional parameter is "start"
◍ What factors lead to cloud computing being more energy efficient and
environmentally friendly?.
Answer: Greater Energy Efficient - sharing hardware. Using less space,
using only what you need.
◍ unmanaged PC.
Answer: -do it yourself-users can do whatever they want with their PC
◍ Are insiders a serious threat?.
Answer: Yes, because 70% of incidents involve insiders.
◍ Software is architected in layers"Layer Cake".
Answer: User Application OS Hardware
◍ What can you not copyright?.
Answer: an idea
◍ CODEC.
Answer: Coder DecoderVideo conference system unit using internet which
sends and receives audio and voice
◍ What vulnerabilities are exploited with compromised websites?.
Answer: Software; incredibly complex and therefore there are bugs -
vulnerable browsers and plug ins. This presents the opportunity for cyber
criminals to take advantage of the fact that we are out there on the internet.
,◍ PTZ (Type of camera).
Answer: Pan- adjust cameraTilt- up & downZoom- wider/narrow camera
frame
◍ Issues to consider with subscription type software licenses?.
Answer: What are the terms and renewal? Upgrade/Newer Version -
included or not? Bug FixesSupportExit ClausesLiability
◍ Are Robo Bosses unbiased?.
Answer: A human has bias based on personal opinion. We are human. A
computer doesn't have that.
◍ What steps can be taken to protect mobile devices?.
Answer: Make sure your mobile device is encrypted.By using a Mobile
Device Management.
◍ Consumerization of IT.
Answer: Consumer devices (iPhones, iPads, Android devices) are more
popular, faster, smaller, lighter, and easier than standard corporate
equipment (more powerful features) (increases productivity of employees in
corporate IT)
◍ Cloud computing is _____ more efficient than standalone servers.
Answer: 95%
◍ Be familiar with the three examples of big data provided in the lecture. How
do you see the Three V's in each?actions speak louder than words.
Answer: · improve therapy diagnoses· supporting US military to help
prevent suicide· 20 measurements per secondo facial expressionso vocal
inflectiono gestures· pattern recognitiono sign and types of distress· virtual
therapist was able to probe conversation and react
◍ What is the problem with using the public Internet to connect remote offices
and mobile users to an organization's private resources?.
Answer: risky and can lose functionality
◍ What can Robo Bosses do?.
, Answer: Machine Learning and can process routine tasks: Approve
TimeSchedule employeesResume ScreeningPerformance evaluation
◍ Risks of Cloud Computing.
Answer: Vendor stability Security RisksConsumerization
◍ Application Programming Interface (API).
Answer: simple means by which one layer can talk to the next
◍ "TRIM()".
Answer: removes excess spaces from text(no leading or trailing spaces, only
one space between each pair of words; reduces match/lookup errors, helps
with data from external sources; use with VLOOKUP if value cannot be
found because of extra spaces in name
◍ Ending balance (formula).
Answer: beginning balance - principal
◍ Niche Players.
Answer: Successfully focus on small market segment
◍ WANo What is it? Briefly, how is it constructed?.
Answer: wide area network; private service provider
◍ Cloud-First Strategy.
Answer: When developing a new app, they figure out how to put it in the
cloud first
◍ Is an anti-virus a systems or application software?.
Answer: Systems - makes the system productive so apps can run.
◍ Leaders.
Answer: Max ability, max vision
◍ Bimodal IT.
Answer: Two Different Modes:- Traditional IT (system used to create
paychecks)- Experimental IT (risks)
◍ Who can use fair us?.
