D467 Exploring Data - Set 4 - 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: What is "data anonymization"?

Removing personally identifiable information from a dataset

Encrypting data to prevent unauthorized access

Removing duplicates from a dataset

Converting data into a different format

Question 2: Which of the following is a characteristic of unstructured data?

It fits neatly into rows and columns

It is organized in a well-defined format

It may have an internal structure but is not organized in a predefined way

It always contains numeric data

Question 3: What is the function of the CONCATENATE formula in a spreadsheet?

Joins together two or more text strings

Splits a text string into multiple cells

Removes spaces from a text string

Replaces a specific value in a text string

Question 4: What does the SQL DISTINCT keyword do in a query?

Removes duplicate rows from the result set

Sorts records in ascending order

Filters data based on specific conditions

Combines data from two or more tables

Question 5: What type of data is best described as "qualitative"?

Data that is counted or measured

Data that is numerical

Data that describes qualities or characteristics

Data that is used for calculations

Question 6: Which SQL function can be used to calculate the total sum of a column's values?

AVG

SUM

MIN

COUNT

Question 7: In the context of data ethics, what does the principle of "openness" refer to?

The free access, use, and sharing of data

The encryption of sensitive data

The requirement for data to be anonymized

The restriction of data access to authorized users

Question 8: What does the SQL WHERE clause do?

Retrieves data from a database

Filters records based on specified conditions

Joins two or more tables

Groups records by a specific field

Question 9: What is a "cookie" in the context of online data?

A small file stored on a computer that contains information about the user

A malicious program used to steal data

A method of encrypting user data

A data entry error in a spreadsheet

Question 10: In a dataset, what is a "population"?

A specific subset of data

All possible data values in a dataset

A single observation within a dataset

A field that contains categorical data

Question 11: What is the purpose of the SQL CAST function?

To convert data from one data type to another

To merge data from multiple tables

To retrieve non-null values

To calculate the sum of a column

Question 12: What does the term "data bias" refer to?

Data that is incomplete or missing

Data that is manipulated to show certain results

A systematic preference in data collection or analysis that skews the results

Data that is used for encryption

Question 13: What does the COUNT function do in SQL?

Returns the total sum of values in a column

Counts the number of non-null values in a column

Calculates the average of values in a column

Retrieves records based on specific conditions

Question 14: What is the purpose of the TRIM function in a spreadsheet?

Removes leading and trailing spaces from text

Joins multiple text strings together

Removes duplicates from a range

Converts text to uppercase

Question 15: In data ethics, what is the principle of "ownership"?

Data must be anonymized before it is shared

Individuals who create data own the data and control its use

Data should be freely accessible to everyone

Data must be encrypted before transmission

Question 16: Which SQL function is used to return only non-null values?

TRIM

MIN

COALESCE

COUNT

Question 17: What is a "primary key" in a relational database?

A field that uniquely identifies each record in a table

A field that contains duplicate values

A temporary key used for sorting data

A function for encrypting data

Question 18: In a spreadsheet, what does the COUNTA function do?

Counts the number of blank cells in a range

Counts the total number of non-blank cells in a range

Returns the sum of values in a range

Filters data based on specific criteria

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

To retrieve data from a database

To add new records to a table

To update existing records in a table

To delete records from a table

Question 20: What is the definition of "metadata"?

Data that describes other data

Data that is encrypted for secure transmission

Data that is used for calculations

Data that is missing from a dataset

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