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

Enable failover for a primary database to one or more accounts in your organization using which command?

Options :

A : ALTER DATABASE … ENABLE FAILOVER TO ACCOUNT

B : It can be set only via SnowSight web interface

C : ALTER DATABASE … ENABLE FAILOVER TO ACCOUNTS

D : ALTER DATABASE … ACTIVATE FAILOVER TO ACCOUNTS

Answer: C

Question 3

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 4

What is the correct Precedence for Warehouse Defaults i.e. when a user connects to Snowflake and start a session, In what order Snowflake determines the default warehouse for the session

Options :

A : None of the above is correct

B :

1. .Default warehouse for the user » overridden by…

2. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake » overridden by…

3.. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.)

C :

1.Default warehouse for the user » overridden by…

2. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.) » overridden by…

3. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake

D :

1. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.) » overridden by

2. … Default warehouse for the user » overridden by…

3. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake

Answer: C

Question 5

Which one is not the Usage schema contained by SNOWFLAKE database?

Options :

A :

ORGANIZATION_USAGE

B : READER_ACCOUNT_USAGE

C : DATA_SHARING_USAGE

D : CONSUMER_ACCOUNT_USAGE

E : ACCOUNT_USAGE

Answer: D

Higher Test Marks with Free Online ADA-C01 Exam Practice

Buying Options: