Snowflake Test-5

The Snowflake SnowPro Core COF-C02 mock test builds confidence by preparing you for certification. It validates your Snowflake knowledge and demonstrates initiative. However, confidence alone won’t land you a job. Employers expect professionals to master Tableau, SQL, SAS, and Azure, while also gaining data engineering expertise in Snowflake, Databricks, and PySpark. Data science and AI skills in TensorFlow, PyTorch, LLMs, and Generative AI are equally critical. Project work is the ultimate proof of employability.

The SynergisticIT Data Science Job Placement Program ensures your confidence translates into career readiness. Explore more through the SynergisticIT Job Placement Program.

Welcome to your Snowflake Test-5

Name

Phone

Q1. Which are the 2 modes in which a multi cluster warehouse can run?

Select 2 option(s):

Minimized

Auto-Scale

Maximized

Balanced

Dynamic

Q2. Whenever the warehouse size is reduced or the number of clusters are decreated, the servers are always removed in reverse order of when they were added (LIFO – Last In First Out)

Select 1 option(s):

TRUE

FALSE

Q3. Which scaling policy, shut down the cluster after 2 to 3 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up the cluster again

Select 1 option(s):

Legacy

Standard

None

Economy

Q4. What all resources are provided by Virtual Warehouse?

Select 3 option(s):

Metadata Storage

CPU

Temporary Storage

Permanent Storage

Memory

Q5. In auto scale mode, if new_max_clusters < running clusters, then excess clusters shut down immediately

Select 1 option(s):

TRUE

FALSE

Q6. Multi-cluster warehouses are beneficial for improving the performance of slow-running queries or data loading

Select 1 option(s):

TRUE

FALSE

Q7. Snowflake utilizes per-second billing (with a 60-second minimum each time the warehouse starts)

Select 1 option(s):

TRUE

FALSE

Q8. How many servers are there in 2X large warehouse?

Select 1 option(s):

128

Q9. What happens when a suspended warehouse is resized (e.g. resized from small to medium)?

Select 1 option(s):

When size of a suspended warehouse is increased it starts the warehouse, and then suspends it back after provisioning additional servers

Additional Servers are added to the warehouse immediately even in suspended state

A suspended warehouse cannot be resized

Additional servers are provisioned only when the warehouse is next resumed

Q10. Each server in a warehouse cluster has:

Select 2 option(s):

Track of each query that was executed on that server

A position in the warehouse that is maintained, even when the warehouse is suspended or resized

An internal timer that tracks when each server was started

Q11. You can view the amount of storage used by failsafe under the Account->Billing & Usage section

Select 1 option(s):

TRUE

FALSE

Q12. Choose the answer which true about key rotation in snowflake

Select 1 option(s):

Only table master key is rotated by Snowflake

Account & Table master keys are automatically rotated by Snowflake when they are more than 30 days old

Only account master key is rotated by snowflake

Key rotation is an expensive operation, hence its done only on need basis

Q13. Method that Snowflake use to limit the number of micro-partitions accessed during a query is called as?

Select 1 option(s):

Indexing

Index Scan

Pruning

Cache Operations

Q14. Virtual Warehouse credits are charged on what basis?

Select 1 option(s):

per second use (with minimum charge of 1 minute)

per hour use

per milli second use

per minute use

per second use with no minimum charge

Q15. What are some general indicators that a clustering key is required on a table?

Select 2 option(s):

The table is being used in many queries

The size of the table is in multi terabytes

The query performance using that table has slowed down over a period of time

The table has many columns

Q16. Multifactor Authentication can be enabled for which of the following? Select all that Apply?

Select 3 option(s):

ODBC

Snowpipe

Python

Snowflake WebUI

Q17. You are a developer with in one company running a Snowflake data warehouse. You required to load JSON based data into a table. What is the best way to do it in snowflake?

Select 1 option(s):

Write a program in Java or Python to convert the JSON into tabular format and then load in Snowflake table

Create a table with variant column and load the json data into that table

Ask the source team to send data into CSV instead of JSON

Q18. A table has a data retention policy of 10 days. Few records in the table were modified 5 days before, and hence that data is already into 5 days of the time travel. Now if the data retention of the table is reduced to 3 days, what happens to the data that was in 5 days of time travel?

