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 project.
Data from a SQL Server 2005 Analysis Services database will be displayed by the report.
According to the requirement of the company CIO, you must make sure that member properties and extended properties are displayed by the report.
So what should you do?
A.
The SQL Server Analysis Services data source should be used.
B.
The SQL Server data source should be used
C.
The OLE DB for SQL Server data source should be used.
D.
The OLE DB for the Analysis Services 8.0 data source should be used