Logo ExamsQA
Exit
Official Bank 0/78

Snowflake SnowPro Advanced: Administrator Certification (ADA-C01) - Snowflake Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
78 Total Questions
1
Question
A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set.

Which action would provide optimal performance for the second SQL query?
Options
A Assign additional clusters to the virtual warehouse.
B Prevent the virtual warehouse from suspending between the running of the first and second queries.
C Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.
D Use the RESULT_SCAN function to post-process the output of the first query.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
What roles can be used to create network policies within Snowflake accounts? (Select THREE).
Select 3
Options
A Any role that owns the database where the network policy is created
B SYSADMIN
C SECURITYADMIN
D Any role with the global permission of CREATE NETWORK POLICY
E ACCOUNTADMIN
F ORGADMIN
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?
Options
A PRODUCER_TEST_ACCT
B MIMIC_CONSUMER_ACCOUNT
C TEST_ACCOUNT_ID
D SIMULATED_DATA_SHARING_CONSUMER
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership On future tables In schema PROD. WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number) ;

Which role(s) can alter or drop table XYZ?
Options
A Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
B PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
C SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
D Only the PROD_WORKING_OWNER role can alter or drop table XYZ.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT data. Time Travel is being used as a component of the company's data quality process in which the ingestion pipeline should revert to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process. According to best practices, how should these requirements be met? (Select TWO).
Select 2
Options
A Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.
B The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).
C The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAYS.
D The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data.
E Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.