DRAG DROP -You are designing a SQL Server Analysis Services (SSAS) data model on a very large data warehouse.The fact tables in the data warehouse contain terabytes of data in tens of billions of rows.You must support the following features:Complex attribute/column relationshipsAdvanced calculations in the data model definitionAdvanced calculations using logic deployed in a custom assemblyYou need to choose the correct SSAS design strategy.What should you do?To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)Select and Place:
You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.For Product A, Projected Revenue is defined as 150 percent of the Total Sales of the product. For all other products, Projected Revenue is defined as 110 percent of the Total Sales of the product.You need to calculate the Projected Revenue as efficiently as possible.Which calculation should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.You have the following requirements:✑ Ensure that queries of the data model correctly display average student age by class.✑ Ensure that the solution supports role-based security and partitions.✑ Minimize development effort.You need to design the data model.What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.The cube includes a Customer dimension that contains a Geography hierarchy and a Gender attribute hierarchy.You need to return only the female customers in the Geography hierarchy.Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
HOTSPOT -You are designing a SQL Server Integration Services (SSIS) package configuration strategy.The package configuration must meet the following requirements:✑ Include multiple properties in a configuration.✑ Force packages to load all settings in the configuration.✑ Support Encrypting File System (EFS) formats.You need to select the appropriate configuration.Which configuration type should you use?To answer, select the appropriate option from the drop-down list in the dialog box.Hot Area:
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.)
