DP-700 Exam QuestionsBrowse all questions from this exam

DP-700 Exam - Question 43


HOTSPOT

-

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse2.

A team of data analysts has Viewer role access to Workspace1.

You create a table by running the following statement.

Exam DP-700 Question 43

You need to ensure that the team can view only the first two characters and the last four characters of the CreditCard attribute.

How should you complete the statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Exam DP-700 Question 43
Show Answer
Correct Answer:
Exam DP-700 Question 43

Discussion

2 comments
Sign in to comment
5e89616
Apr 8, 2025

Correct ALTER TABLE- to modify the tabel ALTER COLUMN - to modify the column PARTIAL(prefix padding, padding string, suffix padding) - to expose first and last n characters, adding custom padding 'xxx' of a text field

13d2a97
Apr 19, 2025

ALTER / ALTER / PARTIAL