Free COF-R02 Exam Dumps PDF Preview

Question 1

Single choice

What is the MOST performant file format for loading data in Snowflake?

A
CSV (Unzipped)
B
Parquet
C
CSV (Gzipped)
D
ORC

Reveal answer details Close answer details

Correct answerA

Question 2

Single choice

What is the purpose of multi-cluster virtual warehouses?

A
To create separate data warehouses to increase query optimization
B
To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
C
To eliminate or reduce Queuing of concurrent queries
D
To allow the warehouse to resize automatically

Reveal answer details Close answer details

Correct answerC

Explanation

https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and%20off%20hours.

Question 3

Single choice

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

A
Compute layer
B
Storage layer
C
Cloud infrastructure layer
D
Cloud services layer

Reveal answer details Close answer details

Correct answerA

Explanation

For query execution, Snowflake uses the Virtual Warehouse. The query processing layer is separated from the disk storage layer in the Snowflake data architecture. You can use the data from the storage layer to run queries in this layer
https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556#:~:text=Query%20Processing%20Layer%2FCompute%20Layer,run%20queries%20in%20this%20layer.

Question 4

Multiple choice

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

A
grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
B
grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
C
grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
D
grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
E
grant SELECT on all tables in database DB1 to role MYROLE;
F
grant SELECT on future tables in database DB1 to role MYROLE;

Reveal answer details Close answer details

Correct answersC, D

Question 5

Single choice

What feature can be used to reorganize a very large table on one or more columns?

A
Micro-partitions
B
Clustering keys
C
Key partitions
D
Clustered partitions

Reveal answer details Close answer details

Correct answerB

Explanation

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Question 6

Multiple choice

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

A
Data is live, ready-to-query, and can be personalized.
B
Data needs to be loaded into a cloud provider as a consumer account.
C
Data is not available for copying or moving to an individual Snowflake account.
D
Data is available without copying or moving.
E
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Reveal answer details Close answer details

Correct answersA, D

Question 7

Single choice

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

A
True
B
False

Reveal answer details Close answer details

Correct answerB

Explanation

References:
https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

Question 8

Multiple choice

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

A
Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
B
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
C
The ACCOUNTADMIN role must be granted to only one user.
D
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
E
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Reveal answer details Close answer details

Correct answersA, D

Question 9

Single choice

Which minimum Snowflake edition allows for a dedicated metadata store?

A
Standard
B
Enterprise
C
Business Critical
D
Virtual Private Snowflake

Reveal answer details Close answer details

Correct answerD

Explanation

References:
https://docs.snowflake.com/en/user-guide/intro-editions.html

Question 10

Single choice

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

A
Each Snowflake account can be hosted in a different cloud vendor and region.
B
Each Snowflake account must be hosted in a different cloud vendor and region
C
All Snowflake accounts must be hosted in the same cloud vendor and region
D
Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

Reveal answer details Close answer details

Correct answerB

Explanation

https://docs.snowflake.com/en/user-guide/intro-regions.html

Question 11

Single choice

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

A
Pipe
B
External stage
C
Task
D
Stream

Reveal answer details Close answer details

Correct answerA

Explanation

Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

Question 12

Single choice

How long is the Fail-safe period for temporary and transient tables?

A
There is no Fail-safe period for these tables.
B
1 day
C
7 days
D
31 days
E
90 days

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

Question 13

Multiple choice

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

A
There is no need to have a Snowflake account in the target region, a share will be created for each user.
B
The listing is replicated into all selected regions automatically, the data is not.
C
The user must have the ORGADMIN role available in at least one account to link accounts for replication.
D
Shares attached to listings in remote regions can be viewed from any account in an organization.
E
For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Reveal answer details Close answer details

Correct answersA, C

Question 14

Single choice

Which of the following are characteristics of security in Snowflake?

A
Account and user authentication is only available with the Snowflake Business Critical edition.
B
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
C
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
D
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Reveal answer details Close answer details

Correct answerC

Question 15

Single choice

Users are responsible for data storage costs until what occurs?

A
Data expires from Time Travel
B
Data expires from Fail-safe
C
Data is deleted from a table
D
Data is truncated from a table

Reveal answer details Close answer details

Correct answerB

Question 16

Multiple choice

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

A
Authentication
B
Resource management
C
Virtual warehouse caching
D
Query parsing and optimization
E
Query execution
F
Physical storage of micro-partitions

Reveal answer details Close answer details

Correct answersA, D, E

Question 17

Single choice

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

