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) solution.
Following is the cube structure. (Click the Exhibit button.)

According to the business requirements, the Amount measure and the Ownership measure are created.
Decimal values that represent percentage of ownership are contained in the Ownership column.

Besides, for a single DimAccount member, there is 100% sum of all the values in the Ownership column.
Now you get an order from your company CIO, according to his requirement, when you calculate the Amount measure against the DimCustomer dimension, you have to make sure that you have the weighted value calculated on the base of the Ownership measure. What action would you perform to achieve this goal? (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’a SQL Server 2008 Analysis Services (SSAS) solution is created.

You also create a dimension named DimCustomer.
Following is the cube structure: (Click the Exhibit button.)

Now you get an order from your company CIO, according to his requirement, you should make sure that you can aggregate the Amount measure for the DimCustomer dimension.
What action should you perform to achieve that goal? (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’a SQL Server 2008 Analysis Services (SSAS) solution is created.
Then a dimension named DimClient is created with the three attributes of Client, Age and Name.

Of the three attributes, the Client is the key. There is a measure group named Production with the Granularity property set to Age and DimClient is related to this group.

Now you receive an e-mail from your company CIO, according to his requirement, you should make sure that measure values can be retrieved based on the Age and Name attributes.
To achieve this goal, what action should you perform? (Exhibit)

You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a table called TestFact which includes two columns listed below for Company.com.

In order to develop a measure which gets the amount of customers who owns placed orders.
Which is the correct answer? (Exhibit)

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)