You need to create the calculation for Salesperson Name.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
A . Create a computed column in the data warehouse’s Dim Salesperson table. Include the column in the Sales Reporting model’s Salesperson table.
B . Modify the data warehouse’s Dim Salesperson table and add a new column. Use an UPDATE statement to populate the new column with values. Update the SSIS package developed to populate the data warehouse’s Dim Salesperson table to use a Derived Column transformation to produce the calculation.
C . Configure the Sales Reporting model’s Salesperson table properties to be based on a query. Define a derived column in the query.
D . Add a calculated column to the Sales Reporting model’s Salesperson table by using the Data Analysis Expressions (DAX) language CONCATENATE function.
E . Create a view in the data warehouse that defines a derived column based on the DimSalesperson table. Base the Sales Reporting model’s Salesperson table on the view. Include the column in the Sales Reporting model’s Salesperson table.
F . Add a calculated column to the Sales Reporting model’s Salesperson table by using the Data Analysis Expressions (DAX) language ADDCOLUMNS function.
Answer: B, E
Leave a Reply