exam questions

Exam 70-461 All Questions

View all questions & answers for the 70-461 exam

Exam 70-461 topic 1 question 235 discussion

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

You administer a Microsoft SQL Server database named Orders.
The database contains a table named Customer that has the following definition:

You add a new data source to the application that inserts records into the Customer table. An example of a query that the application executes is shown below.

Users report that these new records are not displayed correctly. You review data in the table and observe that records from the new data source are displayed as shown below.

You need to change the database schema to support the characters coming in from this new data source. You need to achieve this goal without losing existing customer records.
Which Transact-SQL statement should you run?
A.

B.

C.

D.

E.

Show Suggested Answer Hide Answer
Suggested Answer: D
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/windows-collation-name-transact-sql?view=sql-server-ver15

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
lilupv
4 years, 9 months ago
I think, it is E
upvoted 1 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
Loading ...