You are changing a SQL Server 2008 Integration Services (SSIS) instance which get information from a doc file and loads this information to a SQL Server 2008 table for Company.com.

The information is listed below:

You should make sure that you could modify the instance to get data from many text files of the same directory.

Which is the correct answer? (Select more than one) (Exhibit)

You are creating a SQL Server 2008 Integration Services (SSIS) instance for Company.com.

The package is listed below:

You should make sure that you create a parameter which includes important information that is only useful to the Data Flow Task and the Execute SQL Task and so on.

Which is the correct answer? (Exhibit)

You are creating a SQL Server 2008 Integration Services (SSIS) project for Company.com.

Your project attributes are listed below:In order to develop a deployment manifest for packages in the project.
Which is the correct answer? (Exhibit)

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 the technical support for the company which uses SQL Server2008 Analysis Services (SSAS).
To meet the business development, (SSAS) is used to create a data mining model and the Data Mining Extensions (DMX) code is used to create a mining structure.

The Data Mining Extensions (DMX) code is shown as the following:

Now you are assigned the following tasks:
Make sure that the Microsoft Decision Trees algorithm is used by the model. Have a mining model that can be processed by this mining structure created.

So of the following DMX statements, which one should be used to accomplish the tasks above? (Exhibit)

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 the technical support for the company which uses SQL Server2008.
To meet the business development, you create a SQL Server 2008 Analysis Server (SSAS) solution, which has a measure named ProductQuantity and a price dimension named DimPrice along with a hierarchy named Price.

Then the code segment is added to the calculation script of the cube as the following: (Line letters are used only for reference.) Now you get an order from your manager to accomplish the following tasks:

1. Increase the value of the ProductionQuantity measure by 60% for each month in the fourth quarter of 2006.
2. Keep the value for the fourth quarter of 2006 unchanged.

What action should you perform to accomplish the tasks above? (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. Your company makes and sells Cars.
You work as the technical support. Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) database.

Tim is the distributor of the Southern Area. Now according to the business requirement, Tim has to access the database.
After discussion, your company decides to give Tim the necessary permissions. There are two roles respectively named Southern Area and Cars.
The table below shows the schemas of the two roles. For both roles, you have set the Visual Totals property to True.

Now you get another order from the company, according to the company requirement, Tim can only be able to view the members in the Product dimension that relate to the Cars category in the Southern Area.

You have to accomplish this task. So what action should you perform? (Exhibit)

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 the technical support for the company which uses SQL Server2008.
To meet the development requirements, you have SQL Server 2008 Reporting Services (SSRS) instance installed and configured on your network.

According to the intention of the users of the report server, e-mail messages will be used to delivered reports.
Now you get an order from the CIO that a remote SMTP server should be used to configure the report server so that reports can be delivered through e-mail message.

So of the following files, which one should you modify to achieve that goal? (Exhibit)