HOTSPOT
You are developing a data flow to load sales data into a fact table. In the data flow, you
configure a Lookup Transformation in full cache mode to look up the product data for the
sale.
The lookup source for the product data is contained in two tables.
You need to set the data source for the lookup to be a query that combines the two tables.
Which page of the Lookup Transformation Editor should you select to configure the query?
To answer, select the appropriate page in the answer area.
Answer: 
Explanation:
http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/ms189697.aspx
Someone somewhere else mentioned the Advanced tab since there is a sql command there as well. This is why that is not the answer. The query in the advanced tab is for partial cache lookups only. The difference between that and the query in the connection tab is that the latter is not and can not be parameterized because the lookup transform loads the entire result of the query into the cache during preexecution before the parameters might even resolve.
The given answer is correct. Connection