Information Systems Top Hat Q's

I am a UI student who has this great idea. I want to build an application that uses public available data and can share with the user where available parking exists and capitalizes on crowdsourcing to post sightings of parking tickets attendants at work. What cloud service model do I shop for?  

PaaS: Platform as a Service

I need an off-site data storage area to support my disaster recovery plans. What cloud model would I be looking at?  

IaaS: Infrastructure as a Service

Which of the following is a way that a company might save money by using a cloud SaaS (Software as a Service)? 

"Upfront costs associated with acquiring new servers are avoided and server operating system software maintenance and patching are handled by the cloud provider rather than the company using the cloud services." 

"A company does not have to buy servers or maintain an enterprise data center when they use SaaS ERP." 

I want to adopt a more healthy living lifestyle and be able to log and monitor my activity from any device and anywhere with internet service. The application I would need resides on what type of cloud model?  

SaaS: Software as a Service

An API might enable a website developer to:  

Integrate a Walk Score (provides walkability analysis and apartment search tools) from another system into the website they are developing

Match the response set with the  appropriate Business Analytics Data Type. 'a'   'b'   'c' 

ordinal

Match the response set with the  appropriate Business Analytics Data Type.'1'   '2'   '3' 

discrete

Match the response set with the  appropriate Business Analytics Data Type.'Chicken'  'Goat'  'Sheep' 

nominal

Match the response set with the  appropriate Business Analytics Data Type. 

'1/3'    '4/11'   '3.141592653589793238' 

continuous

Match the response set with the appropriate IS Data Type 'a'   'b'   'c' 

character

Match the response set with the appropriate IS Data Type '1'   '2'  '3' 

integer

Match the response set with the appropriate IS Data Type 'Chicken'  'Goat'  'Sheep' 

string

Match the response set with the appropriate IS Data Type: '1/3'   '4/11'  '3.141592653589793238' 

float

Match the response set with the appropriate IS Data Type:'True'  'False' 

boolean

List in sequence the evolution an entity takes in utilizing IS and data: 1st tier

Keep the doors open (support transactions and maintain operations) 

List in sequence the evolution an entity takes in utilizing IS and data: 2nd tier

Know the past and current operations 

List in sequence the evolution an entity takes in utilizing IS and data: 3rd tier

Combine internal/external data to provide insight to future options/probabilities and help set strategy 

List  the levels within the Gartner's Analytics maturity model, sequence from lowest  level of difficulty and value to highest level. 

• Descriptive Analytics (What happened?) 

• Diagnostic Analytics (Why did it happen?) 

• Predictive Analytics (What will happen?) 

• Prescriptive Analytics (How can we make it happen?) 

What reason would you want to create a dashboard alongside benchmark data? 

Creating a dashboard alongside benchmark data helps businesses and organizations track performance, identify trends, and make informed decisions.

All but one listed area is a component of an Annual Computer Risk Assessment 

data governance

According to the lecture, characteristics of good GUI includes all but the following 

microsoft standards

Which most closely reflects the three branches of the government?  

data governance

what is ETL

ETL is  moving data from a Transactional Database that is optimized for operations/workflows to a Reporting database the supports analytics. What does the ETL acronym stand for? extract transform load

Hierarchical Database 

Parent-Child Relationship 

Relational Database 

Relationships in the form of tables 

Object-Oriented Database 

Stored in the form of objects 

NoSQL data base can be thought of as... 

Not Only SQL Database

If you have a table 'Alphabet', that has one column called 'Letter' and each record has a unique letter of the alphabet, what is the value of the result set for the SQL Statement: 
SELECT COUNT(Letter) 
FROM Alphabet 
WHERE NOT (Letter='a' OR Letter='b' OR Letter='c'); 

23 

If you have a table 'Alphabet' who has one column called 'Letter' and each row has a unique letter of the alphabet, which SQL statement would NOT return record a?  

Select Letter FROM Alphabet Where Letter LIKE 'a?'

If you have a table 'Alphabet', that has one column called 'Letter' and each record has a unique letter of the alphabet, what is the value of the result set for the SQL Statement: 
SELECT COUNT(Letter) 
FROM Alphabet 
WHERE NOT Letter='a'; 

25

If you have a table 'Alphabet', that has one column called 'Letter' and each record has a unique letter of the alphabet, what is the value of the result set for the SQL Statement:  
SELECT COUNT(letter)  
FROM Alphabet  
WHERE Letter='a' and letter ='b' and letter = 'c' 

0

If you have a table 'Alphabet', that has one column called 'letter' and each record has a unique letter of the alphabet, what is the value of the result set for the SQL Statement: 
 
SELECT COUNT(letter) 
 
FROM Alphabet 
 
WHERE letter='a' or letter ='b' or letter = 'c'  

3

Programming commands rely on syntax-ruled statements that direct action (i.e., input, output, print, assign value, compute value) 

true

What is the result if you compile / run the following Python statement? 
A=10 
B=A+1 
if A==B: 
  print("Draw!") 
elif A>B: 
  print("Bummer!") 
else: 
  print("Oops!") 

Oops!

What is the first block created in a blockchain? 

genesis

Which type of network is best suited for an ocean cruise ship to communicate with the mainland when out to sea? 

WWAN

A trucking system might use IoT sensors on their refrigeration trucks to: 

Pull temperature data and send it to the cloud-based database for food safety analysis

What is a function that converts an input of letters and numbers into an encrypted output? 

Hash

For the Python Statement: How_big = input("Enter a choice (small, medium, large): ") 

How_big will have the value of whatever the user types

AI has been around since the 1950's 

True 

Generative AI can create various types of content including text, images, but not video or audio. 

False

 Robotic Process Automation (RPA) bots can make significant impact on already automated work processes that are repetitive and recurring and often have low computer errors 

true

Just because a process is legal does not mean it is ethical.  

true

There are three correct statements and one incorrect statement about Artificial Intelligence(AI). Identify the incorrect statement.  

AI hallucination is the same as generative AI bias that occurs when the training data has biases. 

A trucking system might use IoT sensors on their refrigeration trucks to: 

Pull temperature data and send it to the cloud-based database for food safety analysis

DATA PRIVACY 

Responsibly collecting -   
 using and storing data about people - in line with their expectations - regulations  and laws  

CONFIDENTIALITY 

The assurance that information remain available only to those authorized to view them 

DATA ETHICS 

Doing the right thing with data - considering the human impact from all perspectives and making decisions based on brand values 

The Agile product backlog is: 

A list of product features wanted by the product owner

Which WHERE clause  would NOT select the letter z record in the SQL statement  
SELECT letter  
FROM ALPHABET  
WHERE .... 

Where letter LIKE '?'

For the Python Statement: How_big = input("Enter a choice (small, medium, large): ") 

How_big will have the value of whatever the user types

Daily Scrum is where stakeholders meet with the technical team at the end of the day to provide feedback on the work thus far. 

False 

An API might enable a website developer to: 

"Integrate a Walk Score another system into the website they are developing."