3.3.4.Weekly challenge 3 - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

LATEST SUBMISSION GRADE 100%

Question 1

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.

Question 2

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.

Question 3

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.

Question 4

What is the process that data analysts use to ensure the formal management of their company’s data assets?

  • Data integrity
  • Data mapping
  • Data aggregation
  • Data governance

Correct. Data governance is the process of ensuring the formal management of a company’s data assets.

Question 5

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 thorough
  • The 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.

Question 6

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 order
  • Sort 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.

Question 7

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.

Question 8

Fill in the blank: When writing a query, _____ are used to indicate the beginning and ending of a text string.

  • brackets
  • sterisks
  • backticks
  • 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.