vmartinez

 

Why is SQL the most popular structured query language? Select all that apply.

 

• SQL allows data analysts to use spreadsheets
• SQL is the most secure database on the market
• SQL is easy to understand
• SQL works with a wide variety of databases

 

 

What does a data analyst use to request information within a database?

 

• Calculation
• Dashboard
• Formula
• Query

 

 

What is the main difference between a formula and a function?

 

• A formula can be used multiple times in a spreadsheet; a function can only be used once.
• A formula begins with an equal sign (=); a function begins with an asterisk (*).
• 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.
• A formula is used to add or subtract; a function is used to multiply or divide.

 

 

Fill in the blank: Data analysis has six process steps whereas the data life cycle has six _____.

 

• data analytics tools
• steps
• stages
• key questions

 

 

A data analyst is working at a small tech startup. On their current project they are in the analyze stage of the data life cycle. What might they do in this stage?

 

• Choose the format of their spreadsheet headings
• Determine who is responsible for managing the data
• Validate the insights provided by analysts
• Use a formula to perform calculations

 

 

A data analyst is working at a small tech startup. They’ve just completed an analysis project, which involved private company information about a new product launch. In order to keep the information safe, the analyst uses secure data-erasure software for the digital files and a shredder for the paper files. Which state of the data life cycle does this describe?

 

• Manage
• Archive
• Destroy
• Plan