Organizing and Protecting Your Data INTRODUCTION

Test your knowledge on how to organize data

1. Data analysts use archiving to separate current from past work. it also cuts down on clutter.

2. Data analysts use guidelines to describe a file’s version, content, and date created. What are these guidelines called?

3. Data analysts use foldering to achieve what goals? Select all that apply.

4. Fill in the blank: To separate current from past work and reduce clutter, data analysts create _____. This involves moving files from completed projects to a separate location.

5. What is the process of structuring folders broadly at the top, then breaking down those folders into more specific topics?

6. Successful file naming conventions include information that’s useful when trying to locate or update a file. Which of the following is an effective file name?

Test your knowledge on securing your data

1. Fill in the blank: Data security involves using _____ to protect data from unauthorized access or corruption.

2. When using data security measures, analysts can choose between protecting an entire spreadsheet or protecting certain cells within the spreadsheet.

3. What tools can data analysts use to control who can access or edit a spreadsheet? Select all that apply.

GOOGLE DATA ANALYTICS COURSERA ANSWERS AND STUDY GUIDE

Weekly Breakdown | Google Study Guides | Back to Top

Prepare Data for Exploration Weekly Challenge 4

1. A data analytics team labels its files to indicate their content, creation date, and version number. The team is using what data organization tool?

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?

3. 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?

4. Foldering may be used by data analysts to organize folders into what?

5. Data analysts use archiving to copy and keep backups of important files. These backups are used if original files are lost.

6. Data analysts create hierarchies to organize their folders. They do this by structuring folders by specific topics at the top, then more broadly below.

7. 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.

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.

9. Data analysts use a process called encryption to organize folders into subfolders.

10. 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?

11. 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.

12. A data analytics team labels its files to indicate their content, creation date, and version number. The team is using what data organization tool?

13. To align file naming and storage practices, it’s useful to develop metadata practices with your data analytics team.

14. 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?

15. Data analysts use archiving to separate current from past work. What does this process involve?

16. Fill in the blank: Data analysts create _____ to structure their folders.

17. Using encryption to protect data is an example of what?

18. What process do data analysts use to keep project-related files together and organize them into subfolders?

19. 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.

20. What aspects of a file do file-naming conventions typically describe? Select all that apply.

21. To align file naming and storage practices, it’s useful to develop metadata practices with your data analytics team.

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.

23. Data analysts create hierarchies to organize their folders. How are folder hierarchies structured?

24. A data analyst adds sharing permissions to limit who can edit the data contained within a file. This is an example of what?

25. 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.

26. Fill in the blank: File-naming conventions are _____ that describe a file’s content, creation date, or version.

27. 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.

28. Data analysts use a process called encryption to organize folders into subfolders.

Organizing and Protecting Your Data CONCLUSION