- All Exams Instant Download
When does a multi-cluster warehouse shuts down with default scaling policy
When does a multi-cluster warehouse shuts down with default scaling policyA . Immediately after the query is run B. After 2 to 3 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up...
All multi cluster warehouses that were using the Legacy policy now use the default Standard policy
All multi cluster warehouses that were using the Legacy policy now use the default Standard policyA . TRUE B. FALSEView AnswerAnswer: A Explanation: A third scaling policy, Legacy, was provided for backward compatibility. In contrast to the other policies, it used a static approach based on length of time a...
Which are those?
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENT B. RECORD_METADATA C. RECORD_MESSAGEView AnswerAnswer: A,B Explanation: Schema of Topics for Kafka Topics Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns:
CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?
You have create a table in snowflake as below CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?A . VARCHAR(10) B. VARCHAR C. VARCHAR(16777216) D. STRINGView AnswerAnswer: C Explanation: Please run these commands in snowflake and...
Which of the below operations are allowed on an inbound share data?
Which of the below operations are allowed on an inbound share data?A . MERGE B. CREATE/DROP/ALTER TABLE C. ALTER SCHEMA D. SELECT WITH JOIN E. SELECT WITH GROUP BY F. INSERT INTOView AnswerAnswer: D,E Explanation: This is a trick question:) remember a share is read only, so you can only...
Select the true statement
Select the true statementA . Privileges are granted to roles. Roles are granted to users B. Privileges are granted to users. Users are granted to roles C. Privileges are granted to both roles and usersView AnswerAnswer: A Explanation: Privileges are granted to roles, and roles are granted to users, to...
Which of the below commands lists all the pipes for which you have access?
Which of the below commands lists all the pipes for which you have access?A . Display Pipes() B. SHOW PIPES() C. LIST PIPES() D. LIST @PIPESView AnswerAnswer: B Explanation: SHOW PIPES Lists the pipes for which you have access privileges. This command can be used to list the pipes for...
If a multi-cluster warehouse is resized, the new size applies to
If a multi-cluster warehouse is resized, the new size applies toA . Clusters that are currently running B. Clusters that are started after the warehouse is resized C. All of the aboveView AnswerAnswer: C Explanation: Multi-cluster Size and Credit Usage The number of servers in each cluster is determined by...
While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?
While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?A . Unlimited B. 3 to 4 C. Not more than 16 D. 32View AnswerAnswer: B Explanation: A single clustering key can contain one or more columns or...
Which of the two are limitations of the insertReport API of SnowPipe?
Which of the two are limitations of the insertReport API of SnowPipe?A . The 10,000 most recent events are retained B. Events are retained for a maximum of 10 minutes C. Events are retained for a maximum of 24 hoursView AnswerAnswer: A,B Explanation: Endpoint: insertReport Retrieves a report of files...
