Exam DP-300 topic 2 question 28 discussion

Actual exam question from Microsoft's DP-300

Question #: 28
Topic #: 2

DRAG DROP
-

You have an Azure subscription that contains an Azure SQL database named DB1.

You plan to perform a classification scan of DB1 by using Azure Purview.

You need to ensure that you can register DB1.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Show Suggested Answer

Suggested Answer:

by licna at Jan. 23, 2023, 3:37 p.m.

Comments

Submit Cancel

KIET2131

Highly Voted 1 year, 4 months ago

Create a Purview account. Modify the Access control (IAM) settings for DB1. From the Purview Studio, create a scan rule set.

upvoted 10 times

voodoo_sh

4 months, 3 weeks ago

I think the answer should be: 1. Create a Purview account 2. Create a system-assigned managed identity (enable it for Purview account). 3. Modify the Access control (IAM) settings of DB1 (grant permissions to system-assigned managed identity, so Purview account can access DB1)

upvoted 6 times

...

alexatl

Highly Voted 1 year, 5 months ago

after some further reading, i think the provided answer seems right. the question is not how to perform scan. it is about what need to be done to register for the scanning. If you carefully read the content in this link, you will see the answer make more sense. https://learn.microsoft.com/en-us/azure/purview/register-scan-azure-sql-database?tabs=sql-authentication

upvoted 5 times

licna

1 year, 5 months ago

Seem you are right and I was wrong. Only I would change the sequence of the steps 2 and 3. First to create a managed identity => then to modify IAM of the database

upvoted 4 times

testdumps2017

10 months, 3 weeks ago

system managed identity CANNOT be created by the user, so it's not valid.

upvoted 3 times

igorclapa

8 months, 2 weeks ago

How do you know that? The question doesn't mention if the person here is a generic "user" or an Azure admin of some kind.

upvoted 1 times

...

licna

Most Recent 1 year, 5 months ago

I think the answer is wrong. It should be: 1. Create a Purview account 2. Create a scan rule set 3. Create a scan trigger https://learn.microsoft.com/en-us/azure/purview/concept-best-practices-scanning#scanning

upvoted 1 times

eleeitor

8 months, 3 weeks ago

thats after the data source is registered..... here we need to ensure we can register our db as a data source in purview

upvoted 1 times

...