ISTM 210 - Exam 3 (Phinney) Questions And
Answers Verified 100% Correct
Parameter Query - ANSWER -Allows you to specify a criterion for the query
results at the time that the query is executed by displaying a window to the user
that asks the for an input
[ ] - ANSWER -To make a parameter query, what needs to go around the question
in the criteria box?
Multi-Table Queries - ANSWER -Used to display results from fields on different
tables
Aggregate Queries - ANSWER -Used to calculating summary statistics. Also used
to group query results into categories based on the values for a field and then
perform calculations for each category
Group By - ANSWER -Uses the values for that field to categorize the records in
the query results
Where - ANSWER -Used to add criteria for that field
Queries with Calculated fields - ANSWER -Perform arithmetic or apply a prebuilt
formula on the values in our database tables
[field name] +, *, - [ field name]
Crosstab Queries - ANSWER -Used to create a multi-dimensional view of our
data
True - ANSWER -True or False: Crosstab queries are always aggregate queries.
, Netflix - ANSWER -For April Fools day, an example of a company who used
their website as a joke was _______.
BANA - ANSWER -The old ISYS class was called _______.
Moore's Law - ANSWER -Cloud computing is making which law untrue?
eCampus - ANSWER -What is switching to the cloud soon?
16 - ANSWER -If tamu password is longer than ____ characters you can keep it
for 4 years without having to change it
Gracie Ellen - ANSWER -What is the name of Phinney's grandbaby?
April 2nd at 6:30 a.m - ANSWER -When was Phinney's grandbaby born?
Spring - ANSWER -In what season were all of Phinney's kids born?
74 - ANSWER -How many points did Phinney get on the word "query" in words
with friends?
Greg Stankey - ANSWER -Who is the commissioner of the SEC?
Decision Support Systems (DSS) - ANSWER -The concept of _________
__________ __________ evolved as academic research.
Unstructured data - ANSWER -Facebook posts, Instagram pictures, Twitter
Tweets, Youtube videos, etc. are examples of what type of data?
Veracity - ANSWER -Lots of data is not "clean." What begs the question " Is the
data your organization collected any good?"
Structured, semi-structured, unstructured - ANSWER -Variety refers to what
possible combinations of collected data types?
, Velocity - ANSWER -"How fast can you collect your data?" refers to
Customer Relationship Management (CRMs) - ANSWER -System that holds
information about sales, marketing, customer service records, and much more...
Data warehouses - ANSWER -It's like a warehouse that houses wheat crops
A datamart - ANSWER -You're a smaller organization and aren't dealing with as
big or complex of data, so you use...
Normalizing data - ANSWER -_______means that your data is typically
organized into the fields and records of a relational database..
ETL (extract, transform, load) - ANSWER -It can eat bandwith at an alarming rate
Their return on investment - ANSWER -What should a business consider when
choosing how to collect, translate, and transport data?
ETL - ANSWER -Used to standardize data across systems
Centralize an organization's data so that it ends up being a wealth of data with
value across the organization - ANSWER -What is one of the main functions of an
ERP (Enterprise Resource Planning)?
cluster, muliple servers - ANSWER -Hadoop uses a _________ system that allows
files to be stored on __________ ______________.
Facebook, eBay, Amazon, and American Express because they create Terabytes
and Petabytes of data every day. They have highly qualified data scientists to deal
with the complexity of Hadoop. - ANSWER -Hadoop is best for what large
companies? Why?
It allows data to be queried and processed directly on the server where it lives,
instead of moving the data across the network to be analyzed on the computer. -
Answers Verified 100% Correct
Parameter Query - ANSWER -Allows you to specify a criterion for the query
results at the time that the query is executed by displaying a window to the user
that asks the for an input
[ ] - ANSWER -To make a parameter query, what needs to go around the question
in the criteria box?
Multi-Table Queries - ANSWER -Used to display results from fields on different
tables
Aggregate Queries - ANSWER -Used to calculating summary statistics. Also used
to group query results into categories based on the values for a field and then
perform calculations for each category
Group By - ANSWER -Uses the values for that field to categorize the records in
the query results
Where - ANSWER -Used to add criteria for that field
Queries with Calculated fields - ANSWER -Perform arithmetic or apply a prebuilt
formula on the values in our database tables
[field name] +, *, - [ field name]
Crosstab Queries - ANSWER -Used to create a multi-dimensional view of our
data
True - ANSWER -True or False: Crosstab queries are always aggregate queries.
, Netflix - ANSWER -For April Fools day, an example of a company who used
their website as a joke was _______.
BANA - ANSWER -The old ISYS class was called _______.
Moore's Law - ANSWER -Cloud computing is making which law untrue?
eCampus - ANSWER -What is switching to the cloud soon?
16 - ANSWER -If tamu password is longer than ____ characters you can keep it
for 4 years without having to change it
Gracie Ellen - ANSWER -What is the name of Phinney's grandbaby?
April 2nd at 6:30 a.m - ANSWER -When was Phinney's grandbaby born?
Spring - ANSWER -In what season were all of Phinney's kids born?
74 - ANSWER -How many points did Phinney get on the word "query" in words
with friends?
Greg Stankey - ANSWER -Who is the commissioner of the SEC?
Decision Support Systems (DSS) - ANSWER -The concept of _________
__________ __________ evolved as academic research.
Unstructured data - ANSWER -Facebook posts, Instagram pictures, Twitter
Tweets, Youtube videos, etc. are examples of what type of data?
Veracity - ANSWER -Lots of data is not "clean." What begs the question " Is the
data your organization collected any good?"
Structured, semi-structured, unstructured - ANSWER -Variety refers to what
possible combinations of collected data types?
, Velocity - ANSWER -"How fast can you collect your data?" refers to
Customer Relationship Management (CRMs) - ANSWER -System that holds
information about sales, marketing, customer service records, and much more...
Data warehouses - ANSWER -It's like a warehouse that houses wheat crops
A datamart - ANSWER -You're a smaller organization and aren't dealing with as
big or complex of data, so you use...
Normalizing data - ANSWER -_______means that your data is typically
organized into the fields and records of a relational database..
ETL (extract, transform, load) - ANSWER -It can eat bandwith at an alarming rate
Their return on investment - ANSWER -What should a business consider when
choosing how to collect, translate, and transport data?
ETL - ANSWER -Used to standardize data across systems
Centralize an organization's data so that it ends up being a wealth of data with
value across the organization - ANSWER -What is one of the main functions of an
ERP (Enterprise Resource Planning)?
cluster, muliple servers - ANSWER -Hadoop uses a _________ system that allows
files to be stored on __________ ______________.
Facebook, eBay, Amazon, and American Express because they create Terabytes
and Petabytes of data every day. They have highly qualified data scientists to deal
with the complexity of Hadoop. - ANSWER -Hadoop is best for what large
companies? Why?
It allows data to be queried and processed directly on the server where it lives,
instead of moving the data across the network to be analyzed on the computer. -
