SnowPro Core Certification Exam (COF-C02) Free Questions - Part 2
Question No : 16) Which data type can be used to store geospatial data in Snowflake?
A. Variant
B. Object
C. Geometry
D. Geography
Question No : 17) Which command is used to unload data from a Snowflake table into a file in a stage?
A. COPY INTO
B. GET
C. WRITE
D. EXTRACT INTO
Question No : 18) True or False: Fail-safe can be disabled within a Snowflake account.
A. True
B. False
Question No : 19) What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
A. The ability to scale up warehouses
B. The use of warehouse auto scaling
C. The ability to resize warehouses
D. Use of multi-clustered warehouses
E. The use of warehouse indexing
Question No : 20) What Snowflake role must be granted for a user to create and manage accounts?
A. ACCOUNTADMIN
B. ORGADMIN
C. SECURITYADMIN
D. SYSADMIN
Question No : 21) What is a limitation of a Materialized View?
A. A Materialized View cannot support any aggregate functions
B. A Materialized View can only reference up to two tables
C. A Materialized View cannot be joined with other tables
D. A Materialized View cannot be defined with a JOIN
Question No : 22) True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
A. True
B. False
Question No : 23) What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
A. Data is hashed by the cluster key to facilitate fast searches for common data values
B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
C. Smaller micro-partitions are created for common data values to allow for more parallelism
D. Data may be co-located by the cluster key within the micro-partitions to improve pruning performance
Question No : 24) Which services does the Snowflake Cloud Services layer manage? (Select TWO).
A. Compute resources
B. Query execution
C. Authentication
D. Data storage
E. Metadata
Question No : 25) In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
A. Compute Credits = 50 Credits Cloud Services = 10
B. Compute Credits = 80 Credits Cloud Services = 5
C. Compute Credits = 10 Credits Cloud Services = 9
D. Compute Credits = 120 Credits Cloud Services = 10
E. Compute Credits = 200 Credits Cloud Services = 26
Question No : 26) Where would a Snowflake user find information about query activity from 90 days ago?
A. account__usage . query history view
B. account__usage.query__history__archive View
C. information__schema . cruery_history view
D. information__schema - query history_by_ses s i on view
Question No : 27) 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 Ul
Question No : 28) Which Snowflake feature is used for both querying and restoring data?
A. Cluster keys
B. Time Travel
C. Fail-safe
D. Cloning
Question No : 29) When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse. According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
A. Use multi-clustered warehousing to scale out warehouse capacity.
B. Scale up the warehouse size to allow Queries to execute faster.
C. Stop and start the warehouse to clear the queued queries
D. Migrate some queries to a new warehouse to reduce load
E. Limit user access to the warehouse so fewer queries are run against it.
Question No : 30) During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
A. STATEMENT_TIMEOUT__IN__SECONDS
B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
C. MAX_CONCURRENCY__LEVEL
D. QUERY_TIMEOUT_IN_SECONDS
COF-C02 Answers