You are performing an outer join between two tables: the Sal…

You are performing an outer join between two tables: the Sales Orders Table which can be considered the ‘left’ table and the Customers Table which can be considered the ‘right’ table.  The join will be performed using the Customer_ID field. The tables have the data shown below. After the outer join has occurred, which of the following statements is true? (check all that apply)

You are performing a join between two tables: the Sales Orde…

You are performing a join between two tables: the Sales Orders Table which can be considered the ‘left’ table and the Customers Table which can considered the ‘right’ table.  The join will be performed using the Customer_ID field. The tables have the data shown below. What will be the total number of rows in the resulting table after performing an inner join between the tables?

As part of some data analysis you are building relationships…

As part of some data analysis you are building relationships among data tables in Tableau based on your client’s business rules.  To help you understand the relationships among data tables your client provides you the following entity relationship diagram (ERD) related to its sales and invoicing process. Given the crows foot notations presented by your client below, which of the following business rule statements is true?