Hello! I am currently taking a course on Watson Analytics and was wondering if a

Question

Hello! I am currently taking a course on Watson Analytics and was wondering if anyone could help me with this question.

The question is part of the DATA section of the course.

REVIEW QUESTION 2 point possible Which of the following statements are true regarding joining data sets prior to upload? When joining data sets, you can choose which table will be the base table in the join, by selecting it prior to clicking Join data sets. When choosing which columns will be used to join two tables, you can choose any column from either table When choosing the join criteria, the Matching rows option results in a full outer join returning rows only where the value for the join key matches when choosing the join criteria, the All rows option results in a full outer join returning all rows from the 1st and 2nd tables. FINAL CHECK SAVE You have used 1 of 2 submissions

Explanation / Answer

Answer:

when joining data sets, you can choose which table will be the base table in the joint, by selecting it prior to clicking join data sets - True, ie., when joining the data sets, the tables will be chosen inorder to perform joining the data sets.

when choosing which columns will be used to join two tables, you can choose any columns from either table - False, because, while joining two tables, only the columns that are said to be common whill be chosen for joining.

when choosing the join criteria the matching rows option results in a full outer join returning rows only where the value for the join key matches - False, because full outer join result in returning all the rows from both the tables, enethough they do not have matches in both the tables.

when choosing the join criteria, the All rows option result in a full outer join returning all from the 1st and 2nd tables - True, Eventhough there is no matches in the both the lst and 2nd, all the rows will be returned as a result the full outer join.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.