Logo
  • Home
  • All Courses
    • Amazon - AWS
    • Cisco
    • CompTIA
    • EC Council
    • Microsoft
    • Oracle
    • Salesforce
    • Snowflake
  • Testimonials
  • Blogs
  • Login
  • Register
  • Cart

SnowPro Core Certification Exam (COF-C02) Free Questions - Part 5

Question No : 61) What are value types that a VARIANT column can store? (Select TWO)

A. STRUCT

B. OBJECT

C. BINARY

D. ARRAY

E. CLOB

 

Question No : 62) Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

A. An FTP server with TLS encryption

B. An HTTPS server with WebDAV

C. A Google Cloud storage bucket

D. A Windows server file share on Azure

 

Question No : 63) What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

A. Informatica

B. Power Bl

C. Adobe

D. Data Robot

 

Question No : 64) True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

A. True

B. False

 

Question No : 65) How long is Snowpipe data load history retained?

A. As configured in the create pipe settings

B. Until the pipe is dropped

C. 64 days

D. 14 days

 

Question No : 66) When is the result set cache no longer available? (Select TWO)

A. When another warehouse is used to execute the query

B. When another user executes the query

C. When the underlying data has changed

D. When the warehouse used to execute the query is suspended

E. When it has been 24 hours since the last query

 

Question No : 67) What is a key feature of Snowflake architecture?

A. Zero-copy cloning creates a mirror copy of a database that updates with the original

B. Software updates are automatically applied on a quarterly basis

C. Snowflake eliminates resource contention with its virtual warehouse implementation

D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters

E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

 

Question No : 68) Which of the following commands cannot be used within a reader account?

A. CREATE SHARE

B. ALTER WAREHOUSE

C. DROP ROLE

D. SHOW SCHEMAS

E. DESCRBE TABLE

 

Question No : 69) Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

A. SCIM

B. Federated authentication

C. TLS 1.2

D. Key-pair authentication

E. OAuth

F. OCSP authentication

 

Question No : 70) A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option. What does the STRIP_OUTER_ARRAY file format do?

A. It removes the last element of the outer array.

B. It removes the outer array structure and loads the records into separate table rows,

C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

 

Question No : 71) A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

A. Yes, because a table owner has full control and can unset masking policies.

B. Yes, because masking policies only apply to cloned tables.

C. No, because masking policies must always reference specific access roles.

D. No, because ownership of a table does not include the ability to change masking policies

 

Question No : 72) What are the default Time Travel and Fail-safe retention periods for transient tables?

A. Time Travel - 1 day. Fail-safe - 1 day

B. Time Travel - 0 days. Fail-safe - 1 day

C. Time Travel - 1 day. Fail-safe - 0 days

D. Transient tables are retained in neither Fail-safe nor Time Travel

 

Question No : 73) What data is stored in the Snowflake storage layer? (Select TWO).

A. Snowflake parameters

B. Micro-partitions

C. Query history

D. Persisted query results

E. Standard and secure view results

 

Question No : 74) Which statement about billing applies to Snowflake credits?

A. Credits are billed per-minute with a 60-minute minimum

B. Credits are used to pay for cloud data storage usage

C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D. Credits are consumed based on the warehouse size and the time the warehouse is running

 

Question No : 75) Which Snowflake technique can be used to improve the performance of a query?

A. Clustering

B. Indexing

C. Fragmenting

D. Using INDEX__HINTS

 

COF-C02 Answers

 

Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

Part 7

Part 8

Part 9

Part 10

Part 11

Part 12

Part 13

Part 14

Part 15

Part 16

Part 17

Part 18

Logo

Our goal is to help students clear their exam by providing them genuine questions which helps students to achieve their goal. Many students have cleared their exam by going through our courses. Are you ready to clear yours?


Site Secured

mcaafe-secure

Last Scanned: 08-05-2025

Links

  • FAQ
  • Money Back Guarantee
  • About Us
  • Privacy Policy
  • Terms & Conditions
  • Contact Us
  • Testimonials

Disclaimer

  • SAP, Microsoft, Google, Amazon, Qualtrics, and all other brands are Registered Trademarks of their respective companies.
  • Theexamquestions.com is no way affiliated With any brand hosted on this website.
  • Theexamquestions.com offers only probable exam questions and answers.
  • Theexamquestions.com offer learning materials and practice tests created by subject matter technology experts to assist and help learners prepare for those exams. Theexamquestions.com do not offer dumps or questions from the actual exam.
  • Theexamquestions.com does not own or claim any ownership on any of the brands.
  • All Certification Brands used on the website are owned by the respective brand owners.

All course contents, trademarks, service marks, trade names, product names and logos appearing on the site are the property of their respective owners. The website Theexamquestions.com is in no way affiliated with any of the certification providers. Copyright © 2025 www.theexamquestions.com. All rights reserved.