BenchMark Quizzes by MDFT Pro

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
PeriodDate: returns a date representing the first day of the month for EnrollmentDate

You have the following T-SQL query:

SELECT 
    CourseID,
    StudentID, 
    _______ (month, EnrollmentDate) AS PeriodDate
FROM Enrollments

How should you complete the query?

Choose the correct answer from the options below.

Explanations for each answer:

DATE_BUCKET is incorrect. DATE_BUCKET groups dates into buckets of specified sizes but does not specifically return the first day of a month
DATEFROMPARTS is incorrect. DATEFROMPARTS requires you to provide the year, month, and day as separate parameters. While you could use it with other functions to construct the first day of a month, it is not designed to directly truncate an existing date to the first of the month
DATEPART is incorrect. DATEPART extracts specific parts of a date (like month or year) but does not return a complete date representing the first day of a month
DATETRUNC is correct.

Learn more about the T-SQL DATETRUNC function:

Practice Exam