Microsoft
70-448 · Question #346
You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. The solution uses a source…
The correct answer is B. Create multiple named queries for the SSAS solution. See the full explanation below for the reasoning.
Question
You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server 2008. The solution uses a source database that contains a table named Customer. The Customer table has multiple columns. You have read-only access to the database. You plan to reduce the number of columns in the Customer table. You need to split the Customer table to be distributed across multiple table definitions. What should you do?
Options
- ACreate multiple data sources for the SSAS solution.
- BCreate multiple named queries for the SSAS solution.
- CCreate multiple data source views for the SSAS solution.
- DCreate multiple database views for the source database.
How the community answered
(33 responses)- A6% (2)
- B82% (27)
- C9% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.