D467 Exploring Data - Set 1 - Part 1

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: A data analyst wants to combine first and last names into a single field in a dataset. Which SQL function would they use?

CONCATENATE

COUNT

SUM

AVERAGE

Question 2: Which SQL clause would you use to filter data based on a specific condition in a query?

GROUP BY

ORDER BY

WHERE

HAVING

Question 3: In a database, what is the purpose of a foreign key?

To uniquely identify each record in the table

To link records between two tables

To store the metadata of the table

To create temporary tables

Question 4: Which SQL clause is used to extract data from a specific column in a database?

SELECT

WHERE

ORDER BY

INSERT INTO

Question 5: What type of data represents true/false values?

Boolean

String

Integer

Float

Question 6: Which SQL function can be used to count non-null entries in a column?

COUNTIF

COUNT

COUNTA

COUNTNULL

Question 7: What is the primary purpose of normalization in a database?

To create new tables

To eliminate data redundancy

To update old data

To import external data

Question 8: A data analyst is tasked with cleaning a dataset by removing duplicate entries. Which SQL keyword would they use?

DISTINCT

UNIQUE

FILTER

DELETE

Question 9: In a dataset, what term is used to describe a value that falls significantly outside the expected range of values?

Mean

Median

Outlier

Mode

Question 10: What is the difference between primary and foreign keys in a database?

Both are used to create relationships between tables

A primary key uniquely identifies a record, while a foreign key links two tables

A primary key is optional, while a foreign key is mandatory

A foreign key stores metadata, while a primary key stores data

Question 11: Which function would you use to return the number of cells in a range that contain a specific value in a spreadsheet?

COUNTIF

SUMIF

AVERAGEIF

MAX

Question 12: In data visualization, what type of chart is best suited for showing proportions of a whole?

Bar chart

Line chart

Pie chart

Scatter plot

Question 13: What does a SQL CASE statement do?

Groups records by a specific field

Filters records by a specific condition

Allows conditional logic in queries

Joins two tables

Question 14: Which function in a spreadsheet will add the values of a selected range of cells?

SUM

MAX

AVERAGE

CONCATENATE

Question 15: Which SQL keyword is used to update records in a table?

SELECT

DELETE

UPDATE

INSERT

Question 16: A data analyst needs to store and organize large datasets across multiple departments. What tool should they use?

Spreadsheet

Database

Metadata

CSV file

Question 17: In a dataset, what does the term "continuous data" refer to?

Data that can only take specific, distinct values

Data that can take any value within a range

Data that represents text values

Data that contains missing values

Question 18: Which spreadsheet function is used to count non-empty cells in a range?

COUNT

COUNTBLANK

COUNTA

SUM

Question 19: Which term refers to a small piece of data stored on a user’s computer by a web browser?

Pixel

Boolean

Script

Question 20: What is a primary key's main function in a database?

It links tables together

It allows for fast sorting

It uniquely identifies each record

It stores metadata

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support