A
The shared objects are transferred.
B
The shared objects are copied.
C
The shared objects become accessible.
D
The shared objects can be re-shared.

Reveal answer details Close answer details

Correct answerB

Question 18

Multiple choice

What happens when an external or an internal stage is dropped? (Select TWO).

A
When dropping an external stage, the files are not removed and only the stage is dropped
B
When dropping an external stage, both the stage and the files within the stage are removed
C
When dropping an internal stage, the files are deleted with the stage and the files are recoverable
D
When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
E
When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Reveal answer details Close answer details

Correct answersA, C

Question 19

Multiple choice

What internal stages are available in Snowflake? (Choose three.)

A
Schema stage
B
Named stage
C
User stage
D
Stream stage
E
Table stage
F
Database stage

Reveal answer details Close answer details

Correct answersA, B, E

Question 20

Single choice

True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

A
True
B
False

Reveal answer details Close answer details

Correct answerA

Question 21

Single choice

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

A
Create a zero-copy clone of the worksheet and grant permissions to teammates
B
Create a private Data Exchange so that any teammate can use the worksheet
C
Share the worksheet with teammates within Snowsight
D
Create a database and grant all permissions to teammates

Reveal answer details Close answer details

Correct answerC

Question 22

Single choice

Which of the following statements would be used to export/unload data from Snowflake?

A
COPY INTO @stage
B
EXPORT TO @stage
C
INSERT INTO @stage
D
EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

Question 23

Multiple choice

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A
Bytes sent over network
B
Percentage scanned from cache
C
Partitions total
D
Bytes spilled to local storage
E
Partitions scanned

Reveal answer details Close answer details

Correct answersB, E

Question 24

Single choice

Which of the following statements describes a schema in Snowflake?

A
A logical grouping of objects that belongs to a single database
B
A logical grouping of objects that belongs to multiple databases
C
A named Snowflake object that includes all the information required to share a database
D
A uniquely identified Snowflake account within a business entity

Reveal answer details Close answer details

Correct answerA

Question 25

Single choice

What is the recommended compressed file size range for continuous data loads using Snowpipe?

A
8-16 MB
B
16-24 MB
C
10-99 MB
D
100-250 MB

Reveal answer details Close answer details

Correct answerB

Question 26

Single choice

How are serverless features billed?

A
Per second multiplied by an automatic sizing for the job
B
Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
C
Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
D
Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Reveal answer details Close answer details

Correct answerD

Question 27

Single choice

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

A
Enterprise
B
Business Critical
C
Standard
D
Virtual Private Snowflake

Reveal answer details Close answer details

Correct answerB

Explanation

References:
https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition

Question 28

Single choice

What are the default Time Travel and Fail-safe retention periods for transient tables?

A
Time Travel-1 day. Fail-safe-1 day
B
Time Travel-0 days. Fail-safe-1 day
C
Time Travel-1 day. Fail-safe-0 days
D
Transient tables are retained in neither Fail-safe nor Time Travel

Reveal answer details Close answer details

Correct answerC

Explanation

https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help%20manage&text=Temporary%20tables%20can%20also%20have,have%20no%20Fail%2Dsafe%20period.

Question 29

Single choice

When unloading to a stage, which of the following is a recommended practice or approach?

A
Set SINGLE: = true for larger files
B
Use OBJECT_CONSTRUCT ( * ) when using Parquet
C
Avoid the use of the CAST function
D
Define an individual file format

Reveal answer details Close answer details

Correct answerC

Question 30

Multiple choice

Which of the following statements describes a benefit of Snowflake's separation of compute and storage?

(Choose all that apply.)

A
Growth of storage and compute are tightly coupled together
B
Storage expands without the requirement to add more compute
C
Compute can be scaled up or down without the requirement to add more storage
D
Multiple compute clusters can access stored data without contention

Reveal answer details Close answer details

Correct answersB, C, D

Explanation

References:
https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt-separate-storage-and-compute-65d2dffd450f

Question 31

Multiple choice

Which file formats are supported for unloading data from Snowflake? (Choose two.)

A
Avro
B
JSON
C
ORC
D
XML
E
Delimited (CSV, TSV, etc.)

Reveal answer details Close answer details

Correct answersC, E

Explanation

References:
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc,is%20comma%20(i.e.%20CSV)
.&text=File%20format%20options%20specify%20the,the%20format%20of%20the% 20data

Question 32

Single choice

Which of the following terms best describes Snowflake's database architecture?

