Snowpro Core Certification Exam; Questions and
Answers Already Passed
Snowflake can import semi-structured data from what formats? Correct Ans-1.JSON
2.Avro
3.ORC
4.Parquet
5.XML
Semi-structured data is typically stored in what Snowflake data types? Describe each.
Correct Ans-1.ARRAY: similar to an array in other languages
2.OBJECT: similar to a JSON object, also called a "dictionary", "hash", or "map" in many
languages. This contains key-value pairs.
3.VARIANT: a data type that can hold a value of any other data type (including array and
object). It is used to build and store hierarchical data.
How are credits charged for warehouses? Correct Ans-Credit charges are calculated based
on:
1.The warehouse size
, Snowpro Core Certification Exam; Questions and
Answers Already Passed
2.The number of warehouses (if using multi-cluster warehouses)
3.The length of time each warehouse is running
Snowflake provides a mechanism for its customers to override its natural clustering
algorithms. This method is: Correct Ans-Clustering Keys
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
A. Custom
B. Economy
C. Optimized
D. Standard Correct Ans-B.Economy & D.Standard
True or False: A single database can exist in more than one Snowflake account. Correct
Ans-False
, Snowpro Core Certification Exam; Questions and
Answers Already Passed
Which role is recommended to be used to create and manage users and roles? Correct
Ans-SECURITYADMIN
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
Correct Ans-True
What are the different types of Internal Stages? Correct Ans-1.Named Stage (Internal and
External)
2.User Stage
3.Table Stage
True or False: A customer using SnowSQL / native connectors will be unable to also use the
Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.
Correct Ans-False
Account-level storage usage can be monitored via: Correct Ans-The Snowflake Web
Interface (UI) in the Account -> Billing & Usage section
, Snowpro Core Certification Exam; Questions and
Answers Already Passed
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: Correct Ans-
Credits are charged based on the number of virtual warehouses you use, how long they run,
and their size.
What is clustering? Correct Ans-???
True or False: The COPY command must specify a File Format in order to execute. Correct
Ans-FALSE
What command sets the Virtual Warehouse for a session? Correct Ans-USE WAREHOUSE
<<warehouse name>>;
Which of the following objects can be cloned? (Choose four.)
A.Tables
B.Named File Formats
Answers Already Passed
Snowflake can import semi-structured data from what formats? Correct Ans-1.JSON
2.Avro
3.ORC
4.Parquet
5.XML
Semi-structured data is typically stored in what Snowflake data types? Describe each.
Correct Ans-1.ARRAY: similar to an array in other languages
2.OBJECT: similar to a JSON object, also called a "dictionary", "hash", or "map" in many
languages. This contains key-value pairs.
3.VARIANT: a data type that can hold a value of any other data type (including array and
object). It is used to build and store hierarchical data.
How are credits charged for warehouses? Correct Ans-Credit charges are calculated based
on:
1.The warehouse size
, Snowpro Core Certification Exam; Questions and
Answers Already Passed
2.The number of warehouses (if using multi-cluster warehouses)
3.The length of time each warehouse is running
Snowflake provides a mechanism for its customers to override its natural clustering
algorithms. This method is: Correct Ans-Clustering Keys
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
A. Custom
B. Economy
C. Optimized
D. Standard Correct Ans-B.Economy & D.Standard
True or False: A single database can exist in more than one Snowflake account. Correct
Ans-False
, Snowpro Core Certification Exam; Questions and
Answers Already Passed
Which role is recommended to be used to create and manage users and roles? Correct
Ans-SECURITYADMIN
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
Correct Ans-True
What are the different types of Internal Stages? Correct Ans-1.Named Stage (Internal and
External)
2.User Stage
3.Table Stage
True or False: A customer using SnowSQL / native connectors will be unable to also use the
Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.
Correct Ans-False
Account-level storage usage can be monitored via: Correct Ans-The Snowflake Web
Interface (UI) in the Account -> Billing & Usage section
, Snowpro Core Certification Exam; Questions and
Answers Already Passed
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: Correct Ans-
Credits are charged based on the number of virtual warehouses you use, how long they run,
and their size.
What is clustering? Correct Ans-???
True or False: The COPY command must specify a File Format in order to execute. Correct
Ans-FALSE
What command sets the Virtual Warehouse for a session? Correct Ans-USE WAREHOUSE
<<warehouse name>>;
Which of the following objects can be cloned? (Choose four.)
A.Tables
B.Named File Formats
