Online Access Free COF-C03 Practice Test

What does Snowflake recommend when planning virtual warehouse usage for a data load?

• A.Load the fewest possible number of large files.
• B.Use several single-duster warehouses.
• C.Dedicate a separate warehouse for loading data.
• D.Increase the size of the warehouse used.

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

• A.USERADMIN
• B.ACCOUNTADMIN
• C.SYSADMIN
• D.SECURITYADMIN

What does creating a resource monitor for a virtual warehouse allow a user to do?

• A.Schedule when the warehouse starts and stops.
• B.Automatically adjust the settings of the warehouse based on the workload.
• C.Track and control the credits consumed by the warehouse.
• D.Monitor the real-time performance of all queries running on the warehouse.

Which DDL/DML operation is allowed on an inbound data share?

• A.ALTER TA3LE
• B.INSERT INTO
• C.SELECT
• D.MERGE

What is the data lineage feature used for in Snowflake?

• A.To track dependencies at the object level
• B.To track how records are read by a user
• C.To track how data has been transformed among columns
• D.To track how transformation processes have impacted individual records