Exam DP-300 topic 2 question 47 discussion

Actual exam question from Microsoft's DP-300

Question #: 47
Topic #: 2

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.

Show Suggested Answer

Suggested Answer:

by pjfunner at April 24, 2024, 9:16 p.m.

Comments

Submit Cancel

2f5c7cd

10 months ago

T-SQL version ADD SENSITIVITY CLASSIFICATION TO SalesLT.Product.StandardCost, SalesLt.Product.ListPrice WITH ( LABEL = 'Confidential', INFORMATION_TYPE = 'Financial' );

upvoted 2 times

voodoo_sh

7 months, 2 weeks ago

Thanks for the T-SQL! GUI: for SQL Server, can right click database in SSMS -> Tasks -> Data Discovery and Classification. For Azure SQL DB and SQL MI, go to Azure Portal -> Database -> Security -> Data Discovery and Classification

upvoted 1 times

...

pjfunner

1 year, 3 months ago

Steps would be similar to this: https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and-classification?view=sql-server-ver16&tabs=t-sql

upvoted 1 times

...