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

6 months, 1 week 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

3 months, 3 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 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

...

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 2 question 47 discussion

Comments

2f5c7cd

voodoo_sh

pjfunner

SY0-701