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 4

Question No : 46) The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

A. Users

B. Tables

C. Databases

D. Internal Stages

 

Question No : 47) What are two ways to create and manage Data Shares in Snowflake? (Choose two.) 

A. Via the Snowflake Web Interface (Ul)

B. Via the data_share=true parameter

C. Via SQL commands

D. Via Virtual Warehouses

 

Question No : 48) A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

A. list @mytable;

B. list @%raytable;

C. list @ %m.ystage;

D. list @mystage;

 

Question No : 49) How often are encryption keys automatically rotated by Snowflake?

A. 30 Days

B. 60 Days

C. 90 Days

D. 365 Days

 

Question No : 50) Which cache type is used to cache data output from SQL queries?

A. Metadata cache

B. Result cache

C. Remote cache

D. Local file cache

 

Question No : 51) Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

A. ROLES

B. POLICY_REFERENCES

C. QUERY_HISTORY

D. RESOURCE_MONIT ORS

E. ACCESS_HISTORY

 

Question No : 52) A company's security audit requires generating a report listing all Snowflake logins (e.g. date and user) within the last 90 days. Which of the following statements will return the required information?

A. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME 

FROM ACCOUNT_USAGE.USERS;

B. SELECT EVENT_TIMESTAMP, USER_NAME

FROM table(information_schema.login_history_by_user())

C. SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.ACCESS_HISTORY;

D. SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.LOGIN_HISTORY;

 

Question No : 53) Which of the following objects can be shared through secure data sharing?

A. Masking policy

B. Stored procedure

C. Task

D. External table

 

Question No : 54) Which feature is only available in the Enterprise or higher editions of Snowflake?

A. Column-level security

B. SOC 2 type II certification

C. Multi-factor Authentication (MFA)

D. Object-level access control

 

Question No : 55) True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

A. True

B. False

 

Question No : 56) True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

A. True

B. False

 

Question No : 57) What features does Snowflake Time Travel enable?

A. Querying data-related objects that were created within the past 365 days

B. Restoring data-related objects that have been deleted within the past 90 days

C. Conducting point-in-time analysis for Bl reporting

D. Analyzing data usage/manipulation over all periods of time

 

Question No : 58) Which command can be used to stage local files from which Snowflake interface?

A. SnowSQL

B. Snowflake classic web interface (Ul)

C. Snowsight

D. .NET driver

 

Question No : 59) A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

A. GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

B. GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

C. GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

D. GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

 

Question No : 60) Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

A. The table contains a column that has very low cardinality

B. DML statements that are being issued against the table are blocked

C. The table has a small number of micro-partitions

D. Queries on the table are running slower than expected

E. The clustering depth for the table is large

 

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.