Snowflake Snow Pro Certification Exam
Questions with Solutions
Partitioning - answer Snowflake manages micro-partitions and clustering under the
hood. These tasks are performed automatically by Snowflake and thus there are no
action items for developers to take.
If you find that you do need additional query speed, you can manipulate the cluster keys
for micro partitions using the ALTER TABLE ... CLUSTER BY () command.
Clustering Keys & Clustered Tables - answer In general, Snowflake automatically
produces well-clustered data in tables; however, over time, particularly as DML occurs
on very large tables (as defined by the amount of data in the table, not the number of
rows), the data in some table rows may no longer cluster optimally on desired
dimensions.
Snowflake supports addressing this issue by allowing the architect to designate one or
more table columns/expressions as a clustering key for the table. You should only
consider over-riding Snowflake's default clustering approach, for tables which are more
than 2 TB in size.
True or False: A single database can exist in more than one Snowflake account. -
answerFALSE
Which of the following roles is recommended to be used to create and manage users
and roles? - answerACCOUNTADMIN
To run a Multi-Cluster Warehouse in auto-scale mode, a user would: - answerSet the
Minimum Clusters and Maximum Clusters settings to the different values
Scaling Policy Types - answerStandard and Economy
Which of the following objects is not covered by Time Travel?
- Tables
- Schemas
- Databases
- Stages - answerStages
When can a Virtual Warehouse start running queries?
- 12am-5am
- Only during administrator defined time slots
- When its provisioning is complete
,- After replication - answerOnly during administrator defined time slots
True or False: Pipes can be suspended and resumed. - answerFALSE
As best practice, clustering keys should only be defined on tables of which minimum
size?
- Multi-Kilobyte (KB) range
- Multi-Megabyte (MB) range
- Multi-Gigabyte (GB) range
- Multi-Terabyte (TB) range - answerMulti-Terabyte (TB) range
Which is the lowest Snowflake edition that offers time travel up to 90 days? -
answerEnterprise Edition
True or False: A third-party tool that supports standard JDBC or ODBC but has no
Snowflake-specific driver will be unable to connect to Snowflake. - answerTRUE
Which of the following objects can be cloned:
- Tables
- Named File Formats
- Schemas
- Shares
- Databases
- Users - answer- Tables
- Schemas
- Databases
- Users
Which of the following commands are not blocking operations?
- UPDATE
- INSERT
- MERGE
- COPY - answer- INSERT
- COPY
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT
statement. - answerFALSE
True or False: A table in Snowflake can only be queried using the Virtual Warehouse
that was used to load the data. - answerFALSE
What parameter controls if the Virtual warehouse starts immediately after the CREATE
WAREHOUSE statement?
- INITIALLY_SUSPENDED = TRUE/FALSE
- START_AFTER_CREATE = TRUE/FALSE
- START_TIME = 60 // (seconds from now)
, - START_TIME = CURRENT_DATE() - answerINITIALLY_SUSPENDED =
TRUE/FALSE
Which of the following statements would be used to export/unload data from
Snowflake?
- COPY INTO @stage
- EXPORT TO @stage
- INSERT INTO @stage
- EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1); - answerCOPY
INTO @stage
Which of the following statements about data sharing are true? choose 2 answers
- New objects created by a Data Provider are automatically shared with existing Data
Consumers & Reader Accounts
- All database objects can be included In a shared database
- Reader Accounts are created and funded by Data Prowlers
- Shared databases are read-only - answer- Reader Accounts are created and funded
by Data Prowlers
- Shared databases are read-only
On which of the following cloud platform can a Snowflake account be hosted? Choose 2
answers
- Amazon Web Services
- Private Virtual Cloud
- Oracle Cloud
- Microsoft Azure Cloud - answer- Amazon Web Services
- Microsoft Azure Cloud
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated
with different roles, databases, schemas, and Virtual Warehouses. - answerTRUE
What services does Snowflake automatically provide for customer that they may have
been responsible for with their on premise system? Select all the below that apply.
- Installing and configuring hardware
- Patching software
- Physical security
- Maintaining metadata and statists - answer- Patching software
- Maintaining metadata and statists
What is the maximum compressed row size in Snowflake?
- 8KB
- 16MB
- 50MB
- 4000GB - answer16MB
Questions with Solutions
Partitioning - answer Snowflake manages micro-partitions and clustering under the
hood. These tasks are performed automatically by Snowflake and thus there are no
action items for developers to take.
If you find that you do need additional query speed, you can manipulate the cluster keys
for micro partitions using the ALTER TABLE ... CLUSTER BY () command.
Clustering Keys & Clustered Tables - answer In general, Snowflake automatically
produces well-clustered data in tables; however, over time, particularly as DML occurs
on very large tables (as defined by the amount of data in the table, not the number of
rows), the data in some table rows may no longer cluster optimally on desired
dimensions.
Snowflake supports addressing this issue by allowing the architect to designate one or
more table columns/expressions as a clustering key for the table. You should only
consider over-riding Snowflake's default clustering approach, for tables which are more
than 2 TB in size.
True or False: A single database can exist in more than one Snowflake account. -
answerFALSE
Which of the following roles is recommended to be used to create and manage users
and roles? - answerACCOUNTADMIN
To run a Multi-Cluster Warehouse in auto-scale mode, a user would: - answerSet the
Minimum Clusters and Maximum Clusters settings to the different values
Scaling Policy Types - answerStandard and Economy
Which of the following objects is not covered by Time Travel?
- Tables
- Schemas
- Databases
- Stages - answerStages
When can a Virtual Warehouse start running queries?
- 12am-5am
- Only during administrator defined time slots
- When its provisioning is complete
,- After replication - answerOnly during administrator defined time slots
True or False: Pipes can be suspended and resumed. - answerFALSE
As best practice, clustering keys should only be defined on tables of which minimum
size?
- Multi-Kilobyte (KB) range
- Multi-Megabyte (MB) range
- Multi-Gigabyte (GB) range
- Multi-Terabyte (TB) range - answerMulti-Terabyte (TB) range
Which is the lowest Snowflake edition that offers time travel up to 90 days? -
answerEnterprise Edition
True or False: A third-party tool that supports standard JDBC or ODBC but has no
Snowflake-specific driver will be unable to connect to Snowflake. - answerTRUE
Which of the following objects can be cloned:
- Tables
- Named File Formats
- Schemas
- Shares
- Databases
- Users - answer- Tables
- Schemas
- Databases
- Users
Which of the following commands are not blocking operations?
- UPDATE
- INSERT
- MERGE
- COPY - answer- INSERT
- COPY
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT
statement. - answerFALSE
True or False: A table in Snowflake can only be queried using the Virtual Warehouse
that was used to load the data. - answerFALSE
What parameter controls if the Virtual warehouse starts immediately after the CREATE
WAREHOUSE statement?
- INITIALLY_SUSPENDED = TRUE/FALSE
- START_AFTER_CREATE = TRUE/FALSE
- START_TIME = 60 // (seconds from now)
, - START_TIME = CURRENT_DATE() - answerINITIALLY_SUSPENDED =
TRUE/FALSE
Which of the following statements would be used to export/unload data from
Snowflake?
- COPY INTO @stage
- EXPORT TO @stage
- INSERT INTO @stage
- EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1); - answerCOPY
INTO @stage
Which of the following statements about data sharing are true? choose 2 answers
- New objects created by a Data Provider are automatically shared with existing Data
Consumers & Reader Accounts
- All database objects can be included In a shared database
- Reader Accounts are created and funded by Data Prowlers
- Shared databases are read-only - answer- Reader Accounts are created and funded
by Data Prowlers
- Shared databases are read-only
On which of the following cloud platform can a Snowflake account be hosted? Choose 2
answers
- Amazon Web Services
- Private Virtual Cloud
- Oracle Cloud
- Microsoft Azure Cloud - answer- Amazon Web Services
- Microsoft Azure Cloud
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated
with different roles, databases, schemas, and Virtual Warehouses. - answerTRUE
What services does Snowflake automatically provide for customer that they may have
been responsible for with their on premise system? Select all the below that apply.
- Installing and configuring hardware
- Patching software
- Physical security
- Maintaining metadata and statists - answer- Patching software
- Maintaining metadata and statists
What is the maximum compressed row size in Snowflake?
- 8KB
- 16MB
- 50MB
- 4000GB - answer16MB
