Layer 1 Relational databases contain a series of tables connected to form relationships. Which two types of fields exist in two connected tables? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When writing a query, it’s necessary for the name of the dataset to be inside two backticks in order for the query to run properly. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Primary and foreign keys are two connected identifiers within separate tables. These tables exist in what kind of database? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When working with data from an external source, what can metadata help data analysts do? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What is the process that data analysts use to ensure the formal management of their company’s data assets? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Data analysts use metadata for what tasks? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: Data _____ is the process of ensuring the formal management of a company’s data assets. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst reviews a database of Wisconsin car sales to find the last five car models sold in Milwaukee in 2019. How can they sort and filter the data to return the last five cars at the top? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: Data governance is the process of ensuring that a company’s _____ are managed in a formal manner. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst chooses not to use external data because it represents diverse perspectives. This is an appropriate decision when working with external data. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When writing a query, what does a data analyst write to indicate that the database should select the entire dataset? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In what circumstance might a data analyst choose not to use external data in their analysis? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Structural metadata indicates how a piece of data is organized and whether it’s part of one or more than one data collection. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Think about data as a student at a high school. In this metaphor, which of the following are examples of metadata? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A nonprofit provides laptops to students and maintains a list of how many laptops are provided to each school in the county. A data analyst wants to determine which schools were given the fewest laptops. In the table, there is a column called number_of_laptops. How should they sort the data to return these schools first? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A clinic surveys a group of male and female patients about their experience with physical therapy. The survey does not include people with disabilities. Is the survey data biased? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which type of bias is the tendency to always construe ambiguous situations in a positive or negative way? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 An individual who provides their data has the right to know and understand all of the data-processing activities and algorithms used on that data. This concept refers to which aspect of data ethics? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following “C’s” describe qualities of good data? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 An employer accesses an employee’s credit report without their consent. This is not a violation of the employee’s privacy because they work at the company. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following are commonly used methods for anonymizing data? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A key aspect of open data is free access to people’s personal information. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following are types of data bias often encountered in data analytics? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In general, the usefulness of data decreases as time passes. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions