Snowflake Test-9

Passing the Snowflake SnowPro Core COF-C02 mock test boosts your resume by validating your ability to work with Snowflake’s architecture and features. Recruiters notice certifications, but they want more than theoretical knowledge. Employers expect candidates to master Power BI and Tableau, query with SQL, and apply statistical analysis using SAS. Data engineering expertise in Snowflake, Databricks, and PySpark is essential, along with data science and AI skills in TensorFlow, PyTorch, LLMs, and Generative AI. Project work is equally important to prove practical expertise.

The SynergisticIT Data Science Job Placement Program bridges this gap, combining certification-level fundamentals with advanced training and project-based learning. Learn more through the SynergisticIT Job Placement Program.

Welcome to your Snowflake Test-9

Name

Phone

Q1. Please choose all the securable objects from the given options.

Select 5 option(s):

SCHEMA

UDF

EXTERNAL TABLE

DATABASE

STORED PROCEDURE

Unattempted

Q2. An hour ago, you ran a complex query. You then ran several simple queries from the same worksheet. You want to export the results from the complex query but they are no longer loaded in the Results pane of the worksheet. What is the least costly way to download the results?

Select 1 option(s):

Click on History -> Locate the Query -> Click “Download Results“ in column 3

Type the command SELECT RESULTS(-3) into the Worksheet and click “Run“

Type the command Select RESULTS(,,) in the Worksheet and click “Run“

Click on History -> Locate the Query -> Click the QueryID -> Use the “Export Result“ button

Q3. Which of these can access database objects and issue SQL statements

Select 1 option(s):

User-Defined Function

Both

Stored Procedure

Q4. If you find a data-related tool that is not listed as part of the Snowflake ecosystem, what industry standard options could you check for as a way to easily connect to Snowflake? (Select 2)

Select 2 option(s):

Check to see if the tool can connect to other solutions via JDBC

Check to see if there is a petition in the community to create a driver

Check to see if you can develop a driver and put it on GitHub

Check to see if the tool can connect to other solutions via ODBC

Q5. Which actions are not supported with shared data?

Select 4 option(s):

Editing the comments for a shared database

Time Travel for a shared database or any schemas/tables in the database

Creating a clone of a shared database or any schemas/tables in the database

Can be re-shared by data consumer

Unattempted

Q6. What are the types of Caches? (Select 2)

Select 2 option(s):

Storage Cache

Results Cache

History Cache

Metadata Cache

Q7. Snowflake decouples Storage and Compute. In case of increase in Compute usages, Storage usage also increases..

Select 1 option(s):

TRUE

FALSE

Q8. New or modified data in tables in a share are immediately not available to all consumers who have created a database from a share

Select 1 option(s):

FALSE

TRUE

Q9. Each share contains a single database, and all other objects included in the share must be from this same database.

Select 1 option(s):

TRUE

FALSE

Q10. Which cache type runs on a 24 hour “clock“?

Select 1 option(s):

Results Cache

Metadata Cache

Warehouse Cache

Q11. Secured view can be used to hide the definition but its performance can get degraded?

Select 1 option(s):

TRUE

FALSE

Q12. No need to grant usage on new objects created in a database in a share in order for them to be available to consumers.

Select 1 option(s):

FALSE

TRUE

Q13. Which of the following object types are child objects within schemas?

Select 5 option(s):

User Defined Functions

File Formats

Roles

Stages

Sequences

Stored Procedures

Q14. What type of Privilege Data Consumer should have to administer shares

Select 1 option(s):

EXPORT SHARE

SHOW SHARE

LIST SHARE

IMPORT SHARES

Q15. Snowflake follows the Staged release process for new releases. How many days it take to normally to complete all the stages of the staged release.

Select 1 option(s):

3 days

2 days

7 days

1 day

Q16. Can you share data with multiple consumers with row based access control?

Select 1 option(s):

YES

Q17. You create a Sequence in Snowflake with an initial value of 3 and an interval of 2. Which series of numbers do you expect to see?

Select 1 option(s):

3,4,5,6,7

3,6,9,12,15

2,5,8,11,14

3,5,7,9,11

Q18. User-Defined Function (UDF) supports

Select 1 option(s):

JavaScript

Python

SQL

Java

Q19. User A and User B can access one another‘s result sets from the Results Cache, as long as which of the following are true? (Choose two)

Select 2 option(s):

They run with 59 minutes of one another.

They use the same Warehouse.

They run the exact same SQL Text/Query.

They sign in to the same Session.

They use the same Role.

Q20. Once the Snowflake Account is provisioned, user can access Snowflake using following methods:

Select 4 option(s):

Any client application connected via JDBC or ODBC

Any 3rd-party partner that can connect to Snowflake

SnowSQL, the Snowflake command line client

Browser-based web interface

Unattempted

Q21. Which statements accurately describes the Snowflake Data Sharing?

Select 3 option(s):

A share can‘t be cloned by Consumer

When creating views in a share, secured views are required

A share can contain more than one database

Data sharing is only supported between accounts in the same snowflake region

Q22. Snowflake offers multiple editions. Which one is not a offering from Snowflake.

Select 1 option(s):

Enterprise

Standard

Premium

Business Critical

Q23. A CAST command (symbol) will force a value to be output as a certain datatype. Which of the following code samples will result in the “employeename“ being output using the VARCHAR datatype?

Select 1 option(s):

Q24. Which are the options available for SECURITYADMIN in Snowflake UI ribbon?(Choose all applicable)

Select 3 option(s):

Data Exchange

History

Notifications

Warehouses

Account

Q25. Snowflake Administrators should utilize resource monitors to help control costs and avoid unexpected credit usage. Which of the following actions can Snowflake‘s resource monitor triggers initiate automatically? (Check all that apply)

Select 3 option(s):

Roll over query executions to under-utilized warehouses

Impose limits on the number of credits that warehouses consume each month

Trigger alert notifications for high usage

Trigger warehouse suspension for high usage

Q26. You have a dashboard that connects to Snowflake via JDBC. The dashboard is refreshed hundreds of times per day. The data is very stable, only changing once or twice per day. The query run by the dashboard connector user never changes. How will Snowflake manage changing and non-changing data? Mark all true statements.

Select 1 option(s):

Snowflake will spin up a warehouse each time the dashboard is refreshed

Snowflake will compile results cache data from all user results so no warehouse is needed

Snowflake will show the most up-to-date data each time the dashboard is refreshed

Snowflake will re-use data from the Results Cache as long as it is still the most up-to-date data available

Snowflake will spin up a warehouse only if the underlying data has changed

Q27. John wants to share a VIEW with Monica but John wants to hide View definition and details from Monica. What type of view John should create and share with Monica?

Select 1 option(s):

Secured

None

Standard

Materialized

Q28. The acronym ETL stands for what three words?

Select 1 option(s):

Extract, Transition, Loading

Extract, Transform, Load

Extract, Transfer, Load

Extract, Transition, Load

Q29. Which is not the Security function of cloud services layer?

Select 1 option(s):

Pruning using metadata about micro-partitions

Encryption and key management

Access control for shares

Authentication

Access control for users and roles

Q30. If you are defining a multi-column clustering key of a table, the order in which the columns are specified in the CLUSTER BY clause is important. As general rule, Snowflake recommends:

Select 1 option(s):

Ordering the columns from lowest cardinality to highest cardinality

Order doesn‘t matter

Ordering the columns from highest cardinality to lowest cardinality

Q31. Which of the following terms or phrases can also be used to describe Snowflake? (Select 4)

Select 4 option(s):

Build from the ground up for the cloud

Hadoop-Compliant

Multi-cluster

Hybrid Columnar

Native SQL

Q32. Which of the following Snowflake Editions encrypt all data transmitted over the network within a Virtual Private Cloud (VPC)?

Select 1 option(s):

Standard

Enterprise

Business Critical

Q33. Which view does behave like a table and get auto-refreshed?

Select 1 option(s):

None

Secured

Materialized

Standard

Q34. Which of the following are Snowflake view types? (Select 3)

Select 3 option(s):

Standard

Permanent

Materialized

Secure

Transient

Q35. What are the best practices for JOIN on unique keys?

Select 1 option(s):

Avoid unintentional cross join

Avoid MANY-TO-MANY Join

Use distinct keys

Unattempted

Q36. You create a new worksheet in the WebUI. You want to set the user role, warehouse, database, and schema context that will be used when running the SQL code. Which of the options listed here are valid?

Select 2 option(s):

Use the Context drop menu in the upper right corner of the worksheet.

Use fully qualified references to the role and warehouse in each select statement

Run the SET_CONTEXT(role,warehouse,database,schema) command.

Run four “USE“ commands, setting each context with a separate statement.

Q37. In the History Page, a query shows Bytes Scanned having Assigned Partitions: 110, Scanned Partitions 58, and Original Partitions 110. Why did the optimizer show fewer partitions scanned than assigned?

Select 1 option(s):

During the execution of the query, new data was added to the table and the optimizer had to add those micro partitions into the scan.

The static optimization determined the number of possible micro partitions would be 110 but the dynamic optimization was able to prune some of the partitions from a joined table

One of the tables in the query was an external table and didnt have micro partitions The metadata for the table was out of date and there were really only 58 partitions total

The optimizer estimated only 58 partitions would need to be scan but during the execution of the query, the optimizer realized it would have to read all 110 micro partitions

The query was using an Xlarge warehouse and could scan the partitions in parallel

Q38. John is having SECURITYADMIN role. He created a custom DBA_ROLE. He Granted SYSADMIN role to DBA_ROLE. He created a user ‘Monica‘. John granted DBA_ROLE to Monica. Monica creates a Database Monica_DB. Monica then created a Table T1 in Monica_DB under PUBLIC schema. What should John do to access Table T1 created by Monica?

Select 1 option(s):

GRANT TOLE DBA_ROLE TO John; USE ROLE DBA_ROLE; USE DATABASE monica_db; Select * from t1;

USE ROLE dba_role; USE DATABASE monica_db; Select * from t1;

USE ROLE SECURITYADMIN; USE DATABASE monica_db; Select * from t1;

GRANT ROLE DBA_ROLE TO John; USE DATABASE monica_db; Select * from t1;

Q39. Which of the following have drivers/connectors (or information about where to find them) available via Help->Downloads in the Snowflake WebUI? (Select 4)

Select 1 option(s):

Node.js

JDBC

Spark

Kafka

Q40. Which approach would result in improved performance through linear scaling of data ingestion workload?

Select 1 option(s):

Consider the practice of splitting input file batch within the recommended range of 10MB to 100MB

All of these

Consider the practice of organizing data by granular path

Resize virtual warehouse

Q41. if another objects get added to a shared database. Will consumer able to see immediately?

Select 1 option(s):

Yes

Q42. Reclustering in Snowflake is automatic. (TRUE / FALSE)

Select 1 option(s):

TRUE

FALSE

Q43. How often does Snowflake release new features?

Select 1 option(s):

Weekly

Yearly

Bi-Weekly

Monthly

Q44. A query you initiated is taking too long. You‘ve gone into the History area to check whether this query (which usually runs every hour) is supposed to take a long time. Check all true statements.

Select 4 option(s):

If you decide to end the query, you must return to the worksheet to Abort the query

Information in the History area can be filtered to show a single Warehouse

Information in the History area can be filtered to show a single User

Information in the History area can be filtered to show a single Session

Information in the History area can help you visually compare query times

Q45. If snowflake hostname is https://bbx99999.us-east-1.snowflakecomputing.com, what is the customer Full account name?

Select 1 option(s):

bbx99999

bbx99999.us-east-1

us-east-1

snowflakecomputing

bbx99999.us-east-1.snowflakecomputing

Q46. A Snowflake account can be hosted on any of the many cloud platforms. Please select all the correct answers.

Select 3 option(s):

Dropbox

Google Cloud (GCP)

Azure

AWS

Oracle Cloud

Q47. Snowflake data warehouse is not built on an existing database or big data software platform such as Hadoop.

Select 1 option(s):

TRUE

FALSE

Q48. Snowflake is a Cloud Data Platform delivered as a service.

Select 1 option(s):

FALSE

TRUE

Q49. Which tables will experience the most benefit from clustering?

Select 1 option(s):

Tables in the multi-terabyte (TB) range

Tables with sizes between the range of 100 MB to 1 GB compressed

Tables with sizes between the range of 1 GB to 10 GB compressed

All sizes of tables

Q50. Snowflake Architecture consists of many separate layers. Please select the correct layers. (Select 3).

Select 3 option(s):

Database Storage Layer

Security Layer

Query Processing Layer

Cloud Services Layer

Q51. Objects that are dropped from a shared database and then recreated with the same name are not immediately available in the share; you must execute grant usage on the objects to make them available

Select 1 option(s):

TRUE

FALSE

Q52. Which table type disappears after the close of the session and therefore has no fail-safe, and no time travel options after the close of the session?

Select 1 option(s):

Permanent

External

Transient

Temporary

Q53. Snowflake is a packaged software offering that can be installed by a user.

Select 1 option(s):

FALSE

TRUE

Q54. Which of the following options would result in a column named FIRST NAME being sandwiched between to percent signs? (Check all that apply)

Select 2 option(s):

Q55. Which query will require compute (Virtual Warehouse)? Consider table created as – CREATE or replace TABLE T1 ( ID number(2), Name varchar(20), ID number (11,2) );

Select 1 option(s):

Q56. The following SQL statement will require a running warehouse – CREATE TABLE T1 (NAME (VARCHAR20), ADDRESS VARCHAR (50));

Select 1 option(s):

TRUE

FALSE

Q57. If you want to view query history older than 14 days, where can you go to view it? Choose one path and one “term“ commonly used.

Select 2 option(s):

History-> Profile -> Account_Usage

The Usage Sharing Monitor

Account->Usage->History

SNOWFLAKE (Database) -> ACCOUNT_USAGE (Schema) -> QUERY_HISTORY (Secure View)

The Account Usage Share

Q58. Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed.(TRUE / FALSE)

Select 1 option(s):

FALSE

TRUE

Q59. Which of the following workload is Snowflake suited for?

Select 6 option(s):

Data Engineering

Data Applications

Data Lakes

Data Sharing and Exchanges

Data Science

Data Warehouse

Unattempted

Q60. How many maximum columns (or expressions) are recommended for a cluster key?

Select 1 option(s):

7 to 8

12 to 16

3 to 4

Higher the number of columns (or expressions) in the key, better will be the performance

Q61. Which statement accurately describes the Snowflake Cloud Services layer?

Select 1 option(s):

A collection of independent, scalable, and stateless services providing crucial data management capabilities

A collection of tightly coupled database management features

A set of Cloud providers‘ general services made available to users via the internet

Managed and scaled by the user

Q62. Stored Procedure supports

Select 2 option(s):

SQL

Java (Using Snowpark)

JavaScript

Python

Q63. Snowflake calculates usage of data stored in the system for:

Select 4 option(s):

Cloud storage used in External Stage

Files staged for bulk data loading/unloading

Clones of database tables that reference data deleted in the table that owns the clones

Database tables, including historical data for Time Travel

Fail-safe for database tables

Q64. Which of the following are unique objects introduced by Snowflake?

Select 1 option(s):

PIPE

STAGE

TABLE

Q65. Snowflake offers the early access of staged release to designated Standard Edition Customer. True or false?

Select 1 option(s):

TRUE

FALSE

Snowflake Test-9

Q1. Please choose all the securable objects from the given options.

Q2. An hour ago, you ran a complex query. You then ran several simple queries from the same worksheet. You want to export the results from the complex query but they are no longer loaded in the Results pane of the worksheet. What is the least costly way to download the results?

Q3. Which of these can access database objects and issue SQL statements

Q4. If you find a data-related tool that is not listed as part of the Snowflake ecosystem, what industry standard options could you check for as a way to easily connect to Snowflake? (Select 2)

Q5. Which actions are not supported with shared data?

Q6. What are the types of Caches? (Select 2)

Q7. Snowflake decouples Storage and Compute. In case of increase in Compute usages, Storage usage also increases..

Q8. New or modified data in tables in a share are immediately not available to all consumers who have created a database from a share

Q9. Each share contains a single database, and all other objects included in the share must be from this same database.

Q10. Which cache type runs on a 24 hour “clock“?

Q11. Secured view can be used to hide the definition but its performance can get degraded?

Q12. No need to grant usage on new objects created in a database in a share in order for them to be available to consumers.

Q13. Which of the following object types are child objects within schemas?

Q14. What type of Privilege Data Consumer should have to administer shares

Q15. Snowflake follows the Staged release process for new releases. How many days it take to normally to complete all the stages of the staged release.

Q16. Can you share data with multiple consumers with row based access control?

Q17. You create a Sequence in Snowflake with an initial value of 3 and an interval of 2. Which series of numbers do you expect to see?

Q18. User-Defined Function (UDF) supports

Q19. User A and User B can access one another‘s result sets from the Results Cache, as long as which of the following are true? (Choose two)

Q20. Once the Snowflake Account is provisioned, user can access Snowflake using following methods:

Q21. Which statements accurately describes the Snowflake Data Sharing?

Q22. Snowflake offers multiple editions. Which one is not a offering from Snowflake.

Q23. A CAST command (symbol) will force a value to be output as a certain datatype. Which of the following code samples will result in the “employeename“ being output using the VARCHAR datatype?

Q24. Which are the options available for SECURITYADMIN in Snowflake UI ribbon?(Choose all applicable)

Q25. Snowflake Administrators should utilize resource monitors to help control costs and avoid unexpected credit usage. Which of the following actions can Snowflake‘s resource monitor triggers initiate automatically? (Check all that apply)

Q27. John wants to share a VIEW with Monica but John wants to hide View definition and details from Monica. What type of view John should create and share with Monica?

Q28. The acronym ETL stands for what three words?

Q29. Which is not the Security function of cloud services layer?

Q30. If you are defining a multi-column clustering key of a table, the order in which the columns are specified in the CLUSTER BY clause is important. As general rule, Snowflake recommends:

Q31. Which of the following terms or phrases can also be used to describe Snowflake? (Select 4)

Q32. Which of the following Snowflake Editions encrypt all data transmitted over the network within a Virtual Private Cloud (VPC)?

Q33. Which view does behave like a table and get auto-refreshed?

Q34. Which of the following are Snowflake view types? (Select 3)

Q35. What are the best practices for JOIN on unique keys?

Q36. You create a new worksheet in the WebUI. You want to set the user role, warehouse, database, and schema context that will be used when running the SQL code. Which of the options listed here are valid?

Q37. In the History Page, a query shows Bytes Scanned having Assigned Partitions: 110, Scanned Partitions 58, and Original Partitions 110. Why did the optimizer show fewer partitions scanned than assigned?

Q39. Which of the following have drivers/connectors (or information about where to find them) available via Help->Downloads in the Snowflake WebUI? (Select 4)

Q40. Which approach would result in improved performance through linear scaling of data ingestion workload?

Q41. if another objects get added to a shared database. Will consumer able to see immediately?

Q42. Reclustering in Snowflake is automatic. (TRUE / FALSE)

Q43. How often does Snowflake release new features?

Q44. A query you initiated is taking too long. You‘ve gone into the History area to check whether this query (which usually runs every hour) is supposed to take a long time. Check all true statements.

Q45. If snowflake hostname is https://bbx99999.us-east-1.snowflakecomputing.com, what is the customer Full account name?

Q46. A Snowflake account can be hosted on any of the many cloud platforms. Please select all the correct answers.

Q47. Snowflake data warehouse is not built on an existing database or big data software platform such as Hadoop.

Q48. Snowflake is a Cloud Data Platform delivered as a service.

Q49. Which tables will experience the most benefit from clustering?

Q50. Snowflake Architecture consists of many separate layers. Please select the correct layers. (Select 3).

Q51. Objects that are dropped from a shared database and then recreated with the same name are not immediately available in the share; you must execute grant usage on the objects to make them available

Q52. Which table type disappears after the close of the session and therefore has no fail-safe, and no time travel options after the close of the session?

Q53. Snowflake is a packaged software offering that can be installed by a user.

Q54. Which of the following options would result in a column named FIRST NAME being sandwiched between to percent signs? (Check all that apply)

Q55. Which query will require compute (Virtual Warehouse)? Consider table created as – CREATE or replace TABLE T1 ( ID number(2), Name varchar(20), ID number (11,2) );

Q56. The following SQL statement will require a running warehouse – CREATE TABLE T1 (NAME (VARCHAR20), ADDRESS VARCHAR (50));

Q57. If you want to view query history older than 14 days, where can you go to view it? Choose one path and one “term“ commonly used.

Q58. Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed.(TRUE / FALSE)

Q59. Which of the following workload is Snowflake suited for?

Q60. How many maximum columns (or expressions) are recommended for a cluster key?

Q61. Which statement accurately describes the Snowflake Cloud Services layer?

Q62. Stored Procedure supports

Q63. Snowflake calculates usage of data stored in the system for:

Q64. Which of the following are unique objects introduced by Snowflake?

Q65. Snowflake offers the early access of staged release to designated Standard Edition Customer. True or false?

Q47. Snowflake data warehouse is not built on an existing database or big data software platform such as Hadoop.