Practice Exam

Choose the Correct DATENAME Parameter

You work for MDFT Pro, a well-known training agency. You have a Fabric warehouse that contains a table named Enrollments with the following columns:

You need to write a T-SQL query that will return the following columns:

• CourseID: returns CourseID
• StudentID: returns StudentID
• DayName: returns the name of the day of the week for EnrollmentDate, such as ‘Wednesday’

You have the following T-SQL query:

SELECT 
    CourseID,
    StudentID, 
    DATENAME(_______, EnrollmentDate) AS DayName
FROM Enrollments

How should you complete the query?

Choose the correct answer from the options below.