A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting.
A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RetailSales. Each RetailSales database stores data only for the continent in which it resides. All of the SSAS instances are configured identically. The cube names and objects are identical.
Reports must meet the following requirements:
A report parameter named ServerName must be defined in each report.
When running a report, users must be prompted to select a server instance.
The report data source must use the Microsoft SQL Server Analysis Services data
source type.
---
You need to create a data source to meet the requirements.
How should you define the expression that is assigned to the connection string property of the data source?

• A. ="Server=@ServerName;Initial Catalog=RevenueData"
• B. ="Server=" &Parameters!ServerName.Value& ";Initial Catalog=RevenueData"
• C. ="Data Source=" &Parameters!ServerName.Value& ";Initial Catalog=RevenueData"
• D. ="Server=" & Parameters!ServerName.Value
• E. ="Data Source=@ServerName;Initial Catalog=RevenueData"

You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.

You have the following requirements:
- Ensure that queries of the data model correctly display average student age by
class.
- Ensure that the solution supports role-based security and partitions.
- Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Create a tabular project and define measures. Create partitions in SQL Server Data Tools (SSDT).
• B. Create a tabular project and define calculated columns. Create partitions in SQL Server Management Studio (SSMS).
• C. Create a multidimensional project and define measures and a many-to-many dimensional relationship. Create partitions in SQL Server Management Studio (SSMS).
• D. Create a multidimensional project and define measures and a reference relationship. Create partitions in SQL Server Data Tools (SSDT).

You are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
---
Dates
Delivery dates
Ship dates
You need to implement the minimum number of required SSAS objects.
What should you do?

• A. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• B. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• C. Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
• D. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• E. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• F. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• G. Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• H. Create a dimension with one attribute hierarchy. Set the XsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• I. Create several dimensions. Add each dimension to the cube.
• J. Add a measure that uses the Count aggregate function to an existing measure group.
• K. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• L. Use the Business Intelligence Wizard to define dimension intelligence.
• M. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• N. Use role playing dimensions.
• O. Create a dimension. Then add a cube dimension and link it several times to the measure group.

You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading.
The production environment includes SSIS 2012 and SSIS 2008. The environment includes existing command shell scripts that invoke the dtutil command-line utility.
You need to design a deployment strategy that supports existing deployment strategies and requires the minimum amount of effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Use a project deployment model. Use the Integration Services Deployment Wizard.
• B. Use a package deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.
• C. Use a project deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.
• D. Use a package deployment model. Use the Integration Services Deployment Wizard.

You are creating a product dimension table and a SQL Server Integration Services (SSIS)
package that will load the table.
You need to keep a history in the table of changes to the names of products.
Which three actions should you perform? Each correct answer presents part of the solution.

• A. Create an end date column in the table.
• B. Add a Slowly Changing Dimension transformation to the package.
• C. Enable Change Data Capture for the table.
• D. From the Slowly Changing Dimension Wizard, set the name column to Type 3.
• E. Create an inferred member column in the table.
• F. Create a start date column in the table.