Skip to content
Pass Any WGU OA Exam Now & Pay After You Pass. Contact Us!
  1. Home
  2. WGU Exams
  3. WGU D465
  4. Set 2
WGU D465 · Data Applications

WGU D465 Practice Questions – Set 2

50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.

Question 1 of 50

A data analyst needs to count the number of non-unique rows in a SQL table. Which function should they use?

Question 2 of 50

Which SQL command can be used to delete all rows in a table without removing the table itself?

Question 3 of 50

What is the primary purpose of the HAVING clause in SQL?

Question 4 of 50

In Excel, which function would be used to find the smallest value in a range that meets specific criteria?

Question 5 of 50

A data analyst needs to select all the rows where a value is between two specific numbers. Which SQL clause should they use?

Question 6 of 50

Which Excel function is used to calculate the number of blank cells in a range?

Question 7 of 50

In R, which function would you use to calculate the correlation between two variables?

Question 8 of 50

Which clause in SQL is used to sort the result set in ascending or descending order?

Question 9 of 50

A data analyst needs to create a pivot table in Excel. Which of the following is an element of a pivot table?

Question 10 of 50

In R, which function is used to remove rows with missing values (NA) from a dataframe?

Question 11 of 50

Which SQL keyword is used to combine rows from two or more tables?

Question 12 of 50

In Excel, which function would you use to search for a value in the first row of a horizontal table and return a value in the same column?

Question 13 of 50

In R, which function is used to calculate the mean of values in a vector, excluding missing values?

Question 14 of 50

Which SQL clause is used to group records with the same values into summary rows?

Question 15 of 50

In Excel, which function is used to sum values that meet a specific condition?

Question 16 of 50

A data analyst wants to concatenate two strings in SQL. Which function should they use?

Question 17 of 50

In R, which function calculates the square root of a number?

Question 18 of 50

In SQL, what does the DISTINCT keyword do?

Question 19 of 50

Which Excel function counts the number of cells that meet a single condition?

Question 20 of 50

In R, which function is used to calculate the standard deviation of a dataset?

Question 21 of 50

What is the purpose of the WHERE clause in SQL?

Question 22 of 50

In Excel, which function would you use to return the current date and time?

Question 23 of 50

In R, which function is used to convert a dataframe to a tibble?

Question 24 of 50

Which SQL function is used to calculate the average of a column’s values?

Question 25 of 50

In Excel, which function would you use to count the number of non-empty cells in a range?

Question 26 of 50

Which SQL command is used to remove a table from a database?

Question 27 of 50

In R, which function calculates the sum of the elements of a vector?

Question 28 of 50

In SQL, which keyword is used to limit the number of rows returned by a query?

Question 29 of 50

In Excel, which function would you use to find the maximum value in a range of cells?

Question 30 of 50

A data analyst needs to filter out rows where a value is greater than a specific number in SQL. Which clause should they use?

Question 31 of 50

In R, which function is used to rename a column in a dataframe?

Question 32 of 50

In SQL, which function would you use to count only the unique values in a column?

Question 33 of 50

In Excel, which function is used to retrieve the value from a specified position in a table or array?

Question 34 of 50

Which clause is used in SQL to specify a condition that rows must meet after they are grouped?

Question 35 of 50

In R, which function is used to create a scatter plot?

Question 36 of 50

In SQL, which function returns the remainder of a division operation?

Question 37 of 50

Which Excel function returns the number of characters in a text string?

Question 38 of 50

In R, which function combines two or more vectors into a single vector?

Question 39 of 50

In SQL, which clause is used to group rows that have the same values into summary rows?

Question 40 of 50

In Excel, which function is used to round a number to a specified number of digits?

Question 41 of 50

In R, which function would you use to remove missing values from a vector?

Question 42 of 50

Which SQL function would you use to calculate the total sum of a numeric column?

Question 43 of 50

In Excel, which function is used to return the average of a set of values?

Question 44 of 50

In R, which function would you use to calculate the median of a numeric vector?

Question 45 of 50

Which SQL keyword is used to return only distinct values in a query result?

Question 46 of 50

Which Excel function would you use to count the number of cells that contain a specific value?

Question 47 of 50

In R, which function is used to check if a value is NA (missing)?

Question 48 of 50

In SQL, which function is used to calculate the number of non-null values in a column?

Question 49 of 50

Which Excel function would you use to add all the numbers in a range?

Question 50 of 50

In R, which function is used to calculate the variance of a numeric vector?

Set 2 complete

You scored 0%

0 correct out of 0 answered (50 questions in this set).

Next: Set 3

Struggling with WGU D465?

If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.

Chat Now