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...

May 18, 2023 No Comments READ MORE +

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...

May 18, 2023 No Comments READ MORE +

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...

May 18, 2023 No Comments READ MORE +

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...

May 18, 2023 No Comments READ MORE +

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...

May 18, 2023 No Comments READ MORE +

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...

May 18, 2023 No Comments READ MORE +

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...

May 18, 2023 No Comments READ MORE +

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...

May 18, 2023 No Comments READ MORE +

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...

May 18, 2023 No Comments READ MORE +

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

May 18, 2023 No Comments READ MORE +