ExamTopics DP 600 29 TO 52 Flashcards by John Pappas

Q

126) SLOWEST 17, 39, 1047

A

REDUCE VISUALS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

125) 10 MILLIONS
MINIMIZE DATA SHUFFLING

A

F.BROADCAST

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

124 )AWS S3 TWO OPTIONS

A

ACCESS KEY ID
SECRET ACCESS KEY

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

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

A

DELTA FORMAT
SHORTCUT IN TABLE

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

123) CLONE, 3 T-SQL STATEMENTS

A

YES - METADATA, NO, NO

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

122) MUST SUPPORT M-FORMULAS

A

DATAFLOW

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

115) 160GB , 120GB - 40GB REMOVED

A

REMOVE, SPLIT

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

114) EXECUTE STORED PROCEDURE

A

LOOKUP

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

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

A

YES,
NO - ORDER/DATE
YES

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

111) DIRECT LAKE FALLBACK
QUERY
TWO ANSWERS

A

AUTOMATIC
DIRECT QUERY

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

110) THROTTLING

A

CAPACITY METRICS APP

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

109) CALCULATE..MEET THE GOAL

A

NO

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

109)NOT CALCULATE..MEET THE GOAL

A

NO

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

108) NOT ISEMPTY

A

YES

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

107)ISEMPTY RELATED TABLE

A

NO

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

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

A

NO

Q

103) 500 ROWS MIN MAX

A

COLUMN PROFILE, DETAILS PANE

Q

102) TOTAL AMOUNT OF SALES SAMEPERIOD LAST YEAR

A

CALCULATE
LY SALES

Q

101) RETAINED LOST

A

DESCRIPTIVE

Q

100) BILLION ANOMALY
DATA TRANSFORMATION

A

PYSPARK

Q

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

A

DATETRUNC
WEEKDAY

Q

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

A

GREATEST
COALESCE

Q

75) SALES.ORDERS
REF 97, 99 ALSO

A

COALESCE
LEAST

Q

96)3 DATA VIEWS

A

PDQ
ACD NOT DETAILS PANE

95) HR MANAGER

HR MANAGER

92)DIRECT LAKE MODE

DIRECT LAKE BEHAVIOR

91 ) 126 REPEAT 1047 SLOW

REDUCE VISUALS

90) MTD , CALCULATED GROUPS

CALCULATE SELECTED MEASURE

89) 15 TABLES, MDX TO FALSE, PROGRAMMATICALLY

TABULAR EDITOR

86) FAILURE OF THE FIRST

UPON COMPLETION