SnowPro Core Certification COF-C02 Updated Dumps

test2023-01-30T07:19:55+00:00

The SnowPro Core certification COF-C02 is a highly sought after certification for those working in the Snowflake industry. The COF-C02 exam is updated regularly to ensure that the content remains relevant and up to date, and the latest SnowPro Core Certification COF-C02 dumps have just been released. These SnowPro Core Certification COF-C02 dumps are designed to give candidates a taste of the types of questions that may be asked on the actual exam. By practicing with the SnowPro Core Certification COF-C02 dumps, candidates can get a feel for the format and structure of the exam, as well as improve their knowledge and skills.

In conclusion, the latest SnowPro Core certification COF-C02 dumps are an excellent resource for those preparing for the exam. By practicing with the COF-C02 dumps, candidates can get a head start on their preparation and increase their chances of success on the actual exam.

Page 1 of 7

1. What is cached during a query on a virtual warehouse?

All columns in a micro-partition

Any columns accessed during the query

The columns in the result set of the query

All rows accessed during the query

2. Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

Database replication and failover

Automated index management

Customer managed keys (Tri-secret secure)

Extended time travel

Native support for geospatial data

3. Which Snowflake technique can be used to improve the performance of a query?

Clustering

Indexing

Fragmenting

Using INDEX__HINTS

4. Which of the following are characteristics of security in Snowflake?

Account and user authentication is only available with the Snowflake Business Critical edition.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

5. A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

Create a task that runs a copy into operation from an external stage every 5 minutes

Create a task that puts the files in an internal stage and automate the data loading wizard

Create a task that runs a GET operation to intermittently check for new files

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

6. Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Configure 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 user's access to expire within a specified timeframe.

7. Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Snowflake leverages a Role-Based Access Control (RBAC) model.

Snowflake requires a user to configure an IAM user to connect to the database.

All data in Snowflake is encrypted.

Snowflake can run within a user's own Virtual Private Cloud (VPC).

All data in Snowflake is compressed.

8. When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

An error will occur, as views with qualified references cannot be cloned.

An error will occur, as stored objects cannot be cloned.

The stored procedures and views will refer to tables in the source database.

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

The shared objects are transferred.

The shared objects are copied.

The shared objects become accessible.

The shared objects can be re-shared.

10. Which command sets the Virtual Warehouse for a session?

COPY WAREHOUSE FROM <<config file>>;

SET WAREHOUSE = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Page 2 of 7

11. What can be used to view warehouse usage over time? (Select Two).

The load HISTORY view

The Query history view

The show warehouses command

The WAREHOUSE_METERING__HISTORY View

The billing and usage tab in the Snowflake web Ul

12. How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Configure the warehouse to a size larger than generally required

Set the minimum and maximum clusters to autoscale

Use the standard warehouse scaling policy

Use the economy warehouse scaling policy

13. What is a responsibility of Snowflake’s virtual warehouses?

Infrastructure management

Metadata management

Query execution

Query parsing and optimization

Permanent storage of micro-partitions

14. Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Files

External tables

Secure User-Defined Functions (UDFs)

Sequences

Streams

15. Which of the following is the Snowflake Account_Usage.Metering_History view used for?

Gathering the hourly credit usage for an account

Compiling an account's average cloud services cost over the previous month

Summarizing the throughput of Snowpipe costs for an account

Calculating the funds left on an account's contract

16. A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

Query against the result set cache

Query against a virtual warehouse cache

Query against the most-recently created micro-partition

Query against the metadata excite

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

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

18. True or False: Fail-safe can be disabled within a Snowflake account.

True

False

19. Which statement describes how Snowflake supports reader accounts?

A reader account can consume data from the provider account that created it and combine it with its own data.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

20. What is the minimum Snowflake edition required to create a materialized view?

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

Page 3 of 7

21. Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

INSERT

PUT

GET

COPY

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

When dropping an external stage, the files are not removed and only the stage is dropped

When dropping an external stage, both the stage and the files within the stage are removed

When dropping an internal stage, the files are deleted with the stage and the files are recoverable

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

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

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

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

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

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

24. Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

ROLES

POLICY_REFERENCES

QUERY_HISTORY

RESOURCE_MONIT ORS

ACCESS_HISTORY

25. 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

26. Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Schemas

Roles

Secure Views

Stored Procedures

Tables

Secure User-Defined Functions (UDFs)

27. Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

An FTP server with TLS encryption

An HTTPS server with WebDAV

A Google Cloud storage bucket

A Windows server file share on Azure

28. Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

parse_json()

json_extract_path_text()

object_construct()

flatten

29. What is the minimum Snowflake edition required to use Dynamic Data Masking?

Standard

Enterprise

Business Critical

Virtual Private Snowflake (VPC)

30. Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Standard

Premium

Enterprise

Business Critical

Page 4 of 7

31. When should a multi-cluster warehouse be used in auto-scaling mode?

When it is unknown how much compute power is needed

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

If the runtime of the executed query is very slow

When a large number of concurrent queries are run on the same warehouse

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

Schema stage

Named stage

User stage

Stream stage

Table stage

Database stage

33. How can a user change which columns are referenced in a view?

Modify the columns in the underlying table

Use the ALTER VIEW command to update the view

Recreate the view with the required changes

Materialize the view to perform the changes

34. In which use cases does Snowflake apply egress charges?

Data sharing within a specific region

Query result retrieval

Database replication

Loading data into Snowflake

35. What is the default character set used when loading CSV files into Snowflake?

UTF-8

UTF-16

ISO S859-1

ANSI_X3.A

36. What affects whether the query results cache can be used?

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

37. Which Snowflake architectural layer is responsible for a query execution plan?

Compute

Data storage

Cloud services

Cloud provider

38. True or False: A Virtual Warehouse can be resized while suspended.

True

False

39. Which statement about billing applies to Snowflake credits?

Credits are billed per-minute with a 60-minute minimum

Credits are used to pay for cloud data storage usage

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

Credits are consumed based on the warehouse size and the time the warehouse is running

40. What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Page 5 of 7

41. 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

42. How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

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

There is no Fail-safe period for these tables.

1 day

7 days

31 days

90 days

44. 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

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

Compute layer

Storage layer

Cloud infrastructure layer

Cloud services layer

46. Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

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

Removing a column from the query SELECT list

Stopping the virtual warehouse that the query is running against

Clustering of the data used by the query

Executing the RESULTS_SCAN() table function

Changing a column that is not in the cached query

48. Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Tri-Secret Secure

Time Travel

Fail-safe

Data encryption

External stages

49. Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

SHOW GRANTS OF ROLE MY_ROLE

SHOW GRANTS TO ROLE MY_ROLE

SHOW GRANTS FOR ROLE MY_ROLE

SHOW GRANTS ON ROLE MY_ROLE

50. Which statement MOST accurately describes clustering in Snowflake?

The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

The clustering key must be included in the COPY command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

Page 6 of 7

51. What are value types that a VARIANT column can store? (Select TWO)

STRUCT

OBJECT

BINARY

ARRAY

CLOB

52. Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

ORC

XML

Avro

Parquet

JSON

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

1 day

7 days

45 days

90 days

54. Which Snowflake partner specializes in data catalog solutions?

Alation

DataRobot

dbt

Tableau

55. What data is stored in the Snowflake storage layer? (Select TWO).

Snowflake parameters

Micro-partitions

Query history

Persisted query results

Standard and secure view results

56. Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

Amazon Web Services

Docker

IBM Cloud

Microsoft Azure Cloud

Google Cloud Platform

Oracle Cloud

57. 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

58. Which Snowflake feature is used for both querying and restoring data?

Cluster keys

Time Travel

Fail-safe

Cloning

59. Which of the following accurately describes shares?

Tables, secure views, and secure UDFs can be shared

Shares can be shared

Data consumers can clone a new table from a share

Access to a share cannot be revoked once granted

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

CREATE SHARE

ALTER WAREHOUSE

DROP ROLE

SHOW SCHEMAS

DESCRBE TABLE

Page 7 of 7

61. Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Caching query results

Running EXPLAIN and SHOW commands

Cloning a database

Running a custom query

Running COPY commands

62. Which of the following describes a Snowflake stored procedure?

They can be created as secure and hide the underlying metadata from the user.

They can only access tables from a single database.

They can contain only a single SQL statement.

They can be created to run with a caller's rights or an owner's rights.

63. Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Execute a COPY command

Updating data

Snowpipe

AUTOMATIC__CLUSTERING

Scaling up a warehouse

64. A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

list @mytable;

list @%raytable;

list @ %m.ystage;

list @mystage;

65. In a Snowflake role hierarchy, what is the top-level role?

SYSADMIN

ORGADMIN

ACCOUNTADMIN

SECURITYADMIN

66. During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

STATEMENT_TIMEOUT__IN__SECONDS

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

MAX_CONCURRENCY__LEVEL

QUERY_TIMEOUT_IN_SECONDS

67. Users are responsible for data storage costs until what occurs?

Data expires from Time Travel

Data expires from Fail-safe

Data is deleted from a table

Data is truncated from a table

68. What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

Users who are trying to use the warehouse will receive an error message until the resizing is complete