Free Snowflake ADA-C01 Exam Questions

Become Snowflake Certified with updated ADA-C01 exam questions and correct answers

Page: 1 / 53

Total 265 Questions | Updated On: Jan 02, 2024

Add To Cart

Question 1

What is the correct Precedence for Warehouse Defaults i.e. when a user connects to Snowflake and start a session, In what order Snowflake determines the default warehouse for the session

A : None of the above is correct

B : 1. .Default warehouse for the user » overridden by…2. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake » overridden by…3.. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.)

C : 1.Default warehouse for the user » overridden by…2. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.) » overridden by…3. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake

D : 1. Default warehouse in the configuration file for the client utility (SnowSQL, JDBC driver, etc.) » overridden by2. … Default warehouse for the user » overridden by…3. Default warehouse specified on the client command line or through the driver/connector parameters passed to Snowflake

Answer: C

Question 2

A user created column level security using dynamic data masking policy in one of the column & then later on applied row level access policy in another column, which one of type of access policies snowflake evaluates first in order to provide security of data?

A : Row access policy evaluates first

B : Snowflake does not support both type of policy at the same time

C : Timing does not matter here, individual column level security i.e. dynamic data masking will evaluates first & applied

D : Dynamic data masking first as its applied before

Answer: A

Question 3

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?

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

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

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?

A : TRUE

B : FALSE

Answer: A

Page: 1 / 53

Total 265 Questions | Updated On: Jan 02, 2024

Add To Cart