Free COF-C02 Exam braindumps download (COF-C02 exam dumps Free)

QUESTION: 451

What is a characteristic of the Snowflake query profiler?

It can provide statistics on a maximum number of 100 queries per week.
It provides a graphic representation of the main components of the query processing.
It provides detailed statistics about which queries are using the greatest number of compute resources.
It can be used by third-party software using the query profiler API.

Answer(s): B

A Snowflake user wants to share transactional data with retail suppliers. However, some of the suppliers do not use Snowflake.

According to best practice, what should the Snowflake user do? (Choose two.)

Provide each non-Snowflake supplier with their own reader account.
Deploy a single reader account to be shared by all of the non-Snowflake suppliers.
Create an ETL pipeline that uses select and inserts statements from the source to the target supplier accounts.
Use a data share for suppliers in the same cloud region and a replicated proxy share for other cloud deployments.
Extract the shared transactional data to an external stage and use cloud storage utilities to reload the suppliers' regions.

Answer(s): A,D

Show Answer Next Question

QUESTION: 453

Which statement about data sharing is true?

Accounts can share with other accounts regardless of their Snowflake edition, without requiring help from Snowflake Support.
Data sharing can cross regions, but not cloud providers.
The Data Consumer can only see objects in the Data Provider’s source database that have been explicitly added to the share.
A Data Provider can only share with other Snowflake customers.

Answer(s): C

Show Answer Next Question