DP 600 CARDS 84 TO 57

Question 1

84) WITHOUT ADDITIONAL COPIES

Answer 1

SHORTCUT

Question 2

83) 114 ALSO
TWO TIMES STORED PROCEDURE

Answer 2

LOOKUP

Question 3

82) POS CUSTOMERS

Answer 3

(CTAS) CREATE TABLE AS SELECT
LAKEHOUSE

Question 4

81) PREVENT AUTOMATICALLY

Answer 4

SQL ANALYTICS ENDPOINT

Question 5

80)SCHEMA1, SCHEMA 2,..MINIMIZE COPYING OF DATA
REF : QUESTION KEYWORD FOR 123 IS THE ANSWER KEYWORD TO THIS QUESTION

Answer 5

CLONE

Question 6

78) CUSTOMERS - NEW VERSION
OVERWRITE

Answer 6

TYPE 2
TYPE 1

Question 7

77) 30 DAYS
ACID

Answer 7

VACUUM

Question 8

76) ALL TABLES MERGE

Answer 8

FULL OUTER JOIN

Question 9

74 ) ALL EXISTING DATA PLUS NEW DATA
TWO ANSWERS

Answer 9

APPEND
MERGESCHEMA, TRUE

Question 10

72)SALES.PARQUET, ABFSS, LAKEHOUSE EXPLORER - TWO ANSWERS

Answer 10

DELTA, SALES

Question 11

71) CHANGE THE DATA TYPE
3 ANSWERS

Answer 11

1. WITH COLUMN
2. COL
3. CAST

Question 12

68) SPARK DATA
SQLENDPOINT DATA
two answers

Answer 12

1. SPARK DATA - READ ALL
2. SQLENDPOINT - READ DATA

Question 13

66) CALCULATION GROUPS

Answer 13

TABULAR EDITOR

Question 14

64)FABRIC CAPACITY

Answer 14

F -SKU

Question 15

63) LITWARE CASE STUDY
DATALOADING SEQUENCE

Answer 15

PIPELINE WITH DEPENDENCIES
LONGEST ANSWER

Question 16

62) LITWARE
DATE DIMENSION
DATE STORE
TWO ANSWERS

Answer 16

DATA FLOW
STORED PROCEDURE

Question 17

61) LITWARE
AUTHENTICATION - METHOD
MODE
TWO ANSWERS

Answer 17

SSO
DIRECT LAKE

Question 18

60)LITWARE
TWO ACTIONS - FABRIC ADMIN PORTAL
2 ANSWERS

Answer 18

BE
CAN TRY - SPECIFIC SECURITY GROUPS
CREATE - SPECIFIC SECURITY GROUPS

Question 19

59) MAINTENANCE DONE OR NOT
EXPLAIN

Answer 19

NO

Question 20

58) MAINTENANCE DONE OR NOT
REFRESH

Answer 20

NO

Question 21

57) MAINTENANCE DONE OR NOT
DESCRIBE HISTORY

Answer 21

YES