You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
PowerPivot for Microsoft Excel workbooks and SQL Server Reporting Services (SSRS)
reports have been created and published to provide a self-service data analysis and
reporting environment.
Due to the increasing volume of data, you need to create server-based data models to
continue to provide the self-service data analysis and reporting environment.
You need to configure a solution that can support the addition of calculated columns and
use the existing SSRS reports.
Which of the following steps should you perform to create and implement your solution?
(Choose all that apply).
A.
Create SQL Server Analysis Services tabular projects by importing the PowerPivot workbooks.
B.
Create SQL Server Analysis Services UDM (Unified Dimensional Model) projects by importing
the PowerPivot workbooks.
C.
Deploy the new SSAS projects to the server.
D.
Import the existing reports.
E.
Modify the existing reports by changing the data source to use the new databases.
Explanation:
ok