You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and you are in charge of a
SQL
Server 2008
Integration Services (SSIS) instance.
The SSIS instance has the packages stored in a SQL Server 2008 instance while another
SSIS instance had its packages stored in a shared directory.
According to the order of your manager, you need to deploy the package from the SSIS
instance to another
SSIS instance.
In order to achieve this goal, which command should be executed?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as a developer of a SQL Server 2008
Integration Services (SSIS) for the company. To meet the business requirements, SSIS
should be used on a SQL Server 2008 failover cluster. There is a complex package on your
server and it needs a long time to start it. Now your manager asks you to make sure that the

package can be resumed when it fails to execute the failover. What action should you
perform?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as a developer of a SQL Server 2008

Integration Services (SSIS) for the company. To meet the business requirement, you use the
SSIS to develop a package and use your local development environment to test the
package. Then the package is deployed to the file system in the production environment.
After the deployment, the users notice that the package contains no connection strings,
which means the package gets a failure of the deployment. Now you are assigned a task to
make sure that the package can be viewed and executed by changing the protection level of
the package. So of the protection levels of the package, which one would be used?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server
2008 Reporting Services (SSRS) for the company.
To meet the business requirement, you develop a SSRS report with a parameter named
@ProductPriceRangeID.
Then you select a specific region to set the value of @ProductPriceRangeID in the report.
In order to stop modifying the value of @ProductPriceRangeID, you have to configure the
report.
So of the methods below, which one would be used to configure the report?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as a developer of a SQL Server 2008
Reporting Services (SSRS) report for the company.
A parameter named Kind is contained in your developed report and you use it to filter a list of
Sales.
Besides, the list uses a dataset, which includes the queries of SELECT p.SalesID, p.Place,
p.ListName, FROM SalesAmount.Sales AS p
WHERE p.Kind = @Kind.
To meet the business requirements, the report parameter is modified to allow multiple
values.
Now you are asked to modify the report to help search for multiple Kind values and minimize
the development effort.
What action should be performed to achieve the goal above?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) instance.
Now you get an e-mail from your company CIO, in the e-mail he wants you to run the UsageBased Optimization Wizard.

You have to enable query logging. What action should you perform?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as a developer of a SQL Server 2008
Reporting Services (SSRS) for the company. You use SSRS to design a report. A Windows
Forms application is distributed to remote users and it contains the report, but the report
server cannot be accessed by these remote users. Now you are asked to make sure that the
report can be rendered by the application correctly. Of the following methods, which one
would be used to accomplish this task?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as a developer of a SQL Server 2008
Reporting Services (SSRS) for the company. You use SSRS to design a report with a
dataset contained and a Table data region used. Besides, a column named FirstPicture is
contained in the dataset. Now you get an order from your company CIO, according to his
requirement, you need to make sure that the second character in the FirstPicture column
makes group for the report items. Which option below would be chosen?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.

Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server 2008 Reporting Services (SSRS) for the company.
You use SSRS to create a report with a table contained.
Besides, the table contains alternate columns.
Now you get an order from your company CIO, according to his requirement, you have to
make sure the alternate columns have a light blue background.
So of the following code segments, which one would be used for each text box?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of
a SQL Server 2008 Reporting Services (SSRS) for the company.
To meet the business requirements, you use SSRS to develop a production report with a
table contained.
Now you get an order from your company CIO, according to his requirement, when users
click on a field in the table, a SSRS technology should be executed to open a new report for
them.
Which SSRS technology should be used to achieve this goal?