Question 1Fill in the blank: To combine rows from two or more tables based on a _____ column, data professionals use the SQL JOIN clause.1 point

Which SQL statement is used to combine rows from two or more tables based on a related column between them?CONCATENATEMERGEUNIONJOIN

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.

Nonceba, who is your colleague, asked you to show her how to combine two or more tables through common data attributes to form a new table by using the unique data attributes amongst these tables. Nonceba’s request involves ________. A. linking B. projecting C. selecting D. joining

Question 20When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?1 pointLEFTRIGHTINNEROUTER

Combining Tables of DataTo create new columns from matching rows in a related table, which of Power Query’s functions would you use?Keep RowsJoin TablesAppend tablesMerge tables