snow9
Authored by Ismael Navarro Cruz
Specialty
Professional Development
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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
4.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
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
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the MINIMUM permission needed to access a file URL from an external stage?
MODIFY
READ
SELECT
USAGE
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
