Microsoft
70-768 · Question #22
70-768 Question #22: Real Exam Question with Answer & Explanation
Sign in or unlock 70-768 to reveal the answer and full explanation for question #22. The question stem and answer options stay visible for context.
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
Unlock 70-768 to see the answer
You've previewed enough free 70-768 questions. Unlock 70-768 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.