True or False: Snowflake charges a premium for storing semi-structured data.
A.
True
B.
False
False
Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/doessnowflakechargespremium-
for-storing-semi-structured-data
True or False: You can define multiple columns within a clustering key on a table.
A.
True
B.
False
True
Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse
is started.
A.
True
B.
False
False
Reference: https://docs.snowflake.com/en/user-guide/credits.html
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
A.
Customers can change the size of the Warehouse after creation
B.
A Warehouse can be resized while running
C.
A Warehouse can be configured to suspend after a period of inactivity
D.
A Warehouse can be configured to auto-resume when new queries are submitted
Customers can change the size of the Warehouse after creation
A Warehouse can be resized while running
A Warehouse can be configured to suspend after a period of inactivity
A Warehouse can be configured to auto-resume when new queries are submitted
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
Which of the following statements is true of zero-copy cloning?
A.
Zero-copy clones objects inherit
B.
All zero-copy clone objects inherit the privileges of their original objects
C.
Zero-copy coning is licensed as an additional Snowflake feature
D.
At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.
At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.
Reference: https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copycloning-
base-data
How would you determine the size of the virtual warehouse used for a task?
A.
Root task may be executed concurrently (i.e. multiple instances), it is recommended to
leave some margins in the execution window to avoid missing instances of execution
B.
Querying (select) the size of the stream content would help determine the warehouse
size. For example, if querying large stream content, use a larger warehouse size
C.
If using the stored procedure to execute multiple SQL statements, it's best to test run the
stored procedure separately to size the compute resource first
D.
Since task infrastructure is based on running the task body on schedule, it's
recommended to configure the virtual warehouse for automatic concurrency handling using
If using the stored procedure to execute multiple SQL statements, it's best to test run the
stored procedure separately to size the compute resource first
Which of the following statements is true of Snowflake?
A.
It was built specifically for the cloud
B.
It was built as an on-premises solution and then ported 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
It was built specifically for the cloud
The Information Schema and Account Usage Share provide storage information for which
of the following objects? (Choose three.)
A.
Users
B.
Tables
C.
Databases
D.
Internal Stages
Users
Tables
Databases
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
A.
True
B.
False
False
Reference: https://metriccamp.com/snowflake/caching.html
Which formats are supported for unloading data from Snowflake?
Choose 2 answers
A.
Delimited (CSV, TSV, etc.)
B.
Avro
C.
JSON
D.
ORC
Delimited (CSV, TSV, etc.)
JSON
Copyright © - All Rights Reserved