Exam 4: Master the Data: Preparing Data for Analysis

One disadvantage of Tableau is that __________.

A column (or group of columns) that exist to create relationships between two tables, linking to the primary key in another table is called a __________.

All of the information regarding one patient (name, address, patient information, etc.) would be an example of a(n) __________.

One advantage of Excel over a database is __________.

The most common type of database model is the __________ database.

If asset ID number is a unique identifier for the fixed asset ledger, it would be considered to be the __________.

Structured set of data allowing access by many potential users is called a(n) __________.

Excel is generally regarded to be more secure than databases because users can add passwords to worksheets and workbooks.

To faithfully represent what occurs, accounting information needs to be all except for which of the following?

__________ is truth in data, or how the data presents the truth of the underlying transactions, transactions, or events that occurred.

Primary keys are required in every relational database table.

A __________ is data organized into sets of columns and rows.

Tableau shows you are importing a geographical variable by showing the __________ icon.

Preventive internal controls are harder to enforce in a relational database than in other databases.

A row that corresponds to a unique instance of what is being described in the table is called a(n) __________.

Version control reduces the possibility of having more than one version of the data on different computers.

Accessing data in __________ requires that you connect to a(n) external datasource.

The functionality of Excel connections can enable you to do all the following except __________.

In SQL, the command SELECT * denotes to __________.

The main reason for using Excel is for data storage.