Select 1 option(s):

None is true

That data will remain in time travel for 10 days even if the retention period is reduced

The data will move to fail safe

The data would be removed completely (i.e. not even moved to fail safe)

Q19. Default Size of the warehouse created using Snowflake Web UI is

Select 1 option(s):

MEDIUM

SMALL

X-LARGE

X-SMALL

Q20. When the warehouse is resized (scaled up or out), then the additional servers that get added will be available for use by any queries that are queued or newly submitted

Select 1 option(s):

TRUE

FALSE

Q21. Which scaling policy, starts additional cluster only if the system estimates there is enough query load to keep the cluster busy for at least 6 minutes.

Select 1 option(s):

Legacy

None

Standard

Economy

Q22. How many credits per hour is consumed by a 3X large warehouse

Select 1 option(s):

128

Q23. If a server runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, it is billed for how many seconds?

Select 1 option(s):

120

121

Q24. If any of the servers for the warehouse fail to provision during start-up, Snowflake attempts to repair the failed server(s). During the repair process, the warehouse starts processing SQL statements only when a minimum of how much % of the requested servers are successfully provisioned

Select 1 option(s):

Q25. Snowflake does not begin executing SQL statements submitted to a warehouse until all of the servers for the warehouse are successfully provisioned, unless any of the servers fail to provision

Select 1 option(s):

TRUE

FALSE

Q26. Snowflake compute costs depend on which of the following?

Select 1 option(s):

The total number of warehouses in the account

The amount of time warehouses have run.

The sizes of running warehouses.

The number of rows returned in queries.

Q27. Multi-cluster warehouses are best utilized for scaling resources to improve concurrency for users/queries

Select 1 option(s):

TRUE

FALSE

Q28. True or false: A table in Snowflake can only be queried using the Virtual Warehouse used to load the data.

Select 1 option(s):

TRUE

FALSE

Q29. Scaling a warehouse OUT will increase the number of clusters. (e.g. Min to Max)

Select 1 option(s):

TRUE

FALSE

Q30. The columns in the query history include the QueryID, the SQL Text, the Warehouse name, the Warehouse Size, the Session ID and others. Which column is a good indicator of whether a Warehouse was used (and Compute costs incurred) by a query?

Select 1 option(s):

Warehouse Size

QueryID

Session ID

SQL Text

Warehouse Name

Q31. Scaling up of a warehouse can be done only in Enterprise edition and higher

Select 1 option(s):

FALSE

TRUE

Q32. Which scaling policy, shut down the cluster after 5 to 6 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up the cluster again

Select 1 option(s):

None

Economy

Legacy

Standard

Q33. In maximized mode, what happens if the number of clusers are decreased? (e.g. previously min & max was 4, but now min & max cluster size is changed to 2)

Select 1 option(s):

The number of clusters in maximized mode cannot be changed

Specified number of clusters shut down when they finish executing statements and the auto-suspend period elapses

Specified number of clusters shut down immediately, as soon as they finish executing statements

Q34. To restore the table by undrop command what all conditions should be met?

Select 3 option(s):

The table can be restored in any schema irrespective from whichever schema the table was dropped.

The table can be restored in same schema only from which it has been dropped

User executing undrop command should have ownership privilege on the table

User must have CREATE privileges on the schema in which table is getting restored

Q35. What is the benefit of client-side encryption in snowflake?

Select 1 option(s):

It provides a secure system for managing data in cloud storage

Helps in decrypting data faster when needed

None

Saves the cloud encryption cost

Q36. Restoring tables and schemas is only supported in the current schema or current database, even if a fully-qualified object name is specified.

Select 1 option(s):

TRUE

FALSE

Q37. When the files is uploaded to snowflake internal stage, files are automatically encrypted by the client on the local machine prior to being transmitted to the internal stage.

Select 1 option(s):

FALSE

TRUE

Q38. How many credits will be consumed if a Medium-size warehouse (4 servers per cluster) with 3 clusters runs in Auto Scale mode for 2 hours, where Cluster 1 runs continuously for 2 hours, Cluster 2 runs continously for 2nd hour only, Cluster 3 runs for 30 minutes only during 2nd hour

Select 1 option(s):

