Question No : 1
Which of the following are options when creating a Virtual Warehouse?

• A.Auto-suspend
• B.Auto-resume
• C.Local SSD size
• D.User count

Show Answers

Answer:

Question No : 2
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

• A.Load files that are approximately 25 MB or smaller.
• B.Remove all dates and timestamps.
• C.Load files that are approximately 100-250 MB (or larger)
• D.Avoid using embedded characters such as commas for numeric data types
• E.Remove semi-structured data types

Show Answers

Answer:
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

Question No : 3
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

• A.True
• B.False

Show Answers

Answer:
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

Question No : 4
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

• A.Concurrency
• B.Performance

Show Answers

Answer:
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

Question No : 5
What is the default File Format used in the COPY command if one is not specified?

• A.CSV
• B.JSON
• C.Parquet
• D.XML

Show Answers

Answer:
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

Question No : 6
Will data cached in a warehouse be lost when the warehouse is resized?

• A.Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
• B.Yes. because the compute resource is replaced in its entirety with a new compute resource.
• C.No. because the size of the cache is independent from the warehouse size
• D.Yes. became the new compute resource will no longer have access to the cache encryption key

Show Answers

Answer:

Question No : 7
Which of the following statement is true of Snowflake?

• A.It was built specifically for the cloud
• B.it was built as an on-premises solution and then potted to the cloud
• C.It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
• D.It was built for Hadoop architecture
• E.It's based on an Oracle Architecture

Show Answers

Answer:

Question No : 8
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

• A.True
• B.False

Show Answers

Answer:
Explanation:
Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

Question No : 9
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

• A.The Pipe load history is reset to empty
• B.The REFRESH parameter is set to TRUE
• C.Previously loaded files will be ignored
• D.All of the above

Show Answers

Answer:
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history
"When a pipe is recreated, the load history is dropped."

Question No : 10
Which command can be used to load data into an internal stage?

• A.LOAD
• B.copy
• C.GET
• D.PUT

Show Answers

Answer:
Explanation:
https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9