You are developing a SQL Server 2008 Reporting Services (SSRS) instance of report model
for Company. com.
In the Report Builder tool, the users should need to create their SSRS reports.
The data source they used will include a Microsoft SQL Server 2008 database. Which
include 1000 tables?
You should design the report model for users, and allow access to only the 20 tables which
they require for reporting. Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database for
Company.com.
A sales manager called Clerk is responsible for the sales of bikes in the Northeast region.
You decide to give some rights to the rights to Clerk to visit the database. You won two roles
below called Northeast Region and Bikes.
Their schemas are listed below:
You have make The Visual Totals properties attribute true for roles above.
You should make sure that Clerk could browser the workers in the Product dimension which
link to the Bikes category in the Northeast region.
Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a
Sale dimension that includes the Category and Subcategory properties for Company.com.

There is a rigid relationship type for properties.
The data source for the Sale dimension alters the relationship between the Type and Sub
Type values.
You should make sure that you could run an XML to operate the dimension to reflect the
change normally for Analysis (XMLA).
Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) instance for
Company.com.
In order to execute the Usage-Based Optimization Wizard you should make query logging
enable.
Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database for
Company.com.
You get the Duplicate Key error when you operate the Analysis Services database.
You should alter the ErrorConfiguration attribute in order to make processing run normally.
Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database for
Company.com.
In order to update data in a partition each hour you should run the incremental processing
method.
In order to solve the problem, which is the correct answer?

You are developing a SQL Server 2008 Reporting Services (SSRS) report for
Company.com.
Assembly should be created in order to run real-time lookup and currency conversion.
The assembly has a static class named daily which lives in the namespace HomeCalc. there
is a
method called DMO which need two arguments, Cuurnt and HomeCalc
When the report is operating, you should reference the ToEUR method in an expression to
convert USD to USO.
Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) instance which includes a
database for Company.com.
You alter the DataDir attribute of the instance to a new folder.
You should make sure that instance utilizes the new folder in least time.
Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a
dimension called Product for Company.com.
You should set the Dimension Data configurations as following:
Deny access to the {[ Product].[Country].[USA],[ Product].[Country].[China]} configure of
property workers.
New workers increased to the property are seen by default. Which is the correct answer?

You are creating SQL Server 2008 Integration Services (SSIS) packages which is stored in a
folder on the network for Company.com.
All members of the team can view the packages but not the attribute values.
Your task is to make the attribute values be protected by password.
Which is the correct answer below?