You work for MDFT Pro, a well-known training agency that offers certification preparation courses. Mark, a Database Security Administrator at MDFT Pro, manages a Fabric warehouse called CourseData that contains sensitive student information. The warehouse has a table called Students with columns including StudentID, Name, Email, EnrollmentDate, PaymentAmount, and CreditCardNumber. Multiple trainers and administrative staff need access to student records, but for privacy and compliance reasons, they should only see columns relevant to their role. For example, trainers should see student names and enrollment dates but not payment information or credit card numbers. Mark needs to implement column-level security to restrict which columns different users can access while still allowing them to query the Students table.
Which T-SQL command should Mark use to implement column-level security in the warehouse?
Choose the correct answer from the options below.
Explanations for each answer: