11. Fill in the blank: Sorting ranks data based on a specific _____ that you select.
- calculation
- observation
- metric
- model
12. A data analyst is sorting data in a spreadsheet. Which tool are they using if all of the data is sorted by the ranking of a specific sorted column and data across rows is kept together?
- Sort Sheet
- Sort Together
- Sort Rank
- Sort Document
13. A data analyst sorts a spreadsheet range between cells A1 and E50. They sort in descending order by the fourth column, Column D. What is the syntax they are using?
- =SORT(A1:E50, 4, FALSE)
- =SORT(A1:E50, 4, TRUE)
- =SORT(A1:E50, D, TRUE)
- =SORT(A1:E50, D, FALSE)
14. You are querying a database that contains data about music. You are only interested in data related to the jazz musician Miles Davis. The names of the musicians are listed in the composer column.
You write the following SQL query, but it is incorrect. What is wrong with the query?
SELECT *
FROM Track
WHERE composer = Miles Davis
- Line 3 should be rewritten as WHERE composer is Miles Davis.
- Composer in line 3 should be capitalized.
- SELECT, FROM, and WHERE should not be capitalized.
- Miles Davis should be in double quotation marks.
15. You are working with a database that contains invoice data about online music purchases. You are only interested in invoices sent to customers located in the city of Paris. You want to sort the invoices by order total in ascending order. The order totals are listed in the total column.
You write the SQL query below. However this query is incorrect. What is wrong with it?
SELECT *
FROM invoice
WHERE billing_city = “Paris”
ORDER total
- SELECT, FROM, WHERE, and ORDER are capitalized.
- Line 4 is missing the text column = between ORDER and total.
- In line 3, “Paris” has quotation marks.
- Line 4 is missing the word BY between ORDER and total.
16. After collecting the relevant datasets for their analysis, a data analyst compares this data to external sources. In which of the four phases of analysis does this occur?
- Organize data
- Format and adjust data
- Transform data
- Get input from others
17. A data analyst working on a data set is investigating possible relationships in the data. What phase of analysis is the analyst in?
- Format and adjust data
- Get input from others
- Transform data
- Organize data
18. A data analyst sorts a spreadsheet range between cells K9 and L20. They sort in ascending order by the first column, Column K. What is the syntax they are using?
- =SORT(K9:L20, K, TRUE)
- =SORT(K9:L20, K, FALSE)
- =SORT(K9:L20, 1, TRUE)
- =SORT(K9:L20, 1, FALSE)
Shuffle Q/A 2
19. You are querying a database that contains data about music. Each album is given an ID number. You are only interested in data related to the album with ID number 3. The album IDs are listed in the album_id column.
You write the following SQL query, but it is incorrect. What is wrong with the query?
SELECT *
FROM Track
WHERE album = 3
- In line 3, album should be album_id.
- SELECT, FROM, and WHERE should be capitalized.
- In line 3, album is not capitalized.
- Line 3 contains an equal sign.
20. In the data analysis process, which of the following refers to a phase of analysis? Select all that apply.
- Format data using sorts and filters
- Get input from others
- Organize data into understandable sections
- Visualize the data
