COF-C02 PDF Dumps 2023 Exam Questions with Practice Test [Q284-Q301]

Rate this post

COF-C02 PDF Dumps 2023 Exam Questions with Practice Test

Dumps for Free COF-C02 Practice Exam Questions

Snowflake COF-C02 exam is a certification exam designed for individuals who are looking to demonstrate their expertise in Snowflake’s cloud data platform. COF-C02 exam is known as the SnowPro Core Certification, which is a globally recognized certification that validates the skills and knowledge of an individual in Snowflake’s core concepts and architecture.

One of the key benefits of the SnowPro Core Certification Exam is its ability to enhance a candidate’s career prospects. SnowPro Core Certification Exam certification is recognized by Snowflake, which is a leading cloud data warehousing company. Passing the exam demonstrates that a candidate has the skills and knowledge to work with Snowflake’s technology, which is highly valued by organizations across industries.

NEW QUESTION 284
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Load files that are approximately 25 MB or smaller.

Remove all dates and timestamps.

Load files that are approximately 100-250 MB (or larger)

Avoid using embedded characters such as commas for numeric data types

Remove semi-structured data types

https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

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

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

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

Custom

Economy

Optimized

Standard

NEW QUESTION 287
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

The Pipe load history is reset to empty.

The REFRESH command is executed.

The stage will be purged.

The destination table is truncated.

NEW QUESTION 288
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

True

False

NEW QUESTION 289
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE
MYROLE;

GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K”-‘SCHEMA TO USER! ;

GRANT ROLE MYROLE TO USER USER1;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

NEW QUESTION 290
Which command can be used to load data into an internal stage?

LOAD

copy

GET

PUT

Explanation
https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121c

NEW QUESTION 291
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

Local disk caching

Authentication and access control

Metadata management

Query processing

Database storage

NEW QUESTION 292
True or False: Snowflake charges additional fees to Data providers for each share they create.

True

False

NEW QUESTION 293
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

STRIP_NULL_VALUES

SKIP_BYTE_ORDER_MARK

REPLACE_INVALID_CHARACTERS

VALIDATION_MODE

Explanation
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:

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

NEW QUESTION 295
True or False the longer the data retention period, the higher the resulting storage costs.

True

False

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

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

COPY INTO

GET

WRITE

EXTRACT INTO

NEW QUESTION 298
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.)

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in database DB1 to role MYROLE;

grant SELECT on future tables in database DB1 to role MYROLE;

NEW QUESTION 299
Select the three types of tables that exist within Snowflake. Choose 3 answers

Temporary

Transient

Provisioned

Permanent

NEW QUESTION 300
Which of the following describes a Snowflake stored procedure?