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 and average class level by student. - 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 multidimensional project and define measures and a reference relationship.
• B. Create a tabular project and define calculated columns.
• C. Create a tabular project and define measures.
• D. Create a multidimensional project and define measures and a many-to-many dimensional relationship.

You need to select the appropriate model type for the Finance database.
Which model type should you select?

• A. Tabular with PowerPivot
• B. Relational
• C. Multidimensional
• D. Star schema

You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an Internet-facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel Services are installed and configured.
You need to upgrade to SSRS 2012 with the minimum downtime and hardware requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Install SSRS 2012 on a new SharePoint farm and migrate content to the new farm.
• B. Migrate SSRS content to a separate instance of SSRS 2012 on the same server.
• C. Perform an in-place upgrade of the SSRS environment.
• D. Migrate SSRS content to new servers that run SSRS 2012.

A company has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube named Sales. Shared data sources exist in SSRS for the relational and SSAS databases. Each company department has its own report writers.
Report writers in the Marketing department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Sales cube. The custom formula will compare time periods across multiple products, categories, and regions.
You have the following requirements:
- Ensure that only Marketing department report writers can access the custom
formula.
- Implement only one dataset.
- Ensure that the dataset references the data source that will provide the fastest
data retrieval.
You need to meet the requirements to support the Marketing department report writers.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Create and secure in the data warehouse a stored procedure that implements the custom formula. Create and deploy a shared dataset that references the data warehouse shared data source.
• B. Create a calculated member in the Sales cube. Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes the calculated member from the cube.
• C. Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes a calculated member for the custom formula.
• D. Create, deploy, and secure a shared dataset that references the data warehouse shared data source and includes custom Transact-SQL (T-SQL) code for the custom formula.

You need to select and configure a tool for the monitoring solution.
What should you choose?

• A. Performance Monitor configured with the MSAS11:Processing counter
• B. SQL Server Profiler configured with the Queries Events: Query Begin event
• C. Performance Monitor configured with the MSAS11:Storage Engine Query counter
• D. SQL Server Profiler configured with the Query Processing: Query Subcube event