Data Analytics - PCLC & Quiz #1 || All Accurately Answered.
Which of the following are differences between a spreadsheet (e.g., Excel) and a table in a
relational database? Select all that apply. correct answers - Each column in a relational database
must contain the same data type.
- A table in a relational database must contain a unique identifier.
True or False: Each table in a relational database can have multiple foreign keys and the foreign
keys cannot contain duplicate values. correct answers False
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. correct answers True
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. Select all that apply. correct
answers FROM AS SELECT
The default order for the ORDER BY command in SQL is ascending order. correct answers True
The FASB is responsible for keeping the GAAP Taxonomy current and aligned with FASB
Codification. correct answers True
A piece of XBRL data is referred to as a: correct answers Fact
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 (e.g., textual data contained
on the face of the report and data from the notes to the financial statements). correct answers
False
, In the "Viewing Data" lesson, we learned that 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.
correct answers Browse
In the "Diving into Expressions" lesson, we learned that Alteryx Expressions can be used for a
number of data preparation and analytic tasks, such as a) cleansing string data, b) applying
conditional logic (i.e., if/then), or c) mathematically transforming numeric values.
In the Alteryx FORMULA tool, where do we enter expressions? correct answers Expression
Editor
In the "String Functions" lesson, we learned that we can use ___________ functions to remove
unwanted characters, including whitespace, from string data. correct answers trim
In the "Connecting to Multiple Sheets at Once" lesson, we learned that an INPUT DATA tool and
a _____________ tool can be used together to input data from multiple sheets within the same
Excel (.xlsx) file. correct answers DYNAMIC INPUT
In the "Writing Conditional Statements" lesson, we learned that basic conditional statements in
Alteryx are composed of how many parts? correct answers 4
The Alteryx TEXT TO COLUMNS tool belongs to this category of tools in the tool pallet:
correct answers Parse
What Alteryx tool can accomplish similar tasks as a VLOOKUP formula in Excel? correct
answers FIND REPLACE
In order to parse data with RegEx, we must identify _____________ in the data. correct answers
Patterns
Consider the following regular expression: \w+
Which of the following are differences between a spreadsheet (e.g., Excel) and a table in a
relational database? Select all that apply. correct answers - Each column in a relational database
must contain the same data type.
- A table in a relational database must contain a unique identifier.
True or False: Each table in a relational database can have multiple foreign keys and the foreign
keys cannot contain duplicate values. correct answers False
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. correct answers True
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. Select all that apply. correct
answers FROM AS SELECT
The default order for the ORDER BY command in SQL is ascending order. correct answers True
The FASB is responsible for keeping the GAAP Taxonomy current and aligned with FASB
Codification. correct answers True
A piece of XBRL data is referred to as a: correct answers Fact
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 (e.g., textual data contained
on the face of the report and data from the notes to the financial statements). correct answers
False
, In the "Viewing Data" lesson, we learned that 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.
correct answers Browse
In the "Diving into Expressions" lesson, we learned that Alteryx Expressions can be used for a
number of data preparation and analytic tasks, such as a) cleansing string data, b) applying
conditional logic (i.e., if/then), or c) mathematically transforming numeric values.
In the Alteryx FORMULA tool, where do we enter expressions? correct answers Expression
Editor
In the "String Functions" lesson, we learned that we can use ___________ functions to remove
unwanted characters, including whitespace, from string data. correct answers trim
In the "Connecting to Multiple Sheets at Once" lesson, we learned that an INPUT DATA tool and
a _____________ tool can be used together to input data from multiple sheets within the same
Excel (.xlsx) file. correct answers DYNAMIC INPUT
In the "Writing Conditional Statements" lesson, we learned that basic conditional statements in
Alteryx are composed of how many parts? correct answers 4
The Alteryx TEXT TO COLUMNS tool belongs to this category of tools in the tool pallet:
correct answers Parse
What Alteryx tool can accomplish similar tasks as a VLOOKUP formula in Excel? correct
answers FIND REPLACE
In order to parse data with RegEx, we must identify _____________ in the data. correct answers
Patterns
Consider the following regular expression: \w+
