ACCT 3543 Vernon Richardson Midterm 1 (Online) exam with correct answers

ACCT 3543 Vernon Richardson Midterm 1 ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




(Online) exam with correct answers
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




4 V's of Big Data - correct answers✔✔Volume, Velocity, Variety,
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




Veracity


Primary vs. Foreign Key - correct answers✔✔Primary Key - ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




Unique identifier in each table, Transaction_ID in Transaction
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




Table; CustomerID in Customer Table ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




Bloom's Taxonomy - Where Data Analytics Plays - correct ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




answers✔✔Accountant's Must "Play" in Create, Evaluate, and ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




anazlye. Machines excel in Apply, Understand, and remember. ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




Bloom's Taxonomy - know ordering from lowest critical thinking ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




skills to highest critical thinking skills - correct answers✔✔(1)
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




remembering, (2) understanding, and (3) applying, to higher ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




levels of thinking in (4) analyzing, (5) evaluating, and (6)
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




creating.

, Basics of Relational Databases, and its advantages - correct
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




answers✔✔Internal control benefits and enhanced data ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




integrity


Fields vs. Records in a Relational Database - correct
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




answers✔✔-Fields (or variables): The columns that contain ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




descriptive characteristics about the observations in the table. ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




- Records: The rows, with each observation corresponding to a
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




record, or unique instance, of what is being described in the
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




table.


What do these acronyms, EDGAR, SQL, XBRL, ETL stand for? -
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




correct answers✔✔Electronic Data Gathering, Analysis, and
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\




Retrieval system ||\\||\\




Structured Query Language ||\\||\\ ||\\||\\




eXtensible Business Reporting Language ||\\||\\ ||\\||\\ ||\\||\\




extract, transform, and load ||\\||\\ ||\\||\\ ||\\||\\




Basic SQL commands - correct answers✔✔Select, from, where
||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\ ||\\||\\