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

WGU D465 Practice Questions – Set 1

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 retrieve unique values from a column in a database. Which SQL function should the analyst use?

Question 2 of 50

Which SQL command allows a data analyst to create a table in a database?

Question 3 of 50

What is the purpose of the VLOOKUP function in spreadsheets?

Question 4 of 50

An analyst needs to filter data in a spreadsheet based on multiple conditions. Which function should they use?

Question 5 of 50

A data professional needs to connect two tables in a SQL query based on matching values in both tables. Which SQL function should they use?

Question 6 of 50

Which R function can be used to remove special characters from column names?

Question 7 of 50

Which SQL clause is used to group rows that have the same values in a table?

Question 8 of 50

Which Excel function calculates the sum of values based on a specified condition?

Question 9 of 50

In R, which package is used for creating complex data visualizations?

Question 10 of 50

A data analyst wants to join two tables and return all rows from the left table and matching rows from the right table. Which SQL function should they use?

Question 11 of 50

An analyst wants to ensure that certain conditions are met for multiple fields in a dataset. Which type of validation are they performing?

Question 12 of 50

Which SQL clause filters the results of a query based on a specified condition?

Question 13 of 50

In Excel, which function returns the smallest value from a range of numbers?

Question 14 of 50

A data analyst is performing calculations on a dataset in SQL. How can they ensure that the order of operations is correct?

Question 15 of 50

Which SQL command is used to change the structure of an existing table by adding a new column?

Question 16 of 50

Which R function returns the type of a variable or data structure?

Question 17 of 50

In SQL, which operator is used to filter records that match a specific pattern?

Question 18 of 50

Which R function can be used to calculate the average of values in a vector?

Question 19 of 50

A data analyst needs to return the sum of the products of corresponding values in two arrays in Excel. Which function should they use?

Question 20 of 50

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

Question 21 of 50

Which SQL clause is used to sort the result set of a query?

Question 22 of 50

Which SQL clause filters groups after aggregation has been applied?

Question 23 of 50

Which SQL command adds new rows of data to a table?

Question 24 of 50

Which SQL command modifies existing rows in a table?

Question 25 of 50

Which SQL command removes rows from a table?

Question 26 of 50

Which SQL aggregate function returns the number of rows?

Question 27 of 50

Which SQL aggregate function calculates the average of a numeric column?

Question 28 of 50

Which SQL aggregate function returns the largest value in a column?

Question 29 of 50

What does an INNER JOIN return?

Question 30 of 50

What does a RIGHT JOIN return?

Question 31 of 50

Which SQL operator combines the result sets of two queries into one, removing duplicates?

Question 32 of 50

Which SQL operator tests whether a value is within a list of values?

Question 33 of 50

Which SQL operator selects values within an inclusive range?

Question 34 of 50

How does SQL handle NULL values in most comparisons?

Question 35 of 50

What is a primary key in a relational database?

Question 36 of 50

What is a foreign key?

Question 37 of 50

What is the purpose of database normalization?

Question 38 of 50

What is a database index primarily used for?

Question 39 of 50

What is a subquery in SQL?

Question 40 of 50

Which Excel function counts cells that meet a single condition?

Question 41 of 50

Which Excel function averages values that meet a condition?

Question 42 of 50

Which Excel combination is a flexible alternative to VLOOKUP that can look left or right?

Question 43 of 50

What does the Excel IF function do?

Question 44 of 50

What does a dollar sign in an Excel cell reference (for example $A$1) indicate?

Question 45 of 50

What is an Excel PivotTable used for?

Question 46 of 50

Which R function reads a CSV file into a data frame?

Question 47 of 50

Which R function provides a statistical summary of each column in a data frame?

Question 48 of 50

In R, what does the na.rm = TRUE argument do in functions like mean()?

Question 49 of 50

Which R package is widely used for data manipulation with functions like filter and mutate?

Question 50 of 50

What is a data frame in R?

Set 1 complete

You scored 0%

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

Next: Set 2

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