Try our Free Demo Practice Tests for Comprehensive SnowPro-Advanced-Architect Exam Preparation

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided? 

An Architect needs to meet a company requirement to ingest files from the company's AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account. How can the ingestion of these files into the company's Snowflake account be initiated? (Select 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;