Question 1

It is possible to input raw data within Tableau.

Accepted Answer

A) True 
 B)False

Question 2

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.

Accepted Answer

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

Question 3

ETL stands for __________:

Accepted Answer

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

Question 4

In SQL, the __________ clause acts like a filter.

Accepted Answer

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

Question 5

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.

Accepted Answer

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

Question 6

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.

Accepted Answer

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

Question 7

A __________ corresponds to a column that contains descriptive information.

Accepted Answer

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

It is possible to input raw data within Tableau.

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.

ETL stands for __________:

In SQL, the __________ clause acts like a filter.

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.

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 __________ corresponds to a column that contains descriptive information.

Using Data Analytics to Ask and Answer Accounting Questions

Master the Data: an Introduction to Accounting Data

Accounting Data Data Types and How They Are Used

Perform the Analysis: Types and Tools of Data Analyses

Perform the Analysis: Descriptive Analyses

Perform the Analysis: Diagnostic Analyses

Perform the Analysis: Predictive Analytics

Perform the Analysis: Prescriptive Analytics

Share the Story

Filters

Exam 4: Master the Data: Preparing Data for Analysis

It is possible to input raw data within Tableau.

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.

ETL stands for __________:

In SQL, the __________ clause acts like a filter.

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.

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 __________ corresponds to a column that contains descriptive information.

Using Data Analytics to Ask and Answer Accounting Questions

Master the Data: an Introduction to Accounting Data

Accounting Data Data Types and How They Are Used

Perform the Analysis: Types and Tools of Data Analyses

Perform the Analysis: Descriptive Analyses

Perform the Analysis: Diagnostic Analyses

Perform the Analysis: Predictive Analytics

Perform the Analysis: Prescriptive Analytics

Share the Story

Filters