Рет қаралды 280
CONTACT FOR TRAINING AND MOCK INTERVIEWS
9912070616
SNOWFLAKE INTERVIEW DISCUSSION:
SELF INTRODUCTION
1 MIN TO 2 MIN
SQL SNOWFLAKE AWS S3 DBT
EXPLATION PROJECT
ETL GUY HE WILL PUSH S3 BUCKET THEN
INTEGRATION
FILE FORMAT
COPY COMMAND
SNOW PIPE HOW REFRSH SNOW PIPE
HOW TO TROPUBLE SHOOT SNOWPIPE
JSON SEMI CSV PSV
LOAD STAGE
FROM @STAGE INTO TARGET TABLE
THE DATA IS JSON
ONE COLUMN (RAW VARIANT);
FLATEN;
DUPTICATE DELETE
UPDATE
VIEW
SECURE VIEW
DATA MIGRATION
FROM ORACLE TO SNOWFLAKE
WHO ARE THE COMPETIRES OF THE SNOWFLAKE
REDSHIFT
BIGQUERY
AZURE SYNAPSE(AZURE DW)
STANDA EDITION
ENTETPRISE
BUSINESS
VPS
HOW MANY WAY LOGIN SNOWFLAKE
SNOWSQL SNOWSIGHT CLASSIC CONCONSOLE
DATA WAREHOUSE
TIME TRAVEL
ZERO COPY CLONING
STAR SCEHEMA AND SNOWFLAKE SCHEMA
WHAT IS DATA LAKE
WAHT IS MART
JSON
VARIANT
HOW MANY WAYS RETRIVE IF DATA LOSE OR DELTED
DELTED ONE MONTH BEFORE ?
TIME TRAVEL
HOW MANY WAYS
TIME STAMP
BEFORE STATEMNET
QUERY ID
VIEW MATERIALIZED VIEW
DIFFENCE BETWEEN THEM
SECURE VIEWS
SNOWFLAKE
WHAT ARE THE LAYERS
DATA STORAGE
QUERY PROCESSING
COLUD SERVICE
WAHT ARE THE COLUD SERVICE
AWS S3 AZURE GCP
CACHE
RESULT CACHE
DISK CACHE
WHAT ARE THE ROLES
ACCOUNT ADMIN
ANALYST
DATA ANALYST
DEVOLOPER
ACCOUND ADMIN
SCCURTUTY
PUBLIC
USER
TABLE TABLE_CLONE
SQL
TABLE A = 1, NULL ,2, 1 , 4 , 5
TABLE B = 1, NULL ,NULL, 6, 5
LEFT JOIN = MATCHD VALUES AND TABLE A VALUES
(1,1), (1,1), (5,5) (2,NULL) , (4,NULL)
(NULL,NULL);
CROSS JOIN = 6 * 5 = 30;
DUPILCATE VALUES WRITE QUERY
FINDING HIGEST 3RD SALARY
DELETE DUPICATE VALUES
EMP YOU CREATE TABLE
DROP
EMP YOU INSERTED ANOTHER DATA
EMP = ? THE FIRST TABLE
YOU NEED RENAME THE EMP
UNDROP
TRUCANTE DIFF DROP
DROP
UNDROP TABLE TABLE_NAME;
TRUCATE DDL OR DML;
COMMIT AND ROLLBACK
SAVE UNDO BUTTON
BY DEFALULT TRUE
ALTER
WAHT IS TASK
HOW YOU SHEDULE TASK
WHAT IS CDC ?
STRAMES
INSERT UPDATE DELETE ROW NUMBER
SOURCE_TABLE STREAM TARGET_TABLE
JUST WITH THESE
WRITE ANSWERSYOUR SELF
YOU WILL GET YOUR OWN IDEA
DATA TYPES
DATE TIME STAMPS