Latest Submission Grade: 100% The manage stage of the data life cycle is when a business decides what kind of data it needs, how the data will be handled, and who will be responsible for it. During planning, a business decides what kind of data it needs, how it will be managed throughout its life cycle, who will be responsible for it, and the optimal outcomes. A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle? This describes the destroy phase, during which data analysts use secure data-erasure software and shred paper files to protect private information. In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply. In the analyze phase of the data life cycle, a data analyst might use formulas to perform calculations, create a report from the data, or use spreadsheets to aggregate data. Describe how the data life cycle differs from data analysis. The data life cycle involves stages for identifying needs and managing data. Data analysis involves process steps to make meaning from data. A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process? The act phase is when insights are put into action. Fill in the blank: Spreadsheets are _____ that can be used to store, organize, and sort data. Spreadsheets are digital worksheets that can be used to store, organize, and sort data. Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____. A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process. Fill in the blank: A query is used to _____ information from a database. Select all that apply. A query enables data analysts to request, retrieve, and update information from a database. Structured query language (SQL) enables data analysts to communicate with a database. SQL allows a data analyst to communicate with a database in order to retrieve and manipulate data. The graphical representation of information helps stakeholders understand data insights. Formulas and functions make this possible.
Page 2
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
1) Fill in the blank: A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the _____ stage of the data life cycle. Ans: Plan 2) The destroy stage of the data life cycle might involve which of the following actions? Select all that apply. Ans:
3) A data analyst uses a spreadsheet function to aggregate data. Then, they add a pivot table to show totals from least to greatest. This would happen during which stage of the data life cycle? Ans: Analyze 4) The data life cycle deals with the stages that data goes through; data analysis involves following a process to analyze data. Ans: True 5) What actions might a data analytics team take in the act phase of the data analysis process? Select all that apply. Ans:
6) What is the main difference between a formula and a function? Ans: A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process 7) Fill in the blank: A query is used to _____ information from a database. Select all that apply. Ans: 8) Structured query language (SQL) enables data analysts to communicate with a database. Ans: True 9) A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle? Ans: destroy 10) Data analysts use queries to request, retrieve, and update information within a database. Ans: True 11) Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____. Ans: process steps 12) Fill in the blank: A function is a predefined operation, whereas a formula is _____. Ans: a set of instructions used to perform a specified calculation. 13) Fill in the blank: To request, retrieve, and update information in a database, data analysts use a ____. Ans: query 14) Fill in the blank: Structured query language (SQL) enables data analysts to _____ the information in a database. Select all that apply. Ans: The graphical representation of information helps stakeholders understand data insights. Formulas and functions make this possible. Review the section on data visualization tools for a refresher.
LATEST SUBMISSION GRADE 100% Question 1Data analysts choose SQL for which of the following reasons? Select all that apply.
Correct. Data analysts choose SQL because it is a well-known standard in the professional community. SQL can also handle huge amounts of data. Question 2In which of the following situations would a data analyst use spreadsheets instead of SQL? Select all that apply.
Correct. An analyst would choose to use spreadsheets instead of SQL when visually inspecting data or working with a small dataset. Question 3A data analyst creates many new tables in their company’s database. When the project is complete, the analyst wants to remove the tables so they don’t clutter the database. What SQL commands can they use to delete the tables?
Correct. The analyst can use the DROP TABLE IF EXISTS query to delete the tables so they don’t clutter the database. Question 4A data analyst is cleaning customer data for an online retail company. They are working with the following section of a database: The analyst wants to retrieve the first two letters of each state so that all the entries are consistent and only contain 2 letters. What is the correct SQL clause to retrieve the first two letters of each state?
Correct. The correct clause is SUBSTR(state, 1, 2)*.* Question 5A data analyst is cleaning a dataset. They find data entries with extra spaces. What SQL function can the analyst use to eliminate the extra spaces for consistency? Correct. The analyst can use the TRIM function to eliminate the extra spaces for consistency. Question 6In SQL databases, what data type refers to a number that contains a decimal?
Correct. In SQL databases, the float data type refers to a number that contains a decimal. Question 7A data analyst is working with product sales data. They import new data into a database. The database recognizes the data for product price as text strings. What SQL function can the analyst use to convert text strings to floats? Correct. The analyst can use the CAST function to convert text strings to floats. Question 8A data analyst is cleaning survey data. The results for an optional question contain many nulls. What function can the analyst use to eliminate the null values from the results?
Correct. The analyst can use the COALESCE function to eliminate the null values from the results. |