ExamTopics DP 600

Question 1

147)MUST SUPPORT M-FORMULAS

Answer 1

DATAFLOWS

Question 2

146)INDIVIDUAL TEXT FILES, FOLDER HIERARCHY

Answer 2

PBIP - PAGINATED

Question 3

145)PYSPARK EXPRESSION df.show()

Answer 3

No

Question 4

113)df.describe.show()

Answer 4

No

Question 5

106) df.explain.show()

Answer 5

No

Question 6

144)4 hours Mon-Friday

Answer 6

Weekly

Question 7

143) COPY ACTIVITY PARTITION COLUMN

Answer 7

OVERWRITE

Question 8

142) SUMMARIZE BY - SET TO OTHER THAN NONE

Answer 8

BEST PRACTICE

Question 9

141)SCD TWO ACTIONS

Answer 9

UPDATE ROWS - NON KEY
INSERT RECORDS - NATURAL

Question 10

140) SCD TYPE 2 - 3 COLUMNS

Answer 10

CDE, EFFECTIVE - START, END TIME, SURROGATE

Question 11

139 )FILTER
KEEPFILTERS

Answer 11

IMPORT MODE

Question 12

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

Answer 12

PRODUCT ID, COLOUR NAME

Question 13

137) RLS , ROW LEVEL SECURITY

Answer 13

FUNCTION SECURITY

Question 14

136) INNER JOIN SPACE

Answer 14

MERGE FUZZY MATCHING

Question 15

135) DOMAIN, SUB DOMAIN

Answer 15

DOMAIN ADMIN -A

Question 16

134) RLS, UPN create a role in model

Answer 16

NO

Question 17

130) RLS, UPN, USERPRINCIPALNAME()

Answer 17

YES

Question 18

129) RLS UPN USEROBJECTID()

Answer 18

NO

Question 19

131) RLS UPN MICROSOFT ENTRA CONNECT

Answer 19

YES

Question 20

132) PIT - POINT IN TIME

Answer 20

CTAS - REATE TABLE AS SELECT

Question 21

128) 100 MILLION 2 ACTIONS REDUCE

Answer 21

SPLIT
REPLACE TOTAL MEASURE

Question 22

127) 30 CSV FILES , REFRESH FAILS

Answer 22

QUERY FOLDING NOT OCCURING

Question 23

126) SLOWEST 17, 39, 1047

Answer 23

REDUCE VISUALS

Question 24

125) 10 MILLIONS

Answer 24

BROADCAST

Question 25

124 )AWS S3 TWO OPTIONS

Answer 25

ACCESS KEY ID
SECRET ACCESS KEY

Question 26

36) S3, WHERE TO USE SHORTCUT AND WHAT FORMAT..2 ANSWERS

Answer 26

DELTA FORMAT
SHORTCUT IN TABLE

Question 27

123) CLONE, 3 T-SQL STATEMENTS

Answer 27

YES - METADATA, NO, NO

Question 28

122) MUST SUPPORT M-FORMULAS

Answer 28

DATAFLOW

Question 29

115) 160GB , 120GB - 40GB REMOVED

Answer 29

REMOVE, SPLIT

Question 30

114) EXECUTE STORED PROCEDURE

Answer 30

LOOKUP

Question 31

112) VERSION 1.2, 12 COLUMNS, SALES.RAW.CSV

Answer 31

YES,
NO - ORDER/DATE
YES

Question 32

111) DIRECT LAKE FALLBACK
QUERY

Answer 32

AUTOMATIC
DIRECT QUERY

Question 33

110) THROTTLING

Answer 33

CAPACITY METRICS APP

Question 34

109) CALCULATE..MEET THE GOAL

Answer 34

NO

Question 35

109)NOT CALCULATE..MEET THE GOAL

Answer 35

NO

Question 36

108) NOT ISEMPTY

Answer 36

YES

Question 37

107)ISEMPTY RELATED TABLE

Answer 37

NO

Question 38

105) CODE IS “DESCRIBE DETAIL”.. MAINTENANCE DONE OR NOT.

Answer 38

NO

Question 39

103) 500 ROWS MIN MAX

Answer 39

COLUMN PROFILE, DETAILS PANE

Question 40

102) TOTAL AMOUNT OF SALES SAMEPERIOD LAST YEAR

Answer 40

1. CALCULATE
2. LY SALES

Question 41

101) RETAINED LOST

Answer 41

DESCRIPTIVE

Question 42

100) BILLION ANOMALY
DATA TRANSFORMATION

Answer 42

PYSPARK

Question 43

99) SALES.ORDERS, (18,3), (18,2)
REF 97, 99

Answer 43

DATETRUNC
WEEKDAY

Question 44

97) SALES.PRODUCTS, 4 TYPES OF PRICES
REF 99, 75

Answer 44

GREATEST
COALESCE

Question 45

75) SALES.ORDERS
REF 97, 99 ALSO

Answer 45

COALESCE
LEAST

Question 46

96)3 DATA VIEWS

Answer 46

PDQ
ACD NOT DETAILS PANE

Question 47

95) HR MANAGER

Answer 47

HR MANAGER

Question 48

92)DIRECT LAKE MODE

Answer 48

DIRECT LAKE BEHAVIOR

Question 49

91 ) 126 REPEAT 1047 SLOW

Answer 49

REDUCE VISUALS

Question 50

90) MTD , CALCULATED GROUPS

Answer 50

CALCULATE SELECTED MEASURE

Question 51

89) 15 TABLES, MDX TO FALSE, PROGRAMMATICALLY

Answer 51

TABULAR EDITOR

Question 52

86) FAILURE OF THE FIRST

Answer 52

UPON COMPLETION