You need to ensure that the Reports Writer role can vie…
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 need to grant permission for salespersons to view o…
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 need to choose a project type and a data access mod…
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 need to write-enable one of the linked measure grou…
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 need to increase query and dimension processing per…
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 need to create a measure to report on year-over-yea…
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.)
Which project types should you use?
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.)
Which query mode should you select?
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?
You need to temporarily suspend the shared schedule unt…
You manage an environment that has SharePoint Server 2010 and a SQL Server Reporting Services (SSRS)
instance in SharePoint integrated mode.
Several report subscriptions are configured to deliver reports through email by using a shared schedule.
The email server will be going offline.
You need to temporarily suspend the shared schedule until the email server is brought back online.
What should you do?
Which value should you select for the AggregationFuncti…
You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department.
You create a measure group named Exchange Rate that consists of measures pertaining to currency exchange
rates.
One of the measures in this group is named Average Rate and it will be used to report the average currency
exchange rate over time.
Currently the AggregationFunction property for the Average Rate measure is set to Sum.
You need to ensure that Average Rate measure reports the average of the currency exchange rate over time.
Which value should you select for the AggregationFunction property for the Average Rate measure?
To answer, select the appropriate setting in the answer area.