Info Systems TopHat

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

o   A- Large Language Models are Deep Learning algorithms capable of summarizing, creating, predicting, translating and synthesizing text because that are trained on an enormous amount of data.

o   B- Generative AI can create various types of content including text, images, video and audio.

o   C- Machine Learning Training involves feeding the system millions of labeled images, for which it identifies statistical patterns in pictures and uses those patterns to recognize and classify newly presented images.

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

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

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

A- No savings as companies still need to pay license software fees

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

C- Companies can send their already purchased/owned servers to the cloud provider to use when the software use increases.

D- A company does not have to buy servers or maintain a data center when they use a Saas System.

E- Two of the listed response are correct.

E- Two of the listed response are correct. (B&D)

3. An API might enable a website developer to:

o   A- Manually cut copy paste data from another website into the site they are developing

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

o   C- Handle all project management details

o   D- Get  all products they will sell on their e-commerce site delivered for free

o   E- Action Plan

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

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

o   A- Monitor and mostly replace their entire Customer Relationship Management(CRM) system

o   B- Replace their network firewall

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

o   D- To monitor and mostly replace their ERP (Enterprise Resource Planning) system

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

5.  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?

o   A- Select Letter FROM Alphabet Where Letter LIKE 'a*'

o   B- Select Letter FROM Alphabet Where Letter LIKE '*a'

o   C- Select Letter FROM Alphabet Where Letter LIKE 'a?'

o   D- Select Letter FROM Alphabet Where Letter ='a'

o   C- Select Letter FROM Alphabet Where Letter LIKE 'a?'

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

o   A- How_big  will have the value of small, medium or large

o   B- How_big will have the value of whatever the user types

o   B- How_big will have the value of whatever the user types

The Agile product backlog is:

a- A list of product features wanted by the product owner

b- A list of very detailed requirements and tasks

c- Only useful for a small software project

d- A design diagram

a- A list of product features wanted by the product owner

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

a- True

b- False

a- 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.

a- True

b-False

b- False

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

a- Draw!

b- Bummer!

c- Oops!

c- Oops!

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

a

WHERE letter LIKE 'z*'

b

WHERE letter LIKE '*z'

c

WHERE letter LIKE 'z'

d

Where letter LIKE '?'

e

Where letter LIKE 'z?'

f

Where letter LIKE '*'

e

Where letter LIKE 'z?'This clause checks for records that contain the letter 'z' followed by any single character, excluding standalone 'z'.

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='z';

a- 25

b- 26

c- 1

d- This is not a valid SQL statement, so there would be no result

a- 25