Layer 1 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. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Using encryption to protect data is an example of what? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 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? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Data analysts use a process called encryption to organize folders into subfolders. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Data analysts create hierarchies to organize their folders. How are folder hierarchies structured? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Data analysts use archiving to separate current from past work. What does this process involve? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Data analysts create hierarchies to organize their folders. They do this by structuring folders by specific topics at the top, then more broadly below. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: File-naming conventions are _____ that describe a file’s content, creation date, or version. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Relational databases illustrate relationships between tables. Which fields represent the connection between these tables? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Metadata is data about data. What kinds of information can metadata offer about a particular dataset? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Think about data as driving a taxi cab. In this metaphor, which of the following are examples of metadata? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What are some key benefits of using external data? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst reviews a national database of movie theater showings. They want to find the first 10 movies shown in San Francisco in 2001. How can they organize the data to return the first 10 movies at the top? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When writing a query, you must remove the two backticks around the name of the dataset in order for the query to run properly. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When writing a query, what term is used to indicate where the database should look for the desired data? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions