Question 2 in which of the following situations would a data analyst use spreadsheets instead of sql? select all that apply

When working with a dataset with more than 1,000,000 rows

Table of Contents Show

Related Questions & Answers:
Weekly challenge 3
In which of the following situations would a data analyst use spreadsheets instead of SQL Select all that apply 1 point?
Which of the following tasks can data analysts do using both spreadsheets and SQL Select all that apply?
Which of the following SQL functions can data analysts use to clean string variables select all that apply 1 point?
What are the most common processes and procedures handled by data engineers select all that apply?

When visually inspecting data ✓

Correct
An analyst would choose to use spreadsheets instead of SQL when visually inspecting data or working with a small dataset.

When using a language to interact with multiple database programs

When working with a small dataset ✓

Correct
An analyst would choose to use spreadsheets instead of SQL when visually inspecting data or working with a small dataset.

Data analysis is the various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data. 1.Data analysis is the various elements that interact with one another in order to provide, manage, store, organize, analyze, and ... Read more...
Structured query language (SQL) enables data analysts to communicate with a database. 8.Structured query language (SQL) enables data analysts to communicate with a database. 1 / 1 point True ✓ False CorrectSQL allows ... Read more...
If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B? 3.If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they ... Read more...
A doctor’s office discovers that patients are waiting 20 minutes longer for their appointments than in past years. In what ways could a data analyst help solve this problem? Select all that apply. 2.A doctor’s office discovers that patients are waiting 20 minutes longer for their appointments than in past years. In what ... Read more...
A data analyst creates data visualizations and a slideshow. Which phase of the data analysis process does this describe? 2. A data analyst creates data visualizations and a slideshow. Which phase of the data analysis process does this describe? ... Read more...
Fill in the blank: Return on investment compares the _____ of an investment to the net profit gained from that investment. 7. Fill in the blank: Return on investment compares the _____ of an investment to the net profit gained from ... Read more...

When working with a huge amount of data ✓

Correct
A data analyst would use SQL instead of a spreadsheet to work with a huge amount of data. SQL can also quickly pull information from many different sources in a database and record queries and changes throughout a project.

When using the COUNTIF function to find a specific piece of information

When recording queries and changes throughout a project ✓

Correct
A data analyst would use SQL instead of a spreadsheet to work with a huge amount of data. SQL can also quickly pull information from many different sources in a database and record queries and changes throughout a project.

When quickly pulling information from many different sources in a database ✓

Correct
A data analyst would use SQL instead of a spreadsheet to work with a huge amount of data. SQL can also quickly pull information from many different sources in a database and record queries and changes throughout a project.

Weekly challenge 3

LATEST SUBMISSION GRADE 100%

Question 1

Data analysts choose SQL for which of the following reasons? Select all that apply.

SQL is a well-known standard in the professional community
SQL can handle huge amounts of data
SQL is a powerful software program
SQL is a programming language that can also create web apps

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 2

In which of the following situations would a data analyst use spreadsheets instead of SQL? Select all that apply.

When using a language to interact with multiple database programs
When working with a small dataset
When working with a dataset with more than 1,000,000 rows
When visually inspecting data

Correct. An analyst would choose to use spreadsheets instead of SQL when visually inspecting data or working with a small dataset.

Question 3

A 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?

DROP TABLE IF EXISTS
INSERT INTO
CREATE TABLE IF NOT EXISTS
UPDATE

Correct. The analyst can use the DROP TABLE IF EXISTS query to delete the tables so they don’t clutter the database.

Question 4

A 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?

DISTINCT(state, 1, 2)
SUBSTR(state, 1, 2)
WHERE(state, 1, 2)
LENGTH(state, 1, 2)

Correct. The correct clause is SUBSTR(state, 1, 2)*.*

Question 5

A 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?

SUBSTR
CAST
TRIM
LENGTH

Correct. The analyst can use the TRIM function to eliminate the extra spaces for consistency.

Question 6

In SQL databases, what data type refers to a number that contains a decimal?

Integer
Boolean
String
Float

Correct. In SQL databases, the float data type refers to a number that contains a decimal.

Question 7

A 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?

TRIM
CAST
SUBSTR
LENGTH

Correct. The analyst can use the CAST function to convert text strings to floats.

Question 8

A 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?

CONCAT
COALESCE
CAST
LENGTH

Correct. The analyst can use the COALESCE function to eliminate the null values from the results.

🗂️ Page Index for this GitHub Wiki

In which of the following situations would a data analyst use spreadsheets instead of SQL Select all that apply 1 point?

Correct. An analyst would choose to use spreadsheets instead of SQL when visually inspecting data or working with a small dataset.

Which of the following tasks can data analysts do using both spreadsheets and SQL Select all that apply?

Which of the following tasks can data analysts do using both spreadsheets and SQL? Select all that apply. Correct. Analysts can use SQL and spreadsheets to perform arithmetic, use formulas, and join data.

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

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

What are the most common processes and procedures handled by data engineers select all that apply?

What are the most common processes and procedures handled by data engineers? Select all that apply. Correct. Data engineers transform data into a useful format for analysis; give it a reliable infrastructure; and develop, maintain, and test databases and related systems.

Question 2 in which of the following situations would a data analyst use spreadsheets instead of sql? select all that apply