HOTSPOT - You need to ensure that security requirements are met. How should you complete the code segment? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Suggested Answer:Explanation
Box 1: ExpenseAccount - Scenario: User's expense account number must be visible only to logged in users. All other views of the expense account number should include only the last segment. With the remaining parts obscured.
Box 2: Text - If MaskingFunction has a value of Number or Text, you can specify the NumberFrom and NumberTo parameters, for number masking, or the PrefixSize, ReplacementString, and SuffixSize for text masking.
Box 3: 4 - -SuffixSize specifies the number of characters at the end of the text that are not masked. Specify this parameter only if you specify a value of Text for the MaskingFunction parameter. Scenario: Format is 1234-1234-1235 Box 4: xxxx" Scenario: Format is 1234-1234-1235 References: https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/new-azurermsqldatabasedatamaskingrule?view=azurermps-6.13.0
As per MS docs:
-ReplacementString
Specifies the number of characters in the end of the text that are not masked. Specify this parameter only if you specify a value of Text for the MaskingFunction parameter. The default value is an empty string.
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/new-azurermsqldatabasedatamaskingrule?view=azurermps-6.13.0
Refer to https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview - "Dynamic Data Masking Policy"
• Use XXXX or fewer Xs if the size of the field is less than 4 characters for string data types (nchar, ntext, nvarchar).
Therefore, XXXX would suffice
This is for Masking type "Default".Please refer below
fault 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).
Masking method, which exposes the first and last characters and adds a custom padding string in the middle. If the original string is shorter than the exposed prefix and suffix, only the padding string is used.
prefix[padding]suffix
I think it makes sense to have suffix 4 and padding XXXX
https://docs.microsoft.com/en-us/rest/api/sql/datamaskingrules/createorupdate
replacementString => If maskingFunction is set to Text, the character to use for masking the unexposed part of the string. Otherwise, this parameter will be ignored.
suffixSize => If maskingFunction is set to Text, the number of characters to show unmasked at the end of the string. Otherwise, this parameter will be ignored.
This section is not available anymore. Please use the main Exam Page.AZ-203 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.
brajen
Highly Voted 4 years, 9 months agochaudh
4 years, 9 months agoLTiwana
4 years, 9 months agoLTiwana
4 years, 9 months agosidnyc
4 years, 8 months agosubrata83
4 years, 6 months agoahadjithoma
4 years, 4 months agofunfun
4 years, 3 months agoNanaboso2
Highly Voted 4 years, 11 months agopierre_grns
2 years, 4 months agosidnyc
Most Recent 4 years, 8 months agocloud_guru
4 years, 9 months agoPratekk
4 years, 10 months agorubylight89
4 years, 11 months agoRaedKazan
5 years, 1 month ago