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 receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you. You use SQL Server 2008 Reporting Services (SSRS) to create a solution.

There is a dimension named Number and a time dimension named Day.
A column named PresentBalance is contained in a fact table. PresentBalance contains the current account balance.
A measure named NumberBalance has to be created from the PresentBalance column.

The NumberBalance is used to display the closing account balance for a time period. So what action should you perform?

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. According to the requirement of the company CIO, you design a SQL Server 2008 Integration Services (SSIS) data flow.

The data flow inserts data from a source query to a destination table. But now you must make sure that only those rows that do not already exist in the destination table are inserted. So what should you do to accomplish this task? (choose more than one)

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.
According to the requirement of the company CIO, you use SQL Server 2008 Integration Services (SSIS) to create a package.

The exhibit below shows the structure of the package. You have to define a variable. The variable contains sensitive information that can only be accessed by the Sequence Container, the Data Flow Task, and the Execute SQL Task.

What action should you perform? (Exhibit)

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.

According to the requirement of the company CIO, you are using Business Intelligence Development Studio to edit a SQL Server 2008 Integration Services (SSIS) package.
A custom data flow component is used by the package which runs successfully.
You try to add another instance of the custom data flow component to the package, but you find that the data flow component does not appear in the toolbox or in the Choose Toolbox Items dialog box.

You have to solve this problem. So what should you do to successfully add the custom data flow component to the toolbox?

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) database.
The database has a dimension which is named Client.

Now your company manager assigns a task to you.
You are asked to perform the configuration on the Dimension Data settings, after the configuration, the two requirements below must be met:
* First, new members added to the attribute must be visible by default;
* Second, deny access to the {[Customer].[Country].[Germany],[Customer].[Country].[France]} set of attribute members.

So what action should you perform?

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.
According to the requirement of the company CIO, you are using SQL Server 2008 Integration Services (SSIS) to create packages.
The package connects to a third-party database server by using an OLE DB connection manager.
Integrated Windows authentication is not supported by the database.

A configuration file is created to configure the connection manager. The configuration file is added to the package after it is created.
An error message pops up when the package executes.

The error message says that the login step fails. Now you must solve this problem.

So what should you do to successfully execute the package?

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 Reporting Services (SSRS) instance.

Some reports are included in the instance. The reports access data from a SQL Server 2008 instance by using stored credentials. There is a computer which contains an instance.

The computer experiences hardware failure, after it recovers, you install a new SSRS instance on it.

Now you must make sure that the reports hosted on the instance can still function correctly. So what action should you perform?

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 responsible for the security in SQL Server 2008 Reporting Services (SSRS).

There is a folder named Supervision Reports in the report server. Reports in any folder can be viewed and modified by all groups.

Now you receive an e-mail from the company CIO, according to his requirement, only the Managers group is allowed to view and modify reports in the Supervision Reports folder.

The company assigns this task to you. So what action should you perform to make sure of this?

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.

There is a SQL Server 2008 Reporting Services (SSRS) instance. Now you are in charge of a report in this instance.
Query parameters are contained in this report which queries the data source at random. Users are allowed to filter the contents of the report according to the query parameters.

You perform this configuration on the report, making it be rendered from a report execution snapshot.
You must make sure that parameters can still be used to filter the report after the configuration.

So what action should you perform?