Final Exam for Information Systems UPDATED Exam Questions and CORRECT Answers
5 views 0 purchase
Course
Information Systems
Institution
Information Systems
Final Exam for Information Systems
UPDATED Exam Questions and
CORRECT Answers
1) Which of the following, (1) money deposited in a bank account, (2) student recording her
answer to a question in an online test, (3) customer adding an item to the online shopping
cart, are considered transacti...
Final Exam for Information Systems
UPDATED Exam Questions and
CORRECT Answers
1) Which of the following, (1) money deposited in a bank account, (2) student recording her
answer to a question in an online test, (3) customer adding an item to the online shopping
cart, are considered transactions in an information system? - Correct Answer- All of them
2) A(n) _____ can replace many applications with one unified set of programs, this system
can then be used to manage all its vital business operations. - Correct Answer- Enterprise
resource planning system
3) Which of the following is true about structured data from an Online Transaction
Processing System? - Correct Answer- Each transaction is processed at the time of entry
4) Which of the following is true about structured data from an Online Transaction
Processing System? - Correct Answer- Point of Sale system that reads a UPC code in an
example
5) Transaction processing systems that support a large enterprise typically store data in a -
Correct Answer- Relational database
6) Transaction processing system output might be used for - Correct Answer- Developing a
predictive model for future student enrollment
Reporting for evaluating revenue in an e-commerce sales system
Input into a separate system
2 of the above are correct
Which of the following is NOT considered a business intelligence (BI) practice or tool? -
Correct Answer- Transaction processing controls
Which of the following is an example of unstructured data - Correct Answer- a. University of
Iowa course registrations
,b. Social media posts
c. University of Iowa payment amounts received for tuition
d. Clickstream data
e. 2 of the above are examples
9) Data used in business intelligence (BI) analysis could come from which of the following
sources: - Correct Answer- a. An OLTP internal system
b. Unstructured data from sources outside the company
c. Unstructured data from sources inside the company
e. All of the above are correct
Online Transaction Processing (OLTP) - Correct Answer- Transaction processing system
(TPS) that processes data after transactions occur, frequently in real time.
relational database - Correct Answer- A database that represents data as a collection of tables
in which all data relationships are represented by common values in related tables
OLTP - Correct Answer- Structured data
Tables, Data types, Relationships
Unstructured data is - Correct Answer- NO SQL
Different than Relational Database
System Integration - Correct Answer- systems work together to maintain homeostasis
Real time
E-Commerce sales system
Purchasing system
ETL (extraction, transformation, and loading) - Correct Answer- A process that extracts
information from internal and external databases, transforms the information using a common
set of enterprise definitions, and loads the information into a data warehouse
, Business Intelligence (BI) - Correct Answer- a broad category of applications, technologies,
and processes for gathering, storing, accessing, and analyzing data to help business users
make better decisions
RTO - Recovery Time Objective - Correct Answer- The maximum amount of time that a
process or service is allowed to be down and the consequences still to be considered
acceptable.
RPO (Recovery Point Objective) - Correct Answer- The maximum length of time that an
organization can tolerate between backups.
10) A business intelligence (BI) predictive model that predicts whether a student accepted to
the Tippie COB will actually enroll in the Tippie COB; might use: - Correct Answer-
Structured and Unstructured Data
11) Big and unstructured data is often stored in a NoSQL database for which of these reasons:
- Correct Answer- Data is spread over multiple servers leading to better response times for
queries
12) NoSQL databases require a company to: - Correct Answer- a. Model a business process
prior to building the database and then not allow changes to the database
b. Specifically define the data type for each attribute in the NoSQL table
c. Store data in rows and columns
e. None of the above are correct
13) Multi-valued fields in relational databases are: - Correct Answer- Not allowed
14) When assessing security threats and procedures for endpoints; which of the following is
True: - Correct Answer- All endpoints should have an up-to-date Operating System installed
15) When assessing security threats and procedures for servers; which of the following is
True: - Correct Answer- Servers and endpoints might have different security risk levels
16) After assessing security threats and procedures for IT Systems: - Correct Answer- Servers
and endpoints might have different security risk levels
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
