ExamTopics DP 600 1 TO 28 Flashcards
Pass the DP 600 exam
147)MUST SUPPORT M-FORMULAS
DATAFLOWS
146)INDIVIDUAL TEXT FILES, FOLDER HIERARCHY
PBIP - PAGINATED
145)PYSPARK EXPRESSION df.show()
No
113)df.describe.show()
No
106) df.explain.show()
No
144)4 hours Mon-Friday
Weekly
143) COPY ACTIVITY PARTITION COLUMN
OVERWRITE
142) SUMMARIZE BY - SET TO OTHER THAN NONE
BEST PRACTICE
141)SCD TWO ACTIONS
UPDATE ROWS - NON KEY
INSERT RECORDS - NATURAL
140) SCD TYPE 2 - 3 COLUMNS
CDE, EFFECTIVE - START, END TIME, SURROGATE
139 )FILTER
KEEPFILTERS
IMPORT MODE
138) TABLE FORMAT WITH PRODUCT (ID, COLOUR, NAME) AS ROWS
PRODUCT ID, COLOUR NAME
137) RLS , ROW LEVEL SECURITY
FUNCTION SECURITY
136) INNER JOIN SPACE
MERGE FUZZY MATCHING
135) DOMAIN, SUB DOMAIN
DOMAIN ADMIN -A
134) RLS, UPN create a role in model
NO
130) RLS, UPN, USERPRINCIPALNAME()
YES
129) RLS UPN USEROBJECTID()
NO
131) RLS UPN MICROSOFT ENTRA CONNECT
YES
132) PIT - POINT IN TIME
CTAS - REATE TABLE AS SELECT
128) 100 MILLION 2 ACTIONS REDUCE
SPLIT
REPLACE TOTAL MEASURE
127) 30 CSV FILES , REFRESH FAILS
DATA TYPE CHANGE..CHECK ANSWER WITH PRIYANKA
126) SLOWEST 17, 39, 1047
REDUCE VISUALS
125) 10 MILLIONS
BROADCAST
