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
RevenueData.
Each RevenueData 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?

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
When users browse the dimension, three hierarchies are visible to them.
You need to ensure that the Organization hierarchy is not visible to users.
What should you do?

You are working with a SQL Server Reporting Services (SSRS) instance in native mode.
An item role named Reports Writer is present on the server.
The Reports Writer role cannot view and modify report caching parameters.
You need to ensure that the Reports Writer role can view and modify report caching parameters.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution.
You need to grant permission for salespersons to view only the data based on their sales territory.
What should you do?

You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL
Azure database and an OData data feed.
The model will be deployed to a server with significantly more memory than the total size of the source data.
You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).
The model must meet the following requirements:
– Maximize performance
– Data latency of up to one month is acceptable
You need to choose a project type and a data access mode to meet the requirements.
What should you do?

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 conducting a design review of a multidimensional project.
In the geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the geography dimension supports relationships between attributes.
You need to increase query and dimension processing performance.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model defines a measure named Profit and includes a table named Date.
The table includes year, semester, quarter, month, and date columns.The Date column is of data type Date.
The table contains a set of contiguous dates.
You need to create a measure to report on year-over-year growth of profit.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

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.
The reports will show the relationship between product sales and rainfall over time.
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 SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, queries must be resolved only by using cache.
You need to configure the appropriate query mode.
Which query mode should you select?