OMIS 351 EXAMINATION QUESTIONS AND 100%
VERIFIED ANSWERS
Why does Facebook have a lower click-through rate on ads than Google (pick the single best
answer)? A. Google users have a focused interest ("hunt"). B. Facebook users have much less
focus ("hike"). C. Facebook is used more for brand building. D. All of these. - D. All of
these.
Which Big Data characteristic does a security camera, recording 24/7, definitely demonstrate?
A. Volume
B. Variety
C. Velocity
D. Value
E. Veracity - A. Volume
Why is the current Unit, Unit 6, important (pick the single best answer)?
A. Because we need Business Intelligence
B. Because we've got these wonderful devices that process 1's and 0's quickly and remember
them almost perfectly, and we need to understand how they get connected.
C. Because we need to understand how to match technology solutions to business problems.
,D. Because Web 2.0 is exploding, users are generating content, many voices are being heard,
and businesses better pay attention. - A. Because we need Business Intelligence
Using these sheets, how would you answer the Dean's question ("What did Marketing students
average on Q4?")?
A. Sort both sheets by znumber, copy the Major column over, average the Marketing students.
B. Sort the registrar sheet by Major, then use "Find" on the Q4 sheet and average scores.
C. Import both sheets into a Relational Database, then run a query for Marketing average on Q4.
- C. Import both sheets into a Relational Database, then run a query for Marketing
average on Q4.
What is an Excel column heading in Access?
A. Field
B. Record
C. Table
D. Character - A. Field
What is an Excel row in Access?
A. Field
B. Record
,C. Table
D. Character - B. Record
What is an Excel spreadsheet in Access?
A. Field
B. Record
C. Table
D. Character - C. Table
Why is it bad that 32% of corporate information is stored in spreadsheets?
A. Often information needs to be integrated from many sources, and separate spreadsheets do
not do this well.
B. Because big data has such high volume it will overwhelm the spreadsheets.
C. Because analytics cannot be run on spreadsheets.
D. Because it should be closer to 100%. - A. Often information needs to be integrated
from many sources, and separate spreadsheets do not do this well.
If information on Customers, Orders, and Products are being stored in different spreadsheets in
different departments, are there any problems? If "yes", what?
A. No.
, B. Yes. They take up too much disk space.
C. Yes. The sheets don't talk to each other... we won't have BI.
D. Yes. The sheets should be in a PivotTable. - C. Yes. The sheets don't talk to each other...
we won't have BI.
For VC4, how would you get this data on the web page into Access? [Note: VC4: Tables (with
def), keys, relationships, forms]
A. Copy/paste into Access.
B. Copy/paste into Excel then import into Access.
C. Use the "Import from Web Page" Wizard in Access.
D. Type it in. - B. Copy/paste into Excel then import into Access.
Which of the four tabs in Access is used to import Excel data?
A. File
B. Create
C. External Data
D. Database Tools - C. External Data
VERIFIED ANSWERS
Why does Facebook have a lower click-through rate on ads than Google (pick the single best
answer)? A. Google users have a focused interest ("hunt"). B. Facebook users have much less
focus ("hike"). C. Facebook is used more for brand building. D. All of these. - D. All of
these.
Which Big Data characteristic does a security camera, recording 24/7, definitely demonstrate?
A. Volume
B. Variety
C. Velocity
D. Value
E. Veracity - A. Volume
Why is the current Unit, Unit 6, important (pick the single best answer)?
A. Because we need Business Intelligence
B. Because we've got these wonderful devices that process 1's and 0's quickly and remember
them almost perfectly, and we need to understand how they get connected.
C. Because we need to understand how to match technology solutions to business problems.
,D. Because Web 2.0 is exploding, users are generating content, many voices are being heard,
and businesses better pay attention. - A. Because we need Business Intelligence
Using these sheets, how would you answer the Dean's question ("What did Marketing students
average on Q4?")?
A. Sort both sheets by znumber, copy the Major column over, average the Marketing students.
B. Sort the registrar sheet by Major, then use "Find" on the Q4 sheet and average scores.
C. Import both sheets into a Relational Database, then run a query for Marketing average on Q4.
- C. Import both sheets into a Relational Database, then run a query for Marketing
average on Q4.
What is an Excel column heading in Access?
A. Field
B. Record
C. Table
D. Character - A. Field
What is an Excel row in Access?
A. Field
B. Record
,C. Table
D. Character - B. Record
What is an Excel spreadsheet in Access?
A. Field
B. Record
C. Table
D. Character - C. Table
Why is it bad that 32% of corporate information is stored in spreadsheets?
A. Often information needs to be integrated from many sources, and separate spreadsheets do
not do this well.
B. Because big data has such high volume it will overwhelm the spreadsheets.
C. Because analytics cannot be run on spreadsheets.
D. Because it should be closer to 100%. - A. Often information needs to be integrated
from many sources, and separate spreadsheets do not do this well.
If information on Customers, Orders, and Products are being stored in different spreadsheets in
different departments, are there any problems? If "yes", what?
A. No.
, B. Yes. They take up too much disk space.
C. Yes. The sheets don't talk to each other... we won't have BI.
D. Yes. The sheets should be in a PivotTable. - C. Yes. The sheets don't talk to each other...
we won't have BI.
For VC4, how would you get this data on the web page into Access? [Note: VC4: Tables (with
def), keys, relationships, forms]
A. Copy/paste into Access.
B. Copy/paste into Excel then import into Access.
C. Use the "Import from Web Page" Wizard in Access.
D. Type it in. - B. Copy/paste into Excel then import into Access.
Which of the four tabs in Access is used to import Excel data?
A. File
B. Create
C. External Data
D. Database Tools - C. External Data
