COF-R02 exam

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?A . The tables are now orphaned B. The user that deleted the role C. SYSADMIN D. The assumed role that dropped the roleView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html

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 timeView AnswerAnswer: B...

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.A . True B. FalseView AnswerAnswer: B

Which of the following statement is true of Snowflake?A . It was built specifically for the cloud B. it was built as an on-premises solution and then potted to the cloud C. It was designed as a hybrid database to allow customers to store data either on premises or in...

What can be used to view warehouse usage over time? (Select Two).A . The load HISTORY view B. The Query history view C. The show warehouses command D. The WAREHOUSE_METERING__HISTORY View E. The billing and usage tab in the Snowflake web UlView AnswerAnswer: D,E

Which of the following objects is not covered by Time Travel?A . Tables B. Schemas C. Databases D. StagesView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

What privileges are required to create a task?A . The global privilege create task is required to create a new task. B. Tasks are created at the Application level and can only be created by the Account Admin role. C. Many Snowflake DDLs are metadata operations only, and create task...

Will data cached in a warehouse be lost when the warehouse is resized?A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits. B. Yes. because the compute resource is replaced in its entirety with a new compute resource. C. No. because the...

Which Snowflake technique can be used to improve the performance of a query?A . Clustering B. Indexing C. Fragmenting D. Using INDEX__HINTSView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?A . It removes the last element of the outer array. B. It removes the outer array structure and loads...