Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Choose two.)
A. GO driver
B. Node.js driver
C. ODBC driver
D. Python connector
E. Spark connector
What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?
A. 1-16 MB
B. 16-128 MB
C. 100-250 MB
D. 256-512 MB
What does Snowflake's search optimization service support?
A. External tables
B. Materialized views
C. Tables and views that are not protected by row access policies
D. Casts on table columns (except for fixed-point numbers cast to strings)
Which table type is no longer available after the close of the session and therefore has no Fail-safe or Time Travel recovery option?
A. External
B. Permanent
C. Temporary
D. Transient
How many network policies can be assigned to an account or specific user at a time?
A. One
B. Two
C. Three
D. Unlimited
What is a characteristic of a tag associated with a masking policy?
A. A tag can be dropped after a masking policy is assigned.
B. A tag can have only one masking policy for each data type.
C. A tag can have multiple masking policies for each data type.
D. A tag can have multiple masking policies with varying data types.
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
A. Table definition
B. Stage definition
C. Session level
D. COPY INTO TABLE statement
A complex SQL query involving eight tables with joins is taking a while to execute. The Query Profile shows that all partitions are being scanned.
What is causing the query performance issue?
A. Pruning is not being performed efficiently.
B. A huge volume of data is being fetched, with many joins applied.
C. Incorrect joins are being used, leading to scanning and pulling too many records.
D. The columns in the micro-partitions need granular ordering based on the dataset.
How long does Snowflake retain information in the ACCESS_HISTORY view?
A. 7 days
B. 14 days
C. 28 days D. 365 days
Which encryption type will enable client-side encryption for a directory table?
A. AES
B. AWS_CSE
C. SNOWFLAKE_SSE
D. SNOWFLAKE_FULL
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.