WGU D465 - Data Applications |! |! |! |! |!
Exam with precise detailed |! |! |! |!
answers
R and Python similarities - Correct answer ✔Both widely used in data science
|! |! |! |! |! |! |! |! |! |! |! |!
with extensive libraries.
|! |! |!
R unique challenges - Correct answer ✔Steeper learning curve, limited web
|! |! |! |! |! |! |! |! |! |! |!
dev capabilities.
|!
Advantage of storing code in R - Correct answer ✔Allows reproducibility and
|! |! |! |! |! |! |! |! |! |! |! |!
collaboration among analysts. |! |!
Programming languages and use cases - Correct answer ✔Python: web dev,
|! |! |! |! |! |! |! |! |! |! |!
data science, ML, automation.
|! |! |!
MIN function in spreadsheets - Correct answer ✔Returns the smallest value
|! |! |! |! |! |! |! |! |! |! |!
in a cell range.
|! |! |!
COUNTIF function in spreadsheets - Correct answer ✔Counts cells meeting a
|! |! |! |! |! |! |! |! |! |!
specified condition.
|! |!
,Pivot table elements - Correct answer ✔Rows, columns, values, filters for data
|! |! |! |! |! |! |! |! |! |! |!
aggregation.
|!
SELECT command in SQL - Correct answer ✔Retrieves data from one or
|! |! |! |! |! |! |! |! |! |! |! |!
more database tables.
|! |!
JOIN commands in SQL - Correct answer ✔INNER, LEFT, RIGHT, FULL
|! |! |! |! |! |! |! |! |! |! |!
OUTER JOIN types. |! |!
Delimiter for code chunks - Correct answer ✔Triple backticks or markup to
|! |! |! |! |! |! |! |! |! |! |! |!
define code sections.
|! |!
Output formats for documents - Correct answer ✔HTML, PDF, Word (docx),
|! |! |! |! |! |! |! |! |! |! |!
Markdown.
Presentation formats - Correct answer ✔Slides, Dashboards, Interactive web
|! |! |! |! |! |! |! |! |!
apps.
Knit button in R - Correct answer ✔Compiles R Markdown into desired
|! |! |! |! |! |! |! |! |! |! |! |!
output formats. |!
Symbol for comments in R - Correct answer ✔Pound sign (`#`) precedes
|! |! |! |! |! |! |! |! |! |! |! |!
comments in R. |! |!
Nested function usage - Correct answer ✔Simplifies operations, improves
|! |! |! |! |! |! |! |! |!
code readability.
|!
,Logical operators - Correct answer ✔AND (&&), OR (||), NOT (!).
|! |! |! |! |! |! |! |! |! |!
Advantage of tidyverse - Correct answer ✔Cohesive data manipulation
|! |! |! |! |! |! |! |! |!
packages in R. |! |!
Functions in ggplot2 - Correct answer ✔ggplot(), geom_point(), geom_line(),
|! |! |! |! |! |! |! |! |!
aes().
Plus sign in ggplot2 - Correct answer ✔Adds layers to ggplot objects for
|! |! |! |! |! |! |! |! |! |! |! |! |!
customization.
Common errors in ggplot2 - Correct answer ✔Incorrect aesthetic mappings,
|! |! |! |! |! |! |! |! |! |!
syntax misunderstanding.
|!
Basic aesthetic attributes in ggplot2 - Correct answer ✔x-axis, y-axis, color for
|! |! |! |! |! |! |! |! |! |! |! |!
plot customization.
|!
Smoothing line usage - Correct answer ✔Visual representation of trends in
|! |! |! |! |! |! |! |! |! |! |!
data.
dplyr filter() function - Correct answer ✔Subset rows based on specific
|! |! |! |! |! |! |! |! |! |! |!
conditions in R. |! |!
, VLOOKUP function in spreadsheets - Correct answer ✔Searches for values in
|! |! |! |! |! |! |! |! |! |!
a vertical column.
|! |! |!
Locking table array in VLOOKUP - Correct answer ✔Prevents range changes
|! |! |! |! |! |! |! |! |! |! |!
for formula accuracy.
|! |!
Different JOIN functions in SQL - Correct answer ✔INNER, LEFT, RIGHT,
|! |! |! |! |! |! |! |! |! |! |!
FULL OUTER JOIN types.|! |! |!
COUNT vs. COUNT DISTINCT in SQL - Correct answer ✔COUNT: total
|! |! |! |! |! |! |! |! |! |! |!
rows, COUNT DISTINCT: unique values.
|! |! |! |!
SELECT statement usage in SQL - Correct answer ✔Retrieving data from one
|! |! |! |! |! |! |! |! |! |! |!
or more tables.
|! |! |!
FROM statement in SQL - Correct answer ✔Specifies tables for data retrieval
|! |! |! |! |! |! |! |! |! |! |! |!
in SQL queries.
|! |!
Tibbles vs. data frames - Correct answer ✔Modernized data frames with
|! |! |! |! |! |! |! |! |! |! |!
improved features. |!
Main operators in R - Correct answer ✔Arithmetic, relational, logical,
|! |! |! |! |! |! |! |! |! |!
assignment operators. |!
sample() function for biased data - Correct answer ✔Creates random
|! |! |! |! |! |! |! |! |! |!
unbiased data samples. |! |!
Exam with precise detailed |! |! |! |!
answers
R and Python similarities - Correct answer ✔Both widely used in data science
|! |! |! |! |! |! |! |! |! |! |! |!
with extensive libraries.
|! |! |!
R unique challenges - Correct answer ✔Steeper learning curve, limited web
|! |! |! |! |! |! |! |! |! |! |!
dev capabilities.
|!
Advantage of storing code in R - Correct answer ✔Allows reproducibility and
|! |! |! |! |! |! |! |! |! |! |! |!
collaboration among analysts. |! |!
Programming languages and use cases - Correct answer ✔Python: web dev,
|! |! |! |! |! |! |! |! |! |! |!
data science, ML, automation.
|! |! |!
MIN function in spreadsheets - Correct answer ✔Returns the smallest value
|! |! |! |! |! |! |! |! |! |! |!
in a cell range.
|! |! |!
COUNTIF function in spreadsheets - Correct answer ✔Counts cells meeting a
|! |! |! |! |! |! |! |! |! |!
specified condition.
|! |!
,Pivot table elements - Correct answer ✔Rows, columns, values, filters for data
|! |! |! |! |! |! |! |! |! |! |!
aggregation.
|!
SELECT command in SQL - Correct answer ✔Retrieves data from one or
|! |! |! |! |! |! |! |! |! |! |! |!
more database tables.
|! |!
JOIN commands in SQL - Correct answer ✔INNER, LEFT, RIGHT, FULL
|! |! |! |! |! |! |! |! |! |! |!
OUTER JOIN types. |! |!
Delimiter for code chunks - Correct answer ✔Triple backticks or markup to
|! |! |! |! |! |! |! |! |! |! |! |!
define code sections.
|! |!
Output formats for documents - Correct answer ✔HTML, PDF, Word (docx),
|! |! |! |! |! |! |! |! |! |! |!
Markdown.
Presentation formats - Correct answer ✔Slides, Dashboards, Interactive web
|! |! |! |! |! |! |! |! |!
apps.
Knit button in R - Correct answer ✔Compiles R Markdown into desired
|! |! |! |! |! |! |! |! |! |! |! |!
output formats. |!
Symbol for comments in R - Correct answer ✔Pound sign (`#`) precedes
|! |! |! |! |! |! |! |! |! |! |! |!
comments in R. |! |!
Nested function usage - Correct answer ✔Simplifies operations, improves
|! |! |! |! |! |! |! |! |!
code readability.
|!
,Logical operators - Correct answer ✔AND (&&), OR (||), NOT (!).
|! |! |! |! |! |! |! |! |! |!
Advantage of tidyverse - Correct answer ✔Cohesive data manipulation
|! |! |! |! |! |! |! |! |!
packages in R. |! |!
Functions in ggplot2 - Correct answer ✔ggplot(), geom_point(), geom_line(),
|! |! |! |! |! |! |! |! |!
aes().
Plus sign in ggplot2 - Correct answer ✔Adds layers to ggplot objects for
|! |! |! |! |! |! |! |! |! |! |! |! |!
customization.
Common errors in ggplot2 - Correct answer ✔Incorrect aesthetic mappings,
|! |! |! |! |! |! |! |! |! |!
syntax misunderstanding.
|!
Basic aesthetic attributes in ggplot2 - Correct answer ✔x-axis, y-axis, color for
|! |! |! |! |! |! |! |! |! |! |! |!
plot customization.
|!
Smoothing line usage - Correct answer ✔Visual representation of trends in
|! |! |! |! |! |! |! |! |! |! |!
data.
dplyr filter() function - Correct answer ✔Subset rows based on specific
|! |! |! |! |! |! |! |! |! |! |!
conditions in R. |! |!
, VLOOKUP function in spreadsheets - Correct answer ✔Searches for values in
|! |! |! |! |! |! |! |! |! |!
a vertical column.
|! |! |!
Locking table array in VLOOKUP - Correct answer ✔Prevents range changes
|! |! |! |! |! |! |! |! |! |! |!
for formula accuracy.
|! |!
Different JOIN functions in SQL - Correct answer ✔INNER, LEFT, RIGHT,
|! |! |! |! |! |! |! |! |! |! |!
FULL OUTER JOIN types.|! |! |!
COUNT vs. COUNT DISTINCT in SQL - Correct answer ✔COUNT: total
|! |! |! |! |! |! |! |! |! |! |!
rows, COUNT DISTINCT: unique values.
|! |! |! |!
SELECT statement usage in SQL - Correct answer ✔Retrieving data from one
|! |! |! |! |! |! |! |! |! |! |!
or more tables.
|! |! |!
FROM statement in SQL - Correct answer ✔Specifies tables for data retrieval
|! |! |! |! |! |! |! |! |! |! |! |!
in SQL queries.
|! |!
Tibbles vs. data frames - Correct answer ✔Modernized data frames with
|! |! |! |! |! |! |! |! |! |! |!
improved features. |!
Main operators in R - Correct answer ✔Arithmetic, relational, logical,
|! |! |! |! |! |! |! |! |! |!
assignment operators. |!
sample() function for biased data - Correct answer ✔Creates random
|! |! |! |! |! |! |! |! |! |!
unbiased data samples. |! |!
