PCLC

Question 1

Which of the following are differences between a spreadsheet (excel) and a table in a relational database?

Answer 1

• each column in a relational database must contain the same data type
• a table in a relational database must contain a unique identifier

Question 2

T/F: Each table in a relational database can have multiple foreign keys and the foreign keys cannot contain duplicate values

Answer 2

F: Each table can contain duplicate values

Question 3

T/F: Relational databases are the optimal way to store date, while flat files are the optimal way for humans to visually consume data and are optimal for analyzing data.

Answer 3

T

Question 4

If you would like to query multiple fields from a relational table and simultaneously rename some of the fields, you would use the following SQL commands

Answer 4

Select
From
AS

Question 5

T/F: The default order for the ORDER BY command in SQL is ascending order

Answer 5

T

Question 6

A piece of XBRL data is referred to as a

Answer 6

Fact

Question 7

T/F: XBRL data includes all amounts reported on a company’s financial statements filed with the SEC, but does not extend to data outside of the financial statements (textual data on the face of the report and data from the notes to the financial statements)

Answer 7

F

Question 8

T/F: The FASB is responsible for keeping the GAAP Taxonomy current and aligned with FASB Codification

Answer 8

T

Question 9

The ___ tool allows us to see the entire contents of a dataset and allows us to assess the quality, distribution, and attributes of the data

Answer 9

Browse

Question 10

In the Alteryx FORMULA tool, where do we enter expressions?

Answer 10

Expression Editor

Question 11

We can use ___ functions to remove unwanted characters, including whitespace, from string data

Answer 11

Trim

Question 12

An INPUT DATA tool and a ___ tool can be used together to input data from multiple sheets within the same Excel file

Answer 12

Dynamic input

Question 13

Basic conditional statements in Alteryx are composed of how many parts?

Answer 13

4
IF, ELSE, THEN, ENDIF

Question 14

The Alteryx TEXT TO COLUMNS tools belongs to this category of tools in the tools pallet

Answer 14

Parse

Question 15

What Alteryx tool can accomplish similar tasks as a VLOOKUP formula in Excel?

Answer 15

Find Replace

Question 16

In order to parse data with RegEx, we must identify ___ in the data

Answer 16

patterns

Question 17

Consider the following regular expression: \w+
Which of the following string records would NOT be completely identified by this regular expression

Goodbye
1234
TIGERS
Clemson University

Answer 17

Clemson University

Question 18

Which of the following string records would be completely identified by this regular expression? \d

1
12
123
1234

Answer 18

1

Question 19

T/F: Both the FORMULA tool and the MULTI-ROW FORMULA toot a) can create new columns or modify existing columns, b) use an expression editor to input functions, and c) can apply multiple expressions per tool

Answer 19

F: Multi-Row Formula tool only allows one expression per tool

Question 20

T/F: When transposing data using the TRANSPOSE tool, the tool will output at least two columns of data with standardized names (called NAME and VALUE).

Answer 20

T

Question 21

T/F: The OUTPUT tool allows us to output data to one single file or can group data and output this grouped data into separate files

Answer 21

True

Question 22

Stacked Bar Charts, Line Charts, and Combo Charts are all examples of what type of vizualizations

Answer 22

Comparison

Question 23

Which type of visualization is not a distribution visualization?

Answer 23

Line Chart

Question 24

What has research found to be the least accurate way to compare magnitudes in a visualization?

Answer 24

Color

Question 25

T/F: Exploratory visualizations are used as part of the analysis phase (not communication phase) and are used to develop a question/problem that has not clearly defined and help asses a question without a clear answer

Answer 25

T

Question 26

T/F: Any visualization can be exploratory or explanatory. The distiction relates to how/why they are being used and how they are presented (if presented at all)

Answer 26

T

Question 27

T/F: Pre-attentive attributes require conscious thought in order to be detected by your brain

Answer 27

F

Question 28

T/F: Removing redundant labels from visualizations helps increase the “data-to-ink ratio”

Answer 28

T

Question 29

T/F: Benford’s law applies to all datasets, as long as there are a sufficient number of observations in the data

Answer 29

F: Benford’s law only applies to datasets where each number 1 through 9 has an equal chance of being the leading digit

Question 30

T/F: A common audit area in which analytics can streamline the audit is performing tests on massive journal-entry populations to identify risks and items of audit interest

Answer 30

T

Question 31

Assume you want to estimate the following model:

collGPA = a + B1hsGPA + B2ACT + e
collGPA = college GPA, hsGPA = high school GPA, and ACT = ACT score

Assume the estimated model is:

collGPA = 1.29 + 0.453hsGPA + 0.0094ACT

According to our model, what is the expected college GPA of as student with a high-school GPA of 3.49 and an ACT score of 21?
Round to 2 decimal places.

Answer 31

3.07

Question 32

Assume you want to estimate the following model:

collGPA = a + B1hsGPA + B2ACT + e
collGPA = college GPA, hsGPA = high school GPA, and ACT = ACT score

Assume the estimated model is:

collGPA = 1.29 + 0.453hsGPA + 0.0094ACT

Our model has an R2 of 0.13.
T/F: An R2 of 0.13 indicates that the sample students’ high school GPAs and ACT scores explain 13% of the variance in college GPAs.

Answer 32

T

Question 33

Assume you want to estimate the following model:

collGPA = a + B1hsGPA + B2ACT + e

where collGPA = college GPA, hsGPA = high-school GPA, and ACT = ACT score.

Assume the estimated model is:

collGPA = 1.29 + 0.453hsGPA + 0.0094ACT

T/F: Assuming two students have the same ACT score, if student 1 has a high school GPA of 3.0 and student 2 has a high school GPA of 4.0, then this model would predict that student 1’s college GPA is 0.453 points lower than student 2’s college GPA.

Answer 33

T