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

When future grants are defined at both the database and schema level, the schema level grants take precedence over the database level grants, and the database level grants are ignored.?

Options :

A : FALSE

B : TRUE

Answer: B

Question 3

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 4

What are characteristics of Dynamic Data Masking? (Select TWO).

Options :

A : A masking policy that is currently set on a table can be dropped.

B : A single masking policy can be applied to columns in different tables.

C : A masking policy can be applied to the VALUE column of an external table.

D : The role that creates the masking policy will always see unmasked data in query results.

E : A single masking policy can be applied to columns with different data types.

Answer: B,E

Question 5

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