Free Practice Snowflake SnowPro-Advanced-Architect Exam Questions 2026

A Snowflake Architect is writing a User-Defined Function (UDF) with some unqualified object names.

How will those object names be resolved during execution?

What is the data size limit for loading into a variant column?

For which use cases, will you use cross-cloud and cross-region replication?

A new table and streams are created with the following commands: CREATE OR REPLACE TABLE LETTERS (ID INT, LETTER STRING) ; CREATE OR REPLACE STREAM STREAM_1 ON TABLE LETTERS; CREATE OR REPLACE STREAM STREAM_2 ON TABLE LETTERS APPEND_ONLY = TRUE; The following operations are processed on the newly created table: INSERT INTO LETTERS VALUES (1, 'A'); INSERT INTO LETTERS VALUES (2, 'B'); INSERT INTO LETTERS VALUES (3, 'C'); TRUNCATE TABLE LETTERS; INSERT INTO LETTERS VALUES (4, 'D'); INSERT INTO LETTERS VALUES (5, 'E'); INSERT INTO LETTERS VALUES (6, 'F'); DELETE FROM LETTERS WHERE ID = 6; What would be the output of the following SQL commands, in order? SELECT COUNT (*) FROM STREAM_1; SELECT COUNT (*) FROM STREAM_2;

Which are the two VARIANT columns each schema has in every Snowflake table loaded by the Kafka connector? (Choose two.)