MENU
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.
Suggested Answer: D, E
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
13 comments · newest first
CA
Carlee
12 months ago
Wait, can users really be restricted like that? Sounds tricky!
LE
Leontine
1 year ago
Not sure about that, RBAC seems more relevant here.
CO
Cortney
1 year ago
I thought column encryption keys were necessary too?
NE
Nettie
1 year ago
A security policy is also a must-have.
RU
Ruby
1 year ago
Definitely need a custom RBAC role for this!
MA
Maryanne
1 year 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.
GE
Gennie
1 year ago
I’m a bit confused; I thought column encryption keys were more about data protection rather than access control.
AD
Adrianna
1 year ago
I remember practicing with RBAC roles in a similar question, so I feel like that could be a good choice here.
TA
Tamera
1 year ago
I think we need a security policy to enforce row-level security, but I'm not sure about the second object.
VE
Verona
1 year 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.
AR
Aretha
1 year 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.
RI
Rickie
1 year 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.
BE
Bernardine
1 year ago
I was thinking it might be around 25 days, but that feels too low based on the typical inventory turnover rates I studied.