Deck 4: Master the Data: Preparing Data for Analysis

Question 1

The main reason for using Excel is for data storage.

Answer 1

False

Question 2

One of the internal control benefits of storing data in a relational databaseis multiple versions of entries may repeat customer details, thus cutting down on errors.

Answer 2

False

Question 3

SQL stands for __________.

A) structured query language
B) standard query language
C) structured query links
D) standard query links

Answer 3

A

Question 4

It is possible to input raw data within Tableau.

Question 5

One of the primary internal control benefits of storing data in a relational database is increased redundancy cuts down on errors.

Question 6

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

Question 7

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

A) Excel
B) Tableau
C) Access
D) Query

Question 8

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

A) graphical
B) Abc
C) bar chart
D) #

Question 9

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

A) hierarchical
B) network
C) relational
D) star schema

Question 10

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

A) primary key
B) foreign key
C) unique key
D) credible key

Question 11

Foreign keys are required in every relational database table.

Question 12

ETL stands for __________:

A) extract, transform, load
B) extract, translate, load
C) extract, translate, link
D) examine, translate, load

Question 13

Tableau's biggest advantage over Excel is its specific emphasis on data visualization.

Question 14

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

Question 15

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

Question 16

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

A) numerical
B) Abc
C) globe
D) #

Question 17

Querying data in Excel to build a connection in a database creates a dynamic connection that does not need to be refreshed.

Question 18

In SQL, the __________ clause identifies the columns that you would like to extract.

A) FROM
B) SELECT
C) WHERE
D) EXTRACT

Question 19

The transformation step is necessary when your data isn't formatted in the manner it needs to be for analysis.

Question 20

Primary keys are required in every relational database table.

Question 21

The __________ of the data can be damaged if different versions of the data are stored on the users' desktop computers or laptops rather than analyzing data through a live connection to the database.

A) trustworthiness
B) integrity
C) correctness
D) breadth

Question 22

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

A) Excel spreadsheet
B) database
C) data file
D) data cache

Question 23

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

A) complete
B) free from error
C) neutral
D) timely

Question 24

A field in a relational database may be a __________.

A) primary key
B) foreign key
C) primary key in one table and a foreign key in another table
D) primary key in one table and a foreign key in one table

Question 25

In SQL, the __________ clause acts like a filter.

A) EXTRACT
B) SELECT
C) TABLE
D) WHERE

Question 26

The purpose of an __________ JOIN is to allow you to SELECT data from more than one table, as long as those two tables are related.

A) INNER
B) OUTER
C) INTERNAL
D) EXTERNAL

Question 27

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

A) Relevant data
B) Reliable data
C) Data quality
D) Data integrity

Question 28

A(n) __________ diagram is a graphical representation of an information system, illustrating relationships among people, objects, places, and events within that system to allow you to SELECT data from more than one table, as long as those two tables are related.

A) data flow diagram
B) relational
C) entity-relationship (ER)
D) database

Question 29

Internal control benefits of storing data in relational databases include all except for which of the following?

A) Reduced redundancy cuts down on errors.
B) Physical security of the data is enhanced.
C) Version control.
D) Increased redundancy for more accuracy.

Question 30

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

A) attribute
B) field
C) data point
D) record

Question 31

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

A) field
B) record
C) attribute
D) aspect

Question 32

A __________ corresponds to a column that contains descriptive information.

A) primary key
B) field
C) data point
D) record

Question 33

A __________ communicates the same pieces of information (which tables are in the database, which fields are in each table, and how each table is related through primary key/foreign key placement) as a data dictionary, but in visual form.

A) data flow diagram
B) relational database diagram
C) database diagram
D) relationship database diagram

Question 34

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 __________.

A) primary key
B) foreign link
C) foreign key
D) primary link

Question 35

In SQL, the command SELECT * denotes to __________.

A) query all columns
B) summarize some columns
C) query some columns
D) return every column

Question 36

Which of the following are benefits of storing data in a relational database?

A) Security around data entry and table access can aid in creating and enforcing data entry internal controls
B) Ability to store more data
C) Easier access by all database users
D) Important data is stored in more than one database

Question 37

The name of each patient at a doctor's office would be an example of a __________.

A) field
B) record
C) data item
D) row

Question 38

In SQL, the __________ clause identifies the tables that store the data.

A) FROM
B) SELECT
C) TABLE
D) EXTRACT

Question 39

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

A) table
B) field
C) data point
D) record

Question 40

A column in a relational table/database that serves as a unique identifier is called a __________.

A) primary key
B) foreign identifier
C) foreign key
D) primary identifier

Question 41

To access data through a query in Excel, you would click on the following to access a database.

A) New Query > Data > From Database
B) Data > From Database
C) Data > From Database > New Query
D) Data > New Query > From Database

Question 42

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

A) create queries to form direct connections to a database
B) import data from another Excel workbook
C) create dynamic connections
D) create static connections that must be refreshed when the source data changes

Question 43

When the source data used to create an Excel pivottable change, the pivottable will update __________.

A) automatically
B) only after the file is saved
C) only when the pivottable is "refreshed"
D) never, any change requires a new pivottable

Question 44

A __________ communicates which tables are in the relational database, which fields are in the table, and how each table is related through primary key/foreign key placement.

A) relational database data dictionary
B) relational database diagram
C) relational database atlas
D) relational database data map

Question 45

One advantage of Excel over a database is __________.

A) it can be accessed by multiple users at the same time
B) analysis tools and data modeling capabilities
C) that it eliminates data redundancy
D) not applicable Excel is a database program

Question 46

One disadvantage of Tableau is that __________.

A) there is data integrity because you cannot create raw data in Tableau
B) data can be added from multiple data source connections
C) limited data visualization functionality
D) it cannot handle large amounts of data

Question 47

The typical order for getting data ready for analysis is as follows:

A) transform the data to make data usable, extract the data, and load the data in the analysis tool
B) load the data in the analysis tool, extract the data, and transform the data to make data usable
C) extract the data, load the data in the analysis tool and transform the data to make the data usable
D) extract the data, transform the data to make data usable and load the data in the analysis tool