Online Access Free COF-C03 Exam Questions

Why is a federated environment used for user authentication in Snowflake?

• A.To separate user authentication from user access
• B.To enable direct integration with external databases
• C.To provide real-lime monitoring of user activities
• D.To enhance data security and privacy

What can be used to view warehouse usage over time? (Select Two).

• A.The Query history view
• B.The show warehouses command
• C.The billing and usage tab in the Snowflake web Ul
• D.The load HISTORY view
• E.The WAREHOUSE_METERING__HISTORY View

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

• A.Scaling up resizes a virtual warehouse so it can handle more complex workloads.
• B.Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
• C.Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
• D.Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
• E.Scaling out adds clusters of varying sizes to a virtual warehouse.
• F.Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

Which table function is used to perform additional processing on the results of a previously-run query?

• A.QUERY_HISTORY
• B.RESULT_SCAN
• C.DESCRIBE_RESULTS
• D.QUERY HISTORY BY SESSION

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

• A.User
• B.View
• C.Table
• D.Internal stage
• E.Schema
• F.Role