Online Course Support | Prepare Data for Exploration

Relational databases contain a series of tables connected to form relationships. Which two types of fields exist in two connected tables?

1. Question 1 Relational databases contain a series of tables connected to form relationships. Which two types of fields exist in two connected tables? 1 / 1 point   Internal and external data…

Online Course Support | Prepare Data for Exploration

A data analyst chooses not to use external data because it represents diverse perspectives. This is an appropriate decision when working with external data.

5. Question 5 A data analyst chooses not to use external data because it represents diverse perspectives. This is an appropriate decision when working with external data. 1 point   True…

Online Course Support | Prepare Data for Exploration

Structural metadata indicates how a piece of data is organized and whether it’s part of one or more than one data collection.

3. Question 3 Structural metadata indicates how a piece of data is organized and whether it’s part of one or more than one data collection. 1 / 1 point   True   False…

Online Course Support | Prepare Data for Exploration

Relational databases illustrate relationships between tables. Which fields represent the connection between these tables? Select all that apply.

1. Question 1 Relational databases illustrate relationships between tables. Which fields represent the connection between these tables? Select all that apply. 1 / 1 point   Foreign keys   Correct Primary and foreign…

Online Course Support | Prepare Data for Exploration

The government of a large city collects data on the quality of the city’s infrastructure. Any business, nonprofit organization, or person can access the government’s databases and re-use or redistribute the data. Is this an example of open data?

8. Question 8 The government of a large city collects data on the quality of the city’s infrastructure. Any business, nonprofit organization, or person can access the government’s databases and…

Online Course Support | Prepare Data for Exploration

What is the process of protecting people’s private or sensitive data by eliminating identifying information?

7. Question 7 What is the process of protecting people’s private or sensitive data by eliminating identifying information? 1 / 1 point   Data anonymization   Data ethics   Data design   Data…

Online Course Support | Prepare Data for Exploration

A university surveys its student-athletes about their experience in college sports. The survey only includes student-athletes with scholarships. What type of bias is this an example of?

2. Question 2 A university surveys its student-athletes about their experience in college sports. The survey only includes student-athletes with scholarships. What type of bias is this an example of?…

Online Course Support | Prepare Data for Exploration

A data analyst at a book publisher is working on an urgent report for executives. They are using only historical data. What is the most likely reason for choosing to analyze only historical data?

1. Question 1 A data analyst at a book publisher is working on an urgent report for executives. They are using only historical data. What is the most likely reason…