Question 1

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

Question 2

Which database objects are not supported by UNDROP command?

Options :

A : UNDROP SCHEMA

B : UNDROP TAG

C : UNDROP VIEWS

D : UNDROP TABLE

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

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 5

The maximum number of unique tag keys that can be set on a single object is

Options :

A : 100

B : 10

C : 50

D : 20

Answer: D

Higher Test Marks with Free Online ADA-C01 Exam Practice

Buying Options: