Prepare Data for Exploration

Which statements define primary keys and foreign keys and describe their relationship? Select all that apply.

A foreign key is a field within a table that's a primary key in another table A primary key is an identifier that references a column in which each value is unique Primary and foreign keys are two connected identifiers within separate tables in a relational database.

What tasks can data analysts accomplish using metadata? Select all that apply.

Combine data from more than one source Evaluate the quality of data Interpret the contents of a database

Imagine that a company uses your personal data as part of a financial transaction. Before it occurs, you are not made aware of the nature and scale of this transaction. What concept of data ethics does this violate?

Currency

A data analyst is evaluating data to determine whether it is good or bad. Which qualities characterize good data? Select all that apply.

Current Cited Comprehensive

Which of the following are uses of relational databases? Select all that apply.

Keep data consistent regardless of where it's accessed Contain and describe a series of tables that can be connected to form relationships Present the same information to each collaborator

What are the benefits of data modeling? Select all that apply.

Make data easier to understand keep data consistent provide a map of how data is organized

Which of the following are protections afforded by data privacy? Select all that apply.

Providing users the right to inspect, update, or correct their own data Preserving a data subject's information and activity for all data transactions

You are writing a SQL query to filter data from a database that describes trees in Omaha, Nebraska. You want to only display entries for trees that have a diameter of 30 inches. The name of the table you're using is Nebraska_trees and the name of the column that shows the diameters of the trees is trunk_diameter. What is the correct query syntax that will retrieve and filter data from this table?

SELECT * FROM Nebraska_tree WHERE trunk_diameter = 30

A data analyst reviews a spreadsheet of boat auction sales to find the last five sailboats sold in Kentucky. What steps would they take in order to narrow the scope? Select all that apply.

Sort by date in descending order Filter out sales outside of Kentucky

A data analyst at a construction company is working on a report for a quickly approaching deadline. Why might they choose to analyze only historical data?

The project has a very short time frame.

Consistent naming conventions describe which properties of a file? Select all that apply.

Version Content Creation Date

A group of high school students take a survey that asks," Are you on an athletic team? Please reply yes or no." What kind of data is being collected?

boolean