You need to ensure that the aggregations designed on FactSales always include the Month attribute
You create a SQL Server 2008 Analysis Services (SSAS) solution.
The solution has the following components:
A dimension named DimTime that contains an attribute named Month
A measure group named FactSales that references the DimTime dimension
You need to ensure that the aggregations designed on FactSales always include the Month
attribute.
What should you do?
You need to ensure that SSAS can query relational data when multidimensional storage is being updated
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You enable proactive caching for a partition.
You need to ensure that SSAS can query relational data when multidimensional storage is
being updated.
What should you do?
You need to ensure that you can retrieve measure values based on the City and Country attributes
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named DimCustomer that contains the following three attributes:
Customer
City
Country
The Customer attribute is the key. The DimCustomer dimension is related to a measure
group
named Sales that has the Granularity property set to City.
You need to ensure that you can retrieve measure values based on the City and Country
attributes.
What should you do?
You need to ensure that when the Amount measure is calculated against the DimCustomer dimension, the weighted
You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as
shown in the following exhibit. (Click the Exhibit button.)
The Ownership column contains decimal values that represent percentage of ownership.
The sum of all the values in the Ownership column for a single DimAccount member is
100%. You create the following measures:
Ownership
Amount
You need to ensure that when the Amount measure is calculated against the DimCustomer
dimension, the weighted value is calculated based on the Ownership measure.
What should you do?
You need to create a measure that returns the number of customers who have placed orders
You need to ensure that aggregations are not associated with the Price attribute
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named DimProduct that contains an attribute named Price. You use
the DimProduct dimension in a cube.
You need to ensure that aggregations are not associated with the Price attribute.
What should you do?
Which control flow logic should you implement?
You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts
data from flat files and loads this data to a SQL Server 2008 database. The package
contains two Boolean variables named @IsWeekday and @IsHoliday. When the package is
executed on week days, the @IsWeekday variable is set to True. When the package is
executed on holidays, the @IsHoliday variable is set to True. You need to implement the
following business logic in the control flow of the package:
When the ©IsWeekday variable is set to True, the Perform Weekday Processing Data Flow
task is executed.
When the ©IsWeekday variable is set to False, the Perform Weekend Processing Data Flow
task is executed.
When the @IsHoliday variable is set to True, the Perform Holiday Processing Data Flow task
is executed.
Which control flow logic should you implement?
You need to modify the path where the package writes event data to a text file
You develop a SQL Server 2008 Integration Services (SSIS) package.
You need to modify the path where the package writes event data to a text file.
What should you do?
You need to add the custom data flow component to the toolbox
You are editing a SQL Server 2008 Integration Services (SSIS) package by using Business
Intelligence Development Studio. The package uses a custom data flow component. The
package runs successfully.
You attempt to add another instance of the custom data flow component to the package. The
data flow component does not appear in the toolbox or in the Choose Toolbox Items dialog
box.
You need to add the custom data flow component to the toolbox.
What should you do?
What are two possible ways to achieve this goal?
You design a SQL Server 2008 Integration Services (SSIS) data flow that inserts data from a
source query to a destination table.
You need to insert only those rows that do not already exist in the destination table.
What are two possible ways to achieve this goal? (Each correct answer presents a complete
solution. Choose two.)