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?