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 18

Question No : 256) What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

A. Business Critical Edition

B. Standard Edition

C. Virtual Private Snowflake (VPS)

D. Enterprise Edition


Question No : 257) Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

E. grant SELECT on all tables in database DB1 to role MYROLE;

F. grant SELECT on future tables in database DB1 to role MYROLE;


Question No : 258) Where is Snowflake metadata stored?

A. Within the data files

B. In the virtual warehouse layer

C. In the cloud services layer

D. In the remote storage layer


Question No : 259) Which TABLE function helps to convert semi-structured data to a relational representation?

A. CHECK_JSON

B. TO_JSON

C. FLATTEN

D. PARSE_JSON


Question No : 260) Which statement is true about running tasks in Snowflake?

A. A task can be called using a CALL statement to run a set of predefined SQL commands.

B. A task allows a user to execute a single SQL statement/command using a predefined schedule.

C. A task allows a user to execute a set of SQL commands on a predefined schedule.

D. A task can be executed using a SELECT statement to run a predefined SQL command.

 

Question No : 261) What happens to historical data when the retention period for an object ends?

A. The data is cloned into a historical object.

B. The data moves to Fail-safe

C. Time Travel on the historical data is dropped.

D. The object containing the historical data is dropped.


Question No : 262) Which of the following are best practices for loading data into Snowflake? (Choose three.)

A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

C. Enclose fields that contain delimiter characters in single or double quotes.

D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

F. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.


Question No : 263) How does Snowflake Fail-safe protect data in a permanent table?

A. Fail-safe makes data available up to 1 day, recoverable by user operations.

B. Fail-safe makes data available for 7 days, recoverable by user operations.

C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
 

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.