Question 1

If the Account Administrator granted global CREATE DATA EXCHANGE LISTING privilege to a role, the role can be used to perform which of the following tasks?

Options :

A : Reject listing requests

B : Submit listings for approval/publishing listings

C : Create and view provider profiles

D : Modify listings properties

Answer: A,B,C,D

Question 2

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 3

What are known benefits of TAGS in Snowflake?

Options :

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 4

In case of Query Result Cache reuse requirements, Changes can be made to source tables, but only if they do not affect any micro-partitions relevant to query?

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

Once an account is created, ORGADMIN can view the account properties but does not have access to the account data?

Options :

A : FALSE

B : TRUE

Answer: B

Smartly Prepare Exam with Free Online ADA-C01 Practice Test

Buying Options: