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