Prepare Data for Exploration: Weekly challenge 4

Prepare Data for Exploration: Weekly challenge 4

1.

Question 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?

1 / 1 point

File-naming verifications

File-naming references

File-naming conventions

File-naming attributes

Correct

2.

Question 2

Your boss assigns you a new multi-phase project and you create a naming convention for all of your files. With this project lasting years and incorporating multiple analysts it’s crucial that you create data explaining how your naming conventions are structured. What is this data called?

0 / 1 point

Descriptive data

Named convention

Metadata

Labeled data

Incorrect

Please review the video on naming conventions.

3.

Question 3

A grocery store is collecting inventory data from their produce section. What is an appropriate naming convention for this file?

0 / 1 point

Todays_Produce

Produce_Inventory_2022-09-15_V01

Todays Produce 2022-15-09

Inventory_Produce 2022-09-15 V01

Incorrect

Please review the video on naming conventions.

4.

Question 4

You have just started a new project and have created a naming convention for all of your files. Once the data has been collected you start foldering. What does the foldering process allow you to do?

1 / 1 point

Sort your files by name

Organize your files into subfolders

Organize your files in the filing cabinet

Organize your files into the cloud

Correct

5.

Question 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?

1 / 1 point

Duplicating files

Archiving files

Renaming files

Destroying files

Correct

6.

Question 6

An analyst team is organizing their project files in a hierarchical fashion. They decide to implement best practices. How do they structure their folders?

0 / 1 point

Broad topics at the top, then more specific topics below

Specific topics in the main folder, then more broad topics in the subfolders

Broad topics at the right, then more specific topics at the left

Broad topics at the left, then more specific topics at the right

Incorrect

Please review the reading on organization guidelines.

7.

Question 7

You’re in charge of the monthly inventory spreadsheet across all branches of your company. The spreadsheet has multiple pages, each of which denotes a branch. With branch managers needing to access these records, you decide to only give them access to their branch’s page. Applying these restrictions is an example of what?

1 / 1 point

Data integrity

Data hygiene

Data preservation

Data security

Correct

8.

Question 8

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.

1 / 1 point

Make a copy of the spreadsheet, delete tab 5, then share the new file with the client.

Correct

Rename tab 5 to include the word “private” then share the spreadsheet with the client.

Copy tabs 1-4 into a separate spreadsheet, then share the new file with the client.

Correct

Hide tab 5, then share the spreadsheet with the client.

1.

Question 1

A data analyst has been tasked with a new project and has started to collect data from multiple sources. The analyst will be working with multiple team members on this project and needs to create a naming convention to allow projects files to be located efficiently. What should the analyst include in each file's name? Select all that apply.

1 / 1 point

Creation date

Correct

Version number

Correct

Collaborators

Content

Correct

2.

Question 2

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

1 / 1 point

True

False

Correct

3.

Question 3

A data analyst is working with a file from a customer satisfaction survey. The survey was sent to anyone who became a new customer between April and June, 2020. Which of the following are effective names for the file?

1 / 1 point

April_May_June_2020_Responses_to_New_Customer_Survey_ANALYSISDATA_928310

NewCustomerSurvey_2020-6-20_V03

Apr2020_CustSurvey_V

Survey_Responses

Correct

4.

Question 4

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

1 / 1 point

Subfolders

Databases

Versions

Tables

Correct

5.

Question 5

You have recently completed a project describing annual sales across the various branches of your company. As the project has been completed you do not have use for these files anymore. What should you do with the project files?

1 / 1 point

Archive them

Copy them to a USB drive

Leave them where they are

Delete them

Correct

6.

Question 6

A data analyst working for a pet supply company has just started a new project. They organize their project folders to be broad topics at the top with more specific topics in the subfolders. This folder structure is known as what?

1 / 1 point

Hierarchical approach

Broad approach

Bottom to top approach

Top to bottom approach

Correct

7.

Question 7

Using encryption to protect data is an example of what?

1 / 1 point

Data security

Data integrity

Data ethics

Data validation

Correct

8.

Question 8

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.

1 / 1 point

True

False

Correct