Show
Test your knowledge on how to organize dataTOTAL POINTS 5 Question 1Data analysts use guidelines to describe a file’s version, content, and date created. What are these guidelines called?
Correct. Naming conventions are guidelines that describe the content, date, or version of a file. Question 2Data analysts use foldering to achieve what goals? Select all that apply.
Correct. Data analysts use foldering to keep project-related files together and organize them into subfolders. Question 3Fill 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.
Correct. To separate current from past work and reduce clutter, data analysts create archives. Question 4What is the process of structuring folders broadly at the top, then breaking down those folders into more specific topics?
Correct. The process of structuring folders broadly at the top, then breaking down those folders into more specific topics, is creating a hierarchy. Question 5Successful 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?
Correct. AirportCampaign_2013_10_09_V01 is an effective file name because it is an appropriate length and it references the project name, creation date, and version. This is the third course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. As you continue to build on your understanding of the topics from the first two courses, you’ll also be introduced to new topics that will help you gain practical data analytics skills. You’ll learn how to use tools like spreadsheets and SQL to extract and make use of the right data for your objectives and how to organize and protect your data. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources. Enroll On Coursera Prepare Data for Exploration Week 01 Quiz AnswersL2 Differentiate between data structures:Q1. Fill in the blank: The running time of a movie is an example of _____ data.
Q2. What are the characteristics of unstructured data? Select all that apply.
Q3. Structured data enables data to be grouped together to form relations. This makes it easier for analysts to do what with the data? Select all that apply. Q4. Which of the following is an example of unstructured data?
Practice Quiz-2 AnswersL3 Generating data:Q1. Which method of data collection is most often used by scientists?
Q2. Fill in the blank: Organizations such as the U.S. Centers for Disease Control (CDC) often use data collected from other organizations. Data gathered by hospitals, then collected by the CDC is an example of _____.
Q3. A data analyst is working for a company that’s about to launch a new product. The analyst needs to collect qualitative data from customers during the product launch. What is the quickest, most accurate, and most relevant method of data collection in this scenario?
Practice Quiz-3 AnswersL4 Explore data types, fields, and values:Q1. You’re working as a data analyst and you use a formula to average data in a spreadsheet. You receive an error based on the data type. Which data types in cells may have caused the error? Select all that apply.
Q2. The Boolean operator Not performs which of the following actions?
Q3. Fill in the blank: Internet search engines are an everyday example of how Boolean operators are used. The Boolean operator _____ expands the number of results when used in a keyword search. Q4. Which of the following statements accurately describes a key difference between wide and long data?
Q5. Data transformation enables you to do what with your data?
Prepare Data for Exploration Weekly challenge 1 AnswersQ1. If you have a short time frame for data collection and need an answer immediately, you would have to use historical data. Q2. Which of the following is an example of continuous data?
Q3. Which of the following questions collects nominal qualitative data?
Q4. Which of the following is a benefit of internal data?
Q5. A social media post is an example of structured data. Q6. Fill in the blank: A Boolean data type can have _____ possible values. Q7. In long data, separate columns contain the values and the context for the values, respectively. What does each column contain in wide data?
Q8. A data analyst is working in a spreadsheet application. They use Save As to change the file type from .XLS to .CSV. This is an example of a data transformation. Prepare Data for Exploration Week 02 Quiz AnswersPractice Quiz-1 AnswersL2 Unbiased and objective data:Q1. Which of the following are examples of sampling bias? Select all that apply.
Q2. Two doctors look at the exact same image of a brain scan. The image is inconclusive, yet one doctor sees evidence of an abnormality in the brain. The other doctor sees a healthy brain. This is an example of sampling bias. Practice Quiz-2 AnswersL3 Explore data credibility:Q1. Which of the following are usually good data sources? Select all that apply.
Q2. To determine if a data source is cited, you should ask which of the following questions? Select all that apply.
Q3. Which of the following are qualities of a bad data source? Select all that apply.
Q4. A data analyst is analyzing sales data for the newest version of a product. They use third-party data about an older version of the product. For what reasons is this inappropriate for their analysis? Select all that apply. The data is not accurate The data is biased
Practice Quiz-3 AnswersL4 Understand data ethics and privacy:Q1. A data analyst uses fixed-length codes to represent data columns in order to remove personally identifying information from a dataset. What process does this scenario describe?
Q2. Data analysts never anonymize license plate numbers because that type of data can be easily seen whenever someone is out driving their car. Q3. Before completing a survey, an individual reads information about how and why the data they provide will be used. What is this concept called?
Practice Quiz-4 AnswersL5 Explaining open data:Q1. What aspect of data ethics promotes the free access, usage, and sharing of data?
Q2. What are the main benefits of open data?
Q3. Universal participation is a standard of open data. What are the key aspects of universal participation? Select all that apply.
Prepare Data for Exploration Weekly challenge 2 AnswersQ1. Fill in the blank: A preference in favor of or against a person, group of people, or thing is called _____. It is an error in data analytics that can systematically skew results in a certain direction.
Q2. A university surveys its student-athletes about their experience in college sports. The survey only includes student-athletes with scholarships. What type of bias is this an example of?
Q3. Which of the following are qualities of unreliable data? Select all that apply.
Q4. In data ethics, consent gives an individual the right to know the answers to which of the following questions? Select all that apply.
Q5. An individual who provides their data has the right to know and understand all of the data-processing activities and algorithms used on that data. This concept refers to which aspect of data ethics?
Q6. What is data privacy?
Q7. Data anonymization applies to both text and images. Q8. The government of a large city collects data on the quality of the city’s infrastructure. Any business, nonprofit organization, or citizen can access the government’s databases and re-use or redistribute the data. Is this an example of open data? Prepare Data for Exploration Week 03 Quiz AnswersPractice Quiz-1 AnswersAccessing different data sources:Q1. A .CSV file saves data in a table format. What does .CSV stand for?
Q2. A data analyst wants to bring data from a .CSV file into a spreadsheet. This is an example of what process?
Q3. A .CSV file makes it easier for data analysts to complete which tasks? Select all that apply.
Practice Quiz-2 AnswersL2 Working with databases:Q1. Fill in the blank: Normalized databases help avoid _____ data.
Q2. What does a database’s metadata tells a data analyst about its contents? Select all that apply.
Q3. What is the difference between a primary key and a foreign key?
Q4. A data analyst at a PR firm needs to construct a database of celebrity clients. If their boss needs the data to be accessed as quickly as possible, the analyst should use a snowflake schema. Q5. Fill in the blank: A relational database contains a series of _____ that can be connected to form relationships. Practice Quiz-3 AnswersQ1. A large company has several data collections across its many departments. What kind of metadata indicates exactly how many collections the data lives in?
Q2. Fill in the blank: Data _____ ensures that a company’s data assets are properly managed.
Q3. A large metropolitan high school gives each of its students an ID number to differentiate them in its database. What kind of metadata are the ID numbers?
Q4. A company needs to merge third-party data with its own data. The company can accomplish this with which of the following actions? Select all that apply.
Q5. The date and time a database was created is an example of which kind of metadata?
Practice Quiz-4 AnswersL5 Sorting and filtering:Q1. What is the process for arranging data into a meaningful order to make it easier to understand, analyze, and visualize?
Q2. Filtering by a particular criteria is an effective way to narrow the scope of a query. However, filtering is time-intensive because it can only be done one variable at a time. Q3. A data analyst is reviewing a national database of real estate sales. They are only interested in sales of condominiums. How can the analyst narrow their scope?
Q4. A data analyst works for a rental car company. They have a spreadsheet that lists car ID numbers and the dates cars were returned. How can they sort the spreadsheet to find the most recently returned cars?
Q5. Fill in the blank: To keep a header row at the top of a spreadsheet, highlight the row and select _____ from the View menu. Practice Quiz-5 AnswersL6 Working with large datasets in SQL:Q1. In MySQL, what is a proper way to write a SELECT clause starter?
Q2. Which case should be used when writing the column names in a database table?
Prepare Data for Exploration Weekly challenge 3 AnswersQ1. Primary and foreign keys are two connected identifiers within separate tables. These tables exist in what kind of database?
Q2. Metadata is data about data. What kinds of information can metadata offer about a particular dataset? Select all that apply.
Q3. Think about data as a student at a high school. In this metaphor, which of the following are examples of metadata? Select all that apply.
Q4. Think about data as a refrigerator. Which kind of metadata is the refrigerator’s product number?
Q5. What is the process that data analysts use to ensure the formal management of their company’s data assets?
Q6. Describe the key differences between a star and a snowflake schema. Select all that apply.
Q7. What are some key benefits of using external data? Select all that apply.
Q8. A data analyst reviews a database of Wisconsin car sales to find the last five car models sold in Milwaukee in 2019. How can they sort and filter the data to return the last five cars at the top? Select all that apply.
Prepare Data for Exploration Week 04 Quiz AnswersPractice Quiz-1 AnswersL2 Effectively organize data:Q1. Data analysts use guidelines to describe a file’s version, content, and date created. What are these guidelines called?
Q2. Data analysts use foldering to achieve what goals? Select all that apply.
Q3. 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.
Q4. What is the process of structuring folders broadly at the top, then breaking down those folders into more specific topics?
Q5. Successful file naming conventions include information that’s useful when trying to locate or update a file. Which of the following are effective file names? Select all that apply.
Practice Quiz-2 AnswersL3 Securing data:Q1. Fill in the blank: Data security involves using _____ to protect data from unauthorized access or corruption.
Q2. When using data security measures, analysts can choose between protecting an entire spreadsheet or protecting certain cells within the spreadsheet. Q3. What tools can data analysts use to control who can access or edit a spreadsheet? Select all that apply.
Prepare Data for Exploration Weekly challenge 4 AnswersQ1. Fill in the blank: Naming conventions are _____ that describe a file’s content, creation date, or version.
Q2. 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?
Q3. 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_Feb2022_V3. Q4. Foldering may be used by data analysts to organize folders into what?
Q5. Data analysts use archiving to separate current from past work. What does this process involve?
Q6. Fill in the blank: Data analysts create _____ to structure their folders.
Q7. 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.
Q8. 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. Prepare Data for Exploration Week 05 Quiz AnswersPractice Quiz-1 AnswersCourse challenge:Scenario 1, questions 1-5Q1. You’ve been working at a data analytics consulting company for the past six months. Your team helps restaurants use their data to better understand customer preferences and identify opportunities to become more profitable. To do this, your team analyzes customer feedback to improve restaurant performance. You use data to help restaurants make better staffing decisions and drive customer loyalty. Your analysis can even track the number of times a customer requests a new dish or ingredient in order to revise restaurant menus. Currently, you’re working with a vegetarian sandwich restaurant called Garden. The owner wants to make food deliveries more efficient and profitable. To accomplish this goal, your team will use delivery data to better understand when orders leave Garden, when they get to the customer, and overall customer satisfaction with the orders. Before project kickoff, you attend a discovery session with the vice president of customer experience at Garden. He shares information to help your team better understand the business and project objectives. As a follow-up, he sends you an email with datasets. Click below to read the email: C3 Scenario 1_Client Email.pdf And click below to access the datasets: Course 3 Final Challenge Data Sets – Customer survey data (1).csv Course 3 Final Challenge Data Sets – Delivery times_distance (1).csv Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data is first-party data. What does this mean?
Q2. Next, you review the customer satisfaction survey data: CustomerSurveyData – Customer survey data.csv The question in column E asks, “Was your order accurate? Please respond yes or no.” What kind of data is this?
Q3. Now, you review the data on delivery times and the distance of customers from the restaurant: DeliveryTimes_DistanceData – Delivery times_distance.csv The data in column E shows the duration of each delivery. What type of data is this? Select all that apply.
Q4. The next thing you review is the file containing pictures of sandwich deliveries over a period of 30 days. This is an example of structured data. Q5. Now that you’re familiar with the data, you want to build trust with the team at Garden. What actions should you take when working with their data? Select all that apply.
Scenario 2, questions 6-10Q6. You’ve completed this program and are interviewing for a junior data scientist position at a company called Sewati Financial Services. Click below to review the job description: C3 Course Challenge Junior Data Scientist Job Description .pdf So far, you’ve successfully completed the first interview with a recruiter. They arrange your second interview with the team at Sewati Financial Services. Click below to read the email from the human resources director: Course 3 Scenario 2_Second Interview Email.pdf You arrive 15 minutes early for your interview. Soon, you are escorted into a conference room, where you meet Kai Harvey, the senior manager of strategy. After welcoming you, he begins the behavioral interview. Q6. Consider and respond to the following question. Select all that apply. Our data analytics team often surveys clients to get their feedback. If you were on the team, how would you ensure the results do not favor a particular person, group of people, or thing?
Q7. Consider and respond to the following question. Select all that apply. Our data analytics team often uses both internal and external data. Describe the difference between the two.
Q8. Consider and respond to the following question. Select all that apply. Our analysts often work with the same spreadsheet, but for different purposes. How would you use filtering to help in this situation?
Q9. Next, your interviewer wants to better understand your knowledge of basic SQL commands. He asks: How would you write a query that retrieves only data about people with the last name Hassan from the Clients table in our database?
Q10. For your final question, your interviewer explains that Sewati Financial Services cares about its clients’ trust, and this is an important responsibility for the data analytics team. They do this by:
He asks: Which data analytics practice does this describe?
Next Course Quiz Answers >> Ask Questions to Make Data-Driven Decisions << Previous Course Quiz Answers Foundations: Data, Data, Everywhere All Course Quiz Answers of Google Data Analytics Professional Certificate Course 01: Foundations: Data, Data, Everywhere Course 02: Ask Questions to Make Data-Driven Decisions Course 03: Prepare Data for Exploration Course 04: Process Data from Dirty to Clean Course 05: Analyze Data to Answer Questions Course 06: Share Data Through the Art of Visualization Course 07: Data Analysis with R Programming Course 08: Google Data Analytics Capstone: Complete a Case Study Prepare Data for Exploration Coursera Course Review:In our experience, we suggest you enroll in the Prepare Data for Exploration Coursera Course and gain some new skills from Professionals completely free and we assure you will be worth it. Prepare Data for Exploration Coursera course is available on Coursera for free, if you are stuck anywhere between quiz or graded assessment quiz, just visit Networking Funda to get Prepare Data for Exploration Coursera Quiz Answers This Course is a part of the Google Data Analytics Professional Certificate Conclusion:I hope this Prepare Data for Exploration Coursera Quiz Answers would be useful for you to learn something new from this Course. If it helped you then don’t forget to bookmark our site for more Coursera Quiz Answers. This course is intended for audiences of all experiences who are interested in learning about Data Analytics in a business context; there are no prerequisite courses. Keep Learning!
|