Snowflake SnowPro Core Certification - COF-C02 Exam Questions

A. Data Replication B. Data Exchange C. Secure Data Sharing D. Snowflake Marketplace

A. Role_A can execute any tasks assigned to Role_B, without an explicit grant. B. Role_A automatically inherits all privileges assigned to Role_B. C. Role_A can use the privileges of Role_B, if Role_A is higher than Role_B in a defined hierarchy. D. Role_A can grant or revoke access to the role.

A. The predicted time it will take to run the operation. B. The number of credits that the operation will consume. C. The total number of micro-partitions that the operation will reference. D. The type of data that will be returned when the operation is run.

A. Partitioning staged data files B. Removing data files after loading C. Loading only the most recently-staged data files D. Identifying and removing duplicates after each data load

A. Credits will be charged when the daily consumption of cloud services resources exceeds Wo of the daily warehouse usage. B. Credits will be charged only when a virtual warehouse consumes serverless compute services. C. Credits will be charged whenever the Cloud Services layer is used. D. Credits will be charged only when running a Snowflake-provisioned compute warehouse comfute_wh.

A. Assign the custom role to the SYSADMIN role B. Assign the custom role to the PUBLIC role C. Add__CUSTOM to all custom role names D. Create the custom role using the SYSADMIN role.

A. The REFRESH command is executed. B. The Pipe load history is reset to empty. C. The stage will be purged. D. The destination table is truncated.

A. ROLES B. QUERY_HISTORY C. ACCESS_HISTORY D. POLICY_REFERENCES E. RESOURCE_MONIT ORS

A. Statistics for each component of the processing plan B. Real-time monitoring of the database operations C. Detailed Information about I he database schema D. Graphical representation of the data model

A. Run the warehouse in Maximized mode. B. Update the query WHERE clause. C. Increase the MAX_CLUSTER_COUNT. D. Increase the WAREHOUSE_SIZE. E. Increase the warehouse AUTO_SUSPEND duration.

A. MANAGE GRANTS B. REFERENCES C. USAGE D. MODIFY

A. Query pruning B. Queries using a result cache C. Queries using a local disk cache D. Operations using Data Manipulation Language, or DML E. Queries using a remote disk cache

A. The table has a small number of micro-partitions B. The table contains a column that has very low cardinality C. Queries on the table are running slower than expected D. DML statements that are being issued against the table are blocked E. The clustering depth for the table is large