Practice ADA-B01 Exam Online

Question 1

If the transaction is not aborted by the user, what are the correct behavior?

A : To abort a running transaction, the user who started the transaction or an account administrator can call the system function, SYSTEM$ABORT_TRANSACTION

B : If it blocks another transaction from acquiring a lock on the same table and is idle for 5 minutes, it is automatically aborted and rolled back.

C : If it does not block other transactions from modifying the same table and is older than 24 hours, it is automatically aborted and rolled back

D : If it does not block other transactions from modifying the same table and is older than 4 hours, it is automatically aborted and rolled back

E : If it blocks another transaction from acquiring a lock on the same table and is idle for 50 minutes, it is automatically aborted and rolled back

Answer: A,D

Question 2

As Administrator you have been asked to setup on-premise user to provide secure connectivity to Snowflake internal stage, then which are the supported interface endpoints you can configure?

A : GCP Private link

B : AZURE Private link

C : AWS Private link

D : Oracle or on-premise supported private link recommended

Answer: B,C

Question 3

Which are the Common Query Problems Identified by Query Profile?

A : Inefficient Pruning

B : Queries Too Large to Fit in Memory

C : “Exploding” Joins

D : DeDuplication

E : UNION Without ALL

Answer: A,B,C

Question 4

Authorization to execute CREATE < object > statements comes from the primary role only?

A : FALSE

B : TRUE

Answer: B

Question 5

Let’s say as an Administrator you have created public key & now you need to assign the Public Key to a Snowflake User named Stuart, How you will do it?

A : alter account set user stuart set rsa_public_key='SKIMIjANBkkqh...';

B : alter user stuart set rsa_general_key='SKIMIjANBkkqh...';

C : alter role of user stuart set rsa_public_key='SKIMIjANBkkqh...';

D : alter user stuart set rsa_public_key='SKIMIjANBkkqh...';

Answer: D

Name:	SnowPro Advanced Administrator Certification
Exam Code:	ADA-B01
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	200
Last Updated:	Apr 25, 2024

Snowflake ADA-B01