Question 2 which of the following tasks can data analysts do using both spreadsheets and sql? select all that apply.

Consider where the data came from ✓

Correct
To add context to their data, data analysts ask questions about the data, consider where it came from, and use descriptive column headers.

 Create reports for stakeholders

 Ask questions about the data ✓

Correct
To add context to their data, data analysts ask questions about the data, consider where it came from, and use descriptive column headers.

 Use descriptive column headers ✓

Correct
To add context to their data, data analysts ask questions about the data, consider where it came from, and use descriptive column headers.

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.

What are the advantages of learning and using standard SQL Select all that apply?

With Standard SQL, complex queries can be started not only with SELECT but also with WITH, making code easier to read, comment, and understand. This also means it's easier to prevent your own and correct others' mistakes.

Which of the following SQL functions can data analysts use to clean string variables select all that apply?

Correct. Data analysts can use the SUBSTR and TRIM functions to clean string variables.

What do data analysts use SQL for?

Data Analysts use SQL to manipulate the data, understand the data, and access, read and analyze the data before storing it in the database.