ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-768 All Questions

View all questions & answers for the 70-768 exam
Go to Exam

Exam 70-768 topic 1 question 27 discussion

Actual exam question from Microsoft's 70-768
Question #: 27
Topic #: 1
[All 70-768 Questions]

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?

  • A. In the SQL Server database, run the system procedure sp_rename to rename the columns in the base tables with the target name.
  • B. In SQL Server Management Studio, navigate to the City table, expand the columns, press F2, and rename the columns in the base tables.
  • C. In the SQL Server database, implement a SYNONYM.
  • D. In the SQL Server database, implement a view over the City table that aliases the columns in the tables.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by bilel_kaaniche at May 2, 2020, 11:09 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
panal
4 years, 5 months ago
I think the correct answer is C
upvoted 1 times
clement_
4 years, 5 months ago
Hi panal, the answer cannot be C because SYNONYM does not apply to columns (cf https://docs.microsoft.com/en-us/sql/relational-databases/synonyms/synonyms-database-engine?view=sql-server-ver15 search for "You can create synonyms for the following database objects:") Answer D is correct.
upvoted 1 times
panal
4 years, 5 months ago
Hi Clement_, You are right.
upvoted 1 times
...
...
...
bilel_kaaniche
5 years ago
I think for minimum effort, we should use data source view, so no response is correct
upvoted 1 times
Jrestrepo
4 years, 10 months ago
I think we are supposed to select the best answer based on the list of solutions provided. In this particular case the best answer would be "D". Because changing the attribute / field name on the table might have an impact on other processing currently using that field.
upvoted 8 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago