Upgraded Snowflake COF-C02 SnowPro Core Certification Exam Dumps

Eleanor2022-10-21T03:16:22+00:00

Candidates need to plan to take the COF-Co2 exam to complete the SnowPro Core certification, because the COF-C01 exam retired on October 7, 2022. The upgraded Snowflake COF-C02 SnowPro Core certification exam dumps are available to help you complete the exam successfully. At ITPrepare, you will get the questions and replies in the COF-C02 exam dumps that have a place with the genuine organization of the SnowPro Core Certification Exam dumps. Snowflake COF-C02 exam dumps contain the most important questions and the answers to every subject of the COF-C02 exam that is valid to use to assist in SnowPro Core exam preparation.

Below are COF-C02 demo questions for reading online before getting the upgraded COF-C02 exam dumps:

Page 1 of 10

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

2. What privileges are required to create a task?

The global privilege create task is required to create a new task.

Tasks are created at the Application level and can only be created by the Account Admin role.

Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

The role must have access to the target schema and the create task privilege on the schema itself.

3. Which of the following are common use cases for zero-copy cloning? Choose 3 answers

Quick provisioning of Dev and Test/QA environments

Data backups

Point in time snapshots

Performance optimization

4. How many shares can be consumed by single Data Consumer?

100, but can be increased by contacting support

Unlimited

5. What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Via the Snowflake Web Interface (Ul)

Via the data_share=true parameter

Via SQL commands

Via Virtual Warehouses

6. A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

The primary cluster in the virtual warehouse

The entire virtual warehouse

The database in which the virtual warehouse resides

The Queries currently being run on the virtual warehouse

7. To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Configure the Maximum Clusters setting to “Auto-Scale”

Set the Warehouse type to “Auto”

Set the Minimum Clusters and Maximum Clusters settings to the same value

Set the Minimum Clusters and Maximum Clusters settings to the different values

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

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

9. A user is preparing to load data from an external stage

Which practice will provide the MOST efficient loading performance?

Organize files into logical paths

Store the files on the external stage to ensure caching is maintained

Use pattern matching for regular expression execution

Load the data in one large file

10. Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

Page 2 of 10

11. 1.True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

True

False

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

Custom

Economy

Optimized

Standard

13. True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

True

False

14. Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

Python

15. What SQL command would be used to view all roles that were granted to user.1?

show grants to user USER1;

show grants of user USER1;

describe user USER1;

show grants on user USER1;

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

CSV (Unzipped)

Parquet

CSV (Gzipped)

ORC

17. Which statements are true of micro-partitions? Choose 2 answers

They are approximately 16MB in size

They are stored compressed only if COMPRESS=TRUE on Table

They are Immutable

They are only encrypted in the Enterprise edition and above

18. Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Pipes

Streams

Tasks

Procedures

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

Time Travel - 1 day. Fail-safe - 1 day

Time Travel - 0 days. Fail-safe - 1 day

Time Travel - 1 day. Fail-safe - 0 days

Transient tables are retained in neither Fail-safe nor Time Travel

20. True or False: Once created, a micro-partition will never be changed.

True

False

Page 3 of 10

21. Which statement best describes Snowflake tables?

Snowflake tables are logical representations of underlying physical data

Snowflake tables ate the physical instantiation of data loaded Into Snowflake

Snowflake tables require that clustering keys be defined to perform optimally

Snowflake tables are owned by a user

22. True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

True

False

23. True or False: You can define multiple columns within a clustering key on a table.

True

False

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. What feature can be used to reorganize a very large table on one or more columns?

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

26. True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

True

False

27. Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

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

29. Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):

SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

SECURITYADMIN ACCOUNTADMIN, SYSADMIN

SECURITYADMIN, ACCOUNTADMIN

ACCOUNTADMIN

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

Page 4 of 10

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

True

False

32. True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

True

False

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

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

Informatica

Power Bl

Adobe

Data Robot

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

COPY INTO @stage

EXPORT TO @stage

INSERT INTO @stage