Q39. When a warehouse is suspended, the idle servers in that warehouse are immediately shut down, but any servers that are executing queries are allowed to run until the queries are completed. Such servers that are waiting to shut down are considered to be in which mode?

Select 1 option(s):

Quiet

Quiesce

Suspending

Shutting Down

Q40. Snowflake can load from data staged in which of the following?

Select 4 option(s):

Azure Blob Storage

Oracle Cloud Storage

VMWare Storage

Snowflake Internal Stage

Google Cloud Storage

AWS S3

Q41. Which one of the following stage can not be cloned?

Select 1 option(s):

Table Stage

Internal Named Stage

External Named Stage

Q42. If a transaction is running on a session and the session disconnects abruptly, the transaction will be in a detached state. It will not allow the transaction to commit or roll back. The locks on the resources will also not be released. If you do not do anything and let snowflake abort the transaction, how long will you need to wait?

Select 1 option(s):

2 Hours

4 Hours

15 Minutes

30 Minutes

1 Hour

Q43. Which of the following will not contribute to your account level storage usage?

Select 3 option(s):

Snowflake Internal Stage

UDF

Snowflake External Stages

Databases (and tables in it)

Views (Normal Views & Not Materialized Views)

Q44. Snowflake encrypts all customer data by default, using the latest security standards, and charges customer for this encryption

Select 1 option(s):

TRUE

FALSE

Q45. You want to get the clustering information for a table Tab1 that is clustered on column Col1. Which of the below queries will you run to get the details?

Select 1 option(s):

show clustering (‘Tab1‘) from clustering_info;

select system$clustering_information(‘Tab1‘);

Show clustering information for Tab1.Col1;

Q46. On the WebUI which button on the top bar should you select to see the query history?

Select 1 option(s):

Databases

Account

Warehouses

History

Q47. A warehouse can be assigned to only a single resource monitor.

Select 1 option(s):

TRUE

FALSE

Q48. Multi-factor Authentication can be used for connecting to Snowflake via the Snowflake JDBC driver

Select 1 option(s):

FALSE

TRUE

Q49. Cloud services also use compute. Does snowflake charge you for cloud services.

Select 1 option(s):

Cloud services are charged irrespective of the compute resource usage

Cloud services are charged only if it exceeds 20% of the daily usage of the compute resources

Snowflake never charges for cloud services

Cloud services are charged only if it exceeds 10% of the daily usage of the compute resources

Q50. Snowflake stores metadata about all rows stored in a micro-partition, including

Select 3 option(s):

The range of values for each of the columns in the micro-partition

The number of distinct values

Additional properties used for both optimization and efficient query processing

Mean & Standard deviation of each column

Q51. What ensures that all customer data, new and old, is encrypted with the latest security technology

Select 1 option(s):

Key Rotation

This has to be done by contacting snowflake support

Periodic Rekeying

None

Q52. select * from my_table at(offset => - 60*5) . This statement will return which period of historical data for the table?

Select 1 option(s):

60 minutes ago

10 minutes ago

5 hours ago

5 minutes ago

Q53. What happens If the TIMESTAMP, OFFSET, or STATEMENT specified in the AT | BEFORE clause of a SELECT statement falls outside the data retention period for the table?

Select 1 option(s):

The query fetches data from fail safe

The query returns no data

The query returns the oldest timestamp data that is available

The query fails and returns an error

Q54. Snowflake database is just based on the massively parallel shared nothing architecture used by data bases like Netezza, Teradata, Greenplum.

Select 1 option(s):

FALSE

TRUE

Q55. When a virtual warehouse is provisioned there is no benefit in stopping the virtual warehouse with in the first 60 seconds because that time period has already been billed.

Select 1 option(s):

TRUE

FALSE

Q56. The Snowflake credit usage for multi cluster virtual warehouses is based on

Select 1 option(s):

For multi cluster credits are always charged based on the maximum cluster size that is defined

Total Number of clusters running and for the time period they are running

For multi cluster credits are always charged based on the average cluster size that is defined

Q57. In the Snowflake Web UI which of the following is true?

Select 1 option(s):

Each open worksheet can have different role, warehouse and database selected

For all open worksheet the session is same

For all open worksheets same role, warehouse and database apply

Each open worksheet is a different session

