Microsoft-TS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Set 2

You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) solution. The SSAS solution contains a table named CKFact that includes two fields. The diagram below illustrates the fields in CKFact: You need to develop a measure that will display the amount of users who owns placed orders. What should you do?

You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database. You are in the process of creating a new measure group in a cube. Abc.com has an application that keeps the partitions on the production copy of the cube. You need to obtain the cube definition on the production server while ensuring that you do not overwrite any existed partitions. What should you do?

You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) method for Abc.com. The cube structure is illustrated below: The total value in the Ownership column is 100% for one Account member and the Ownership column includes decimal values which stand for percentage of ownership. You develop the measures named Ownership and Number. You need to ensure that the weighted value is computed according to the Ownership measure when you are computing against the Customer dimension. What should you do?

You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. Your solution contains a data source view (DSV) that owns a table named CKUsers. The CKUsers table contains a field named UserKey and a field named ManagerKey. The ManagerKey references the manager of the Abc.com user. You need to create a relationship between the users and their managers in the DSV. What should you do?

You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. CubeA has a time dimension named CKTime that has an attribute named Month and a fact table named FactUsersTable. You need to include different hierarchies in the CKTime dimension. What should you do?

You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. You create a cube that uses a dimension named DimCKUsers. The dimension has a property named User. Abc.com also hosts a Microsoft SQL Server 2008 Reporting Services (SSRS) project that includes a report on a user. You need to determine a way to browse the data. What should you do?

You work as a database administrator for Abc.com. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. The SSAS solution contains a key performance indicator (KPI) named PerKey. You configure the Value expression of the KPI to the following: [Measures].[Amount],[Account].[Accounts].[Operating Expenses]/[Measures].[Amount],[Account].[Accounts]. [Gross Margin] The SSAS solution also contains a time dimension named CKTime. The Multidimensional Expressions (MDX) statement is as follows: 21 Iif( 23 ParallelPeriod1 24 ([CKTime].[Calendar].[Quarter],1,[CKTime].[Calendar].CurrentMember 25)), 2, -10) You need to display a difference in the values compared to the previous quarter. You thus need to configure a Trend expression of the KPI that will accomplish this. What should you do?

You work as a database administrator for Abc.com. You are currently running a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. The SSAS solution contains data mining extensions (DMX) to query a data mining model. The code below is used to query the following Abc data mining model in a CKDecision data mining structure: 11 SELECT 12 [CKDecision].[Abc] AS Product 13 FROM 14 [CKDecision] 16 (SELECT 34 AS [ID], 17 '$2.50' AS [Price], 18 '1' AS [Quantity], 19 1 AS [inSock], 20 2 AS [onOrder]) AS t You need to ensure that the input fields map to the fields in the data mining structure. What should you do?

You work as a database administrator for Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) instance for Abc.com. You need to deploy a data mining structure that contains the Microsoft Clustering mining model from Scalable K-Means to Non-scalable K-Means. What should you do?

You work as a database administrator for Abc.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. You need to scrutinize different data mining theories. You have to modify the design of the data mining structure to test. You decide to add the ordered content type columns in the data mining model as well as the underlying case table. You need to ensure that the Data Mining Viewer is suitable for modification in the data mining structure as well as the data mining model technology. What should you do?