VALID COF-C01 Exam Dumps For Certification Exam Preparation [Q57-Q73]

COF-C01 Snowflake

admin • November 1, 2022

VALID COF-C01 Exam Dumps For Certification Exam Preparation [Q57-Q73]

Rate this post

VALID COF-C01 Exam Dumps For Certification Exam Preparation

COF-C01 Dumps PDF 2022 Strategy Your Preparation Efficiently

NEW QUESTION 57
Which of the following are options when creating a virtual Warehouse? Choose 2 answers

Auto-drop

Auto resize

Auto-resume

Auto-suspend

NEW QUESTION 58
True or False: An active warehouse is required to run a COPY INTO statement.

True

False

NEW QUESTION 59
How a Snowpipe charges calculated?

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

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

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

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

True

False

NEW QUESTION 63
What is the recommended Snowflake data type to store semi-structured data like JSON?

VARCHAR

RAW

LOB

VARIANT

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

True

False

NEW QUESTION 65
True or False: You can resize a Virtual Warehouse while queries are running.

True

False

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

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

True

False

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

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

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

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

True

False

NEW QUESTION 72
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

True

False

NEW QUESTION 73
True or False: Fail-safe can be disabled within a Snowflake account.

True

False

Loading …