Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 39 of 40
Free Preview · 40 of 131 · questions 1–40 of 131 are free. Sign up free to sync your progress across devices.
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Hotspot Solution:
default() partial(1,"@",5) default() is based on data type: Strings → 'XXXX' Numbers → 0 Dates → '1900-01-01 00:00:00.0000000' Binary → ASCII 0 random() takes only 2 parameters (start, end) and is only for numeric data types email() returns the first letter [email protected] (always .com), for ex, [email protected] > [email protected] . partial(prefix_length, "padding_string", suffix_length), where prefix_length: Number of characters to show from the beginning. padding_string: The string used to mask the middle portion. suffix_length: Number of characters to show from the end.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
The answer for birthdate is 'default()'. https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver17 For the email it is partial()
default() partial(1,"@",5) default() is based on data type: Strings → 'XXXX' Numbers → 0 Dates → '1900-01-01 00:00:00.0000000' Binary → ASCII 0 random() takes only 2 parameters (start, end) and is only for numeric data types email() returns the first letter [email protected] (always .com), for ex, [email protected] > [email protected] . partial(prefix_length, "padding_string", suffix_length), where prefix_length: Number of characters to show from the beginning. padding_string: The string used to mask the middle portion. suffix_length: Number of characters to show from the end.
default partial Random is only applicable to numeric and binary data types.