London Stock Exchange Group Snowflake Developer Interview Questions and Answers

Streams in Snowflake are continuous flows of data that can be consumed in real-time for processing and analysis.

• Streams capture changes made to a table and make them available for processing in real-time.

• They can be used to implement CDC (Change Data Capture) solutions.

• Streams can be created using the CREATE STREAM statement.

• Example: CREATE STREAM my_stream ON TABLE my_table;

Data migration from on-premises to cloud data warehouse involves transferring data from local servers to a cloud-based storage solution.

• Assess current data sources and structures on-premises

• Select appropriate cloud data warehouse solution (e.g. Snowflake)

• Plan data migration strategy including data extraction, transformation, and loading (ETL)

• Test data migration process thoroughly before full implementation

• Monitor and o

Clustering keys in Snowflake help improve query performance by organizing data in a specific order.

• Clustering keys determine the physical order of data in Snowflake tables.

• They are defined at the table level and can be set during table creation or altered later.

• Clustering keys can be single or composite, and should be chosen based on the most commonly used columns in queries.

• They help reduce the amount of data scanned ...read more