OMIS 351 Final Exam- Questions &
Answers
Which of the following is not considered an advantage of Hadoop?
flexibility.
relational structure
scalability
cost effectiveness.
fault tolerance. Correct Ans-relational structure
Which of the following is not usually a part of a table in a database?
Field
Column
Query
Record
Primary Key Correct Ans-Query
A table in Access must have a primary key to:
uniquely identify records and form relationships with other tables
,keep the data "unlocked"
match its foreign key
establish primary business-technology solutions
None of the above Correct Ans-uniquely identify records and form relationships with other
tables
_____ is a method of querying and reporting that takes data from standard relational databases,
calculates and summarizes the data, and then stores the data in a special database called a data
cube.
Ad hoc reporting
E-discovery
Data aggregation
Online analytical processing
Data adjacency Correct Ans-Online analytical processing
E-discovery refers to:
identifying and retrieving relevant electronic information to support litigation efforts.
something a firm does not account for in its archiving and data storage plans.
older information systems that are often incompatible with other systems, technologies, and
ways of conducting business.
collecting and reselling data.
,rewards and usage incentive, typically in exchange for a method that provides a more detailed
tracking and recording of consumer activity. Correct Ans-identifying and retrieving relevant
electronic information to support litigation efforts.
Which of the following is FALSE?
Data mining is done mostly by the computer (automatically).
A data mart is smaller than a data warehouse.
SQL is a computer language to create queries (ask questions about the data).
A data warehouse would probably be stored on Access in a Fortune 500 company.
Data warehouses support OLAP, mining, and data marts. Correct Ans-A data warehouse
would probably be stored on Access in a Fortune 500 company.
How did Dr. Downing improve the organic search results for his Kirk Herbstriet joke in fall 2012
(How would anyone improve such results)?
By using Cloud computing
By using Just-in-time e-commerce
By practicing internet privacy and security legislation
By linking text lie "NIU BCS Kirk Herbstreit joke" to Chuckdowning.com from webpages
By using RFID Correct Ans-By linking text lie "NIU BCS Kirk Herbstreit joke" to
Chuckdowning.com from webpages
, The ____ measures the percentage of people who clicked on an ad to arrive at a destination site
churn rate
quality score
click-through rate
impression elasticity
eyeball score Correct Ans-click-through rate
Search engines use _____ to discover documents for indexing and retrieval
caches
landing pages
web crawlers
proxy servers
interstitial Correct Ans-web crawlers
What is a data warehouse?
A way to find unanticipated answers to business questions
A building where the company's databases are housed
A large, batch updated and cleaned database storing organization-wide data
Answers
Which of the following is not considered an advantage of Hadoop?
flexibility.
relational structure
scalability
cost effectiveness.
fault tolerance. Correct Ans-relational structure
Which of the following is not usually a part of a table in a database?
Field
Column
Query
Record
Primary Key Correct Ans-Query
A table in Access must have a primary key to:
uniquely identify records and form relationships with other tables
,keep the data "unlocked"
match its foreign key
establish primary business-technology solutions
None of the above Correct Ans-uniquely identify records and form relationships with other
tables
_____ is a method of querying and reporting that takes data from standard relational databases,
calculates and summarizes the data, and then stores the data in a special database called a data
cube.
Ad hoc reporting
E-discovery
Data aggregation
Online analytical processing
Data adjacency Correct Ans-Online analytical processing
E-discovery refers to:
identifying and retrieving relevant electronic information to support litigation efforts.
something a firm does not account for in its archiving and data storage plans.
older information systems that are often incompatible with other systems, technologies, and
ways of conducting business.
collecting and reselling data.
,rewards and usage incentive, typically in exchange for a method that provides a more detailed
tracking and recording of consumer activity. Correct Ans-identifying and retrieving relevant
electronic information to support litigation efforts.
Which of the following is FALSE?
Data mining is done mostly by the computer (automatically).
A data mart is smaller than a data warehouse.
SQL is a computer language to create queries (ask questions about the data).
A data warehouse would probably be stored on Access in a Fortune 500 company.
Data warehouses support OLAP, mining, and data marts. Correct Ans-A data warehouse
would probably be stored on Access in a Fortune 500 company.
How did Dr. Downing improve the organic search results for his Kirk Herbstriet joke in fall 2012
(How would anyone improve such results)?
By using Cloud computing
By using Just-in-time e-commerce
By practicing internet privacy and security legislation
By linking text lie "NIU BCS Kirk Herbstreit joke" to Chuckdowning.com from webpages
By using RFID Correct Ans-By linking text lie "NIU BCS Kirk Herbstreit joke" to
Chuckdowning.com from webpages
, The ____ measures the percentage of people who clicked on an ad to arrive at a destination site
churn rate
quality score
click-through rate
impression elasticity
eyeball score Correct Ans-click-through rate
Search engines use _____ to discover documents for indexing and retrieval
caches
landing pages
web crawlers
proxy servers
interstitial Correct Ans-web crawlers
What is a data warehouse?
A way to find unanticipated answers to business questions
A building where the company's databases are housed
A large, batch updated and cleaned database storing organization-wide data