Q58. The “load metadata“ (which maintains which files have already been loaded) for a table expires after how many days?

Select 1 option(s):

365

Q59. Storage fees are incurred for maintaining historical data during the Time Travel but not during Fail-safe periods as Fail safe is managed by Snowflake

Select 1 option(s):

FALSE

TRUE

Q60. When data is shared between Snowflake accounts, a database is created on the consumer side for sharing purposes. The type of this database is ?

Select 1 option(s):

Read & Update Only

Read Only

Read & Insert Only

Read & Delete Only

Q61. Snowflakes hierarchical key model consists of which four levels of keys:

Select 4 option(s):

Root Key

File Keys

Account Master Keys

Table Master Keys

User Keys

Role Keys

Q62. What is the correct way to find out virtual warehouse credit usage information in Snowflake?

Select 3 option(s):

Query WAREHOUSE_METERING_HISTORY in account usage schema

Query Warehouse_Credits table in ACCOUNT_USAGE Schema

Query Warehouse_Credits table in INFORMATION_SCHEMA

Query WAREHOUSE_METERING_HISTORY in INFORMATION_schema

Go to Account --> Billing & Usage in Web UI

Q63. On the WebUI which button on the top bar should you select to get to tabs that provide billing and credit information?

Select 1 option(s):

Administrator

Account

Billing Information

Credit Charge

Q64.Which of the following are valid parameters when create a new virtual warehouse?

Select 3 option(s):

RAM Size

Auto Suspend

Auto Resume

Warehouse Size

Type of EC2

CPU Counts

Q65. What happens when a table is shared by a snowflake account to another snowflake account? Select all that applies

Select 2 option(s):

Data is copied to the target snowflake account

Sharing of data is managed via Snowflake Metadata Services Layer

Target snowflake account is charged for data storage

No actual data is copied or transferred between the accounts

[/ppwp]

Snowflake Test-5

Q1. Which are the 2 modes in which a multi cluster warehouse can run?

Q2. Whenever the warehouse size is reduced or the number of clusters are decreated, the servers are always removed in reverse order of when they were added (LIFO – Last In First Out)

Q3. Which scaling policy, shut down the cluster after 2 to 3 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up the cluster again

Q4. What all resources are provided by Virtual Warehouse?

Q5. In auto scale mode, if new_max_clusters < running clusters, then excess clusters shut down immediately

Q6. Multi-cluster warehouses are beneficial for improving the performance of slow-running queries or data loading

Q7. Snowflake utilizes per-second billing (with a 60-second minimum each time the warehouse starts)

Q8. How many servers are there in 2X large warehouse?

Q9. What happens when a suspended warehouse is resized (e.g. resized from small to medium)?

Q10. Each server in a warehouse cluster has:

Q11. You can view the amount of storage used by failsafe under the Account->Billing & Usage section

Q12. Choose the answer which true about key rotation in snowflake

Q13. Method that Snowflake use to limit the number of micro-partitions accessed during a query is called as?

Q14. Virtual Warehouse credits are charged on what basis?

Q15. What are some general indicators that a clustering key is required on a table?

Q16. Multifactor Authentication can be enabled for which of the following? Select all that Apply?

Q17. You are a developer with in one company running a Snowflake data warehouse. You required to load JSON based data into a table. What is the best way to do it in snowflake?

Q18. A table has a data retention policy of 10 days. Few records in the table were modified 5 days before, and hence that data is already into 5 days of the time travel. Now if the data retention of the table is reduced to 3 days, what happens to the data that was in 5 days of time travel?

Q19. Default Size of the warehouse created using Snowflake Web UI is

Q20. When the warehouse is resized (scaled up or out), then the additional servers that get added will be available for use by any queries that are queued or newly submitted

Q21. Which scaling policy, starts additional cluster only if the system estimates there is enough query load to keep the cluster busy for at least 6 minutes.

Q22. How many credits per hour is consumed by a 3X large warehouse

Q23. If a server runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, it is billed for how many seconds?

Q24. If any of the servers for the warehouse fail to provision during start-up, Snowflake attempts to repair the failed server(s). During the repair process, the warehouse starts processing SQL statements only when a minimum of how much % of the requested servers are successfully provisioned

