HOTSPOT - You need to mask tier 1 data. Which functions should you use? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Suggested Answer:
A: Default - Full masking according to the data types of the designated fields. For string data types, use XXXX or fewer Xs if the size of the field is less than 4 characters (char, nchar, varchar, nvarchar, text, ntext).
B: email -
C: Custom text - Custom StringMasking method which exposes the first and last letters and adds a custom padding string in the middle. prefix,[padding],suffix Tier 1 Database must implement data masking using the following masking logic: References: https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking
It's custom text for B indeed but email masking show the first letter and .com only like "[email protected]"
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15
B = email - from the Dynamic Data Masking link:
EMAIL - "Masking method that exposes the first letter of an email address and the constant suffix ".com", in the form of an email address. [email protected].
Yes therefore B should be custom text because the question asks for masking the first letter and domain but email masking like you mentioned expose the first letter.
Email is correct, just look at the example given by microsoft here :
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dynamic-data-masking-get-started
we get what email masking is. but it says to mask the first char and the domain. the exact opposite of what email masking is. b should be custom. (or the question fixed)
A is correct:
Default Full masking according to the data types of the designated fields
• Use XXXX or fewer Xs if the size of the field is less than 4 characters for string data types (nchar, ntext, nvarchar).
• Use a zero value for numeric data types (bigint, bit, decimal, int, money, numeric, smallint, smallmoney, tinyint, float, real).
• Use 01-01-1900 for date/time data types (date, datetime2, datetime, datetimeoffset, smalldatetime, time).
https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview
B is messed up
B = email - from the link you posted EMAIL - "Masking method that exposes the first letter of an email address and the constant suffix ".com", in the form of an email address. [email protected].
"
If the second answer is Email, then the question description is wrong.
https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview
Hi to all,
to avoid confusion the answer to email masking is correct.
take a look at this example: https://www.sqlshack.com/implementing-dynamic-data-masking-in-azure-sql-database/
text taken: "....Log in to the Azure SQL Server and query the table again to see the data which is masked with email function. The only first character is visible, and the rest of part is masked with [email protected]..."
it is concordant with type B : mask first letter and domain
regards
All you said support that B must be custom, because "Mask first letter and domain" means that First letter and Domain must be masked/hidden, not visible. Email masking does exactly the opposite.
Even the first one is confused because does not clarify if these 4 or less masked characters are all. I mean, you can mask 4 characters or less from a string of 10 characters. The question does not specify if this 4 or less masked characters are the only ones you see.
Guys, the second requirement is wrong and makes no sense. It should be mask Email, expose first letter, mask domain, expose domain suffix. -> Email function masking.
Even the first one makes no sense. Default masks everything with four X if the column width allows otherwise it puts as many X's as the length of the column... the wording of the question is absolute non-sense.
upvoted 3 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-200 Exam Questions
Log in to ExamTopics
Sign in:
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.
Narender_Bhadrecha
Highly Voted 5 years, 3 months agoz8zhong
5 years, 3 months agoSteve92873197
3 years, 12 months agoavestabrzn
Highly Voted 5 years, 3 months agoz8zhong
5 years, 3 months agoabeworld
5 years, 1 month agorunningman
5 years agoLuke97
5 years agodiulin
4 years, 11 months agoIkrom
4 years, 11 months agoMMM777
Most Recent 4 years agoSteve92873197
3 years, 12 months agodeepz8
4 years, 2 months agoI
4 years, 2 months agoSilNilanjan
4 years, 3 months agodumpsm42
4 years, 6 months agomaynard13x8
4 years, 5 months agosyu31svc
4 years, 6 months agoQuish
4 years, 8 months agomaynard13x8
4 years, 6 months agomaynard13x8
4 years, 6 months agoJJBarns
4 years, 11 months agoM0e
4 years, 8 months ago