Question 1

A company has built a data pipeline using Snowpipe to ingest files from an Amazon S3 bucket. Snowpipe is configured to load data into staging database tables. Then a task runs to load the data from the staging database tables into the reporting database tables. The company is satisfied with the availability of the data in the reporting database tables, but the reporting tables are not pruning effectively. Currently, a size 4X-Large virtual warehouse is being used to query all of the tables in the reporting database. What step can be taken to improve the pruning of the reporting tables?

Options :

A : Eliminate the use of Snowpipe and load the files into internal stages using PUT commands.

B : Increase the size of the virtual warehouse to a size 5X-Large.

C :

D : Create larger files for Snowpipe to ingest and ensure the staging frequency does not exceed 1 minute.

Answer: C

Question 2

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

Options :

A : CSV

B : XML

C : Avro

D : JSON

E : Parquet

Answer: C,D

Question 3

During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?

Options :

A : Snowpipe loads duplicate data into the source table

B : Data loading will fail when the snowpipe is triggered

C : All the files will be loaded into stage again

Answer: A

Question 4

A table, EMP_ TBL has three records as shown: The following variables are set for the session:Which SELECT statements will retrieve all three records? (Select TWO).

Options :

A : Select * FROM Stbl_ref WHERE Scol_ref IN ('Name1','Nam2','Name3');

B : SELECT * FROM EMP_TBL WHERE identifier(Scol_ref) IN ('Namel','Name2', 'Name3');

C : SELECT * FROM identifier WHERE NAME IN ($var1, $var2, $var3);

D : SELECT * FROM identifier($tbl_ref) WHERE ID IN Cvarl','var2','var3');

E : SELECT * FROM $tb1_ref WHERE $col_ref IN ($var1, Svar2, Svar3);

Answer: B,E

Question 5

A user needs access to create materialized view on a shema mydb.myschema. What is the appropriate command to provide the access?

Options :

A : GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

B : GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

C : GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

Answer: A

Free SnowPro-Advanced-Architect Mock Exam – Practice Online Confidently

Buying Options: