Getting Started with Snowflake. Queries,
Dashboards, & Tables Questions and
Answers
What is the name of Snowflake's new user experience? – answer Snow sight
SELECT * FROM CUSTOMERS WHERE NAME LIKE "Ma%";
Which values will this query return? – answer Madison
MADISON
How can you create a chart in the Snowflake dashboard (assume you are using Snow
sight)? - answer Create a query and create charts from its result
Snowflake has various account-level credentials. These include the organization,
region, account ID, and locator. Which combinations of these account-level credentials
can Snowflake use to identify an account? - answer Organization and account ID
Locator and region
Which statements about temporary database constructs are true? - answer Temporary
tables exist only as long as their associated session
Snowflake allows temporary tables but not temporary schemas or databases
Which Snowflake construct can you use to group data by date values and perform
aggregations based on that grouping? - answerdatebucket
Which statements about micro-partitions are true? - answerThe micro partitions can
contain overlapping values
The micro partitions are between 50-500 MB in size
Which types of tables can you clone temporary tables to? - answerTemporary tables
Transient tables
You have run a query outputting a categorical field in Snowsight. Which details can you
view about this field in the pane next to the output? - answerThe percentage of data that
is null
The cardinality of the data
Which types of tables can you clone transient tables to? - answerTemporary tables
Transient tables
Dashboards, & Tables Questions and
Answers
What is the name of Snowflake's new user experience? – answer Snow sight
SELECT * FROM CUSTOMERS WHERE NAME LIKE "Ma%";
Which values will this query return? – answer Madison
MADISON
How can you create a chart in the Snowflake dashboard (assume you are using Snow
sight)? - answer Create a query and create charts from its result
Snowflake has various account-level credentials. These include the organization,
region, account ID, and locator. Which combinations of these account-level credentials
can Snowflake use to identify an account? - answer Organization and account ID
Locator and region
Which statements about temporary database constructs are true? - answer Temporary
tables exist only as long as their associated session
Snowflake allows temporary tables but not temporary schemas or databases
Which Snowflake construct can you use to group data by date values and perform
aggregations based on that grouping? - answerdatebucket
Which statements about micro-partitions are true? - answerThe micro partitions can
contain overlapping values
The micro partitions are between 50-500 MB in size
Which types of tables can you clone temporary tables to? - answerTemporary tables
Transient tables
You have run a query outputting a categorical field in Snowsight. Which details can you
view about this field in the pane next to the output? - answerThe percentage of data that
is null
The cardinality of the data
Which types of tables can you clone transient tables to? - answerTemporary tables
Transient tables