A
Columnar shared nothing
B
Shared disk
C
Multi-cluster, shared data
D
Cloud-native shared memory

Reveal answer details Close answer details

Correct answerC

Explanation

https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.

Question 33

Multiple choice

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

A
Row level access policies
B
Data masking policies
C
Data encryption
D
Time Travel
E
External tokenization

Reveal answer details Close answer details

Correct answersC, D

Question 34

Single choice

Which of the following roles is recommended to be used to create and manage users and roles?

A
SYSADMIN
B
SECURITYADMIN
C
PUBLIC
D
ACCOUNTADMIN

Reveal answer details Close answer details

Correct answerB

Explanation

https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

"Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"

Question 35

Single choice

How would you determine the size of the virtual warehouse used for a task?

A
Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
B
Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
C
If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
D
Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Reveal answer details Close answer details

Correct answerC

Question 36

Multiple choice

Which of the following statements are true of Snowflake releases: (Choose two.)

A
They happen approximately weekly
B
They roll up and release approximately monthly, but customers can request early release application
C
During a release, new customer requests/queries/connections transparently move over to the newer version
D
A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

Reveal answer details Close answer details

Correct answersA, C

Explanation

https://docs.snowflake.com/en/user-guide/intro-releases.html

Question 37

Single choice

Which of the following describes a Snowflake stored procedure?

A
They can be created as secure and hide the underlying metadata from the user.
B
They can only access tables from a single database.
C
They can contain only a single SQL statement.
D
They can be created to run with a caller's rights or an owner's rights.

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

Question 38

Single choice

Which of the following commands cannot be used within a reader account?

A
CREATE SHARE
B
ALTER WAREHOUSE
C
DROP ROLE
D
SHOW SCHEMAS
E
DESCRBE TABLE

Reveal answer details Close answer details

Correct answerB

Explanation

A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.

Question 39

Single choice

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

A
SELECT SUM (ORDER_AMT) FROM SALES;
B
SELECT AVG(ORDER_QTY) FROM SALES;
C
SELECT MIN(ORDER_AMT) FROM SALES;
D
SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Reveal answer details Close answer details

Correct answerB

Question 40

Single choice

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

A
True
B
False

Reveal answer details Close answer details

Correct answerB

Explanation

References:
https://docs.snowflake.com/en/user-guide/connecting.html

Question 41

Single choice

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

A
select src:dealership from car_sales;
B
select src.dealership from car_sales;
C
select src:Dealership from car_sales;
D
select dealership from car_sales;

Reveal answer details Close answer details

Correct answerA

Question 42

Multiple choice

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

A
Reader
B
Consumer
C
Vendor
D
Standard
E
Personalized

Reveal answer details Close answer details

Correct answersD, E

Question 43

Multiple choice

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A
Removing a column from the query SELECT list
B
Stopping the virtual warehouse that the query is running against
C
Clustering of the data used by the query
D
Executing the RESULTS_SCAN() table function
E
Changing a column that is not in the cached query

Reveal answer details Close answer details

Correct answersA, D

Question 44

Single choice

The Snowflake Search Optimization Services supports improved performance of which kind of query?

A
Queries against large tables where frequent DML occurs
B
Queries against tables larger than 1 TB
C
Selective point lookup queries
D
Queries against a subset of columns in a table

Reveal answer details Close answer details

Correct answerC

Explanation

References:
https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimization%20service%20can%20improve%20the%20performance%20of%20point,OBJECT%2C%20and%20ARRAY%20columns)

Question 45

Single choice

True or False: The COPY command must specify a File Format in order to execute.

A
True
B
False

Reveal answer details Close answer details

Correct answerB

Explanation

Create Stage:
https://docs.snowflake.com/en/sql-reference/sql/create-stage.html

Create Table (STAGE_FILE_FORMAT option):
https://docs.snowflake.com/en/sql-reference/sql/create-table.html
Copy Into:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

Question 46

Single choice

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

A
True
B
False

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

Question 47

Single choice

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

A
True
B
False

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://docs.snowflake.com/en/user-guide-data-unload.html

Question 48

Single choice

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

A
Concurrency
B
Performance

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

Question 49

Single choice

What is the default File Format used in the COPY command if one is not specified?

A
CSV
B
JSON
C
Parquet
D
XML

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

Question 50

Single choice

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

A
True
B
False

Reveal answer details Close answer details

Correct answerB

Explanation

References:
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

VOL	TYPE	QUESTIONS
1	Single choice	36
2	Multiple choice	14