SnowPro Core Certification Exam (COF-C02) Free Questions - Part 8
Question No : 106) When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
A. There is no need to have a Snowflake account in the target region, a share will be created for each user.
B. The listing is replicated into all selected regions automatically, the data is not.
C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
D. Shares attached to listings in remote regions can be viewed from any account in an organization.
E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
Question No : 107) Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
A. VARIANT
B. VARRAY
C. STRUCT
D. ARRAY
E. QUEUE
Question No : 108) A virtual warehouse is created using the following command: Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two
days.
What action should be taken to address this situation?
A. Increase the warehouse size from Medium to 2XL.
B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
C. Configure the warehouse to a multi-cluster warehouse.
D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
Question No : 109) Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
A. parse_json()
B. json_extract_path_text()
C. object_construct()
D. flatten
Question No : 110) A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII. Which Snowflake feature will support this?
A. Row access policies
B. Data masking policies
C. Data encryption
D. Role based access control
Question No : 111) How would a user execute a series of SQL statements using a task?
A. Include the SQL statements in the body of the task
CREATE TASK mytask .. AS
INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2
SELECT .. FROM stream_s1
WHERE ..
B. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition
CREATE TASK mytask .... AS
call stored_proc1(); call stored_proc2();
C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task.
CREATE TASK mytask .... AS call
stored_proc_multiple_statements_inside();
D. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
Question No : 112) Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
A. SHOW GRANTS OF ROLE MY_ROLE
B. SHOW GRANTS TO ROLE MY_ROLE
C. SHOW GRANTS FOR ROLE MY_ROLE
D. SHOW GRANTS ON ROLE MY_ROLE
Question No : 113) What is the minimum Snowflake edition required to use Dynamic Data Masking?
A. Standard
B. Enterprise
C. Business Critical
D. Virtual Private Snowflake (VPC)
Question No : 114) Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
A. Cloud services layer
B. Compute layer
C. Storage layer
D. Cloud agnostic layer
Question No : 115) Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
A. USAGE
B. OPERATE
C. MONITOR
D. MODIFY
Question No : 116) What impacts the credit consumption of maintaining a materialized view? (Choose two.)
A. Whether or not it is also a secure view
B. How often the underlying base table is queried
C. How often the base table changes
D. Whether the materialized view has a cluster key defined
E. How often the materialized view is queried
Question No : 117) In a Snowflake role hierarchy, what is the top-level role?
A. SYSADMIN
B. ORGADMIN
C. ACCOUNTADMIN
D. SECURITYADMIN
Question No : 118) Which services does the Snowflake Cloud Services layer manage? (Choose two.)
A. Compute resources
B. Query execution
C. Authentication
D. Data storage
E. Metadata
Question No : 119) How long is the Fail-safe period for temporary and transient tables?
A. There is no Fail-safe period for these tables.
B. 1 day
C. 7 days
D. 31 days
E. 90 days
Question No : 120) Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
A. STRIP_NULL_VALUES
B. SKIP_BYTE_ORDER_MARK
C. REPLACE_INVALID_CHARACTERS
D. VALIDATION_MODE
COF-C02 Answers