COF-C01 Exam Dumps, COF-C01 Practice Test Questions [Q46-Q65]

Rate this post

COF-C01 Exam Dumps, COF-C01 Practice Test Questions

PDF (New 2023) Actual Snowflake COF-C01 Exam Questions

NEW QUESTION 46
Which of the following commands are not blocking operations?
Choose 2 answers

UPDATE

INSERT

MERGE

COPY

NEW QUESTION 47
Which of the following statements is true of Snowflake micro-partitioning?

Micro-partitioning has been known to introduce data skew

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Micro-partitioning can be disabled within a Snowflake account

NEW QUESTION 48
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

NEW QUESTION 49
Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A multi-cluster Warehouse can add clusters automatically based on query activity

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

A multi-cluster Warehouse can scale down when query activity slows

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

NEW QUESTION 50
What is the minimum duration charged when starting a virtual warehouse?

1 second

1 minute

1 hour

1 day

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

True

False

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

True

False

NEW QUESTION 53
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Concurrency

Performance

NEW QUESTION 54
When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

When users will be using compute at different times throughout a 24/7 period

When you don’t want to have to manually turn on the Warehouse each time a user needs it

When the compute must be available with no delay or lag time

When managing a steady workload

NEW QUESTION 55
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Standard

Premier

Enterprise

Business Critical Edition

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

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

NEW QUESTION 58
Which of the following objects can be cloned? (Choose four.)

Tables

Named File Formats

Schemas

Databases

Users

NEW QUESTION 59
What command is used to load files into an Internal Stage within Snowflake? Select one.

PUT

COPY INTO

TRANSFER

INSERT

NEW QUESTION 60
What is the lowest Snowflake edition that offers Time Travel up to 90 days.

standard Edition

Premier Edition

Enterprise Edition

Business Critical Edition

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

True

False

NEW QUESTION 62
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 63
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 64
Which of the following statements is true of Snowflake?

It was built specifically for the cloud

It was built as an on-premises solution and then ported 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

NEW QUESTION 65
True or False: A Virtual Warehouse can be resized while suspended.

True

False

Loading …