Exam DP-700 topic 1 question 43 discussion

Actual exam question from Microsoft's DP-700

Question #: 43
Topic #: 1

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.

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.

Show Suggested Answer

Suggested Answer:

by 5e89616 at April 8, 2025, 12:04 p.m.

Comments

Submit Cancel

5e89616

Highly Voted 1 month, 1 week ago

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

upvoted 8 times

...