Free Practice Snowflake ADA-C01 Exam Questions 2025

Stay ahead with 100% Free SnowPro Advanced Administrator ADA-C01 Dumps Practice Questions

Page: 1 / 53

Total 265 Questions | Updated On: Apr 22, 2025

Add To Cart

Question 1

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).

A : SYSADMIN

B : SECURITYADMIN

C : ACCOUNTADMIN

D : IMPORT SHARE and CREATE DATABASE

E : IMPORT PRIVILEGES and SHARED DATABASE

Answer: C,D

Question 2

Snowflake data providers can share data with data consumers in a different region?

A : FALSE

B : TRUE

Answer: B

Question 3

Auto-resume only applies when the entire warehouse is suspended (i.e. no clusters are running)

A : FALSE

B : TRUE

Answer: B

Question 4

Enable failover for a primary database to one or more accounts in your organization using which command?

A : ALTER DATABASE … ENABLE FAILOVER TO ACCOUNT

B : It can be set only via SnowSight web interface

C : ALTER DATABASE … ENABLE FAILOVER TO ACCOUNTS

D : ALTER DATABASE … ACTIVATE FAILOVER TO ACCOUNTS

Answer: C

Question 5

SQL to view the amount of replication data transferred (in bytes) for your Snowflake account within a specified date range can be queried using which of the Views/Table functions

A : REPLICATION_USAGE_HISTORY table function (in the Snowflake Information Schema).

B : REPLICATION_METERING_HISTORY View view (in Account Usage)

C : REPLICATION_USAGE_HISTORY View view (in Account Usage)

D : REPLICATION_METERING_HISTORY table function (in the Snowflake Information Schema)

Answer: A,C

Page: 1 / 53

Total 265 Questions | Updated On: Apr 22, 2025

Add To Cart