DP 600 CARDS 56 TO 24

Question 1

56) df.summary() min , max

Answer 1

yes

Question 2

55) df.show() min, max

Answer 2

no

Question 3

54) df.explain() min, max

Answer 3

no

Question 4

51) repeat of 125
DATA SHUFFLING

Answer 4

BROADCAST

Question 5

50) PROPER
1. CONNECTION AND
2. ENDPOINT
TWO ANSWERS

Answer 5

CONNECTION HTTPS
ENDPOINT DFS
DFS - DISTRIBUTED FILE SYSTEM

Question 6

48) 100 IoT devices
2 answers

Answer 6

VACUUM REMOVE
Combine OPTIMIZE

Question 7

47) FOLDABLE POWER QUERY
3 ANSWERS

Answer 7

1.VALUE
2. NATIVEQUERY
3. ENABLE FOLDING

Question 8

46) 45 MINUTES NOT RENDERED DMV

Answer 8

SYS.DM_EXEC_REQUESTS

Question 9

42) COLUMNS BECOME ROWS

Answer 9

CRU - UNPIVOTING

Question 10

41) PARTITION BY( YEAR, MONTH , DATE)
3 ANSWERS

Answer 10

YES, YES , YES

Question 11

40) V-ORDER OPTIMIZED

Answer 11

LAKEHOUSE

Question 12

37) LOAD CSV

Answer 12

LOAD TO TABLES FEATURE

Question 13

34) DATAFLOW
TWO ANSWERS

Answer 13

SOME
POWERQUERY

Question 14

33) IMPLICIT MEASURES
TWO ANSWERS

Answer 14

1. PBI DESKTOP
2. TABULAR EDITOR

Question 15

31) DIMENSIONAL DATA MODEL
CREATE
TWO ANSWERS

Answer 15

COMPANY PRODUCT
CUSTOMER PRODUCT DENORMALIZED

Question 16

30) DAX QUERIES LOAD UNNECESSARY COLUMNS 2 ANSWERS

Answer 16

1. VERTIPAQ
2. $ system

Question 17

29) DIAGRAM

Answer 17

MODEL VIEW

Question 18

27) ENABLE SCALE OUT

Answer 18

LARGE DATASET STORAGE FORMAT

Question 19

25) REDUCE TIME
TWO ANSWERS

Answer 19

BOTH AGGREGATIONS

Question 20

DEV, TEST, PROD
THREE ANSWERS

Answer 20

PROCESS OF ELIMINATION B.E.D