DP-300 Certification Practice Question #107

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.

Accepted Answer

To classify the columns `StandardCost` and `ListPrice` of the `SalesLT.Product` table in `db1` with the information type of `Financial` and sensitivity label of `Confidential`, you can use T-SQL or the GUI (SSMS Data Discovery and Classification or Azure Portal). The T-SQL syntax uses the `ADD SENSITIVITY CLASSIFICATION` statement mapping both columns to the specified `LABEL` and `INFORMATION_TYPE`.

More DP-300 practice questions