- All Exams Instant Download
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...
The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.
The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.A . The post can contain at most 5000 files. B. Each file path given must be <= 1024 bytes long when...
What will happen to the query?
You have a large warehouse with auto suspend configured for 10 minutes. You submitted a query and it is going to run for more than 10 minutes. What will happen to the query?A . The query will automatically cancelled after 10 minutes B. The query will go on a hold...
A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses
A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view usesA . TRUE B. FALSEView AnswerAnswer: A Explanation: A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view...
What datatype Snowflake will use for EMPLOYEE_ID?
You have created a table as below CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR); What datatype Snowflake will use for EMPLOYEE_ID?A . FIXED B. INTEGER C. NUMBERView AnswerAnswer: A Explanation: Please try this for yourself. Note that this advanced certification requires working experience, so some of these hands-on will help in...
Which of the below objects cannot be replicated from one region to the other?
Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULLA . An error is returned and no changes are applied to the column B. Snowflake automatically assigns a default value and let the change happen C. Snowflake drops the row and...
