You are creating a SQL Server 2008 Integration Services (SSIS) instance for Company.com.
The package displays job listed below:
– You should operate multiple files through utilizing a For Each Loop container.
– You should get the files’ content to a table through utilizing a Data Flow task.
– Through utilizing an Execute SQL task, you should Log the results of the state into a table
– You should make sure that the Execute SQL task only could not run in one transaction.
Which is the correct answer? (Select more than one)

You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com.
The package should contain a Data Flow task with a Fuzzy Grouping transformation that
creates data.
You should browser the output data of the Fuzzy Grouping transformation to debug the
package.
Which is the correct answer?

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?

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.
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?

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. You have a table named
Bills with three columns contained. They are respectively Shipper, BillKey and BillQuantity.
To meet the business development, a dimension named DimBills and a measure group
named TruthBills are created from the Bills table. Besides, the BillKey is set as a key column

and the Shipper is set as an attribute column. According to the order of the CIO, a dimension
relationship between the BillQuantity column and the Shipper column should be created to
make sure that the Shipper column is able to aggregate BillQuantity column. What action
below should be performed to achieve this goal?

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, you create a (SSAS) solution and enable proactive
caching for a partition. Now you get an order from your company CIO, according to his
requirement, while updating the multidimensional storage, you should make sure that you
can use SSAS to query relational data.
What action below should be performed?

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 Services
(SSAS)
solution, which has a hierarchy named Season in a Time dimension named Dimtime.
The attributes of Spring level, Summer level, Autumn level and Winter level are contained in
the Season hierarchy.
Now you are assigned a task to create a named set to refer to the first season of the year
2008.
What action should you perform to accomplish this task?

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 companynamed 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.
A Product dimension is contained in the database. The dimension contains two attributes
both of which have a Rigid relationship type.
The two attributes are the Category attribute and Subcategory attribute.
The relationship between the Category and Subcategory values is changed by the data
source for the Product dimension.
Now in order to make the dimension successfully reflect the change, you have to execute an
XML for Analysis (XMLA) command to process the dimension to perform this.
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 the technical support for the company
which uses SQL Server2008 Analysis Services (SSAS) solution. To meet the business
development, a dimension named DimSales is created with an Amount attribute, and then it
is used in a cube structure. Now you are assigned a task to make sure that aggregations
have no relationship with the Amount attribute. What action should you perform 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 the technical support for the company
which uses SQL Server2008. To meet the business development, you use SQL Server 2008
to create a SQL Server 2008 Integration Services (SSIS) package. You have a Research
server named SQL_RES01 and a Sales server named SQL_SAL01. SQL_RES01 is not
connected to SQL_SAL01 in the network. Then you have the SSIS package configured on
the SQL_SAL01 server, however, you get a failure of the configuration, which is because the
SQL_RES01 server can not be connected by the package. In order to solve that problem,
the package should be modified to refer to the SQL_SAL01 server when you execute the
configuration.
Which solution would be chosen to solve that problem?