Microsoft
70-768 · Question #22
You are optimizing a Microsoft SQL Server Analysis Services (SSAS) multidimensional model over a SQL Server database. You have a table named City which has several dimensions that do not contain a…
The correct answer is D. In the SQL Server database, implement a view over the City table that aliases the columns in the. See the full explanation below for the reasoning.
Question
You are optimizing a Microsoft SQL Server Analysis Services (SSAS) multidimensional model over a SQL Server database. You have a table named City which has several dimensions that do not contain a space in their names. One dimension is named SalesTerritory rather than Sales Territory. You need to ensure that Report developers can drag the attribute name to the report rather than having to re-label the attributes by implementing spaces. You must minimize administrative effort and not break any upstream processes. What should you do?
Options
- AIn the SQL Server database, run the system procedure sp_rename to rename the columns in the
- BIn SQL Server Management Studio, navigate to the City table, expand the columns, press F2,
- CIn the SQL Server database, implement a SYNONYM.
- DIn the SQL Server database, implement a view over the City table that aliases the columns in the
How the community answered
(27 responses)- A15% (4)
- B4% (1)
- C4% (1)
- D78% (21)
Community Discussion
No community discussion yet for this question.