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