You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.The sales department requires the following set of metrics:Unique count of customers -✑ Unique count of products sold✑ Sum of salesYou need to ensure that the cube meets the requirements while optimizing query response time.What should you do? (Each answer presents a complete solution. Choose all that apply.)
DRAG DROP -You are developing reports based on the SQL Server Analysis Services (SSAS) cube named ProcessedOrders.A Multidimensional Expressions (MDX) query must include a query-scoped calculated member, which computes average sales per order item. The query must also return the set of three states in a query-scoped named set named East Coast Customers.You need to define the calculations in an MDX query to meet the requirements.Which four MDX segments should you insert in sequence before a SELECT statement? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
You work in the Business Intelligence (BI) department of a multinational company.The company has requested a new corporate BI solution that meets the following requirements:✑ The solution must use SQL Server Analysis Services (SSAS).✑ The model must incrementally add 10 million fact rows per month.✑ The model must be translated to English, French, or Spanish based on users' locale.✑ The model must be able to contain the most recent 36 months of data.You need to select the appropriate model type and partitioning strategy to meet the requirements.What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM.The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010.You need to ensure the highest query performance and scalability for the accounting department queries.Which project type should you choose?
HOTSPOT -You have a database named DB1. DB1 contains three tables named FactSales, DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table.A sample from DimCustomer is shown in the following table.A sample from FactSales is shown in the following table.You create a cube named Sales that uses the three tables. FactSales is used as a fact table, DimCustomer is used to create a dimension named Customer, andDimEmployee is used to create a dimension named Employee.Users report the following issues:✑ When browsing the Customer dimension, the users see a blank member in the state hierarchy under United Kingdom.✑ When browsing the Employee dimension, the sales data for Sales Managers and Sales Supervisors is NOT displayed.You need to resolve the issues by configuring the properties of the dimension attributes.What should you do? To answer, select the appropriate value for each property in the answer area.Hot Area:
You are creating a table named Orders. You need to ensure that every time a new row is added to the Orders table, a user-defined function is called to validate the row before the row is added to the table.What should you use? More than one answer choice may achieve the goal. Select the BEST answer.
