Question 1

Auto-resume only applies when the entire warehouse is suspended (i.e. no clusters are running)

Options :

A : FALSE

B : TRUE

Answer: B

Question 2

If a view references any object in another database (e.g. table columns, other views, UDFs, or stages), both databases must be replicated during database replication?

Options :

A : FALSE

B : TRUE

Answer: B

Question 3

As Administrator you have created Custom Role CR1 & this CR1 Roles user are from Billing Department of Company & required SnowFlake Account usage & billing information access, how are you going to enable users who are not account administrators to access/view usage and billing information in this case?

Options :

A : Non Account Admin Role cannot query Billing & Usage information as this is not allowed

B : Grant IMPORTED PRIVILEGES on database SNOWFLAKE to query all of the ACCOUNT USAGE views

C : CR1 Role can be granted MONITOR USAGE privilege

D : User can be granted OPERATE Privilege

Answer: B,C

Question 4

A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema: Table Name:VWH_META Column 1:SNAPSHOT_TIME TIMESTAMP_NTZ Column 2:CONFIG VARIANT Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH META?

Options :

A : 1. SHOW WAREHOUSES;

2. INSERT INTO VWH META

SELECT CURRENT TIMESTAMP (),

FROM TABLE (RESULT_SCAN (LAST_QUERY_ID(1) ) ) ;

B : 1. SHOW WAREHOUSES;

2. INSERT INTO VWH META

SELECT CURRENT TIMESTAMP (), *

FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ())) ;

C : 1. SHOW WAREHOUSES;

2. INSERT INTO VWH_META

SELECT CURRENT_TIMESTAMP (),

OBJECT CONSTRUCT (*)

FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ()));

D : 1. SHOW WAREHOUSES;

2. INSERT INTO VWH META

SELECT CURRENT TIMESTAMP (), *

FROM TABLE (RESULT_SCAN (SELECT

LAST QUERY ID(-1)));

Answer: C

Question 5

Please select the supported Client Interfaces/Connector/Drivers supported SSO enabled Federated Authentication in SnowFlake?[Select All that apply]

Options :

A : dJango

B : NET

C : Go

D : JDBC/ODBC

E : Node.js

F : SnowSQL

G : Python

Answer: A,B,D