Info Systems Final

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' or letter ='b' or 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' and letter ='b' and letter = 'c'

Where letter LIKE '*'

Which WHERE clause would NOT select the letter z record in the SQL statement

SELECT letter

FROM ALPHABET

WHERE ....

TravelOption will have the value of whatever the user types

For the Python Statement: TravelOption = input("Enter a choice (car, bike, plane): ")

Bummer!

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!")

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

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

True

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

False

AI is really good at responding to math questions because they are all formulas.

Structures it data into tables

All but which one is a characteristic of a blockchain?

True

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

IaaS: Infrastructure 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?

A list of product features wanted by the product owner

The Agile product backlog is:

True

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

True

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

All the options are correct.

Which statement best describes how variables are used in programs?

Select Letter FROM Alphabet Where Letter LIKE 'a?'

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?

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 NOT Letter='a'

True

SQL is primarily a query language vs a database.

Parent-Child Relationship

Hierarchical Databas matches

Relationships in the form of tables

Relational Database matches

Stored in the form of objects

Object-Oriented Database matches

Extract Transform Load

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?

True

The shortest path between two points tends to be the simpler the design, the less number of points of failure.

lift and shift

Rehosting matches

rip and replace

Re-architecting matches

drop and shop

Retiring and Repurchasing matches

Data Governance

Which most closely reflects the three branches of the government?

All of the answers are correct

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

text

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

What happened?

Descriptive Analytics

Why did it happen?

Diagnostic Analytics

What will happen?

Predictive Analytics

How can we make it happen?

Prescriptive Analytics

1st Tier

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

2nd Tier

Know the past and current operations matches

3rd Tier

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

There are different colors regarding each major. This infographic is not consistent with information layout

What is misleading with this infographic?

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.

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

SaaS: Software as a Service

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 is what type of cloud mode

PaaS: Platform as a Service

I am a UI student who has this great idea that uses public available data to build an app that shares 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?

Multi-Processing (Parallel)

A large problem can often be divided into smaller ones. which then all the component of the large problem can be solved at the same time.

Hardware

computer, mouse, keyboard, radio, printer, Flashdrive, speaker, controller

software

spotify, gmail, google drive, maps, compass, word, chrome, outlook, apps

on-premise

IT infrastructure hardware and software applications that are hosted on-site

Evolution of data storage

1. On-demand availability data storage/computing power

2. Free of direct active management

3. Shared resources achieves economics of scale

cloud computing pros

1. Minimize up-IT infrastructure costs

2. Get apps up/running faster with improved manageability/ less maintenance

3. Enable rapidly adjust resources to meet fluctuating / unpredictable demand

4. Manage firewalls, intrusion identification and counteractive action frameworks and info stream inside the network

cloud computing cons

"pay as you go" model can lead to unexpected operating expenses if administrators are not familiarized with cloud pricing models

SaaS: Software as a Service

1. IaaS Functions

2. PaaS functions

3. hosted applications/apps

4. accessible via web browser

5. priced on a pay-per-use basis/subscription fee

PaaS: Platform as a Service

1. IaaS functions

2. Operating systems

3. development tools, database management, business analytics

4. development and deployment environment

IaaS: Infrastructure as a Service

1. servers, storage and networking firewalls/ security

2. Data center physical plant/building

Common uses: business continuity, disaster recovery

Structured Data

String, character, integer, float, boolean

string

used for a combination of any characters that appear on a keyboard, such as: letters, numbers, symbols

character

used for single letters

integer

used for whole numbers

float

used for numbers that contain decimal points, or factions

boolean

used where data is restricted to True/False or yes/no options

qualitative data types

nominal and ordinal

nominal

set of values that do not possess a natural ordering (not quantifiable and cannot be measured through numerical units)

Example: blue, yellow, red

ordinal

natural ordering

Ex: small, medium, large

quantitative data types

discrete and continuous

discrete

integers or whole numbers

continuous

fractional numbers

Word Cloud

1. understand what your audience feels about a topic/situation

2. You audience can summarize their view of a topic

Unstructured Data

BLOB and CLOB

BLOB (Binary Large Object)

images, audio files, and video clips

CLOB (Character Large Object)

often source remains at native location and CLOB field is an address which references the location of the data

Example: books, medical record document

API

Application Programming Interface. Software intermediary that allows 2 applications to talk to each other

Sentiment analysis

a natural language processing technique used to determine whether data is positive, negative, or neutral

infographic

representing info in a graphical format so data is easily understandable at a glance

100% stacked column

compare % that each value contributes to the total over time

cluster column

compare values across a few categories

Treemap

visualizing larg enumber of related categories

Pie Chart

compare categories, or parts of a whole

sparkline

tiny chart in a worksheet cell that provides a visual representation of data

- shows trends in a series of values

consolidation

roll-up in groupings to help digest

drill-down

view details

slice and dice

look at info from different perspectives

pivot

rotate data to display alternative perspectives

Good GUI

1. self documenting

2. minimizes data collect errors

3. enhances overall understanding

Good Dashboard elements

visualization, focus, collaboration, responsiveness benchmarking, self serving dashboards, graphicacy,

Cybersecurity Framework

moral, ethical and societal duty to protect the public from harm and that everyone is able to enjoy the benefits

elements of cybersecurity

Creates new safety and security standards for AI, protects consumer privacy, advances equity and civil rights, supports workers, promotes innovation

data goverance

If you know where your data is, who has access to it, and what they are doing with it, you will notice any malicious activity far more quickly.

safeguards

The existence of the data, maintaining of the data and data integrity, definition of the data, appropiate use and access of the data and disposal of the data

Annual Risk Assessment of Safeguards

administrative, physical, and technical

Rick

Threat + Vulnerability

Natural Threats

floods, tornadoes, storms, etc

unintentional threats

employee mistakenly accessing wrong info

intentional threats

spyware, malware, adware companies, or the action of a disgruntled employee

How to prevent threats

Team members stay informed, perform regular threat assessments, and conduct penetration testing

vulnerability

KNOWN weakness that can be exploited by an attacker

data breach

info is accessed and extracted without authorization

data leak

data located where it is NOT supposed to be

- confidential info open to the public, sold on the black market or held for ransom

data alteration

info changed / cannot be restored to previous state

unreliable storage medium storage

data lost due to problems on cloud provider's side

data deletion

accidental / wrongful erasure of info with NO backups (human error / messy database)

loss of access

info in the system but unavailable due to lack of encryption keys and other credentials

geodiversity

when physical location of cloud servers in data centers is dispersed - safeguard for natural disasters / power outages

Denial of Service Attack

make system unusable , so deny access / disrupt workflow

up-to-date Intrusion Detection System

identify anomalous traffic, provide early warning based on credentials and behavioral factors (cloud security break-in alarm)