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