QUESTION 17You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube.Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including FirstServiceDate, SecondServiceDate, and ThirdServiceDate.You need to ensure that users can slice the Service Quality measures by FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized.What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Create cube dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate by using the existing date dimension in the database.B. Create three independent dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate and then link all three of them to the Service Quality measure group.C. Create three new perspectives named FirstServiceDate. SecondServiceDate, and ThirdServiceDate.D. Add three attributes named FirstServiceDate. SecondServiceDate, and ThirdServiceDate to the existing date dimension in the database.

Answer: A

QUESTION 18You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, the queries must be resolved by using cache unless otherwise specified in the connection string. You need to configure the appropriate query mode. Which query mode should you select?

QUESTION 19You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products.The Invoice Line Items table has the following columns:– Product Id– Unit Sales PriceThe Unit Sales Price column stores the unit price of the product sold. The Products table has the following columns:– Product Id– Minimum Sales PriceThe Minimum Sales Price column is available only in the Products table. You add a column named Is Undersell to the Invoice Line Items table. The Is Undersell column must store a value of TRUE if the value of the Unit Sales Price is less than the value of the Minimum Sales Price. Otherwise, a value of FALSE must be stored. You need to define the Data Analysis Expressions (DAX) expression for the Is Undersell column. Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)

Answer: ACExplanation:A: RELATED FunctionReturns a related value from another table.– The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table.C:The lookupvalue function returns the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value.Syntax:LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…)Note:The syntax of DAX formulas is very similar to that of Excel formulas, and uses a combination of functions, operators, and values.

QUESTION 20You are developing a SQL Server Analysis Services (SSAS) tabular project. The model includes a table named Sales. The Sales table includes a single date column. The Sales table must meet the following requirements:– Queries must be able to return all rows.– Must be able to support four different processing schedules for different date ranges.– Date ranges must not include any overlapping data. You need to implement a solution that meets the requirements. What should you do?

A. Create four partitions for the Sales table. Use row filter queries for each partition.B. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.C. Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.D. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.

Answer: A

QUESTION 21Drag and Drop QuestionsYou have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2014. You need to import an existing PowerPivot workbook to create a tabular project. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Answer: Explanation:– To create a new tabular model project from a PowerPivot for Excel file– When creating a new tabular model project by importing from a PowerPivot workbook, the metadata that defines the structure of the workbook is used to create and define the structure of the tabular model project in SQL Server Data Tools. Objects such as tables, columns, measures, and relationships are retained and will appear in the tabular model project as they are in the PowerPivot workbook.– Analysis Services provides three different approaches for creating a business intelligence semantic model: tabular, multidimensional, and PowerPivot. Tabular solutions use relational modeling constructs such as tables and relationships for modeling data, and the xVelocity inmemory analytics engine for storing and calculating dataReference: Import from PowerPivot (SSAS Tabular)

QUESTION 22Drag and Drop QuestionsYou have a database named DB1. DB1 contains four tables named FactSales, DimTime, 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 need to identify which type of dimension must be created for each table.Which type of dimension should you create for each table? To answer, drag the appropriate dimensions to the correct tables. Each dimension may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.Answer: