PCLC

Question 1

Which of the following are differences between a spreadsheet (e.g. Excel) and a table in a relationship database?

Answer 1

• each column in a relationship 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 have multiple foreign keys and the foreign keys can contain duplicate values)

Question 3

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

Answer 3

True

Question 4

What kind of relationship is this? - each record in the tblOrders table may match to several records in the tblOrderDetails table

Answer 4

one-to-many relationship

Question 5

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 5

FROM - specific table we want to extract from
AS - renames fields
SELECT - specifics what we want to view

Question 6

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

Answer 6

True

Question 7

a ____ 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 7

Browse

Question 8

Alteryx __ can be used for a number of data preparation and analytic tasks, such as a) cleansing string data, b) applying conditional logic, or c) mathematically transforming numeric values

Answer 8

Expressions

Question 9

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

Answer 9

Expression editor

Question 10

Use ___ functions to remove unwanted characters, including whitespace, from string data

Answer 10

trim

Question 11

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

Answer 11

DYNAMIC INPUT

Question 12

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

Answer 12

4 - IF, THEN, ELSE, ENDIF

Question 13

THE Alteryx TEXT TO COLUMNS tool belongs to this category of tools in the tool pallet:

Answer 13

PARSE

Question 14

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

Answer 14

FIND REPLACE

Question 15

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

Answer 15

patterns

Question 16

Consider the following regular expression: \w+

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

Goodbye
1234
TIGERS
1a2B3c
Clemson University
hello

Answer 16

Clemson University

Question 17

Consider the following regular expression: \w+

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

1
12
123
1234

Answer 17

1

Question 18

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

Answer 18

False
MULTI-ROW FORMULA cannot apply multiple expression per tool (only one)

Question 19

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 19

True

Question 20

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 20

True