We're so confident of our products that we provide no hassle product exchange.
Snowflake SnowPro® Core Certification (COF-C03) Sample Questions:
1. Which role is responsible for managing the billing and credit data within Snowflake?
A) SYSADMIN
B) ORGADMIN
C) ACCOUNTADMIN
D) SECURITYADMIN
2. Which SQL command can be used to verify the privileges that are granted to a role?
A) SHOW ROLES < Role Name >
B) SHOW GRANTS TO ROLE < Role Name >
C) SHOW GRANTS ON ROLE < Role Name >
D) SHOW GRANTS FOR ROLE < Role Name >
3. This query was executed:
Assuming the weather_events table has not changed, which query would benefit from cached results?
A) select distinct(severity) from weather_events; if run within 48 hours after the initial query execution
B) SELECT DISTINCT(severity) FROM weather_events we; if run within 24 hours after the initial query execution
C) select distinct (severity) from weather_events; if run within 24 hours after the initial query execution
D) SELECT DISTINCT(severity) FROM weather_events ; if run within 24 hours after the initial query execution
4. What information is included in the output of an EXPLAIN_PLAN?
A) The total number of micro-partitions that the operation will reference.
B) The type of data that will be returned when the operation is run.
C) The number of credits that the operation will consume.
D) The predicted time it will take to run the operation.
5. Which items are considered schema objects in Snowflake? (Select TWO).
A) File format
B) Resource monitor
C) Pipe
D) Virtual warehouse
E) Storage integration
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: B | Question # 3 Answer: A | Question # 4 Answer: A | Question # 5 Answer: A,C |
By Elizabeth
