BenchMark Quizzes by MDFT Pro

You are working with a Microsoft Fabric warehouse at MDFT Pro that contains a table named Enrollments. The table contains the following columns:

You need to complete a T-SQL statement that meets these requirements:

Output the course ID
Output the course name, but return NULL if the name is longer than 20 characters

You have the following T-SQL query:

SELECT 
    course_id AS courseID,
    __________ AS courseName
FROM Enrollments

How should you complete the query?

Choose the correct answer from the options below.

Explanations for each answer:

CONVERT(varchar(20), course_name) is incorrect. Using CONVERT with varchar(20) will truncate strings longer than 20 characters instead of returning NULL as required
CONVERT(varchar(max), course_name) is incorrect. Using CONVERT with varchar(max) will not handle strings longer than 20 characters as required, and will never return NULL
TRY_CAST(course_name AS varchar(20)) is correct.
CAST(course_name AS varchar(20)) is incorrect. While CAST converts the value to the target type, it will truncate strings longer than 20 characters or raise an error in contexts where truncation isn't allowed (such as inserts or assignments). It does not return NULL, which is required in this scenario

Learn more about the T-SQL TRY_CAST function:

Practice Exam