Practice ADA-C01 Exam Online

Question 1

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 2

What are characteristics of Dynamic Data Masking? (Select TWO).

A : A masking policy that is currently set on a table can be dropped.

B : A single masking policy can be applied to columns in different tables.

C : A masking policy can be applied to the VALUE column of an external table.

D : The role that creates the masking policy will always see unmasked data in query results.

E : A single masking policy can be applied to columns with different data types.

Answer: B,E

Question 3

Select true statement with respect to API Integration..

A : Your Snowflake account can have multiple API integration objects

B : Only Snowflake roles with OWNERSHIP or USAGE privileges on the API integration can use the API integration directly

C : Multiple external functions can use the same API integration object, and thus the same HTTPS proxy service

D : An API integration object is tied to a specific cloud platform account and role within that account.

Answer: A,B,C,D

Question 4

As Administrator you have created Custom Role CR1 & this CR1 Roles user are from Billing Department of Company & required SnowFlake Account usage & billing information access, how are you going to enable users who are not account administrators to access/view usage and billing information in this case?

A : Non Account Admin Role cannot query Billing & Usage information as this is not allowed

B : Grant IMPORTED PRIVILEGES on database SNOWFLAKE to query all of the ACCOUNT USAGE views

C : CR1 Role can be granted MONITOR USAGE privilege

D : User can be granted OPERATE Privilege

Answer: B,C

Question 5

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

A : FALSE

B : TRUE

Answer: B

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

Snowflake ADA-C01