Information Systems Exam (UIOWA)
Questions with Complete Rationales
2026-2027 Updated.
Scraping of data from the web can be accomplished by using which of the following tools: -
Answer Microsoft Excel
A python program
A software tool specifically designed for scraping
Copying a table of data from a web page and pasting into Excel
**All of the above are correct
A company might choose to scrape data from a website for which of the following reasons -
Answer Follows your sitemap instructions.
The Google Chrome web scraper extension: - Answer Follows your sitemap instructions.
The which of the following is required by the Google Chrome web scraper extension before you
can actually scrape the data: - Answer A sitemap
A starting point url
A Google Chrome web scraper extension sitemap uses which of the following to grab data from
a page: - Answer A SelectorLink selector type
The Google Chrome web scraper extension might allow us to: - Answer Move from one page
on a website to another page on a website in order to collect related data.
An API: - Answer Can be 'called' from an Excel spreadsheet and the data can be used for BI
analysis.
An API will have - Answer Multiples urls where each individual url will handle a request for
specific resource data.
The organic farms API used in lab; returned data in which format: - Answer JSON
,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? - Answer All of them
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. - Answer enterprise resource
planning system
Which of the following is true about structured data from an Online Transaction Processing
System? - Answer Each transaction is processed at the time of entry
Which of the following is true about structured data from an Online Transaction Processing
System? - Answer Point of Sale system that reads a UPC code is an example
Transaction processing systems that support a large enterprise typically store data in a: - Answer
Relational database
Which of the following is NOT considered a business intelligence (BI) practice or tool? - Answer
Transaction processing controls
Which of the following is considered a business intelligence (BI) practice or tool? - Answer
Data extraction
Visualization
Predictive Modeling
Which of the following is an example of unstructured data: - Answer Social media posts
Clickstream data
9) Data used in business intelligence (BI) analysis could come from which of the following
sources - Answer a. An OLTP internal system
b. Unstructured data from sources outside the company
c. Unstructured data from sources inside the company
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: - Answer Structured and
Unstructured Data
Big and unstructured data is often stored in a NoSQL database for which of these reasons: -
Answer Data is spread over multiple servers leading to better response times for queries
, NoSQL databases DOES NOT require a company to - 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
1Multi-valued fields in relational databases are: - Answer Not allowed
When assessing security threats and procedures for endpoints; which of the following is True: -
Answer c. All endpoints should have an up-to-date Operating System installed
&
c. All servers should have an up-to-date Operating System installed
After assessing security threats and procedures for IT Systems: - Answer Servers and endpoints
might have different security risk levels
17) A company buys and receives products from suppliers that they will sell on their e-
commerce site. Once they receive the products from the suppliers and record it in their
Purchasing System; they create a spreadsheet of products and quantities received; and then
manually update the quantity available for sale in their ecommerce system. Real-time system
integration might enable them to: - Answer Sell more products by having more accurate and
real-time data
18) A company buys and receives products from suppliers that they will sell on their e-
commerce site. Once they receive the products from the suppliers and record it in their
Purchasing System; they create a spreadsheet of products and quantities received; and then
manually update the quantity available for sale in their ecommerce system. Options for real-
time system integration software are: - Answer Buy real-time system integration software from
a software provider and implement it
19) Which of the following is an example that would need to use an ETL process: - Answer
Merging sales data with advertising data and deploying the merged data into a business
intelligence tool
Moving data from the old system into a newly developed and deployed system
20) Before importing data into Access from another source; like Excel; the data should be
cleaned. Converting multi valued columns in Excel into multiple columns in Excel prior to
moving to Access: - Answer a. Is necessary as Access doesn't uses multi-valued fields
b. Is necessary as Access doesn't converts multi-valued Excel columns into multiple columns
when you run a Make Table query
c. Is necessary as Access
Questions with Complete Rationales
2026-2027 Updated.
Scraping of data from the web can be accomplished by using which of the following tools: -
Answer Microsoft Excel
A python program
A software tool specifically designed for scraping
Copying a table of data from a web page and pasting into Excel
**All of the above are correct
A company might choose to scrape data from a website for which of the following reasons -
Answer Follows your sitemap instructions.
The Google Chrome web scraper extension: - Answer Follows your sitemap instructions.
The which of the following is required by the Google Chrome web scraper extension before you
can actually scrape the data: - Answer A sitemap
A starting point url
A Google Chrome web scraper extension sitemap uses which of the following to grab data from
a page: - Answer A SelectorLink selector type
The Google Chrome web scraper extension might allow us to: - Answer Move from one page
on a website to another page on a website in order to collect related data.
An API: - Answer Can be 'called' from an Excel spreadsheet and the data can be used for BI
analysis.
An API will have - Answer Multiples urls where each individual url will handle a request for
specific resource data.
The organic farms API used in lab; returned data in which format: - Answer JSON
,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? - Answer All of them
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. - Answer enterprise resource
planning system
Which of the following is true about structured data from an Online Transaction Processing
System? - Answer Each transaction is processed at the time of entry
Which of the following is true about structured data from an Online Transaction Processing
System? - Answer Point of Sale system that reads a UPC code is an example
Transaction processing systems that support a large enterprise typically store data in a: - Answer
Relational database
Which of the following is NOT considered a business intelligence (BI) practice or tool? - Answer
Transaction processing controls
Which of the following is considered a business intelligence (BI) practice or tool? - Answer
Data extraction
Visualization
Predictive Modeling
Which of the following is an example of unstructured data: - Answer Social media posts
Clickstream data
9) Data used in business intelligence (BI) analysis could come from which of the following
sources - Answer a. An OLTP internal system
b. Unstructured data from sources outside the company
c. Unstructured data from sources inside the company
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: - Answer Structured and
Unstructured Data
Big and unstructured data is often stored in a NoSQL database for which of these reasons: -
Answer Data is spread over multiple servers leading to better response times for queries
, NoSQL databases DOES NOT require a company to - 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
1Multi-valued fields in relational databases are: - Answer Not allowed
When assessing security threats and procedures for endpoints; which of the following is True: -
Answer c. All endpoints should have an up-to-date Operating System installed
&
c. All servers should have an up-to-date Operating System installed
After assessing security threats and procedures for IT Systems: - Answer Servers and endpoints
might have different security risk levels
17) A company buys and receives products from suppliers that they will sell on their e-
commerce site. Once they receive the products from the suppliers and record it in their
Purchasing System; they create a spreadsheet of products and quantities received; and then
manually update the quantity available for sale in their ecommerce system. Real-time system
integration might enable them to: - Answer Sell more products by having more accurate and
real-time data
18) A company buys and receives products from suppliers that they will sell on their e-
commerce site. Once they receive the products from the suppliers and record it in their
Purchasing System; they create a spreadsheet of products and quantities received; and then
manually update the quantity available for sale in their ecommerce system. Options for real-
time system integration software are: - Answer Buy real-time system integration software from
a software provider and implement it
19) Which of the following is an example that would need to use an ETL process: - Answer
Merging sales data with advertising data and deploying the merged data into a business
intelligence tool
Moving data from the old system into a newly developed and deployed system
20) Before importing data into Access from another source; like Excel; the data should be
cleaned. Converting multi valued columns in Excel into multiple columns in Excel prior to
moving to Access: - Answer a. Is necessary as Access doesn't uses multi-valued fields
b. Is necessary as Access doesn't converts multi-valued Excel columns into multiple columns
when you run a Make Table query
c. Is necessary as Access
