Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 3 Question 32 Discussion

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.
D) a custom role-based access control (RBAC) role and E) a security policy
A) a column encryption key
B) asymmetric keys
C) a function

Microsoft DP-300 Exam - Topic 3 Question 32 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 32
Topic #: 3
[All DP-300 Questions]

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.

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Carlee
10 months ago
Wait, can users really be restricted like that? Sounds tricky!
upvoted 0 times
...
Leontine
10 months ago
Not sure about that, RBAC seems more relevant here.
upvoted 0 times
...
Cortney
11 months ago
I thought column encryption keys were necessary too?
upvoted 0 times
...
Nettie
11 months ago
A security policy is also a must-have.
upvoted 0 times
...
Ruby
11 months ago
Definitely need a custom RBAC role for this!
upvoted 0 times
...
Maryanne
11 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
11 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
11 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
11 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
11 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
11 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
11 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
11 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
...

Save Cancel