单项选择题
You need to meet the business requirements of the packaging department. What should you do?（）
A.Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Set the order of the ProductSKU attribute to the ProductSizeDescriptor column.
B.Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Set the order of the key attribute of the ProductSize dimension to the ProductSizeDescriptor column.
C.Add the ProductSize data table and the ProductSizeDescriptor column to the Product dimension. Create a user-defined hierarchy that has ProductSKU as the top-level attribute and ProductSizeDescriptor as the bottom-level attribute.
D.Add the ProductSize data table as a dimension and then add this dimension to the cube as a Referenced dimension. Create a user-defined hierarchy within the ProductSize dimension. Set the ProductSizeDescriptor attribute as the top-level attribute.
相关考题
-
单项选择题
YouneedtoensurethatthenewsalesmanagerisabletoviewclientswithinonlytheNorthandSouthregions.Whatshouldyoudo?（）
A.Add a Denied member set for the West clients to NorthRole.
B.Add an Allowed member set for the South clients to NorthRole.
C.Create a new role for the sales manager and add a Denied member set for the South clients.
D.Create a new role for the sales manager and add an Allowed member set for the South clients. Remove the sales manager from SouthAndWestRole. -
单项选择题
YouneedtoselectappropriateprocessingmethodsfortheEmployeeAssignmentmeasuregroupandtheEmployeedimension.Whichmethodshouldyouchoose?（）
A.Run a Process Update against the Employee dimension. Run a Process Full against the EmployeeAssignment measure group.
B.Run a Process Full against the EmployeeAssignment measure group. Run a Process Update against the Employee dimension.
C.Run a Process Full against the Employee dimension. Run a Process Incremental against the EmployeeAssignment measure group.
D.Run a Process Incremental against the EmployeeAssignment measure group. Run a Process Full against the Employee dimension. -
单项选择题
Youneedtomakestructuralchangestothecube.Youalsoneedtoensurethatappropriateaggregationsarecreatedafterthechangesaremade.Whatshouldyoudo?（）
A.Record a weeks user activity by using SQL Profiler. Apply structural changes. Replay the activity and then run the Usage Based Optimization Wizard.
B.Apply structural changes. Run the Database Engine Tuning Advisor.
C.Apply structural changes. Run the Usage Based Optimization Wizard.
D.Record a weeks user activity by using SQL Profiler. Apply structural changes. Run the Database Engine Tuning Advisor.
