Practice Free COF-C03 Exam Online Questions
Which Snowflake features support the ability to write to a Git repository?
- A . Snowsight dashboards and stages
- B . Snowpipe and dynamic tables
- C . Stored procedures, tasks, and worksheets
- D . Streamlit applications, workspaces, and notebooks
What is the impact on storage when a user clones a 1 TB sized table and updates 10% of the rows in the cloned table?
- A . Only metadata is stored
- B . Full storage is duplicated
- C . No additional storage is used
- D . Only modified data consumes additional storage
A size Medium virtual warehouse processes scheduled reports for a team. More than 30 reports run simultaneously during business hours, and the team requires high availability with consistent performance and minimal startup time.
What action should be taken to help avoid queuing when these reports are run?
- A . Increase the size of the warehouse.
- B . Enable a multi-cluster warehouse with Auto-scale mode and an Economy scaling policy.
- C . Enable a multi-cluster warehouse with Maximized mode.
- D . Enable a multi-cluster warehouse with Auto-scale mode and a Standard scaling policy.
What is the FASTEST way to load specific staged files using the COPY INTO <location> command?
- A . Use wildcard characters in the file path.
- B . Select files based on the path prefix of the stage.
- C . List file names using the FILES parameter.
- D . Use pattern matching using the PATTERN parameter.
A dashboard query is running much slower than expected. The Query Profile shows a join operator consuming 70% of the total execution time and producing 1,000 times more rows than its input tables.
What is causing this issue?
- A . The query is queuing because the warehouse has too many concurrent queries.
- B . The joined tables are not benefiting from efficient micro-partition pruning.
- C . The query is generating a cartesian product due to a missing or incorrect ON clause condition.
- D . The query is spilling data to remote storage because the warehouse is too small.
Which are key characteristics of the Query Processing layer? (Choose two.)
- A . Up to 10% of daily usage of compute is free
- B . Storage is tied to the number of compute clusters
- C . The size of virtual warehouses can be changed dynamically
- D . Virtual warehouse start and stop operations can be automated
- E . Compute costs are calculated per hour of virtual warehouse runtime
Which statement will return a NULL value instead of raising an error when converting an input to a date?
- A . SELECT TRY_TO_DATE(START_DATE) FROM TABLE_A;
- B . SELECT DATE(START_DATE) FROM TABLE_A;
- C . SELECT START_DATE:: DATE FROM TABLE_A;
- D . SELECT TO_DATE(START_DATE) FROM TABLE_A;
What does the NULL_IF parameter do when loading CSV data into Snowflake?
- A . Converts binary data to text format
- B . Converts specific strings to SQL NULL
- C . Removes NULL values from the data set
- D . Replaces all NULL values with empty strings
Which interface or service allow users to connect to Snowflake with Python? (Choose two.)
- A . Snowpark API
- B . Snowsight
- C . Streamlit in Snowflake
- D . AI_EXTRACT
- E . Snowflake CLI
Which feature allows a user to review the monthly projected costs of a Snowflake resource against the monthly actual costs?
- A . Budgets
- B . Auto-suspend
- C . Scaling Policy
- D . Resource monitor