Q25. Snowflake does not begin executing SQL statements submitted to a warehouse until all of the servers for the warehouse are successfully provisioned, unless any of the servers fail to provision

Q26. Snowflake compute costs depend on which of the following?

Q27. Multi-cluster warehouses are best utilized for scaling resources to improve concurrency for users/queries

Q28. True or false: A table in Snowflake can only be queried using the Virtual Warehouse used to load the data.

Q29. Scaling a warehouse OUT will increase the number of clusters. (e.g. Min to Max)

Q30. The columns in the query history include the QueryID, the SQL Text, the Warehouse name, the Warehouse Size, the Session ID and others. Which column is a good indicator of whether a Warehouse was used (and Compute costs incurred) by a query?

Q31. Scaling up of a warehouse can be done only in Enterprise edition and higher

Q32. Which scaling policy, shut down the cluster after 5 to 6 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up the cluster again

Q33. In maximized mode, what happens if the number of clusers are decreased? (e.g. previously min & max was 4, but now min & max cluster size is changed to 2)

Q34. To restore the table by undrop command what all conditions should be met?

Q35. What is the benefit of client-side encryption in snowflake?

Q36. Restoring tables and schemas is only supported in the current schema or current database, even if a fully-qualified object name is specified.

Q37. When the files is uploaded to snowflake internal stage, files are automatically encrypted by the client on the local machine prior to being transmitted to the internal stage.

Q38. How many credits will be consumed if a Medium-size warehouse (4 servers per cluster) with 3 clusters runs in Auto Scale mode for 2 hours, where Cluster 1 runs continuously for 2 hours, Cluster 2 runs continously for 2nd hour only, Cluster 3 runs for 30 minutes only during 2nd hour

Q39. When a warehouse is suspended, the idle servers in that warehouse are immediately shut down, but any servers that are executing queries are allowed to run until the queries are completed. Such servers that are waiting to shut down are considered to be in which mode?

Q40. Snowflake can load from data staged in which of the following?

Q41. Which one of the following stage can not be cloned?

Q43. Which of the following will not contribute to your account level storage usage?

Q44. Snowflake encrypts all customer data by default, using the latest security standards, and charges customer for this encryption

Q45. You want to get the clustering information for a table Tab1 that is clustered on column Col1. Which of the below queries will you run to get the details?

Q46. On the WebUI which button on the top bar should you select to see the query history?

Q47. A warehouse can be assigned to only a single resource monitor.

Q48. Multi-factor Authentication can be used for connecting to Snowflake via the Snowflake JDBC driver

Q49. Cloud services also use compute. Does snowflake charge you for cloud services.

Q50. Snowflake stores metadata about all rows stored in a micro-partition, including

Q51. What ensures that all customer data, new and old, is encrypted with the latest security technology

Q52. select * from my_table at(offset => - 60*5) . This statement will return which period of historical data for the table?

Q53. What happens If the TIMESTAMP, OFFSET, or STATEMENT specified in the AT | BEFORE clause of a SELECT statement falls outside the data retention period for the table?

Q54. Snowflake database is just based on the massively parallel shared nothing architecture used by data bases like Netezza, Teradata, Greenplum.

Q55. When a virtual warehouse is provisioned there is no benefit in stopping the virtual warehouse with in the first 60 seconds because that time period has already been billed.

Q56. The Snowflake credit usage for multi cluster virtual warehouses is based on

Q57. In the Snowflake Web UI which of the following is true?

Q58. The “load metadata“ (which maintains which files have already been loaded) for a table expires after how many days?

Q59. Storage fees are incurred for maintaining historical data during the Time Travel but not during Fail-safe periods as Fail safe is managed by Snowflake

Q60. When data is shared between Snowflake accounts, a database is created on the consumer side for sharing purposes. The type of this database is ?

Q61. Snowflakes hierarchical key model consists of which four levels of keys:

Q62. What is the correct way to find out virtual warehouse credit usage information in Snowflake?

Q63. On the WebUI which button on the top bar should you select to get to tabs that provide billing and credit information?

Q64.Which of the following are valid parameters when create a new virtual warehouse?

Q65. What happens when a table is shared by a snowflake account to another snowflake account? Select all that applies

Q61. Snowflakes hierarchical key model consists of which four levels of keys: