Udemy Crack The Snowflake Data Engineer Interview 100 Q A

Files Included :

1 About this course and the Instructor.mp4 (9.6 MB)
MP4
1 How does a stream become empty How can you purge a stream.mp4 (6.07 MB)
MP4
2 Can you join a stream and table.mp4 (3.59 MB)
MP4
3 In what scenario did you use streams in your project Use Case 1.mp4 (7.83 MB)
MP4
4 In what scenario did you use streams in your project Use Case 2.mp4 (10.87 MB)
MP4
5 What is change tracking on a table Why is it used instead of streams.mp4 (6.42 MB)
MP4
6 What is a stream.mp4 (6.95 MB)
MP4
7 What are the different type of streams.mp4 (9.88 MB)
MP4
1 What is time travel What are its advantages.mp4 (10.78 MB)
MP4
2 What are the different options you can use to recover data with time travel.mp4 (9.19 MB)
MP4
3 A table has been truncated and you are not able to recover it using time.mp4 (15.67 MB)
MP4
4 A junior developer dropped a table, you have been asked to recover it how.mp4 (16.46 MB)
MP4
5 How will you find the data retention parameter of a table.mp4 (12.96 MB)
MP4
6 What is the max time travel available on any edition of snowflake.mp4 (7.25 MB)
MP4
7 Does the undrop command work with Schema and databases.mp4 (6.23 MB)
MP4
1 What is fail-safe What are its advantages.mp4 (6.23 MB)
MP4
2 How will you measure how much of data from your tables is in fail-safe and.mp4 (11.19 MB)
MP4
3 Do transient and temporary tables have time-travel.mp4 (2.23 MB)
MP4
1 What is zero Copy Cloning ,What are its advantages over create table as select.mp4 (9.94 MB)
MP4
2 When cloning a table do the grants get copied over.mp4 (22.04 MB)
MP4
3 When cloning a table do the cluster Keys get copied over.mp4 (3.91 MB)
MP4
4 In your project did you use Zero Copy cloning ,Scenario Question.mp4 (8.48 MB)
MP4
5 Lets us say that data in your production table was accidentally updated how.mp4 (8.12 MB)
MP4
6 You have a table in a snowflake prod account and want to clone it and bring.mp4 (15.37 MB)
MP4
7 If I clone a table and update the clone will the original table get updated.mp4 (5.45 MB)
MP4
1 What is the maximum number of clusters you can have in a cluster.mp4 (5.19 MB)
MP4
2 What kind of scaling policy do you use on your project.mp4 (6.65 MB)
MP4
3 What is scaling up vs scaling out.mp4 (9.15 MB)
MP4
4 What is the auto suspension time period you use on the warehouse used in.mp4 (9.35 MB)
MP4
1 What is data unloading.mp4 (13.86 MB)
MP4
2 When unloading data into cloud storage what best practices do you use.mp4 (29.22 MB)
MP4
3 Was there a scenario in your project where you had to unload the data to.mp4 (19.53 MB)
MP4
4 Do you prefer unloading data into multiple files or single file from snowflake.mp4 (12.35 MB)
MP4
5 Can you unload data from multiple tables in a COPY command.mp4 (22.21 MB)
MP4
6 How are parquet files zipped when being unloaded.mp4 (21.01 MB)
MP4
7 How do we modify column data types when unloading data.mp4 (20.38 MB)
MP4
8 What problems have you encountered when unloading data.mp4 (9.96 MB)
MP4
9 How can you limit the size of a file generated by unloading data from snowflake.mp4 (26.29 MB)
MP4
1 What is a secure view Why would you create a secure view.mp4 (9.45 MB)
MP4
2 Have you created a data share and shared data in your project.mp4 (2.68 MB)
MP4
3 What are reader Accounts Have you created reader accounts in your project.mp4 (6.93 MB)
MP4
4 What objects can we share in snowflake.mp4 (2.05 MB)
MP4
1 How can you reduce storage cost on your project.mp4 (12.76 MB)
MP4
2 What are the best practices that we can follow to reduce credit consumption.mp4 (14.94 MB)
MP4
1 What is the max data storage capacity of snowflake.mp4 (2.95 MB)
MP4
1 How do you protect sensitive data like Date of Birth and SSN# from being.mp4 (19.04 MB)
MP4
2 What is Dynamic Data Masking.mp4 (8.42 MB)
MP4
3 What is ROW ACCESS Policy In Snowflake.mp4 (6.8 MB)
MP4
1 Do you use transformation when loading data using the COPY command.mp4 (7.04 MB)
MP4
2 What is needed to establish connectivity between snowflake and cloud storage.mp4 (13.35 MB)
MP4
3 How can we ingest data without using snowpipe, COPY or 3rd party ETL like DBT.mp4 (6.69 MB)
MP4
4 You received files from your new vendor, you are aware of the layout of.mp4 (11.94 MB)
MP4
5 How will you setup a process of automatic validation and quality control of.mp4 (8.37 MB)
MP4
6 Once a file is loaded with the COPY command can you reload the file again.mp4 (9.03 MB)
MP4
7 What is the data loading strategy in your project.mp4 (20.34 MB)
MP4
8 When ingesting data from data lake, are most of your files in parquet format.mp4 (26.9 MB)
MP4
1 Can you unload data from a relational table to a JSON stage with the COPY.mp4 (5.44 MB)
MP4
2 What data type do you recommend to store JSON and XML data.mp4 (3.47 MB)
MP4
3 Can you explain a scenario in your project where you needed to use variant.mp4 (8.73 MB)
MP4
4 What are the semi-structured data types supported by snowflake.mp4 (8.84 MB)
MP4
5 What does the flatten command do.mp4 (6.34 MB)
MP4
1 What is query acceleration How can you enable query acceleration.mp4 (2.55 MB)
MP4
2 What is QUERY ACCLERATION MAX SCALE FACTOR.mp4 (5.03 MB)
MP4
3 What is memory spillage.mp4 (5.94 MB)
MP4
4 How will you fix memory spillage issues.mp4 (10.98 MB)
MP4
5 What is partition pruning or query pruning in snowflake.mp4 (6.41 MB)
MP4
6 What is metadata cache.mp4 (5.26 MB)
MP4
7 What is the difference between automatic clustering and manually clustering.mp4 (10.16 MB)
MP4
8 You suspect that queries are waiting to get picked up by a warehouse to be.mp4 (10.48 MB)
MP4
1 What is an External Table in Snowflake Why would you use it in your project.mp4 (33.06 MB)
MP4
2 What does the alter external table tablename refresh do.mp4 (19.47 MB)
MP4
1 What is a materialized view.mp4 (14.15 MB)
MP4
10 In what scenario will you create a materialized view.mp4 (20.48 MB)
MP4
2 How will you determine if a materialized view is fully refreshed.mp4 (13.22 MB)
MP4
3 Can a materialized view return stale data.mp4 (7.45 MB)
MP4
4 You need to suspend use of a mat view as you plan to bulk load the base.mp4 (12.81 MB)
MP4
5 What are the limitations of materialized view.mp4 (19.37 MB)
MP4
6 Can you Insertupdate a materialized view.mp4 (7.42 MB)
MP4
7 You have been requested to create a mat view on a table which changes.mp4 (14.51 MB)
MP4
8 What would happen if you add or drop columns on a table that has a material.mp4 (16.51 MB)
MP4
9 Can materialized views be clustered.mp4 (12.57 MB)
MP4
1 What are Dynamic Tables.mp4 (9.3 MB)
MP4
2 What parameter controls how frequently a dynamic table is refreshed.mp4 (13.5 MB)
MP4
3 What are the refresh types supported by Dynamic tables.mp4 (13.06 MB)
MP4
4 What is the difference between a Dynamic table and view Why not use a view.mp4 (8.45 MB)
MP4
5 What is the difference between a Dynamic table and Materialized view Why not.mp4 (7.6 MB)
MP4
6 Can you update a Dynamic table using DML.mp4 (2.95 MB)
MP4
7 Can you explain a scenario in your project where you used Dynamic tables.mp4 (13.07 MB)
MP4
8 What are the limitations of Dynamic tables.mp4 (14.28 MB)
MP4
9 How can you monitor Dynamic tables.mp4 (17.85 MB)
MP4
1 Can you explain what the Qualify Keyword does in Snowflake SQL.mp4 (24.57 MB)
MP4
2 How can you change rows to columns in Snowflake.mp4 (11.11 MB)
MP4
3 How can you change columns to rows in Snowflake.mp4 (8.88 MB)
MP4
4 What does the DATE PART function do.mp4 (16.42 MB)
MP4
5 What does the DATE FROM PARTS function do.mp4 (6.86 MB)
MP4
6 Explain the SPLIT PART function.mp4 (9.14 MB)
MP4
7 SELECT GREATEST(2,13,NULL) , what is the expected answer for this.mp4 (3.92 MB)
MP4
8 SELECT O CUSTKEY, COUNT() FROM ORDERS GROUP BY ALL, is this a valid query.mp4 (5.2 MB)
MP4
9 What does the function ARRAY AGG do.mp4 (4.31 MB)
MP4
1 What is a Hybrid Table What are its main features.mp4 (9.32 MB)
MP4
2 What is Unistore and what does Hybrid tables have to do with Unistore.mp4 (10.81 MB)
MP4
3 How are Hybrid tables different from other table types like permanent table.mp4 (10.95 MB)
MP4
4 Is Snowflake Architecture different for Hybrid Tables.mp4 (9.81 MB)
MP4
5 Lab Exercise-Create Hybrid Tables and Insert Rows in them.mp4 (26.28 MB)
MP4
1 How to handle questions you dont know.mp4 (22.51 MB)
MP4
2 How to increase the interviewers confidence in you.mp4 (20.99 MB)
MP4
1 Mock Interview Ravi(Interviewer) Vs Sujith(Data Engineer).mp4 (137.33 MB)
MP4
1 You want to truncate a table in snowflake, can you use a UDF to do so.mp4 (5.75 MB)
MP4
2 What are the benefit of using stored procedure and UDF.mp4 (12.74 MB)
MP4
3 Have you created stored procedures in your project, what dd you use them for.mp4 (3.45 MB)
MP4
4 What language does snowflake UDF support.mp4 (4 MB)
MP4
1 Can we send emails from Snowflake.mp4 (9.23 MB)
MP4
2 In your project do you use snowflake to send emails.mp4 (3.52 MB)
MP4
3 Why do you use airflow instead of using tasks to schedule jobs in snowflake.mp4 (9.44 MB)
MP4
1 In which scenario is using snowpipe not recommended in snowflake.mp4 (13.7 MB)
MP4
2 Why would you use snowpipe instead of batch job in your project data load.mp4 (3.53 MB)
MP4
3 There are several files in cloud storage that was received 11 days ago, you.mp4 (15.01 MB)
MP4
4 What is snowpipe What are its advantages.mp4 (17.2 MB)
MP4
5 How do we pause execution of a pipe which is skipping files due to data issues.mp4 (9.64 MB)
MP4
6 What are the steps for setting up Snowpipe.mp4 (9.53 MB)
MP4
7 Provide me a scenario in your project where you used snowpipe.mp4 (7.62 MB)
MP4
8 How can you monitor and troubleshoot snowpipe errors.mp4 (46.74 MB)
MP4
9 Due to a few bad rows in the file your snowpipe load is skipping files How.mp4 (4.83 MB)
MP4
1 What is a task , What are its advantages.mp4 (18.67 MB)
MP4
2 How can you monitor tasks in snowflake.mp4 (53.46 MB)
MP4
3 When a task is created is it Active or inactive by Default.mp4 (16.82 MB)
MP4
4 What would happen if we created a task without a warehouse.mp4 (30.68 MB)
MP4
5 What is the maximum Number of tasks that a DAG can have +1.mp4 (13.53 MB)
MP4
6 You changed a table column causing a task to fail, how will you handle it.mp4 (8.79 MB)
MP4
7 Explain a scenario in your project where you have used tasks 3 Use Cases.mp4 (31.02 MB)
MP4
8 How will you find dependency information between tasks on a tree of tasks.mp4 (50.69 MB)
MP4
1 What is a resource monitor How would you ensure that a badly written query.mp4 (9.88 MB)
MP4
2 How many Resource monitors can you have in your account.mp4 (16.47 MB)
MP4
3 What actions can be taken inside a resource monitor.mp4 (9.93 MB)
MP4
1 How big is your snowflake data warehouse.mp4 (3.56 MB)
MP4
2 How do you generate PK for tables in snowflake.mp4 (11.56 MB)
MP4
3 We have a table called customer in QA and we need to compare data in it with.mp4 (6.3 MB)
MP4
4 For staging tables being truncated daily what table type do you prefer.mp4 (4.9 MB)
MP4
5 Can I create permanent tables in a transient schema.mp4 (10.76 MB)
MP4
6 Does snowflake support constraints.mp4 (14.63 MB)
MP4
1 What is a stage in snowflake.mp4 (2.97 MB)
MP4
2 In what scenario do you see the need for project to use internal stage.mp4 (3.12 MB)
MP4
3 How can you determine how many files are there in a stage.mp4 (1.93 MB)
MP4
4 What are the different type of internal stages in snowflake.mp4 (6.25 MB)
MP4
5 How can you add, download and remove files from an Internal Stage.mp4 (4.28 MB)
MP4
6 You have 100 files on a server which is on premises that you want to upload to.mp4 (6.74 MB)
MP4