You need to increase the value of the SalesAmount measure by 50% for each month in the first quarter of 2007
You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has the
following components:
A hierarchy named Date in a time dimension named DimTime
A measure named SalesAmount
You add the following code segment to the calculation script of the cube. (Line numbers are
included for reference only.)
01 . . .
02 Freeze([Measures].[SalesAmount],
03 [DimTime].[Date].[Quarter].[Q1 2007]);
04 . . .
You need to increase the value of the SalesAmount measure by 50% for each month in the
first quarter of 2007.
You also need to ensure that the value for the first quarter of 2007 remains unchanged.
What should you do?
You need to ensure that the state names are sorted first by the country name and then by the state name
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named Customer. The Customer dimension has the attributes
named Country and State.
The Country attribute has the following components:
The KeyColumn property is set to the country code.
The NameColumn property is set to the country name.
You create an attribute relation between the Country attribute and the State attribute.
You need to ensure that the state names are sorted first by the country name and then by
the state name.
What should you do?
You need to create an application that will represent the relationship between managers and employees
You need to create an application that will represent the relationship between managers
and employees. You must achieve this goal by using the minimum amount of tables. What
should you do?
You need to create a referenced dimension that allows you to browse the measures of the FactSales table by usi
You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server
2008.
You create the dimensions as shown in the following table.
The CustKey attribute is used as a column in a table named FactSales.
You need to create a referenced dimension that allows you to browse the measures of the
FactSales table by using the DimGeography dimension.
What should you do?
What should you create for each application?
You develop a Microsoft SQL Server 2012 database. The database is used by two web applications
that access a table named Products.
You want to create an object that will prevent the applications from accessing the table directly
while still providing access to the required data.
You need to ensure that the following requirements are met:
Future modifications to the table definition will not affect the applications’ ability to access data.
The new object can accommodate data retrieval and data modification.
You need to achieve this goal by using the minimum amount of changes to the existing applications.
What should you create for each application?
You need to correlate the operating system performance data with the actual query execution trace by using min
You administer a SQL Server 2008 instance. Customers report server performance
degradation because of a newly implemented process. You use Dynamic Management
Views to verify that there are no long running queries. You need to correlate the operating
system performance data with the actual query execution trace by using minimum
administrative effort. What should you do?
You need to define the relationship between the employees and their manager in the DSV
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You add a data source view (DSV) to the solution. The DSV has a table named Employee
that includes the following columns:
EmployeeKey
ManagerKey
The ManagerKey column references the manager of the employees.
You need to define the relationship between the employees and their manager in the DSV.
What should you do?
You need to ensure that the DimTime dimension can be used to browse through measures in the FactSales table fo
You create a SQL Server 2008 Analysis Services (SSAS) solution.
The solution contains a time dimension named DimTime. You have a table named FactSales
that contains the two columns named OrderDate and ShipDate. The two columns refer to the
DimTime dimension.
You need to ensure that the DimTime dimension can be used to browse through measures
in the
FactSales table for both OrderDate and ShipDate.
What should you do?
Which is the correct answer?
You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com.
The SSIS package must contain six Data Flow tasks and three Control Flow tasks.
You should alter the package .Which is the correct answer?
Which collector should you use?
You administer a SQL Server 2008 instance. The instance is using a 32-bit version on a
Windows Server 2008 64-bit server. The awe enabled option is enabled. The instance will
experience a predictable increase in query activity. You plan to ascertain the appropriate
time when the migration of the databases to a 64-bit SQL Server 2008 server on the same
hardware is beneficial. You need to identify a data collector type that provides the
appropriate information. Which collector should you use?