A data analyst at a high-tech manufacturer sorts inventory data in a spreadsheet. They sort all data by ranking in the Order Frequency column, keeping together all data across rows. What spreadsheet tool are they using?
Sort together
Sort rows
Sort sheet
Sort column
Fill in the blank: To filter for all students in the Sophomore table who live in Fairfield County, a data professional uses the _____ clause in SQL.
LIMIT
FILTER
EXCEPT
WHERE
A junior data analyst for a retailer discovers that, beginning three months ago, the number of units sold of printer paper has suddenly increased tenfold. She calls the inventory manager at the distribution center to check if the unit label changed from cases to reams. What phase of analysis is the analyst in?
Get input from others
Format and adjust data
Transform data
Organize data
Which of the following statements accurately describe sorting and filtering? Select all that apply.
Sorting involves arranging data into a meaningful order.
Filtering can be performed in spreadsheets, but not SQL databases.
Filtering enables data professionals to view the data that is most important.
Sorting can be performed in both spreadsheets and SQL databases.
You’re a data analyst with access to data on produce sales in the table
ProduceSales, but you’re only interested in analyzing rhubarb sales for your current project. Which query should you use to examine only the data on rhubarb sales?
SELECT * FROM ProduceSales, rhubarb;
SELECT * FROM ProduceSales WHERE produce_type == rhubarb;
SELECT * FROM ProduceSales WHERE 'rhubarb';
SELECT * FROM ProduceSales WHERE produce_type = 'rhubarb';
- Which query will return a list of all construction businesses that have made more than $8 million, from the largest number of employees to the fewest?
SELECT * FROM
CompanyDataWHERE Business = 'Construction', Revenue < 8000000 ORDER BY number_of_employees ASC;SELECT * FROM
CompanyDataWHERE Business = 'Construction' AND Revenue > 8000000 ORDER BY number_of_employees ASC;SELECT * FROM
CompanyDataWHERE Business = 'Construction' WHERE Revenue < 8000000 ORDER BY number_of_employees DESC;SELECT * FROM
CompanyDataWHERE Business = 'Construction' AND Revenue > 8000000 ORDER BY number_of_employees DESC;
A data professional in customer service is tasked with identifying customers who are at risk for taking their business to a competitor. In the analyze phase of the data analysis process, what activities might this involve? Select all that apply.
Request input from other customer service data professionals
Format the data to filter for low customer satisfaction scores
Prepare a report for the stakeholders
Organize a dataset by customer and purchase history
Which function sorts a spreadsheet range between cells C1 and D70 in ascending order by the first column, Column C?
\=SORT(C1:D70, A, FALSE)
\=SORT(C1:D70, 1, FALSE)
=SORT(C1:D70, 1, TRUE)
\=SORT(C1:D70, A, TRUE)
A data analyst is using the menu of a spreadsheet to sort their data. As they examine their dataset, they notice that one column appears to be incorrect. It is sorted in alphabetical order, but the cells are no longer associated with the row they’re in. What is the most likely cause of this problem?
They sorted only the data in the column, rather than sorting the sheet by row.
They sorted the sheet by row instead of column.
They sorted only the data in the column, rather than sorting the sheet by that column.
They sorted the sheet by column but sorted by the wrong column.
Which query will return
song_title,artist_name, andalbum_titlein alphabetical order bysong_title?SELECT playlist_name, creation_date FROM music_db.playlists ORDER BY creation_date;
SELECT song_title, artist_name, album_title FROM music_db.songs ORDER BY song_title;
SELECT song_title, artist_name, album_title FROM music_db.songs ORDER BY album_title;
SELECT song_title, artist_name, album_title FROM music_db.songs ORDER BY artist_name DESC;