SIMULATION You need to classify the StandardCost and ListPrice columns of the SalesLT.Product table in db1. The columns must have the following configurations: - An information type of Financial - A…

Submitted by ashley.k· Mar 6, 2026Implement Data Security and Compliance - specifically configuring data sensitivity classifications and information protection labels on Azure SQL / SQL Server databases to meet regulatory and governance requirements.

Question

SIMULATION You need to classify the StandardCost and ListPrice columns of the SalesLT.Product table in db1. The columns must have the following configurations: - An information type of Financial - A sensitivity label of Confidential To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal. Answer: To classify your SQL Server database: Step 1: In SQL Server Management Studio (SSMS), connect to the SQL Server. Step 2: In the SSMS Object Explorer, select the database [Here db1] that you would like to classify and choose Tasks > Data Discovery and Classification > Classify Data.... Step 3: The classification engine scans your database for columns containing potentially sensitive data and provides a list of recommended column classifications: Step 4: You can change the recommended Information Type and Sensitivity Label using the drop- down boxes. Step 5: Select columns StandardCost and ListPrice. Unselect other columns if necessary. For StandardCost and ListPrice columns select information type of Financial, and sensitivity label of Confidential. Step 6: To apply the selected recommendations, select the Save selected recommendations button. Step 7: To display the classified columns, select appropriate schema and corresponding table from the drop-down, then select Load Columns. Step 8: You can also manually classify columns as an alternative, or in addition, to the recommendation-based classification: Select Add classification in the top menu of the window. Step 9: If you want to add classification for all the unclassified columns for a specific table in a single attempt, then select All Unclassified in the Column drop down of Add Classification page. Step 10: To complete your classification and persistently label (tag) the database columns with the new classification metadata, select the Save button on the top menu of the window. Reference: https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and- classification

Exhibit

Explanation

The correct answer uses SQL Server Management Studio's built-in Data Discovery and Classification feature, which is the proper tool for applying sensitivity labels and information types to database columns. By navigating to Tasks > Data Discovery and Classification > Classify Data in SSMS, administrators can leverage the classification engine to scan, identify, and manually assign the 'Financial' information type and 'Confidential' sensitivity label to the StandardCost and ListPrice columns. This workflow integrates with Microsoft Purview Information Protection and Azure Defender for SQL, ensuring compliance classifications are recorded and reportable.

Topics

#Data Classification#SQL Server Management Studio#Azure SQL Security#Microsoft Purview Information Protection

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice