What table functions in the Snowflake Information Schema can be queried to retrieve information about directory tables? (Choose two.)
A. AUTO_REFRESH_REGISTRATION_HISTORY
B. EXTERNAL_TABLE_FILE_REGISTRATION_HISTORY
C. EXTERNAL_TABLE_FILES
D. MATERIALIZED_VIEW_REFRESH_HISTORY
E. STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY
A user created a database and set the DATA_RETENTION_TIME_IN_DAYS to 30, but did not set the DATA_RETENTION_TIME_IN_DAYS in table T1. After 5 days, the user accidentally drops table T1.
What are the considerations for recovering table T1?
A. The user can recover the table T1 after 30 days.
B. The table can be recovered because the table retention period default is at the database level.
C. The table can only be recovered by contacting Snowflake Support to recover the table from Fail-safe.
D. The table cannot be recovered because the DATA_RETENTION_TIME_IN_DAYS was not set for table T1.
What is the purpose of a Query Profile?
A. To profile how many times a particular query was executed and analyze its usage statistics over time.
B. To profile a particular query to understand the mechanics of the query, its behavior, and performance.
C. To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.
D. To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.
Which system-defined Snowflake role has permission to rename an account and specify whether the original URL can be used to access the renamed account?
A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSADMIN
D. ORGADMIN
Which key access control concept does Snowflake describe as a defined level of access to an object?
A. Grant
B. Privilege
C. Role
D. Session
Which Snowflake object uses credits for maintenance?
A. Regular table
B. Regular view
C. Materialized view
D. Cached query result
What are the primary authentication methods that Snowflake supports for securing REST API interactions? (Choose two.)
A. OAuth
B. Key pair authentication
C. Federated authentication
D. Multi-Factor Authentication (MFA)
E. Username and password authentication
Any user with the appropriate privileges can view data storage for individual tables by using which queries? (Choose two.)
A. METERING_HISTORY view in the ACCOUNT_USAGE schema
B. TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
C. STORAGE_USAGE view in the ACCOUNT_USAGE schema
D. TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA schema E. METERING_DAILY_HISTORY view in the ORGANIZATION_USAGE schema
Which command is used to start configuring Snowflake for Single Sign-On (SSO)?
A. CREATE SESSION POLICY
B. CREATE NETWORK RULE
C. CREATE SECURITY INTEGRATION
D. CREATE PASSWORD POLICY
A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day.
What will happen at the 24-hour mark?
A. The file will continue to load until all contents are loaded.
B. The file will stop loading and all data up to that point will be committed.
C. The file loading could be aborted without any portion of the file being committed.
D. The file's number of allowable hours to load can be programmatically controlled to load easily into Snowflake.
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.