D467 Exploring Data - Set 2 - Part 2

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

Question 21: In data analysis, what is a "pivot table" used for?

To create a summary report of data

To delete duplicates in a dataset

To convert text into numbers

To update values in a dataset

Question 22: Which SQL function returns the number of non-null records in a dataset?

COUNT

SUM

MAX

MIN

Question 23: What is the purpose of the TRIM function in SQL?

To return the length of a text string

To remove leading and trailing spaces from a text string

To count the number of characters in a text string

To replace spaces with underscores

Question 24: What is the benefit of using first-party data in an analysis?

It is always accurate

It is collected directly by the organization

It is available for free online

It requires no cleaning

Question 25: Which SQL statement would you use to modify existing data in a table?

DELETE

INSERT

UPDATE

SELECT

Question 26: In a dataset, what is an "outlier"?

A value that is repeated often

A value that lies significantly outside the range of most other values

A value that is calculated incorrectly

A value that represents the median

Question 27: In a relational database, what is a "primary key"?

A foreign key used in multiple tables

A unique identifier for each record in a table

A column used to store large datasets

A temporary key used for sorting data

Question 28: What is the role of data governance in an organization?

To improve data encryption

To manage the people, processes, and tools for effective data management

To store data in multiple locations

To prevent data from being shared externally

Question 29: In a dataset, which type of data is classified as "qualitative"?

Data that can be measured numerically

Data that represents categories or characteristics

Data that contains decimals

Data that is missing

Question 30: What does the SQL JOIN operation do?

Combines rows from two or more tables

Sorts data in ascending order

Deletes duplicate rows

Counts the number of records in a table

Question 31: Which SQL clause is used to filter records based on specific conditions?

ORDER BY

GROUP BY

WHERE

JOIN

Question 32: What is the function of the COUNTIF spreadsheet function?

To count all cells in a range

To count cells that meet a specific condition

To count the number of text cells

To count blank cells

Question 33: What type of bias occurs when a survey includes only specific groups, leaving others out?

Observer bias

Confirmation bias

Sampling bias

Response bias

Question 34: In data ethics, what is the principle of "privacy"?

All data must be encrypted

Individuals have the right to control how their data is used

Data must be anonymized before analysis

Data must be shared with the public

Question 35: Which of the following data types is classified as "continuous"?

Shoe size

Height of a person

Number of cars sold

Number of employees

Question 36: What is the purpose of a VLOOKUP function in a spreadsheet?

To find a value in a table based on a row

To calculate the sum of a column

To look up a value in a column and return corresponding data from another column

To merge two columns into one

Question 37: A data analyst wants to find the total number of non-empty cells in a range. Which function should they use?

COUNT

COUNTA

COUNTIF

SUM

Question 38: Which SQL function would you use to combine two or more text strings into one?

CONCAT

SUBSTR

TRIM

LENGTH

Question 39: What does the term "metadata" refer to in data management?

Data about data

A large set of unstructured data

A method for visualizing data

The primary data in a dataset

Question 40: In a relational database, which term refers to a field in one table that refers to the primary key in another table?

Foreign key

Index

Attribute

Variable

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass!

Get Exam Support