snow9

Which command can be used to view the allowed and blocked IP list of a network policy?

• ALTER NETWORK POLICY

• CREATE NETWORK POLICY

• DESCRIBE NETWORK POLICY

• SHOW NETWORK POLICIES

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

• Resource monitor

• Account_usage.query_history

• Information_schema.warehouse_load_history

• Information_schema.warehouse_metering_history

Which SQL statement will require a virtual warehouse to run? EMP_ID NUMBER, EMP_NAME VARCHAR(30), EMP_SALARY NUMBER, DEPT VARCHAR(20)

• SELECT COUNT(*) FROM TBL_EMPLOYEE;

• ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGION VARCHAR(20);

• INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, 'Adam', 20000, 'Finance');

• CREATE OR REPLACE TABLE TBL_EMPLOYEE

Which object-level parameters can be set to help control query processing and concurrency? (Choose two)

• MAX_CONCURRENCY_LEVEL

• DATA_RETENTION_TIME_IN_DAYS

• MIN_DATA_RETENTION_TIME_IN_DAYS

• STATEMENT_TIMEOUT_IN_SECONDS

• STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

What is the MINIMUM permission needed to access a file URL from an external stage?

• MODIFY

• READ

• SELECT

• USAGE

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

• Repair the failed resources

• Restart the failed resources

• Queue the failed resources

• Provision the failed resources

The Snowflake VARIANT data type imposes a 16 MB size limit on what?

• An individual row

• An individual column

• A view

• A file in a stage

Which validation option is the only one that supports the COPY INTO command?

• RETURN_ROWS

• RETURN__ROWS

• RETURN_ERRORS

• RETURN_ALL_ERRORS

Which command should be used to look into the validity of an XML object in Snowflake?

• XMLGET

• TO_XML

• PARSE_XML

• CHECK_XML

What issues can be identified and troubleshooted using the Query Profile? (Choose two.)

• Full index scans

• Cartesian products

• Insufficient privileges

• Queries too large to fit in memory

• Virtual warehouse credit consumption