exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 1 question 22 discussion

Actual exam question from Microsoft's AZ-305
Question #: 22
Topic #: 1
[All AZ-305 Questions]

You plan to deploy an Azure SQL database that will store Personally Identifiable Information (PII).
You need to ensure that only privileged users can view the PII.
What should you include in the solution?

  • A. dynamic data masking
  • B. role-based access control (RBAC)
  • C. Data Discovery & Classification
  • D. Transparent Data Encryption (TDE)
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
ExamTopicsTST
Highly Voted 2 years, 3 months ago
Selected Answer: A
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver16
upvoted 15 times
DA95
1 year, 11 months ago
The question is about privileged user access, masking data is strategy to hiden data behind unprivileged user. See CCSP exam material
upvoted 1 times
...
...
NotMeAnyWay
Highly Voted 1 year, 8 months ago
Selected Answer: A
A. dynamic data masking Dynamic Data Masking (DDM) is a feature in Azure SQL Database that helps you protect sensitive data by obfuscating it from non-privileged users. DDM allows you to define masking rules on specific columns, so that the data in those columns is automatically replaced with a masked value when queried by users without the appropriate permissions. This ensures that only privileged users can view the actual Personally Identifiable Information (PII), while other users will see the masked data.
upvoted 10 times
...
shaiketisalat
Most Recent 3 weeks, 2 days ago
Today's exam question
upvoted 1 times
...
SeMo0o0o0o
3 weeks, 2 days ago
Selected Answer: A
A is correct
upvoted 1 times
...
MeisAdriano
1 month, 2 weeks ago
Selected Answer: A
The best choice here is A. Dynamic Data Masking. Here’s why: Dynamic Data Masking (DDM) Purpose: DDM helps protect sensitive data from unauthorized access by masking the data at the query result level. This means that non-privileged users will only see masked data (e.g., partially hidden) instead of the actual PII. Implementation: It dynamically hides the PII, which is ideal for ensuring that only authorized users can view the full, unmasked data. Why not the others? Role-Based Access Control (RBAC) RBAC controls who has access to the database but doesn’t directly mask or hide PII. Data Discovery & Classification This helps you identify and classify sensitive data, but it doesn't restrict access to PII. Transparent Data Encryption (TDE) TDE protects data at rest by encrypting the database files. It doesn’t prevent privileged users from viewing the data once they have access to the database.
upvoted 1 times
...
Len83
3 months, 4 weeks ago
This question was in the exam, August 2024. I gave this same answer and scored 870
upvoted 3 times
...
ply
11 months, 1 week ago
This question appeared on my Exam today
upvoted 4 times
...
jcxxxxx2020
1 year, 1 month ago
This question didn't not appear on my exam today 10/22/2023
upvoted 2 times
KGi
1 year ago
Didn't not? So, it did appear? :D
upvoted 1 times
...
...
iamhyumi
1 year, 3 months ago
Got this on Sept. 5, 2023
upvoted 2 times
...
jj22222
1 year, 8 months ago
this one is on the test in 2023
upvoted 3 times
...
jj22222
1 year, 9 months ago
Selected Answer: A
A because its right
upvoted 2 times
...
zellck
1 year, 9 months ago
Selected Answer: A
A is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. It's a policy-based security feature that hides the sensitive data in the result set of a query over designated database fields, while the data in the database is not changed.
upvoted 4 times
...
Airil
1 year, 9 months ago
Selected Answer: A
The answer is correct
upvoted 1 times
...
OPT_001122
1 year, 10 months ago
Selected Answer: A
correct ans
upvoted 1 times
...
Piyal
1 year, 10 months ago
Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics support dynamic data masking. Dynamic data masking limits sensitive data exposure by masking it to non-privileged users. Answer is : A
upvoted 1 times
...
jj22222
1 year, 10 months ago
Selected Answer: A
looks right
upvoted 1 times
...
janvandermerwer
1 year, 10 months ago
Selected Answer: A
Agree on A https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql SQL users excluded from masking - A set of SQL users or Azure AD identities that get unmasked data in the SQL query results. Users with administrator privileges are always excluded from masking, and see the original data without any mask.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago