SnowPro Certification Study Guide ; Questions & Answers

SnowPro Certification Study Guide ; Questions &
Answers
What is the best way to store semi-structured data? Correct Ans-Data should be loaded

and stored in a VARIANT type column




What is the best practice for handling semi-structured data with 3rd party BI tools? Correct

Ans-Create a Snowflake view that parse the semi-structured column into structure columns

for the BI tool to retrieve




True or False: Micro-partitions are immutable? Correct Ans-True - subsequent changes of

any type to the data will be written to additional micro-partitions




A Snowflake mechanism that is used to limit the number of micro-partitions scanned by a

query is called ________? Correct Ans-Pruning




What command is used to load files into an Internal Stage within Snowflake?


A. PUT


B. COPY INTO


C. TRANSFER


D. INSERT Correct Ans-A. PUT

, SnowPro Certification Study Guide ; Questions &
Answers

When loading data into Snowflake, the COPY command supports:


Choose 2 answers


A. Joins


B. Fitters


C. Data type conversions


D. Column reordering


E. Aggregates Correct Ans-C. Data Type Conversion & D. Column Reordering




True or False: Snowpipe via RFST API can only reference External Stages as source. Correct

Ans-A. True




On which of the following cloud platform can a Snowflake account be hosted?


Choose 2 answers


A. Amazon Web Services


B. Private Virtual Cloud


C. Oracle Cloud

, SnowPro Certification Study Guide ; Questions &
Answers
D. Microsoft Azure Cloud Correct Ans-A. Amazon Web Services & D. Microsoft Azure Cloud




How would you execute a series of SQL statements using Task?


A. include the SQL statements in the body of the task create task mytask.. as insert into

target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1

where ..


B. A stored procedure can have only one DML statement per stored procedure invocation and

therefore you should sequence stored procedures calls in the task definition CREATE TASK

mytask.... AS call stored_prc1(); call stored_proc2t);


C. A stored procedure executing multiple SQL statements and invoke the stored procedure

from the task. CREATE TASK mytask.... AS callstored_proc_multiple_statements_inside():


D. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the

series of SQL statements by having a control taskcalling task 1, task 2 sequentially. Correct

Ans-C




True or False: Snowflake charges a premium for storing semi-structured data. Correct Ans-

False

, SnowPro Certification Study Guide ; Questions &
Answers
What are the three things customers want most from their enterprise data warehouse

solution?


Choose 3 answers




A. On-premise availability


B. Simplicity


C. Open source based


D. Concurrency


E. Performance Correct Ans-B, D, E




Which of the following are true of multi-cluster Warehouses? Select all that apply below.




A. A multi-cluster Warehouse can add clusters automatically based on query activity


B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity


C. A multi-cluster Warehouse can scale down when query activity slows


D. A multi-cluster Warehouse can automatically turn itself on when a query is executed

against it Correct Ans-A, B, C, D