ExamTopics DP 600 Flashcards

Pass the DP 600 exam

1
Q

147)MUST SUPPORT M-FORMULAS

A

DATAFLOWS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

146)INDIVIDUAL TEXT FILES, FOLDER HIERARCHY

A

PBIP - PAGINATED

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

145)PYSPARK EXPRESSION df.show()

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

113)df.describe.show()

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

106) df.explain.show()

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

144)4 hours Mon-Friday

A

Weekly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

143) COPY ACTIVITY PARTITION COLUMN

A

OVERWRITE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

142) SUMMARIZE BY - SET TO OTHER THAN NONE

A

BEST PRACTICE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

141)SCD TWO ACTIONS

A

UPDATE ROWS - NON KEY
INSERT RECORDS - NATURAL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

140) SCD TYPE 2 - 3 COLUMNS

A

CDE, EFFECTIVE - START, END TIME, SURROGATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

139 )FILTER
KEEPFILTERS

A

IMPORT MODE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

138) TABLE FORMAT WITH PRODUCT (ID, COLOUR, NAME) AS ROWS

A

PRODUCT ID, COLOUR NAME

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

137) RLS , ROW LEVEL SECURITY

A

FUNCTION SECURITY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

136) INNER JOIN SPACE

A

MERGE FUZZY MATCHING

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

135) DOMAIN, SUB DOMAIN

A

DOMAIN ADMIN -A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

134) RLS, UPN create a role in model

A

NO

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

130) RLS, UPN, USERPRINCIPALNAME()

A

YES

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

129) RLS UPN USEROBJECTID()

A

NO

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

131) RLS UPN MICROSOFT ENTRA CONNECT

A

YES

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

132) PIT - POINT IN TIME

A

CTAS - REATE TABLE AS SELECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

128) 100 MILLION 2 ACTIONS REDUCE

A

SPLIT
REPLACE TOTAL MEASURE

22
Q

127) 30 CSV FILES , REFRESH FAILS

A

QUERY FOLDING NOT OCCURING

23
Q

126) SLOWEST 17, 39, 1047

A

REDUCE VISUALS

24
Q

125) 10 MILLIONS

25
124 )AWS S3 TWO OPTIONS
ACCESS KEY ID SECRET ACCESS KEY
26
36) S3, WHERE TO USE SHORTCUT AND WHAT FORMAT..2 ANSWERS
DELTA FORMAT SHORTCUT IN TABLE
27
123) CLONE, 3 T-SQL STATEMENTS
YES - METADATA, NO, NO
28
122) MUST SUPPORT M-FORMULAS
DATAFLOW
29
115) 160GB , 120GB - 40GB REMOVED
REMOVE, SPLIT
30
114) EXECUTE STORED PROCEDURE
LOOKUP
31
112) VERSION 1.2, 12 COLUMNS, SALES.RAW.CSV
YES, NO - ORDER/DATE YES
32
111) DIRECT LAKE FALLBACK QUERY
AUTOMATIC DIRECT QUERY
33
110) THROTTLING
CAPACITY METRICS APP
34
109) CALCULATE..MEET THE GOAL
NO
35
109)NOT CALCULATE..MEET THE GOAL
NO
36
108) NOT ISEMPTY
YES
37
107)ISEMPTY RELATED TABLE
NO
38
105) CODE IS "DESCRIBE DETAIL".. MAINTENANCE DONE OR NOT.
NO
39
103) 500 ROWS MIN MAX
COLUMN PROFILE, DETAILS PANE
40
102) TOTAL AMOUNT OF SALES SAMEPERIOD LAST YEAR
1. CALCULATE 2. LY SALES
41
101) RETAINED LOST
DESCRIPTIVE
42
100) BILLION ANOMALY DATA TRANSFORMATION
PYSPARK
43
99) SALES.ORDERS, (18,3), (18,2) REF 97, 99
DATETRUNC WEEKDAY
44
97) SALES.PRODUCTS, 4 TYPES OF PRICES REF 99, 75
GREATEST COALESCE
45
75) SALES.ORDERS REF 97, 99 ALSO
COALESCE LEAST
46
96)3 DATA VIEWS
PDQ ACD NOT DETAILS PANE
47
95) HR MANAGER
HR MANAGER
48
92)DIRECT LAKE MODE
DIRECT LAKE BEHAVIOR
49
91 ) 126 REPEAT 1047 SLOW
REDUCE VISUALS
50
90) MTD , CALCULATED GROUPS
CALCULATE SELECTED MEASURE
51
89) 15 TABLES, MDX TO FALSE, PROGRAMMATICALLY
TABULAR EDITOR
52
86) FAILURE OF THE FIRST
UPON COMPLETION