Question

Question 1
Fill in the blank: A software engineer accesses the source of code for a new app in a _____, which allows them to revert to previous versions of the code if a problem is discovered.


changelog



dashboard



version control system



dataset


1 point
2.
Question 2
You are a data analyst working for an e-commerce company. You have just finished cleaning data from a customer survey whose original objective was to gather feedback on specific usability issues within the mobile app checkout process. While reviewing the cleaned data and preparing for verification, you notice that a large number of respondents complain about slow website loading times on desktop computers, which was not related to the mobile app checkout.

Based on the principles of data verification and taking the "big picture view," what is the most critical first step you should take in this situation?


Remove from the dataset all survey responses that mention desktop loading times.



Immediately begin a separate analysis of the website loading time comments, as this appears to be a significant customer pain point.



Pause and reassess whether focusing on the desktop loading time comments aligns with the original project goal centered on the mobile app checkout usability.



Ask a teammate to double-check your cleaning process to ensure no data related to desktop loading times was accidentally duplicated or introduced.


1 point
3.
Question 3
Which SQL clause will consider a condition and return a value when that condition is met?



CASE

WHEN column_name = 'condition' THEN 'value' END




CASE column_name = 'condition' THEN 'value' END




WHEN column_name = 'condition' CASE 'value' END




WHEN

CASE column_name = 'condition' THEN 'value' END



1 point
4.
Question 4
A data analyst uses a changelog to record how the data evolves while cleaning their data. What data cleaning best practice does this describe?



Examination



Disclosure



Documentation



Illumination


1 point
5.
Question 5
During verification, you wonder if one of your data modifications was an effective update. What can you reference to revisit the modification and your reasoning behind it?


Changelog



Data table



Text editor



Notepad


1 point
6.
Question 6
A data analyst uses a pivot table in Google Sheets to determine how many times a particular country name occurs within a dataset. What function will provide the required information?



CASE



CHECK



COUNTA



CONCAT


1 point
7.
Question 7
You are a data analyst responsible for cleaning sales data entered manually by the sales team into a shared spreadsheet. Month after month, you notice and document in your cleaning report that a significant number of entries for Product_ID contain typos (e.g., transposing digits, using O instead of 0, etc.). These errors require considerable time to identify and correct during the cleaning process before the data can be used for reporting.

During the feedback phase of the data cleaning process, what would be the most effective recommendation to propose to stakeholders or the process owner?



To build an automated script that runs after data entry each month to specifically find and fix the common Product_ID typos before analysis begins.



To implement a change in the data entry process, such as using a dropdown menu for Product_ID in the spreadsheet or adding a validation rule, to prevent these typos at the source.



To allocate more time for data cleaning each month specifically to handle the Product_ID typos.



To create a comprehensive guide documenting all known Product_ID typos and distribute it to the sales team, asking them to be more careful.


1 point
8.
Question 8
Fill in the blank: To update a client's last name in their spreadsheet, a data professional uses _____ to search for any instance of “Reynolds” and change it to “Mehta.”


TRIM



formatting



find and replace



Remove duplicates


1 point

Answer 1

1. version control system

2. Pause and reassess whether focusing on the desktop loading time comments aligns with the original project goal centered on the mobile app checkout usability.

3. CASE WHEN column_name = 'condition' THEN 'value' END

4. Documentation

5. Changelog

6. COUNTA

7. To implement a change in the data entry process, such as using a dropdown menu for Product_ID in the spreadsheet or adding a validation rule, to prevent these typos at the source.

8. find and replace