Download COF-C02 SnowPro Core Certification Exam Questions

test2022-10-20T06:34:35+00:00

COF-C02 is the new version of SnowPro Core Certification exam. The SnowPro Core Certification demonstrates an individual’s knowledge to apply specific core expertise implementing and migrating to Snowflake. This exam covers Snowflake principles and best practices including: Data Loading and Transformation in Snowflake, Virtual Warehouse Performance and Concurrency, DDL and DML Queries, Using Semi-Structured and Unstructured Data, Cloning and Time Travel, Data Sharing, and Snowflake Account Structure and Management. We have cracked the latest COF-C02 SnowPro Core Certification Exam Questions, which are the best guide for your test preparation.

Share free Snowflake COF-C02 practice exam questions below.

Page 1 of 7

1. Which interfaces can be used to create and/or manage Virtual Warehouses?

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

3. What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Informatica

Power Bl

Adobe

Data Robot

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

True

False

5. True or False: You can resize a Virtual Warehouse while queries are running.

True

False

6. Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

SCIM

Federated authentication

TLS 1.2

Key-pair authentication

OAuth

OCSP authentication

7. Which of the following describes external functions in Snowflake?

They are a type of User-defined Function (UDF).

They contain their own SQL code.

They call code that is stored inside of Snowflake.

They can return multiple rows for each row received

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

True

False

9. True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

10. Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Internal stages

Incremental backups

Time Travel

Zero-copy clones

Fail-safe

Page 2 of 7

11. Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

MIN(< < column value>>)

COPY

SUM(<< column value >>)

UPDATE

12. As a 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

13. Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers

Temporary Tables

Transient Tables

Provisional Tables

Permanent Tables

14. Which copy INTO command outputs the data into one file?

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FAISE

15. Which of the following DML commands isn’t supported by Snowflake?

UPSERT

MERGE

UPDATE

TRUNCATE TABLE

16. If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium

Warehouse?

128

17. Which command is used to unload data from a Snowflake table into a file in a stage?

COPY INTO

GET

WRITE

EXTRACT INTO

18. The fail-safe retention period is how many days?

1 day

7 days

45 days

90 days

19. Which of the following items does the Cloud services Layer manage? Choose 4 answers

user authentication

Metadata

Query compilation and optimization

external blob storage

Data security

20. A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

It removes the last element of the outer array.

It removes the outer array structure and loads the records into separate table rows,

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Page 3 of 7

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

They happen approximately weekly

They roll up and release approximately monthly, but customers can request early release application

During a release, new customer requests/queries/connections transparently move over to the newer version

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

22. When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

When users will be using compute at different times throughout a 24/7 period

When managing a steady workload

When the compute must be available with no delay or lag time

When you don’t want to have to manually turn on the Warehouse each time a user needs it

23. Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Custom

Economy

Optimized

Standard

24. True or False: You can query the files in an External Stage directly without having to load the data into a table.

True

False

25. Which of the following statements is true of zero-copy cloning?

Zero-copy clones objects inherit

All zero-copy clone objects inherit the privileges of their original objects

Zero-copy coning is licensed as an additional Snowflake feature

At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.

26. When creating a user it is advisable sable to: Choose 2 answers

Set the user to be initially disabled

Force an immediate password change

Set a default role for the user

Set the number of minutes to unlock to 15 minutes

Set the users access to expire within a specified timeframe

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

How can this worksheet be shared?

Create a zero-copy clone of the worksheet and grant permissions to teammates

Create a private Data Exchange so that any teammate can use the worksheet

Share the worksheet with teammates within Snowsight

Create a database and grant all permissions to teammates

28. True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

True

False

29. What are ways to create and manage data shares in Snowflake? (Select TWO)

Through the Snowflake web interface (Ul)

Through the DATA_SHARE=TRUE parameter

Through SQL commands

Through the enable__share=true parameter

Using the CREATE SHARE AS SELECT * TABLE command

30. When can a Virtual Warehouse start running queries?

12am-5am

Only during administrator defined time slots

When its provisioning is complete

After replication

Page 4 of 7

31. When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

Concurrency

Performance

32. True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

True

False

33. True or False: It is possible to load data into Snowflake without creating a named File Format object.

True

False

34. Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

The user has the appropriate privileges on the objects associated with the query

Micro-partitions have been reclustered since the query was last run

The new query is run using the same virtual warehouse as the previous query

The query includes a User Defined Function (UDF)

The query has been run within 24 hours of the previously-run query

35. Which of the following objects can be cloned? (Choose four.)

Tables

Named File Formats

Schemas

Databases

Users

36. Which item in the Data Warehouse migration process does not apply in Snowflake>

Migrate Users

Migrate Schemas

Migrate Indexes

Build the Data pipeline

37. True or False: Data Providers can share data with only the Data Consumer.

True

False

38. How often are encryption keys automatically rotated by Snowflake?

30 Days

60 Days

90 Days

365 Days

39. Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

The table contains a column that has very low cardinality

DML statements that are being issued against the table are blocked

The table has a small number of micro-partitions

Queries on the table are running slower than expected

The clustering depth for the table is large

40. Which of the following commands sets the Virtual Warehouse for a session?

COPT WAREHOUSE FROM <<Config file> ;

SET warehouse = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Page 5 of 7

41. How would you execute a series of SQL statements using Task?

include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where .. INSERT INTO target2 SELEC

. FROM stream .s1 where ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);

A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():

Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

42. When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

43. Which of the following objects can be shared through secure data sharing?

Masking policy

Stored procedure

Task

External table

44. True or False: All Snowflake table types include fail-safe storage.

True

False

45. Which feature is only available in the Enterprise or higher editions of Snowflake?

Column-level security

SOC 2 type II certification

Multi-factor Authentication (MFA)

Object-level access control

46. The Query History in the Snowflake Web Interface (UI) is kept for approximately:

60 minutes

24 hours

14 days

30 days

1 year

47. What is the most granular object that the Time Travel retention period can be defined on?

Account

Database

Schema

Table

48. True or False: Snowflake supports federated authentication in all editions.

True

False

49. The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Users

Tables

Databases

Internal Stages

50. Account-level storage usage can be monitored via:

The snowflake wet Interface (UI) in the Databases section.

The Snowflake web interface (UI) in the Account -> Billing a usage section

The Information Schema -> ACCOUNT_USAGE_HISTORY View

The Account usage Schema - > ACCOUNT_USAGE_METRICS View

Page 6 of 7

51. Which stage type can be altered and dropped?

Database stage

External stage

Table stage

User stage

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

CSV

JSON

Parquet

XML

53. Which of the following objects is not covered by Time Travel?

Tables

Schemas

Databases

Stages

54. How a Snowpipe charges calculated?

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

55. When is the result set cache no longer available? (Select TWO)

When another warehouse is used to execute the query

When another user executes the query

When the underlying data has changed

When the warehouse used to execute the query is suspended

When it has been 24 hours since the last query

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

Concurrency

Performance

57. What is the minimum duration charged when starting a virtual warehouse?

1 second

1 minute

1 hour

1 day

58. Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

Column-level security to apply data masking policies to tables and views

59. True or False: Snowflake charges a premium for storing semi-structured data.

True

False

60. What features does Snowflake Time Travel enable?

Querying data-related objects that were created within the past 365 days

Restoring data-related objects that have been deleted within the past 90 days

Conducting point-in-time analysis for Bl reporting

Analyzing data usage/manipulation over all periods of time

Page 7 of 7

61. The PUT command: (Choose two.)

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

62. True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

True

False

63. The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

The complexity of each query

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

The size of the data required for each query

The tool that s executing the query

64. True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

True

False