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 5
WGU D465 · Data Applications

WGU D465 Practice Questions – Set 5

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

Question 1 of 50

In SQL, which clause is used to filter records that meet a specified condition after aggregating data?

Question 2 of 50

Which Excel function is used to return the middle part of a text string, starting at a specific position?

Question 3 of 50

In R, which function is used to apply a function over a list or vector and return a list?

Question 4 of 50

In SQL, which function is used to return the first value in a set of records?

Question 5 of 50

Which Excel function would you use to remove unwanted spaces from a text string?

Question 6 of 50

In R, which function is used to merge two dataframes by matching rows based on one or more columns?

Question 7 of 50

In SQL, which keyword is used to sort the results of a query in descending order?

Question 8 of 50

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

Question 9 of 50

In R, which function is used to return a subset of rows from a dataframe based on logical conditions?

Question 10 of 50

In SQL, which function is used to calculate the total number of rows that meet a specified condition?

Question 11 of 50

Which Excel function is used to find the largest value in a range of cells?

Question 12 of 50

In R, which function is used to apply a function to each column of a dataframe?

Question 13 of 50

In SQL, which clause is used to combine rows from multiple tables while showing all records from both, including unmatched rows?

Question 14 of 50

Which Excel function is used to sum the values in cells based on multiple criteria?

Question 15 of 50

In R, which function is used to return a logical vector indicating whether each element is NA?

Question 16 of 50

In SQL, which statement is used to remove an entire table from a database?

Question 17 of 50

Which Excel function would you use to round a number up to the nearest integer?

Question 18 of 50

In R, which function is used to return the number of rows in a dataframe?

Question 19 of 50

In SQL, which clause is used to select rows that do not meet a specified condition?

Question 20 of 50

Which Excel function would you use to calculate the product of two or more numbers?

Question 21 of 50

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

Question 22 of 50

In SQL, which function is used to combine multiple strings into one?

Question 23 of 50

Which Excel function would you use to return the smallest value in a range of cells?

Question 24 of 50

In R, which function would you use to create a bar plot?

Question 25 of 50

In SQL, which keyword is used to limit the results returned by a query to unique values?

Question 26 of 50

Which Excel function is used to calculate the sum of an array of numbers multiplied by another array of numbers?

Question 27 of 50

In R, which function is used to sample random numbers or elements from a vector?

Question 28 of 50

In SQL, which clause is used to filter rows that have matching values in two tables?

Question 29 of 50

Which Excel function would you use to return the position of a specific value within a range of cells?

Question 30 of 50

In R, which function is used to compute a cumulative sum of a vector?

Question 31 of 50

In SQL, which operator is used to check if a value exists within a range of values?

Question 32 of 50

Which Excel function is used to return the largest value in a range that meets a specific condition?

Question 33 of 50

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

Question 34 of 50

In SQL, which clause is used to specify the source table for a query?

Question 35 of 50

Which Excel function would you use to return the average of cells that meet multiple criteria?

Question 36 of 50

In R, which function is used to combine vectors by columns?

Question 37 of 50

In SQL, which function is used to extract a substring from a string?

Question 38 of 50

Which Excel function is used to return the remainder after dividing two numbers?

Question 39 of 50

In R, which function is used to create a histogram?

Question 40 of 50

In SQL, which operator is used to search for a specific pattern in a column?

Question 41 of 50

Which Excel function would you use to search for a value in the first column of a table and return a value from the same row in another column?

Question 42 of 50

In R, which function is used to return the number of columns in a dataframe?

Question 43 of 50

In SQL, which clause is used to group rows that have the same values in specified columns?

Question 44 of 50

Which Excel function would you use to replace part of a text string with a new string?

Question 45 of 50

In R, which function is used to compute the logarithm of a number?

Question 46 of 50

In SQL, which statement is used to add a new column to an existing table?

Question 47 of 50

Which Excel function would you use to return the rank of a number in a list of numbers?

Question 48 of 50

In R, which function is used to replace NA values in a vector with a specified value?

Question 49 of 50

In SQL, which function is used to calculate the average of a numeric column?

Question 50 of 50

Which Excel function would you use to calculate the number of days between two dates?

Set 5 complete

You scored 0%

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

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