Smartly Prepare Exam with Free Online SnowPro-Advanced-Architect Practice Test

A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)

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;

It is recommended to assign ACCOUNTADMIN role to atleast two user

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

Where can you define the file format settings?