Transform Data - Merging DataWhen merging two queries, what is a common issue with our data structure that can result in an error?Review LaterThe columns used to merge the tables have a different data typeThe columns cannot have any special charactersThe column values must be numericThe tables need a many to many relationship

Question 1What is one of the common structural transformations used for combining data from one or more tables? 1 pointCleaningDenormalization Normalization Joins

What are some other kinds of data you could combine using CONCAT or CONCATENATE?What happens if a data analyst tries to work with dates or names that haven’t been combined with CONCAT or CONCATENATE?1 point

Declare the columns with the right data type for each.

n which two cases would you use the USING clause? (Choose two)Select one or more:a.The tables to be joined have multiple NULL columns.b.The tables to be joined have columns with the same name and compatible data types.c.The tables to be joined have columns of the same name and different data types.d.You want to create a nonequijoin.

Question 1What are the requirements in order for data to be reliable? (Select all that apply) 1 pointData should be relevant Data should be free of all errors  Data should be easy to collect  Data should be structured