Microsoft DP-300 Exam - Topic 3 Question 32 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 32
Topic #: 3

You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies.

You need to ensure that users from each company can view only the data of their respective company.

Which two objects should you include in the solution? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Aa column encryption key

Basymmetric keys

Ca function

Da custom role-based access control (RBAC) role

Ea security policy

Show Suggested Answer

Suggested Answer: D, E

Azure RBAC is used to manage who can create, update, or delete the Synapse workspace and its SQL pools, Apache Spark pools, and Integration runtimes.

Define and implement network security configurations for resources related to your dedicated SQL pool with Azure Policy.

https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac

https://docs.microsoft.com/en-us/security/benchmark/azure/baselines/synapse-analytics-security-baseline

by Corinne at May 08, 2022, 03:21 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Carlee

4 months ago

Wait, can users really be restricted like that? Sounds tricky!

upvoted 0 times

...

Leontine

4 months ago

Not sure about that, RBAC seems more relevant here.

upvoted 0 times

...

Cortney

4 months ago

I thought column encryption keys were necessary too?

upvoted 0 times

...

Nettie

5 months ago

A security policy is also a must-have.

upvoted 0 times

...

Ruby

5 months ago

Definitely need a custom RBAC role for this!

upvoted 0 times

...

Maryanne

5 months ago

I feel like a function could be useful for filtering data, but I can't recall if it's the best option in this scenario.

upvoted 0 times

...

Gennie

5 months ago

I’m a bit confused; I thought column encryption keys were more about data protection rather than access control.

upvoted 0 times

...

Adrianna

5 months ago

I remember practicing with RBAC roles in a similar question, so I feel like that could be a good choice here.

upvoted 0 times

...

Tamera

5 months ago

I think we need a security policy to enforce row-level security, but I'm not sure about the second object.

upvoted 0 times

...

Verona

5 months ago

This one's tricky. The passage seems to be praising Huawei's training services, but the question is just asking if the statement is True or False. I'll have to read it carefully again to decide.

upvoted 0 times

...

Aretha

5 months ago

This looks like a straightforward question on Oracle profile configurations. I'll start by reviewing the options and thinking through which ones are related to account management capabilities.

upvoted 0 times

...

Rickie

5 months ago

This seems similar to that practice question we did last week on variances. If I recall, we need to find the difference in units sold and multiply it by the contribution margin.

upvoted 0 times

...

Bernardine

5 months ago

I was thinking it might be around 25 days, but that feels too low based on the typical inventory turnover rates I studied.

upvoted 0 times

...