EXPORT_TO_STAGE (stage = > @Wage, select = > 'select * from t1);

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

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

SYSADMIN

SECURITYADMIN

PUBLIC

ACCOUNTADMIN

38. Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A Schema may contain one or more Databases

A Database may contain one or more Schemas

A Schema is a logical grouping of Database Objects

Each Schema is contained within a Warehouse

39. True or False: Snowpipe via RFST API can only reference External Stages as source.

True

False

40. True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

True

False

Page 5 of 10

41. What command is used to load files into an Internal Stage within Snowflake?

PUT

COPY INTO

TRANSFER

INSERT

42. Which statement best describes '' clustering''?

Clustering represents the way data is grouped together and stored within snowflake's micro-partitions

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

The clustering key must be included on the COPV command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

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

True

False

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

True

False

45. What is the minimum Snowflake edition that provides data sharing?

Standard

Premier

Enterprise

Business Critical Edition

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

True

False

47. The FLATEEN function is used to query which type of data in Snowflake?

Structured data

Semi-structured data

Both of the above

None of the above

48. Which are true of Snowflake roles?

All grants to objects are given to roles, and never to users

In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation

The public role controls at other roles

Roles are a subset of users and users own objects In Snowflake

49. True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the

data.

True

False

50. True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

True

False

Page 6 of 10

51. If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

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

1 second

1 minute

1 hour

1 day

53. Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Compute resources

Query execution

Authentication

Data storage

Metadata

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

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

Pipe

External stage

Task

Stream

56. What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

INITTIALLY_SUSPENDED = TRUE/FALSE

START_AFTCR_CREATE = TRUE/FALSE

START_TTIME = 60 // (seconds from now)

STAR

TIME = CURREN

DATE()

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

STRUCT

OBJECT

BINARY

ARRAY

CLOB

58. What happens when a Data Provider revokes privileges to a Share on an object in their source database?

The object immediately becomes unavailable for all Data Consumers

Any additional data arriving after this point in time will not be visible to Data Consumers

The Data Consumers stop seeing data updates and become responsible for storage charges for the object

A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

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

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

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FAISE

Page 7 of 10

61. True or False: Users are able to see the result sets of queries executed by other users that share their same role.

True

False

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

63. which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

Bulk copy from an External Stage

Continuous load using Snowpipe REST API

The Snowflake Web Interface (UT) data loading wizard

Bulk copy from an Internal Stage

64. A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data.

Will the developer be able to modify the table to read the masked data?

Yes, because a table owner has full control and can unset masking policies.

Yes, because masking policies only apply to cloned tables.

No, because masking policies must always reference specific access roles.

No, because ownership of a table does not include the ability to change masking policies

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

66. Which Snowflake partner specializes in data catalog solutions?

Alation

DataRobot

dbt

Tableau

67. What happens when a cloned table is replicated to a secondary database? (Select TWO)

A read-only copy of the cloned tables is stored.

The replication will not be successful.

The physical data is replicated

Additional costs for storage are charged to a secondary account

Metadata pointers to cloned tables are replicated

68. How long is Snowpipe data load history retained?

As configured in the create pipe settings

Until the pipe is dropped

64 days

14 days

69. What is a key feature of Snowflake architecture?

Zero-copy cloning creates a mirror copy of a database that updates with the original

Software updates are automatically applied on a quarterly basis

Snowflake eliminates resource contention with its virtual warehouse implementation

Multi-cluster warehouses allow users to run a query that spans across multiple clusters

Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

70. Which of the following is true of Snowpipe via REST API? Choose 2 answers

you can only use it on internal Stages

All COPY INTO options are available fluting pipe creation

Snowflake automatically manages the compute required to execute the Pipe's copy into commands

Snowpipe keeps track of which files it has loaded

Page 8 of 10

71. True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

True

False

72. Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Is available to all Snowflake Editions

Is only available to customers with Business Critical Edition

Restricts or enables access to specific IP addresses

Is activated using an “ALTER DATABASE” command

73. What Snowflake role must be granted for a user to create and manage accounts?

ACCOUNTADMIN

ORGADMIN

SECURITYADMIN

SYSADMIN

74. What is a limitation of a Materialized View?

A Materialized View cannot support any aggregate functions

A Materialized View can only reference up to two tables

A Materialized View cannot be joined with other tables

A Materialized View cannot be defined with a JOIN

75. Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

1 Hour

3 Hours

12 hours

24 hours

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

77. A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Okta Verify

Duo Mobile

Microsoft Authenticator

Google Authenticator

78. Select the three types of tables that exist within Snowflake. Choose 3 answers

Temporary

Transient

Provisioned

Permanent

79. Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

Their default role should be set to SYSTEMADMIN (the lower of the two)

They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so

They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation

They should ensure all database objects in the account are owned by the ACCOUNTADMIN role

They should use the SYSADMIN role to perform administrative work on database objects

80. A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

A)

Option A

Option B

Option C

Option D

Page 9 of 10

81. In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Compute Credits = 50 Credits Cloud Services = 10

Compute Credits = 80 Credits Cloud Services = 5

Compute Credits = 10 Credits Cloud Services = 9

Compute Credits = 120 Credits Cloud Services = 10

Compute Credits = 200 Credits Cloud Services = 26

82. Which type of table corresponds to a single Snowflake session?

Temporary

Translent

Provisional

Permanent

83. Which of the following statement is true of Snowflake?

It was built specifically for the cloud

it was built as an on-premises solution and then potted to the cloud

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

It was built for Hadoop architecture

It's based on an Oracle Architecture

84. What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

On-premise availability

Simplicity

Open source based

Concurrency

Performance

85. Which of the following describes how clustering keys work in Snowflake?

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

86. Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

To accommodate more queries

To accommodate more users

To accommodate fluctuations in workload

To accommodate a more complex workload

87. What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Data can be filtered by an optional where clause

Incoming data can be joined with other tables

Columns can be reordered

Columns can be omitted

Row level access can be defined

88. Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers

SnowSQL

ODBC

HIVE

89. When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse.

According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Use multi-clustered warehousing to scale out warehouse capacity.

Scale up the warehouse size to allow Queries to execute faster.

Stop and start the warehouse to clear the queued queries

Migrate some queries to a new warehouse to reduce load

Limit user access to the warehouse so fewer queries are run against it.

90. Which of the following are benefits of micro-partitioning? (Select TWO)

Micro-partitions cannot overlap in their range of values

Micro-partitions are immutable objects that support the use of Time Travel.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

Rows are automatically stored in sorted order within micro-partitions

Micro-partitions can be defined on a schema-by-schema basis

Page 10 of 10

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

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

Concurrency

Performance

93. On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers

Amazon Web Services

Private Virtual Cloud

Oracle Cloud

Microsoft Azure Cloud

94. Which of the following statements is true of data loading?

Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

The "deal file size for loading is 16MB to match micro-partition size

Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file

95. Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

The validation_mode option is used when creating an Internal Stage

validation_mode=return_all_errors is a parameter of the copy command

The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

96. True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

True

False

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

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

30 Days

60 Days

90 Days

365 Days

99. Which data types does Snowflake support when querying semi-structured data? (Select TWO)

VARIANT

ARRAY

VARCHAR

XML

BLOB

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

Set SINGLE: = true for larger files

Use OBJECT_CONSTRUCT ( * ) when using Parquet

Avoid the use of the CAST function

Define an individual file format

Upgraded Snowflake COF-C02 SnowPro Core Certification Exam Dumps