ACCT 3543 Vernon Richardson Midterm One Complete Online Exam Review with Verified

ACCT 3543 Vernon
Richardson Midterm
One Complete
Online Exam
Review 2026 2027
with Verified
Questions and
Correct Answers

, 4 V's of Big Data - correct answer = Volume, Velocity, Variety, Veracity
m m m m m m m m m m m m




Primary vs. Foreign Key - correct answer = Primary Key - Unique identifier in each table,
m m m m m m m m m m m m m m m m m




Transaction_ID in Transaction Table; CustomerID in Customer Table m m m m m m m




Bloom's Taxonomy - Where Data Analytics Plays - correct answer = Accountant's Must
m m m m m m m m m m m m m m




"Play" in Create, Evaluate, and anazlye. Machines excel in Apply, Understand, and
m m m m m m m m m m m m




remember.

Bloom's Taxonomy - know ordering from lowest critical thinking skills to highest critical
m m m m m m m m m m m m m m




thinking skills - correct answer = (1) remembering, (2) understanding, and (3) applying, to
m m m m m m m m m m m m m m




higher levels of thinking in (4) analyzing, (5) evaluating, and (6) creating.
m m m m m m m m m m m




Basics of Relational Databases, and its advantages - correct answer = Internal control
m m m m m m m m m m m m m m




benefits and enhanced data integrity m m m m




Fields vs. Records in a Relational Database - correct answer = -Fields (or variables): The
m m m m m m m m m m m m m m m m




columns that contain descriptive characteristics about the observations in the table.
m m m m m m m m m m




- Records: The rows, with each observation corresponding to a record, or unique instance, of
m m m m m m m m m m m m m m m




what is being described in the table.
m m m m m m




What do these acronyms, EDGAR, SQL, XBRL, ETL stand for? - correct answer = Electronic
m m m m m m m m m m m m m m m m




Data Gathering, Analysis, and Retrieval system
m m m m m




Structured Query Language m m




eXtensible Business Reporting Language m m m




extract, transform, and load m m m




m Basic SQL commands - correct answer = Select, from, where
m m m m m m m m m




Where tax accounting gets its data? - correct answer = tax data comes from the financial
m m m m m m m m m m m m m m m m m




reporting system. m




Excel vs. Tableau - What are the strengths/weaknesses of each? - correct answer = Excel is
m m m m m m m m m m m m m m m m m




very good at compiling data. Tableau is very good at displaying data. Tableau cannot
m m m m m m m m m m m m m m




formulate data; it must be imported from somewhere else. Excel is not as strong in
m m m m m m m m m m m m m m m




representation, as Tableau gives the user many ways to display data. You could solely use m m m m m m m m m m m m m m m




excel to formulate, manipulate, and display data. You must have something else to do that to
m m m m m m m m m m m m m m m m




use Tableau.m




Keystrokes to perform a query in Excel - correct answer = - Data Tab -New Query -From
m m m m m m m m m m m m m m m m m m




Database

m What is done in each component of the AMPS model? - correct answer = AMPS
m m m m m m m m m m m m m m




AMPS- Ask the Question - correct answer = one should ask carefully constructed questions
m m m m m m m m m m m m m m m




that can potentially be solved using data and Data Analytics.
m m m m m m m m m