Q92.
Technology
Ms. F is to summarize last month’s sales performance in a table, by State (Address_1).
Based on member address, which of the following is an appropriate process to calculate
monthly sales performance by State?
a) 1. Extract the data for last month from the sales performance data, based on “Sales
date.”
2. Sort the extracted sales performance data by “Member_number.”
3. Calculate the total sales of products with the same “Member_number.”
b) 1. Extract the data for last month from the sales performance data, based on “Sales
date.”
2. Using member numbers as the key, join the extracted sales performance data and
the member ledger.
3. Sort the joined information by “Address_1.”
4. Calculate the total sales in units of the same State.
c) 1. Using member numbers as the key, join sales performance data and the member
ledger.
2. Sort the joined information by “Address_1.”
3. Calculate the total sales in units of the same State.
Practice exam 1
d) 1. Using member numbers as the key, join sales performance data and the member
ledger.
2. Sort the joined information by “Member_number.”
3. Calculate the total sales of products with the same “Member_number.”
4. Sort the data by “Address_1.”
5. Calculate the total sales in units of the same State.
334