Question

Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character?

(a) BIN2 (_BIN2)1

(b) Binary (_BIN)1

(c) Case-sensitive (_CS)

(d) Case-insensitive

This question was addressed to me during an online interview.

Asked question is from Analysis Services in division Business Intelligence of SQL Server

Answer 1

The correct choice is (b) Binary (_BIN)1

For explanation I would say: Binary sort order is case sensitive and accent sensitive. Binary is also the fastest sorting order.