[Q37-Q60] Verified COF-C02 dumps Q&As – Pass Guarantee Exam Dumps Test Engine [2023]

Rate this post

Verified COF-C02 dumps Q&As – Pass Guarantee Exam Dumps Test Engine [2023]

COF-C02 dumps and 265 unique questions

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

Enterprise

Business Critical

Standard

Virtual Private Snowflake

NEW QUESTION 38
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

CHECK_OPTION

IS_SECURE

IS_UPDATEABLE

TABLE_NAME

NEW QUESTION 39
What is the minimum Snowflake edition that has column-level security enabled?

Standard

Enterprise

Business Critical

Virtual Private Snowflake

NEW QUESTION 40
Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

COPY INTO

CREATE PIPE

INSERT INTO

TABLE STREAM

NEW QUESTION 41
What is the minimum Snowflake edition that provides data sharing?

Standard

Premier

Enterprise

Business Critical Edition

NEW QUESTION 42
What type of query benefits the MOST from search optimization?

A query that uses only disjunction (i.e., OR) predicates

A query that includes analytical expressions

A query that uses equality predicates or predicates that use IN

A query that filters on semi-structured data types

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

True

False

NEW QUESTION 44
How often are the Account and Table master keys automatically rotated by Snowflake?

30 Days

60 Days

90 Days

365 Days.

NEW QUESTION 45
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

SHOW GRANTS ON ROLE DATA_SCIENCE

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

SHOW GRANTS TO USER INQUISITIVE_PERSON

SHOW GRANTS OF ROLE DATA_SCIENCE

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

8-16 MB

16-24 MB

10-99 MB

100-250 MB

NEW QUESTION 47
What is the recommended file sizing for data loading using Snowpipe?

A compressed file size greater than 100 MB, and up to 250 MB

A compressed file size greater than 100 GB, and up to 250 GB

A compressed file size greater than 10 MB, and up to 100 MB

A compressed file size greater than 1 GB, and up to 2 GB

https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute%20intervals.

NEW QUESTION 48
Which command is used to unload data from a Snowflake table into a file in a stage?

COPY INTO

GET

WRITE

EXTRACT INTO

https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.

NEW QUESTION 49
The Snowflake Cloud Data Platform is described as having which of the following architectures?

Shared-disk

Shared-nothing

Multi-cluster shared data

Serverless query engine

NEW QUESTION 50
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Informatica

Power Bl

Adobe

Data Robot

https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

NEW QUESTION 51
Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Compute resources

Query execution

Authentication

Data storage

Metadata

NEW QUESTION 52
Which command can be used to load data files into a Snowflake stage?

JOIN

COPY INTO

PUT

GET

NEW QUESTION 53
What Snowflake role must be granted for a user to create and manage accounts?

ACCOUNTADMIN

ORGADMIN

SECURITYADMIN

SYSADMIN

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

NEW QUESTION 54
What is a best practice after creating a custom role?

Create the custom role using the SYSADMIN role.

Assign the custom role to the SYSADMIN role

Assign the custom role to the PUBLIC role

Add__CUSTOM to all custom role names

When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

NEW QUESTION 55
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

4 minutes

10 minutes

14 minutes

24 minutes

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

True

False

NEW QUESTION 57
Which formats are supported for unloading data from Snowflake? Choose 2 answers

Delimited (CSV, TSV, etc.)

Avro

JSON

ORC

NEW QUESTION 58
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;

NEW QUESTION 59
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

Database

Tables

Warehouses

Worksheets

NEW QUESTION 60
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

Loading …