MicrosoftLearning / MicrosoftLearning/mslearn-fabric

Lab 6d Secure Data Warehouse - MSLearn DP-700 course is wrong about dynamic masking of email addresses

Open Beginner friendly
#455 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

in review
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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.