- All Exams Instant Download
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...
Schema owner can grant object privileges in a regular schema
Schema owner can grant object privileges in a regular schemaA . TRUE B. FALSEView AnswerAnswer: B Explanation: Another important topic to remember. Please also go through the difference between a managed schema and a regular schema https://docs.snowflake.com/en/user-guide/security-access-control-configure.html#creating-managed-acc ess-schemas
The insertReport endpoint can be thought of like the UNIX command tail
The insertReport endpoint can be thought of like the UNIX command tailA . TRUE B. FALSEView AnswerAnswer: A Explanation: An event occurs when data from a file submitted via insertFiles has been committed to the table and is available to queries. The insertReport endpoint can be thought of like the...
How do you refresh a materialized view?
How do you refresh a materialized view?A . ALTER VIEW <MV_NAME> REFRESH B. REFRESH MATERIALIZED VIEW <MV_NAME> C. Materialized views are automatically refreshed by snowflake and does not require manual interventionView AnswerAnswer: C Explanation: Materialized views are automatically and transparently maintained by Snowflake. A background service updates the materialized view...
While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.
While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.A . TRUE B. FALSEView AnswerAnswer: A Explanation: non-equality JOINS are usually slower compared to equality joins. This is a very important thing to remember when you work on snowflake.
