DP-203 · Question #225
DP-203 Question #225: Real Exam Question with Answer & Explanation
Sign in or unlock DP-203 to reveal the answer and full explanation for question #225. The question stem and answer options stay visible for context.
Question
You are a data engineer for an Azure SQL Database. You write the following SQL statements: CREATE TABLE Customer ( CustomerID int IDENTITY PRIMARY KEY, GivenName varchar(100) MASKED WITH (FUNCTION = 'partial(2,"XX",0)') NULL, SurName varchar(100) NOT NULL, Phone varchar(12) MASKED WITH (FUNCTION = 'default()') INSERT Customer (GivenName, SurName, PhonE. VALUES ('Sammy', 'Jack', '555.111.2222'); SELECT * FROM Customer; You need to determine what is returned by the SELECT query. What data is returned?
Options
- A1 SaXX Jack XXX.XXX.2222
- B1 XXXX Jack XXX.XXX.XXXX
- C1 xx Jack XXX.XXX.2222
- D1 SaXX Jack xxxx
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.