Information Systems Tophats

Match the response set with the appropriate IS Data Type

'a'   'b'   'c' matches Character

'1'   '2'  '3' matches Integer

'Chicken'  'Goat'  'Sheep' matches String

'1/3'   '4/11'  '3.141592653589793238' matches Float

'True'  'False' matches Boolean

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

'a' 'b' 'c' matches Ordinal

'1' '2' '3' matches Discrete

'Chicken'  'Goat'  'Sheep' matches Nominal

'1/3'    '4/11'   '3.141592653589793238' matches Continuous

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

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

List in sequence the evolution an entity takes in utilizing IS and data 

Keep the doors open (support transactions and maintain operations) matches 1st Tier

Know the past and current operations matches 2nd Tier

Combine internal/external data to provide insight to future options/probabilities and help set strategy matches 3rd Tier

All but which is a format that you would use to present information with graphicacy.  

text

Which most closely reflects the three branches of the government? 

Data Governance

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

Follows Microsoft Standards

A Master Data Management (MDM) system will describe all but which about a data variable?

Why

NoSQL data base can be thought of as...

Not Only SQL Database

Match the Database Type with the featured characteristic

Hierarchical Database matches Parent-Child Relationship

Relational Database matches Relationships in the form of tables

Object-Oriented Database matches Stored in the form of objects

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

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' 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' OR Letter='b' OR Letter='c');

23

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

True

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

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

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!

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

How big will have the value of whatever the user types 

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

Hash

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

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

WWAN

What is the first block created in a blockchain?

Genesis

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. 

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

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

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

True

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

False

The Waterfall and Agile Project Planning methods both incorporate Plan, Create, Review and Release phases.

True

The Agile product backlog is:

A list of product features wanted by the product owner

Match the Data Privacy, Confidentiality and Ethics terms to their definition 

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

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

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