Microsoft
70-432 · Question #57
70-432 Question #57: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #57. The question stem and answer options stay visible for context.
Question
You work in a Organization which is named Wiikigo Corp. The Organization uses SQL Server 2008. You are the administrator of the Organization database. Now you are in charge of a SQL Server 2008 instance. Look at the following query: SELECT s., i. FROM SensitiveTbl AS s INNER JOIN InsensitiveTbl AS i ON i.OrganizationName = s.OrganizationName You use the above query to join two tables on a column named OrganizationName. The following error is returned when you execute the query. "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between 'SQL_Latin1_General_CP1_CS_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation." The ON clause of the query has to be modified so that it can perform a case-sensitive joinsuccessfully. What should you do?
Options
- AON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)
- BON UPPER(i.OrganizationName) = UPPER(s.OrganizationName)
- CON i.OrganizationName = s.OrganizationName COLLATE
- DON i.OrganizationName = s.OrganizationName COLLATE
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.