WGU D465 - Data Applications ( Questions and Correct Answers Latest Update 2024)
R and Python similarities - Answers Both widely used in data science with extensive libraries.
R unique challenges - Answers Steeper learning curve, limited web dev capabilities.
Advantage of storing code in R - Answers Allows reproducibility and collaboration among analysts.
Programming languages and use cases - Answers Python: web dev, data science, ML, automation.
MIN function in spreadsheets - Answers Returns the smallest value in a cell range.
COUNTIF function in spreadsheets - Answers Counts cells meeting a specified condition.
Pivot table elements - Answers Rows, columns, values, filters for data aggregation.
SELECT command in SQL - Answers Retrieves data from one or more database tables.
JOIN commands in SQL - Answers INNER, LEFT, RIGHT, FULL OUTER JOIN types.
Delimiter for code chunks - Answers Triple backticks or markup to define code sections.
Output formats for documents - Answers HTML, PDF, Word (docx), Markdown.
Presentation formats - Answers Slides, Dashboards, Interactive web apps.
Knit button in R - Answers Compiles R Markdown into desired output formats.
Symbol for comments in R - Answers Pound sign (`#`) precedes comments in R.
Nested function usage - Answers Simplifies operations, improves code readability.
Logical operators - Answers AND (&&), OR (||), NOT (!).
Advantage of tidyverse - Answers Cohesive data manipulation packages in R.
Functions in ggplot2 - Answers ggplot(), geom_point(), geom_line(), aes().
Plus sign in ggplot2 - Answers Adds layers to ggplot objects for customization.
Common errors in ggplot2 - Answers Incorrect aesthetic mappings, syntax misunderstanding.
Basic aesthetic attributes in ggplot2 - Answers x-axis, y-axis, color for plot customization.
Smoothing line usage - Answers Visual representation of trends in data.
dplyr filter() function - Answers Subset rows based on specific conditions in R.
VLOOKUP function in spreadsheets - Answers Searches for values in a vertical column.
,Locking table array in VLOOKUP - Answers Prevents range changes for formula accuracy.
Different JOIN functions in SQL - Answers INNER, LEFT, RIGHT, FULL OUTER JOIN types.
COUNT vs. COUNT DISTINCT in SQL - Answers COUNT: total rows, COUNT DISTINCT: unique values.
SELECT statement usage in SQL - Answers Retrieving data from one or more tables.
FROM statement in SQL - Answers Specifies tables for data retrieval in SQL queries.
Tibbles vs. data frames - Answers Modernized data frames with improved features.
Main operators in R - Answers Arithmetic, relational, logical, assignment operators.
sample() function for biased data - Answers Creates random unbiased data samples.
Fill in the blank: The spreadsheet function _____ returns the number of cells within a range that match a
specified value.
COUNTIF
ARRAY
COUNT DISTINCT
VALUE - Answers COUNTIF
What is an example of an array in a spreadsheet?
All cells with number values
Cells D7, E14, and F20
The values in cells B2 through B31
All cells with values greater than 100 - Answers The values in cells B2 through B31
Which function will calculate the sum of the products of the corresponding items in the arrays M1:M4
and P1:P4?
=SUMPRODUCT(M1:M4, P1:P4)
=MULTIPLY(M1:M4, P1:P4)
, =PRODUCT(M1:M4, P1:P4)
=ARRAY(M1:M4, P1:P4) - Answers =SUMPRODUCT(M1:M4, P1:P4)
Fill in the blank: The _____ of a pivot table organize and group the selected data horizontally.
columns
rows
filters
values - Answers rows
Which spreadsheet tool finds an average value using values generated within a pivot table?
Filter
Data validation
Conditional formatting
Calculated field - Answers Calculated field
In a SQL query, what is the purpose of the modulo (%) operator?
Return the remainder of a division calculation
Convert a decimal to a percent
Apply an exponent to a value
Find the square root of a number - Answers Return the remainder of a division calculation
A data professional writes a query that uses more than one arithmetic operator. What do they add to
the query to control the order of the calculations?
Dollar sign ($)
Parenthesis [()]
Colon [:]
R and Python similarities - Answers Both widely used in data science with extensive libraries.
R unique challenges - Answers Steeper learning curve, limited web dev capabilities.
Advantage of storing code in R - Answers Allows reproducibility and collaboration among analysts.
Programming languages and use cases - Answers Python: web dev, data science, ML, automation.
MIN function in spreadsheets - Answers Returns the smallest value in a cell range.
COUNTIF function in spreadsheets - Answers Counts cells meeting a specified condition.
Pivot table elements - Answers Rows, columns, values, filters for data aggregation.
SELECT command in SQL - Answers Retrieves data from one or more database tables.
JOIN commands in SQL - Answers INNER, LEFT, RIGHT, FULL OUTER JOIN types.
Delimiter for code chunks - Answers Triple backticks or markup to define code sections.
Output formats for documents - Answers HTML, PDF, Word (docx), Markdown.
Presentation formats - Answers Slides, Dashboards, Interactive web apps.
Knit button in R - Answers Compiles R Markdown into desired output formats.
Symbol for comments in R - Answers Pound sign (`#`) precedes comments in R.
Nested function usage - Answers Simplifies operations, improves code readability.
Logical operators - Answers AND (&&), OR (||), NOT (!).
Advantage of tidyverse - Answers Cohesive data manipulation packages in R.
Functions in ggplot2 - Answers ggplot(), geom_point(), geom_line(), aes().
Plus sign in ggplot2 - Answers Adds layers to ggplot objects for customization.
Common errors in ggplot2 - Answers Incorrect aesthetic mappings, syntax misunderstanding.
Basic aesthetic attributes in ggplot2 - Answers x-axis, y-axis, color for plot customization.
Smoothing line usage - Answers Visual representation of trends in data.
dplyr filter() function - Answers Subset rows based on specific conditions in R.
VLOOKUP function in spreadsheets - Answers Searches for values in a vertical column.
,Locking table array in VLOOKUP - Answers Prevents range changes for formula accuracy.
Different JOIN functions in SQL - Answers INNER, LEFT, RIGHT, FULL OUTER JOIN types.
COUNT vs. COUNT DISTINCT in SQL - Answers COUNT: total rows, COUNT DISTINCT: unique values.
SELECT statement usage in SQL - Answers Retrieving data from one or more tables.
FROM statement in SQL - Answers Specifies tables for data retrieval in SQL queries.
Tibbles vs. data frames - Answers Modernized data frames with improved features.
Main operators in R - Answers Arithmetic, relational, logical, assignment operators.
sample() function for biased data - Answers Creates random unbiased data samples.
Fill in the blank: The spreadsheet function _____ returns the number of cells within a range that match a
specified value.
COUNTIF
ARRAY
COUNT DISTINCT
VALUE - Answers COUNTIF
What is an example of an array in a spreadsheet?
All cells with number values
Cells D7, E14, and F20
The values in cells B2 through B31
All cells with values greater than 100 - Answers The values in cells B2 through B31
Which function will calculate the sum of the products of the corresponding items in the arrays M1:M4
and P1:P4?
=SUMPRODUCT(M1:M4, P1:P4)
=MULTIPLY(M1:M4, P1:P4)
, =PRODUCT(M1:M4, P1:P4)
=ARRAY(M1:M4, P1:P4) - Answers =SUMPRODUCT(M1:M4, P1:P4)
Fill in the blank: The _____ of a pivot table organize and group the selected data horizontally.
columns
rows
filters
values - Answers rows
Which spreadsheet tool finds an average value using values generated within a pivot table?
Filter
Data validation
Conditional formatting
Calculated field - Answers Calculated field
In a SQL query, what is the purpose of the modulo (%) operator?
Return the remainder of a division calculation
Convert a decimal to a percent
Apply an exponent to a value
Find the square root of a number - Answers Return the remainder of a division calculation
A data professional writes a query that uses more than one arithmetic operator. What do they add to
the query to control the order of the calculations?
Dollar sign ($)
Parenthesis [()]
Colon [:]
