Coursera Google Data Analytics Professional Process Data from Dirty to Clean (Week 3) Quiz Answer-Cleaning data with SQL.

 

Recommended Courses:

1. Coursera: Machine Learning
2. Google Data Analytics Professional Certificate.

 3.Cleaning data with SQL.

Question 1

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

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

Data analysts choose SQL because it can handle huge amounts of data. SQL is also a well-known standard in the professional community.

 

Question 2

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

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

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?

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

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 find out if the state data is consistent and if any text strings contain more than two characters. What is the correct SQL clause to use to find any text strings containing more than two characters?

• WHERE(state) > 2
• DISTINCT(state) > 2
• SUBSTR(state) > 2
• LENGTH(state) > 2

The correct LENGTH statement is LENGTH(state) > 2.

 

Question 5

Fill in the blank: The _____ function counts the number of characters a string contains.

• SUBSTR
• CAST
• LENGTH
• TRIM

The LENGTH function counts the number of characters the string contains.

 

Question 6

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

• Integer
• String
• Boolean
• Float

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

 

Question 7

Fill in the blank: In SQL databases, the _____ function can be used to convert data from one datatype to another.

• TRIM
• LENGTH
• SUBSTR
• CAST

The CAST function can be used to convert data from one datatype to another.

 

Question 8

Fill in the blank: The _____ function can be used to return non-null values in a list.

• CONCAT
• TRIM
• COALESCE
• CAST

The COALESCE function can be used to return non-null values in a list.

• 一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一

                         Machine Learning Coursera-All weeks solutions [Assignment + Quiz]   click here

                                                                                &

                         Coursera Google Data Analytics Professional Quiz Answers   click here

Have no concerns to ask doubts in the comment section. I will give my best to answer it.

If you find this helpful kindly comment and share the post.

This is the simplest way to encourage me to keep doing such work.

Thanks & Regards,

- Wolf