Free ADA-C01 Exam Questions - Easiest Way for Success

Prepare for the Snowflake ADA-C01 exam questions with our authentic preparation materials, including free ADA-C01 practice exam questions and answers. TheExamsLab provides all the support you need to succeed in the SnowPro Advanced Administrator ADA-C01 exam. This dedication to student success is why we have the most satisfied ADA-C01 certification exam candidates worldwide.

Page: 1 / 53

Total 265 Questions | Updated On: Sep 11, 2024

Add To Cart

Question 1

What are known benefits of TAGS in Snowflake?

A : Enable Data Optimization

B : Sensitive Data Tracking and Resource Usage

C : EASE of Use & Tag Lineage

D : To facilitate compliance with internal and external regulatory requirements

E : Micro Partition Management

F : Consistent Assignment with Replication

Answer: A,B,C,D

Question 2

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?

A : 1. SHOW WAREHOUSES;2. INSERT INTO VWH METASELECT CURRENT TIMESTAMP (),FROM TABLE (RESULT_SCAN (LAST_QUERY_ID(1) ) ) ;

B : 1. SHOW WAREHOUSES;2. INSERT INTO VWH METASELECT CURRENT TIMESTAMP (), *FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ())) ;

C : 1. SHOW WAREHOUSES;2. INSERT INTO VWH_METASELECT CURRENT_TIMESTAMP (),OBJECT CONSTRUCT (*)FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ()));

D : 1. SHOW WAREHOUSES;2. INSERT INTO VWH METASELECT CURRENT TIMESTAMP (), *FROM TABLE (RESULT_SCAN (SELECTLAST QUERY ID(-1)));

Answer: C

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?

A : FALSE

B : TRUE

Answer: B

Question 4

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

A : ORGANIZATION_USAGE

B : READER_ACCOUNT_USAGE

C : DATA_SHARING_USAGE

D : CONSUMER_ACCOUNT_USAGE

E : ACCOUNT_USAGE

Answer: D

Question 5

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).

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

Page: 1 / 53

Total 265 Questions | Updated On: Sep 11, 2024

Add To Cart