Data Analytics for Accounting

Business

Quiz 4 :

Master the Data: Preparing Data for Analysis

Quiz 4 :

Master the Data: Preparing Data for Analysis

Question Type
search
arrow
The main reason for using Excel is for data storage.
Free
True False
Answer:

Answer:

False

Tags
Choose question tag
close menu
arrow
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.
Free
True False
Answer:

Answer:

False

Tags
Choose question tag
close menu
arrow
SQL stands for __________.
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
It is possible to input raw data within Tableau.
True False
Answer:
Tags
Choose question tag
close menu
arrow
One of the primary internal control benefits of storing data in a relational database is increased redundancy cuts down on errors.
True False
Answer:
Tags
Choose question tag
close menu
arrow
Preventive internal controls are harder to enforce in a relational database than in other databases.
True False
Answer:
Tags
Choose question tag
close menu
arrow
Accessing data in __________ requires that you connect to a(n) external datasource.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Tableau shows you are importing a numerical variable by showing the __________ icon.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The most common type of database model is the __________ database.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
If asset ID number is a unique identifier for the fixed asset ledger, it would be considered to be the __________.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Foreign keys are required in every relational database table.
True False
Answer:
Tags
Choose question tag
close menu
arrow
ETL stands for __________:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Tableau's biggest advantage over Excel is its specific emphasis on data visualization.
True False
Answer:
Tags
Choose question tag
close menu
arrow
Excel is generally regarded to be more secure than databases because users can add passwords to worksheets and workbooks.
True False
Answer:
Tags
Choose question tag
close menu
arrow
Version control reduces the possibility of having more than one version of the data on different computers.
True False
Answer:
Tags
Choose question tag
close menu
arrow
Tableau shows you are importing a geographical variable by showing the __________ icon.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Querying data in Excel to build a connection in a database creates a dynamic connection that does not need to be refreshed.
True False
Answer:
Tags
Choose question tag
close menu
arrow
In SQL, the __________ clause identifies the columns that you would like to extract.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The transformation step is necessary when your data isn't formatted in the manner it needs to be for analysis.
True False
Answer:
Tags
Choose question tag
close menu
arrow
Primary keys are required in every relational database table.
True False
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 47