You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group.
Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?

You are developing a SQL Server Analysis Services (SSAS) multidimensional database. The underlying data source does not have a time dimension table.
You need to implement a time dimension.
What should you do?

You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data
warehouse. The following diagram illustrates the table design.

The Organization dimension includes a parent-child hierarchy named Organizations. The dimension includes the following dimension attributes:
– Organization, which is a key attribute
– Organizations, which defines the parent-child hierarchy
– Currency Code, which is a regular attribute
– PercentageOfOwnership, which is a regular attribute
When users browse the dimension, four hierarchies are visible to them.
You need to ensure that the Organization and PercentageOfOwnership hierarchies are not visible to users.
What should you do?

You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the SalesAmount measure is four digits. You need to ensure that the SalesAmount measure stores values to two
digits of precision.
What should you do?

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data
relationships will not change. The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model
will be deployed to a server with 28 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be
queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?

You work in the Business Intelligence (BI) department of a multinational company.
The company has requested a new corporate BI solution that meets the following requirements:
·The solution must use SQL Server Analysis Services (SSAS).
·The model must incrementally add 10 million fact rows per month.

·The model must be translated to English, French, or Spanish based on users’ locale.
·The model must be able to contain the most recent 36 months of data.
You need to select the appropriate model type and partitioning strategy to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department requires the following set of metrics:
– Unique count of customers
– Unique count of products sold
– Sum of sales
You need to ensure that the cube meets the requirements while optimizing query response time.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

You are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group
named Salary at the month granularity level.
What should you do?

You are designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?