Week 4: Organizing and protecting your data
1. Fill in the blank: File-naming conventions are _____ that describe a file's content, creation date, or version.
- general attributes
- frequent suggestions
- consistent guidelines
- common verifications
2. A data analytics team uses data about data to indicate consistent naming conventions for a project. What type of data is involved in this scenario?
- Metadata
- Aggregated data
- Long data
- Big data
3. Data analysts use naming conventions to help them identify or locate a file. Which of the following is an example of an effective file name?
- Elementary_Students_20090221_V03
- Sept_ElemtaryStudents_V1
- ElementarySchoolStudents_EnrollingSeptember2021_PlusRisingMiddleSchool_FJPSKVND
- Elem_9
4. Data analysts use a process called encryption to organize folders into subfolders.
- True
- False
5. A data analyst completes a project. They move project files to another location to keep them separate from their current work. This is an example of what process?
- Duplicating files
- Destroying files
- Archiving files
- Renaming files
6.Data analysts create hierarchies to organize their folders. How are folder hierarchies structured?
- Broad topics at the top, then more specific topics below
- Broad topics at the right, then more specific topics at the left
- Specific topics at the top, then more broad topics below
- Broad topics at the left, then more specific topics at the right
7. Using encryption to protect data is an example of what?
- Data validation
- Data integrity
- Data ethics
- Data security
8. To reduce clutter, a data analyst hides cells that contain long, complex formulas. To view the formulas again, the analyst will need to adjust the spreadsheet sharing or encryption settings.
- True
- False
9. A data analyst is working with a file from a customer satisfaction survey. The survey was sent to anyone who became a customer between April and June, 2020. Which of the following is an effective name for the file?
- April_May_June_2020_Responses_to_New_Customer_Survey_ANALYSISDATA_928310
- NewCustomerSurvey_2020-6-20_V03
- Survey_Responses
- Apr-June2020_CustSurvey_V
10. Foldering may be used by data analysts to organize folders into what?
- Databases
- Subfolders
- Versions
- Tables
11. Data analysts use archiving to separate current from past work. It also cuts down on clutter.
- True
- False
12. Fill in the blank: Data analysts create _____ to structure their folders.
- scales
- sequences
- ladders
- hierarchies
13. A data analyst wants to ensure only people on their analytics team can access, edit, and download a spreadsheet. They can use which of the following tools? Select all that apply.
- Sharing permissions
- Templates
- Filtering
- Encryption
14. A data analyst wants to share spreadsheet tab A with their team. They’re still working with tabs B and C, and they don’t want their team members to access them yet. Hiding tabs B and C will protect them from being accessed.
- True
- False
15. A data analytics team labels its files to indicate their content, creation date, and version number. The team is using what data organization tool?
- File-naming verifications
- File-naming conventions
- File-naming attributes
- File-naming references
16. To align file naming and storage practices, it’s useful to develop metadata practices with your data analytics team.
- True
- False
17. What process do data analysts use to keep project-related files together and organize them into subfolders?
- Foldering
- Encrypting
- Editing
- Naming
18. A data analyst completes a project. They move project files to another location to keep them separate from their current work. This is an example of what process?
- Renaming files
- Archiving files
- Destroying files
- Duplicating files
19. A data analyst adds sharing permissions to limit who can edit the data contained within a file. This is an example of what?
- Data validation
- Data integrity
- Data security
- Data ethics
20. What aspects of a file do file-naming conventions typically describe? Select all that apply.
- Creation date
- Content
- Version number
- Collaborators
21. Fill in the blank: A data analytics team uses _____ to indicate consistent naming conventions for a project. This is an example of using data about data.
- folder hierarchies
- classifications
- metadata
- version control
22. A data analyst creates a file that lists people who donated to their organization’s fund drive. An effective name for the file is FundDriveDonors_20210216_V01.
- True
- False
23. Data analysts use archiving to separate current from past work. What does this process involve?
- Using secure data-erase software to destroy old files
- Reviewing current data files to confirm they’ve been cleaned
- Moving files from completed projects to another location
- Reorganizing and renaming current files
24. Data analysts create hierarchies to organize their folders. They do this by structuring folders by specific topics at the top, then more broadly below.
- True
- False
25. A data analyst creates a spreadsheet with five tabs. They want to share the data in tabs 1-4 with a client. Tab 5 contains private information about other clients. Which of the following tactics will enable them to keep tab 5 private? Select all that apply.
- Rename tab 5 to include the word “private” then share the spreadsheet with the client.
- Hide tab 5, then share the spreadsheet with the client.
- Copy tabs 1-4 into a separate spreadsheet, then share the new file with the client.
- Make a copy of the spreadsheet, delete tab 5, then share the new file with the client.