You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy.You need to return only the blue products in the Category hierarchy. Which set should you use? (More than one answer choice may achieve the goal. Select theBEST answer.)
An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements:✑ Implement drill-down browsing.✑ Reduce the number of attribute hierarchies but ensure that the information contained within them is available to users on demand.✑ Optimize performance.You need to redesign the cube dimension to meet the requirements.What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
HOTSPOT -You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named Category is based on the DimCategory table.A subset of the data source view is shown in the following graphic.You need to relate the Category dimension to the Sales measure group.Which relationship type should you choose?To answer, select the appropriate option from the drop-down list in the dialog box.Hot Area:
You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse.Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business hours. Most queries against the database are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level.
A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day.You have the following requirements:✑ Ensure that the cube displays current data as quickly as possible.✑ Maximize availability of the cube.✑ Maximize query performance for all aggregation levels.You need to choose a partitioning strategy that meets the requirements.Which partitioning strategy should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)
You administer a SQL Server Reporting Services (SSRS) instance in native mode.You need to assign a predefined role that meets the following requirements:✑ Members of the role must be able to update shared data sources.✑ Members of the role must not be able to consume reports or manage subscriptions.✑ The role must provide only the minimum permissions required.Which role should you assign? (More than one answer choice may achieve the goal. Select the BEST answer.)
