MicrosoftLearning / MicrosoftLearning/mslearn-fabric
Lab 6d Secure Data Warehouse - MSLearn DP-700 course is wrong about dynamic masking of email addresses
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 379
- Forks
- 349
- Avg merge
- 10d 3h
- Merged PRs (30d)
- 1
Description
Module:
Lab/Demo: 06d-secure-data-warehouse.md
Task: 00
Step: 00
Description of issue
Microsoft Learn is incorrect in the DP-700 course about dynamic masking for email.
The labs in this repo are correct, the MS Learn Fabric pages are correct:
https://learn.microsoft.com/en-us/fabric/data-warehouse/dynamic-data-masking
...
Email | Masking method that exposes the first letter of an email address and the constant suffix ".com", in the form of an email address. aXXX@XXXX.com. | Example definition syntax: Email varchar(100) MASKED WITH (FUNCTION = 'email()') NULLExample of alter syntax: ALTER COLUMN Email ADD MASKED WITH (FUNCTION = 'email()')
...
However, in the DP-700 training module Secure a Data Warehouse on
https://learn.microsoft.com/en-us/training/modules/secure-data-warehouse-in-microsoft-fabric/2-explore-dynamic-data-masking
says:
-- Mask the email address
ALTER TABLE Customers
ALTER COLUMN Email ADD MASKED WITH (FUNCTION = 'email()');
...
View masked results
Once masks are in place, a nonprivileged user querying the Customers table sees masked output:
CustomerName: John Doe
Email: j***@contoso.com**
PhoneNumber: XXX-XXX-7890
CreditCardNumber: XXXX-XXXX-XXXX-3456
and thats not correct. Email will be jXXX@XXXX.com
i know that this might not be the correct place to raise this issue, but students ask what is the truth.
In Skillable its not possible to test, because a second testuser is not available to add as a Viewer to the workspace.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Compare the dynamic masking guidance in 06d-secure-data-warehouse.md with the DP-700 training module's dynamic data masking page and the linked Microsoft Fabric documentation. Verify the email masking example and update the training content so its displayed masked result matches the documented behavior; completion means the module no longer shows the disputed output.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Activity status
- Quiet
- Clarity
- Clearly specified
- Newbie friendliness
- 70/100