Snowflake SnowPro Advanced: Administrator Certification (ADA-C01) - Snowflake Actual Exam Questions
Last updated on March 10, 2026
An Administrator wants to delegate the administration of a company's data exchange to users who do not have access to the ACCOUNTADMIN role. How can this requirement be met?
Grant imported privileges on data exchange EXCHANGE_NAME to ROLE_NAME;
Grant modify on data exchange EXCHANGE_NAME to ROLE_NAME;
Grant ownership on data exchange EXCHANGE_NAME to ROLE NAME;
Grant usage on data exchange EXCHANGE_NAME to ROLE_NAME;
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?
The account_level policy will override the user_level policy.
The user_level policy will override the account_level policy.
The user_level network policies will not be supported.
A network policy error will be generated with no definitions provided.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?
Database: Usage Schema: Usage Table: Select, Create Stream
Database: Usage Schema: Usage Table: Select
Database: Usage, Create Stream Schema: Usage Table: Select
Database: Usage Schema: Usage, Create Stream Table: Select
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
A user accidentally truncated the data from a frequently-modified table. The Administrator has reviewed the query history and found the truncate statement which was run on 2021-12-12 15:00 with query ID 8e5d0ca9-005e-44e6-b858-a8f5b37c5726. Which of the following statements would allow the Administrator to create a copy of the table as it was exactly before the truncated statement was executed, so it can be checked for integrity before being inserted into the main table?
CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE BEFORE (timestamp => '2021-12-12 00:00');
SELECT * FROM CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858- a8f5b37c5726');
INSERT INTO CURRENT_TABLE SELECT * FROM CURRENT_TABLE before (statement => '8e5d0ca9- 005e-44e6-b858-a8f5b37c5726');
CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE before (statement => '8e5d0ca9-005e- 44e6-b858-a8f5b37c5726');
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?
CURRENT_ROLE
CURRENT ACCOUNT
CURRENT_USER
CURRENT_CLIENT
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.