Chapter 4
If customer ID is a unique identifier for the customer table, it would be the _______. A. primary key B. foreign key C. unique key
A. primary key
According to the text, data integrity essentially means _______. A. truth in data B. that the testing can handle multiple versions of the data C. reliable data
A. truth in data
Tableau shows you are importing a categorical variable by showing the _______ icon. A. graphical B. Abc C. bar chart D. numerical
B. Abc
Foreign keys are required in every relational database table. A. True B. False
B. False
Internal control benefits of storing data in relational databases include all but which of the following? A. Reduced redundancy cuts down on errors. B. Physical security of the data is enhanced. C. Security around data entry and table access can aid in creating and enforcing data entry internal controls. D. Preventive internal controls are easier to enforce.
B. Physical security of the data is enhanced.
Tableau requires that you create a connection to a(n) _______ data source. A. internal B. external C. proprietary
B. external
To faithfully represent what occurs, accounting information needs to be _______, complete, and neutral. A. reliable B. free from error C. relevant D. timely
B. free from error
The most common type of database model is the _______ database. A. hierarchical B. network C. relational D. star schema
C. relational
To be useful to decision makers, accounting information must be _______ and exhibit faithful representation. A. reliable B. free from error C. relevant D. neutral
C. relevant
Tableau has the biggest advantage over Excel in _______. A. data analysis B. data entry C. data manipulation D. data visualization
D. data visualization