-
Notifications
You must be signed in to change notification settings - Fork 104
3.3.4.Weekly challenge 3
LATEST SUBMISSION GRADE 100%
Relational databases illustrate relationships between tables. Which fields represent the connection between these tables? Select all that apply.
External keys- Primary keys
- Foreign keys
Secondary keys
Correct. Primary and foreign keys represent the connection between tables in a relational database.
Metadata is data about data. What kinds of information can metadata offer about a particular dataset? Select all that apply.
- If the data is clean and reliable
Which analyses to perform on the data- How to combine the data with another dataset
- What kinds of data it contains
Correct. Metadata helps data analysts identify the type of data, if it is clean and reliable, and how it can be combined with another dataset.
Think about data as driving a taxi cab. In this metaphor, which of the following are examples of metadata? Select all that apply.
- Make and model of the taxi cab
- License plate number
- Company that owns the taxi
Passengers the taxi picks up
Correct. The license plate number, make and model of the cab, and the company that owns the taxi represent structural metadata.
What is the process that data analysts use to ensure the formal management of their company’s data assets?
Data integrityData mappingData aggregation- Data governance
Correct. Data governance is the process of ensuring the formal management of a company’s data assets.
In what circumstance might a data analyst choose not to use external data in their analysis?
The data represents diverse perspectives- The data cannot be confirmed to be reliable
The data is too thoroughThe data is free for anyone to access
Correct. A data analyst might choose not to use external data in their analysis if the data cannot be confirmed to be reliable.
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?
Sort numerically in descending orderSort alphabetically in descending order- Sort numerically in ascending order
Sort alphabetically in ascending order
Correct. The data analyst should sort the number_of_laptops column numerically in ascending order.
When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.
- True
False
Correct. When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.
Fill in the blank: When writing a query, _____ are used to indicate the beginning and ending of a text string.
bracketssterisksbackticks- single quotes
Correct. Fill in the blank: When writing a query, single quotes are used to indicate the beginning and ending of a text string.
https://www.coursera.org/professional-certificates/google-data-analytics
© 2021 Coursera Inc. All rights reserved.