D467 Exploring Data - Set 2 - 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 is tasked with finding all entries in a dataset where the values in the "price" column are above $50. Which SQL clause would they use?

SELECT

COUNT

WHERE

SUM

Question 2: In data ethics, what does the principle of "transaction transparency" ensure?

Data transactions must be public

Individuals must understand how their data is processed

Data must be anonymized before use

Data must always be encrypted

Question 3: A company wants to find out how many customers purchased a specific product. Which SQL function would they use to count these occurrences?

COUNT

AVERAGE

SUM

MAX

Question 4: Which SQL keyword would you use to remove duplicate records in a result set?

FILTER

DELETE

DISTINCT

TRIM

Question 5: Which type of data is described as "discrete"?

Data that can take on any value

Data that can only take specific values

Data that is descriptive and non-numerical

Data that is missing

Question 6: What does the term "data integrity" refer to?

The completeness, accuracy, and consistency of data

The ability to modify data without errors

The speed at which data is processed

The encryption of sensitive data

Question 7: What is the purpose of the SQL INSERT INTO statement?

To update existing records

To delete records

To insert new records into a table

To create a new table

Question 8: A data analyst needs to calculate the total revenue from a sales dataset. Which SQL function should they use?

COUNT

SUM

MAX

MIN

Question 9: Which spreadsheet function can count cells that meet a specific condition?

COUNT

SUMIF

COUNTIF

AVERAGE

Question 10: What type of chart is best suited for displaying changes over time?

Bar chart

Pie chart

Line chart

Scatter plot

Question 11: In a relational database, what is the role of a foreign key?

To store metadata

To link two tables

To store data in a hierarchical format

To uniquely identify each record in a table

Question 12: What type of SQL function is used to retrieve only non-null values from a list?

COALESCE

COUNT

SUM

MAX

Question 13: Which SQL keyword is used to remove records from a table?

DELETE

SELECT

INSERT

UPDATE

Question 14: What does the acronym CSV stand for in the context of data files?

Column-Separated Values

Character-Separated Values

Comma-Separated Values

Computed-Separated Values

Question 15: What is the purpose of the SQL SELECT statement?

To modify existing records

To insert new records

To retrieve data from a table

To remove data from a table

Question 16: Which spreadsheet function would you use to find the largest value in a range of cells?

MAX

AVERAGE

MIN

COUNT

Question 17: In the context of data ethics, what is the principle of "consent"?

Data must be encrypted at all times

Data can be collected without informing users

Individuals must agree to the collection and use of their data

Data must always be anonymized

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

To increase redundancy

To reduce redundancy and improve data integrity

To store large amounts of data in a single table

To encrypt sensitive data

Question 19: Which SQL function is used to return the average of a set of values?

SUM

COUNT

MAX

AVG

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

WHERE

GROUP BY

ORDER BY

SELECT

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