Question 1

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 2

Snowflake data providers can share data with data consumers in a different region?

Options :

A : FALSE

B : TRUE

Answer: B

Question 3

SQL to view the amount of replication data transferred (in bytes) for your Snowflake account within a specified date range can be queried using which of the Views/Table functions

Options :

A : REPLICATION_USAGE_HISTORY table function (in the Snowflake Information Schema).

B : REPLICATION_METERING_HISTORY View view (in Account Usage)

C : REPLICATION_USAGE_HISTORY View view (in Account Usage)

D : REPLICATION_METERING_HISTORY table function (in the Snowflake Information Schema)

Answer: A,C

Question 4

An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not

want to change the main table data. The Administrator decides to

make a transient copy of this table and wants the transient table to have all the same permissions as the

original table How can the Administrator create the transient table so it inherits the same permissions as the original table,

and what considerations need to be made concerning the

requirements? (Select TWO).

Options :

A : Use the following SQL command:

create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

B : Use the following SQL command:

create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

C :

Use the following SQL commands:

create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

D : Transient tables will persist until explicitly dropped and contribute to overall storage costs.

E : Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

Answer: B,D

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