SnowPro Core Certification Exam (COF-C02) Free Questions - Part 5
Question No : 61) What are value types that a VARIANT column can store? (Select TWO)
A. STRUCT
B. OBJECT
C. BINARY
D. ARRAY
E. CLOB
Question No : 62) Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
A. An FTP server with TLS encryption
B. An HTTPS server with WebDAV
C. A Google Cloud storage bucket
D. A Windows server file share on Azure
Question No : 63) What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
A. Informatica
B. Power Bl
C. Adobe
D. Data Robot
Question No : 64) True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
A. True
B. False
Question No : 65) How long is Snowpipe data load history retained?
A. As configured in the create pipe settings
B. Until the pipe is dropped
C. 64 days
D. 14 days
Question No : 66) When is the result set cache no longer available? (Select TWO)
A. When another warehouse is used to execute the query
B. When another user executes the query
C. When the underlying data has changed
D. When the warehouse used to execute the query is suspended
E. When it has been 24 hours since the last query
Question No : 67) What is a key feature of Snowflake architecture?
A. Zero-copy cloning creates a mirror copy of a database that updates with the original
B. Software updates are automatically applied on a quarterly basis
C. Snowflake eliminates resource contention with its virtual warehouse implementation
D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
Question No : 68) Which of the following commands cannot be used within a reader account?
A. CREATE SHARE
B. ALTER WAREHOUSE
C. DROP ROLE
D. SHOW SCHEMAS
E. DESCRBE TABLE
Question No : 69) Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
A. SCIM
B. Federated authentication
C. TLS 1.2
D. Key-pair authentication
E. OAuth
F. OCSP authentication
Question No : 70) A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option. What does the STRIP_OUTER_ARRAY file format do?
A. It removes the last element of the outer array.
B. It removes the outer array structure and loads the records into separate table rows,
C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
Question No : 71) A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?
A. Yes, because a table owner has full control and can unset masking policies.
B. Yes, because masking policies only apply to cloned tables.
C. No, because masking policies must always reference specific access roles.
D. No, because ownership of a table does not include the ability to change masking policies
Question No : 72) What are the default Time Travel and Fail-safe retention periods for transient tables?
A. Time Travel - 1 day. Fail-safe - 1 day
B. Time Travel - 0 days. Fail-safe - 1 day
C. Time Travel - 1 day. Fail-safe - 0 days
D. Transient tables are retained in neither Fail-safe nor Time Travel
Question No : 73) What data is stored in the Snowflake storage layer? (Select TWO).
A. Snowflake parameters
B. Micro-partitions
C. Query history
D. Persisted query results
E. Standard and secure view results
Question No : 74) Which statement about billing applies to Snowflake credits?
A. Credits are billed per-minute with a 60-minute minimum
B. Credits are used to pay for cloud data storage usage
C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs
D. Credits are consumed based on the warehouse size and the time the warehouse is running
Question No : 75) Which Snowflake technique can be used to improve the performance of a query?
A. Clustering
B. Indexing
C. Fragmenting
D. Using INDEX__HINTS
COF-C02 Answers