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

Weekly challenge 3

LATEST SUBMISSION GRADE 100%

Question 1

Fill in the blank: Data aggregation involves creating a _____ collection of data that originally came from multiple sources.

  • localized
  • expanded
  • modified
  • summarized

Correct. Data aggregation involves creating a summarized collection of data from multiple sources.

Question 2

The VALUE function converts a numeric value into a text string in a spreadsheet.

  • True
  • False

Correct. The VALUE function converts a text string that represents a number into a numeric value.

Question 3

When using VLOOKUP, there are some common limitations that data analysts should be aware of. One of these limitations is that VLOOKUP only returns the first match it finds, even if there are many possible matches within the column.

  • True
  • False

Correct. One limitation of VLOOKUP is that it only returns the first match it finds, even if there are many possible matches within the column.

Question 4

A data analyst uses an absolute reference to lock a function array so rows and columns don’t change if the function is copied. What symbol is used to create an absolute reference?

  • Asterisk (*)
  • Hashtag (#)
  • Dollar sign ($)
  • Ampersand (&)

Correct. Dollar signs create an absolute reference.

Question 5

The following is a selection from a spreadsheet:

= A B C
1 Country Population in 2020 (millions) Growth in population 2000-2020
2 China 1,439,323,776 13.4%
3 India 1,380,004,385 37.1%
4 United States 331,002,651 17.3%
5 Indonesia 273,523,615 27.7%
6 Pakistan 220,892,340 44.9%
7 Brazil 212,559,417 21.9%
8 Nigeria 206,139,589 66.3%
9 Bangladesh 164,689,383 27.9%
10 Russia 145,934,462 -0.8%

To search for the population of Pakistan, what is the correct VLOOKUP syntax?

  • =VLOOKUP("Pakistan", A2:B10, 2, false)
  • =VLOOKUP(Pakistan, A2*B10, 2, false)
  • =VLOOKUP("Pakistan", A2:B10, 3, false)
  • =VLOOKUP(Pakistan, A2:B10, 3, false)

Correct. To search for the population of Pakistan, the syntax is =VLOOKUP("Pakistan", A2:B10, 2, false). “Pakistan” is the reference. A2:B10 is the table array. The 2 indicates the number of the column from which the value should be returned. And the word false instructs the function to return an exact match.

Question 6

When creating a SQL query, which JOIN clause returns only records with matching values in two or more database tables?

  • LEFT
  • RIGHT
  • INNER
  • OUTER

Correct. The INNER JOIN clause returns only records with matching values in two or more database tables.

Question 7

A data analyst writes a query that asks a database to return only distinct values in a specified range, rather than including repeating values. Which function do they use?

  • RETURN VALUES
  • COUNT
  • RETURN
  • COUNT DISTINCT

Correct. When writing SQL queries, an analyst can use the COUNT DISTINCT function to return only distinct values in a range.

Question 8

Which of the following terms describe a subquery? Select all that apply.

  • Inner query
  • Nested query
  • Small query
  • Inner select

Correct. A subquery can also be called an inner query, inner select, or nested query.