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 enrollment_date in the format of ‘Mon dd, yy’ (for example: Apr 17, 25)

You have the following T-SQL query:

SELECT 
    course_id AS courseID,
    __________ AS EnrollmentDate
FROM Enrollments

How should you complete the query?

Choose the correct answer from the options below.

Explanations for each answer:

convert(varchar, enrollment_date, 7) is correct.
convert(varchar, enrollment_date, 109) is incorrect. Style 109 outputs the date in the format 'Mon dd yyyy hh:mi:ss:mmm(AM/PM)', which includes time components not required for this scenario.
convert(varchar, enrollment_date, 112) is incorrect. Style 112 outputs the date in ISO format 'yyyymmdd', which does not match the required format.
convert(varchar, enrollment_date, 202) is incorrect. Style 202 is not a valid style value.

Learn more about date and time styles for the T-SQL CONVERT function:

Practice Exam